April 15, 2009 at 12:32 am
I am getting cannot connect to SQL Server error.
The environment is like this.
SQL Server is installed in Windows Server 2003. Named instance e.g (HOST_NAME\NAMED)
I am trying to connect to this instance from Windows Server 2008 machine, using Management Studio.
Its throwing error "cannot connect to SQL Server error"
Error message says
An error occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error locating Server/Instance specified) (Microsoft SQL Server)
I am able to connect successfully from a Windows Server 2003 machine.
Can anybody suggest.
(Attached is the screen shot of error message)
Regards | Enbee
April 15, 2009 at 2:13 am
- Is you sqlserver instance enabled for tcp/ip connections ?
- is there a firewall active ? (you may need to open some ports)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
April 15, 2009 at 2:58 am
yes, Tcp/Ip connections are enabled.
Firewall is not running. its disabled.
Regards | Enbee
April 22, 2009 at 1:22 am
Did you checked the connectivity to database on that server using .udl file?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply