Skip to content

Where did my local server go?

May 31, 2012

After installing MSSQL 2005, I uninstalled MSSQL2000 and lost my local server.  I did not realize initially after installing 2005 that It had found the 2000 server instance and used it as the local server.  I thought it had somehow connected to our live server (ip address).  Foolish me.

Registering another server instance.

I created a new instance to our live server, the one I had been accessing using MSSQL 2000.

  • Right click on Database Engine
  • choose Server Registration.
  • In the Server name: specified the IP address
  • selected:  SQL Server Authentication
  • specified the login and password I had used in 2000.

After I had created the new registration to the server, I uninstalled SQL 2000, that is when I realized my opps…

Had to Re-install Database Services

I had to use the installation disks and install the SQL Server Database Services again.  This time I choose a named instance.

Now I have my localServer “my named instance” and my live server from the old 2000 instance working.

Restore the .bak file in new localServer

  •  right clicked on Databases
  • choose Restore Database…
  • Clicked on From Device:
  • Click the … button
  • Click the Add button
  • In the Locate Backup File window, found and selected .bak file
  • Selected the Named backupfile now loaded
  • Choose the database name in the To database: option (i did NOT have to create an empty shell for the DB)
Advertisements

From → MSSQL

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: