Question about SQL 2000 and SQL 2008 running on same server

Posted on 2011-10-19
Last Modified: 2012-05-12
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?

Question by:pbenningfield
    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    LVL 57

    Accepted Solution

    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


    to get it work.

    LVL 2

    Author Comment

    That's for Enterprise Manager (old versions of SQL), correct? I'm using SQL Server Management Studio 2008, and not finding the equivalent.
    LVL 57

    Expert Comment

    by:Raja Jegan R
    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.
    LVL 12

    Expert Comment

    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
    LVL 2

    Author Comment

    Thanks SEr!  My question about registration was in response to Angelll's suggestion.  That worked like a charm!
    LVL 57

    Expert Comment

    by:Raja Jegan R
    >> 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).

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    I had a question today where the user wanted to know how to delete an SSL Certificate, so I thought that I would quickly add this How to! Article for your reference. WHY WOULD YOU WANT TO DELETE A CERTIFICATE? 1. If an incorrect certificate was …
    The recent Microsoft changes on update philosophy for Windows pre-10 and their impact on existing WSUS implementations.
    This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…
    This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

    730 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now