We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now

x

Using SQL Server Manager

Medium Priority
206 Views
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.

THanks...
Comment
Watch Question

Commented:
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

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...

Author

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

Have any more suggestions...
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....

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.