February 2, 2014 at 9:07 am
I am trying to login in sql server 2008 through sql server browser,for this i am using ip address of server in Server name,but getting following error.
Failed to connect to server.(Microsoft.SqlServer.ConnectionInfo)
------------------------------ADDITIONAL INFORMATION:Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (Microsoft SQL Server, Error: -2)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-2&LinkId=20476
------------------------------BUTTONS:OK------------------------------
but in place of ip address if i am using server name then i am getting proper connection with sql server.
can any one explain me reason behind this why it is not working with ip address,but working properly with instance name/server name.Few day before i was able to connect this with ip address too.
February 3, 2014 at 10:51 am
The configuration of the SQL Server is likely not set to accept TCP connections.
Thanks
John.
February 3, 2014 at 11:10 pm
1-can you please confirm DB server has static IP or using DHCP.
2-ping -a hostname replying the same ip you are using while connecting.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply