March 28, 2013 at 9:07 am
Hi We have Windows 2008 box with 9 sqlserver instances all instances are 2008 R2.
One of the user come up with Timeout expired issue for one of the instance.
I have tried loging with his login and my login for both its throwing same error. Checked cpu utilization & Memory usage everything seems to be good.
I have verified Services running fine, TCP/IP is enabled(tried restarting it), Windows firewall is disabled as it is Dev server.
I tried restating MSSQLSERVER and it allowed me to login to instance once surprisingly it is also giving timed out after 2min.
We have tried reboot server then No luck.
below is the error message
-----------------------------
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
(Microsoft SQL Server, Error: -2)
-------------------------------------
Please provide your suggestion's to fix the issue
Thanks,
Sunil.
March 28, 2013 at 9:25 am
Sunny03 (3/28/2013)
Hi We have Windows 2008 box with 9 sqlserver instances all instances are 2008 R2.One of the user come up with Timeout expired issue for one of the instance.
I have tried loging with his login and my login for both its throwing same error. Checked cpu utilization & Memory usage everything seems to be good.
I have verified Services running fine, TCP/IP is enabled(tried restarting it), Windows firewall is disabled as it is Dev server.
I tried restating MSSQLSERVER and it allowed me to login to instance once surprisingly it is also giving timed out after 2min.
We have tried reboot server then No luck.
below is the error message
-----------------------------
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
(Microsoft SQL Server, Error: -2)
-------------------------------------
Please provide your suggestion's to fix the issue
Thanks,
Sunil.
What application are you using to try and connect?
Can you log in with a SQL Account rather than with windows authentication?
Can you use the IP address and port number to connect?
And is the IP address from the local machine used for the server ie Ping <ServerName> giving the same from the ipconfig on the server?
March 28, 2013 at 9:49 am
I am using SSMS to connect.
I tried with SQL Account & windows authentication both are giving same error.
tried IP address and port number to connect giving same error.
Tried 'ipconfig' & 'ping' they are not recognized as an internal or external command, operable program or batch file 🙁
Thanks,
Sunil.
March 28, 2013 at 10:09 am
--misread the previous post--
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
March 28, 2013 at 10:12 am
Is it only for one user or all users?
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
March 28, 2013 at 10:13 am
ya am familiar with ipconfig and ping...tried it command prompt only..
March 28, 2013 at 10:18 am
for all the users..
March 28, 2013 at 10:25 am
Is the SQL Browser running on the server?
Go to the command prompt and run:
tracert <servername>
What is the response? It should list the IP address os the sever and none of the hops should be too excessive so all less then 100ms.
If you are using the SQL Studio to connect make certain that the protocols are enabled on the server.
When you have a remotre desktop seession onto the server can you connect to SQL??
March 28, 2013 at 10:28 am
OK something has done something to your server. The fact that IPCONFIG and PING are not recognized suggests your path has been modified by something.
This article http://www.opal-rt.com/kb-article/ipconfig-not-recognized explains how to fix that.
Then I would start with this to figure out why you can't connect.
http://msdn.microsoft.com/en-us/library/ms190181.aspx
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
March 28, 2013 at 11:34 pm
SQL Browser is running on the server.
tracert <servername> is working from my local machine however its not working from server which has problem. Below is the result from it
tracing route to xxxxxxx
over a maximum of 30 hops:
1 <1 ms <1 ms <1 ms xxxxxxxxxx
Trace complete.
All protocols are enabled on the server.
I am not able to connect to SQL from RDP and local machine.
Thanks,
Sunil.
March 29, 2013 at 4:54 am
If you navigate to the folder or to the equilivant:
C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log
You should see a list of errorlog files. Open the the most recent file and see what port it is running on.
Are you certain that the SQL server service is runing?
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply