• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 200
  • Last Modified:

Using SQL Server Manager

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.

THanks...
0
StrongD1
Asked:
StrongD1
  • 3
1 Solution
 
dqmqCommented:
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.
0
 
StrongD1Author Commented:
I have already enabled remotes connections...  The TCP/IP ports I haven't done yet... will check them..

I both instances have different names...
0
 
StrongD1Author Commented:
Ok..I have checked the TCP/IP ports and they are different.  

Have any more suggestions...
0
 
StrongD1Author Commented:
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....

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.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now