Using SQL Server Manager

Posted on 2009-02-18
Last Modified: 2012-05-06
Hello...  I have a SQL Server DB Server with SQL Server 2005 Express and SQL Server 2008 Express....  I and trying to connect to them remotely with my XP Box using "SQL Server Management Studio 2008 Express"... But when I select server name in the drop down - > Browse for more... -> Network Servers tab ...  It only shows the Server Computer Name... not the DB's...  If I type in ServerName/SQLSERVER2008 I get an error saying it can't find the instance.

I know it will show the whole name, last time I setup SQL Server 2005 at home and connected over the network, I got the whole name...  

Can someone tell me what I need to do...  I have full control over the server and my workstation.

Question by:StrongD1
    LVL 42

    Expert Comment

    First, you need to install one as as a named instance other than SQLExpress.  Second, you need to enable remote connections in Configuration Manager.
    Third, you need to make sure they are listening on different TCP/IP ports.
    LVL 1

    Author Comment

    I have already enabled remotes connections...  The TCP/IP ports I haven't done yet... will check them..

    I both instances have different names...
    LVL 1

    Author Comment

    Ok..I have checked the TCP/IP ports and they are different.  

    Have any more suggestions...
    LVL 1

    Accepted Solution

    Ok... I am able to see the Server name and instancees now...

    I had to install IIS.... or the Application Server componts that are on the Windows 2003 Server CD....


    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

    INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
    If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

    755 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

    24 Experts available now in Live!

    Get 1:1 Help Now