Link to home
Start Free TrialLog in
Avatar of Trish Benningfield
Trish BenningfieldFlag for United States of America

asked on

Question about SQL 2000 and SQL 2008 running on same server

Hi!  I have a Windows Server 2008 64 bit standard running both Microsoft SQL Server 2000, and Microsoft SQL Server 2008, 64 bit. I can't say why, I've inherited it.

If I look in services, I can see both the 2000 version and the 2008 version started, yet when I open Microsoft SQL Server Management Studio 2008, all I can see and connect to is the 2000 installation.  How do I access the new version/instance with Management Studio?

TIA!
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

ASKER CERTIFIED SOLUTION
Avatar of Raja Jegan R
Raja Jegan R
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Trish Benningfield

ASKER

That's for Enterprise Manager (old versions of SQL), correct? I'm using SQL Server Management Studio 2008, and not finding the equivalent.
Nope, whatever I've specified above is for SSMS 2008..
Can you kindly try that once..
If you are not aware of the instance name of SQL 2008, then open SQL Server configuration manager which will list out the services related to SQL Server. In that you can see the instance name of SQL 2008.
What SEr said is probably the case.

In SSMS you do not have to register an instance of SQL SERVER.
When you open SSMS, under database services,you can use it to scan to local or network sql instances and then connect to them.

Try these:
1.when you connect to the local instance and then open the query window and run this stored procedure sp_helpserver ..what do you get?
2.Before you login to an instance,when you search for local instances using ssms - what are the results?
3.Try logging in to the instance using ssms with servername\servername or servername\sqlexpress if its an express version
Thanks SEr!  My question about registration was in response to Angelll's suggestion.  That worked like a charm!
>> My question about registration was in response to Angelll's suggestion.

Yes, you can also register servers in SSMS. In order to do that, follow the steps below:

1. In SSMS, Click View from Menu bar and choose Registered Servers
2. Your local instances will be automatically listed under Local Server Groups
3. Add more servers as required.

And in the meanwhile, I type SEr in my earlier comment by mistake ( thought of typing Server).