Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 unable to connect to server from local system

Author  Topic 

sarath
Starting Member

3 Posts

Posted - 2010-06-22 : 08:25:28
My issue is a bit different. I have a server in which both SQL server 2005 and 2008 are installed. few databases are in sql server 2005 and few are in sql server 2008.
I am able to connect to 2005 from my local system but unable to connect to 2008 from local system. Can anyone please solve this issue.

sarath

patshaw
Posting Yak Master

177 Posts

Posted - 2010-06-22 : 10:01:51
What OS are you using?
Go to Top of Page

sarath
Starting Member

3 Posts

Posted - 2010-06-23 : 01:03:18
Hi Patshaw,
Its windows xp
quote:
Originally posted by patshaw

What OS are you using?



sarath adusumilli
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-06-23 : 01:12:56
What error do you get? Have you verified that the 2008 service is started? Are you using the proper server name to connect?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

sarath
Starting Member

3 Posts

Posted - 2010-06-23 : 01:18:40
Hi Tara Kizer
2008 service is started. I am sure that server name is correct.
the error which iam getting is "a network related or instance specific error occured while establishing connection .....error :26

sarath adusumilli
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-06-23 : 01:28:45
Make sure you connect with hostname\instancename for the 2008 named instance. If the service is started, and you are connecting locally, then hostname\instancename should work. Of course you'll need to replace "hostname" and "instancename" with your values.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -