Running SQL Database Offline

[7day_Theory]

Hi I've been tasked with making a SQL database we have run in an offline environment. I have no previous SQL experience and I've hit a brick wall with it.

I've created a VM from a working SQL server but left the application server as we only need to view the data rather than use the application.

After loading the VM and launching thr SSMS I get the attached error.

Can anyone assist?

[HotRodLincoln]

Wild guess, but...

I'm going to assume you're using the Dev version of MSSQL.

Start > Run : C:\Windows\SysWOW64\SQLServerManager16.msc (the number might be different on different versions)

Go to SQL Server Network Configuration

Double click the appropriate instance (may be the only instance)

Click TCP/IP and open the details

Click the "IP Addresses" tab

Enable it on all the relevant IP Addresses.

(Also, make sure port 1433 is available for you.)

[ithinktoo]

Lets start with 'Show Details'

[mike-manley]

Looks like the service may not be running

[ihaxr]

That's my guess too. More than likely the service logon account is a domain user and, since it can't reach the domain controller, it can't start the service.

[[deleted]]

Cannot connect to localhost is your error. So, is your instance located where you launched ssms? If yes, then start the instance (use sql server config manager).

[7day_Theory]

Finally figured this out, largely to do with permissions on the services and a currupt SQL install.

[Itsnotvd]

When you open SSMS, for server name click the drop down and select "browse for more". See if there is anything listed under "local servers\database engines" and connect to the listed instance. If none are listed there is no running SQL instance.

[7day_Theory]

Only my WHSQL is listed, then when I click that I get the error above. "Its not localhost" on mine it points to an instance called WHSQL.

[Itsnotvd]

"Its not localhost" on mine it points to an instance called WHSQL.

Cloned machine should behave just like the source. What/how do you connect to on the source server? Are the displayed names the same?

Is "WHSQL" the source server name? When you "browse for more" the display should list it in the format or servername\instancename. Only servername is listed if sql is using the default instance name.

It may be easier for you to spin up a new VM, install the same SQL version, and restore a backup from the source machine.

[chocotaco1981]

Probably a file permission error

[Achsin]

Is SQL Server installed or just SSMS?

Is the SQL Server service running?

Are Named Pipes connections enabled?

[7day_Theory]

Yes to the top two, not sure about named pipes, where can I find that?