Developing with SQL Server 2000 and SQL Server 2005 on same machine. -- sql server connect

Groups | Blog | Home

sql server connect : Developing with SQL Server 2000 and SQL Server 2005 on same machine.

Dan Sikorsky
6/3/2006 12:00:00 AM

I have SQL Server 2000 installed which has a server name of NOTEBOOKDELL.

I installed SQL Server 2005 Community Technology Review last October, 2005,
and somehow gave it a server name of NOTEBOOKDELL\SQL2005 so that I can keep
my SQL Server 2005 databases separate.

All was well until I purchased the Ready To Launch package containg VS 2005
Standard edition and MS SQL Server 2005 Standard edition, and removed all
the VS 2005 CTR and SQL Server 2005 CTR and installed the Ready To Launch
versions.

All the installations went without incident, but now when I open the SQL
Server Management Studio I see only the databases on NOTEBOOKDELL, which is
the same as server name (local). The server name NOTEBOOKDELL\SQL2005 no
longer exists.

How can resolve this problem and still be able to develope with either SQL
Server 2000 databases or SQL Server 2005 databases?

--
Dan Sikorsky, MSCS BSCE BAB

Linchi Shea
6/3/2006 7:03:03 AM

You said you removed the CTP version of NOTEBOOKDELL\SQL2005, but you didn't
mention whether you reinstalled it. If you did, it's probably just a matter
of making sure the instance is running and registering the instance on
Management Studio.

Linchi

[quoted text, click to view]

Dan Sikorsky
6/3/2006 4:57:00 PM

I installed the SQL Server 2005 Standard Edition that came with the Ready To
Launch kit I purchased.

How do I check to see if this instance is running?

I didn't enter a specific instance name during installation. What would the
instance name be?

The name of my computer is NOTEBOOKDELL.

--
Dan Sikorsky, MSCS BSCE BAB

[quoted text, click to view]

Dan Sikorsky
6/4/2006 1:19:42 PM

Solved. During SQL Server 2005, you must enter a unique Instance name. That
instance name will be prepended with your machine name such that when you
open SQL Server Management Studio and are asked to connect to a SQL Server,
you select <machinename>\<instance name>.

--
Dan Sikorsky, MSCS BSCE BAB

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server connect

View Other Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
August 2008

home · blog · groups

Questions? Comments? Contact the dn