[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Using SQL Server Manager

Posted on 2009-02-18
Medium Priority
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
  • 3
LVL 42

Expert Comment

ID: 23676401
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.

Author Comment

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

I both instances have different names...

Author Comment

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

Have any more suggestions...

Accepted Solution

StrongD1 earned 0 total points
ID: 23683401
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…

872 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