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!
LVL 2
pbenningfieldAsked:
Who is Participating?
 
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
In your existing setup, SQL Server 2000 might be the default instance and SQL Server 2008 would be the named instance.
In order to connect to named instances from SQL server Management studio(SSMS), For servername you need to provide either

Servername\instancename
or
ServerIP\instancename

to get it work.

SEr
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
0
 
pbenningfieldAuthor Commented:
That's for Enterprise Manager (old versions of SQL), correct? I'm using SQL Server Management Studio 2008, and not finding the equivalent.
0
Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

 
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
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.
0
 
Norman MainaCommented:
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
0
 
pbenningfieldAuthor Commented:
Thanks SEr!  My question about registration was in response to Angelll's suggestion.  That worked like a charm!
0
 
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
>> 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).
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.