| Author |
Topic |
|
zhangn
Starting Member
29 Posts |
 Posted - 2010-03-12 : 07:14:33
|
| Hi allI have installed the sql server 2008 as a server. I am trying to connect from the client side. However, whenever I try to log in the first time. The ssms already return the below message:Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (Microsoft SQL Server, Error: -2)Whenever I click ok, and try to connect the same server again. Then, it works fine. Can anyone help me to remove this timeout expired error message in the first trial. any suggestion will be extremely important!regards,Ning |
|
|
RobertKaucher
Posting Yak Master
169 Posts |
Posted - 2010-03-12 : 14:41:56
|
| Could you ping the SQL Server and see if you get any unusual results? |
 |
|
|
zhangn
Starting Member
29 Posts |
Posted - 2010-03-15 : 05:21:24
|
| May I ask how to ping sql server?Ning |
|
|
|
RobertKaucher
Posting Yak Master
169 Posts |
Posted - 2010-03-15 : 10:30:33
|
| What are you trying to connect with? SQLCMD, SSMS, some other client application?To start I suggest you just ping the server (you would expect no timeouts and 1ms response times or better if on the same LAN) and then use something likehttp://www.microsoft.com/downloads/details.aspx?familyid=89811747-C74B-4638-A2D5-AC828BDC6983&displaylang=ento see if port 1433 is allowing connections as expected. You probably also want to use WireShark to look at the traffic in a more detailed manner.If it were me, I would just run WireShark and try to connect via SSMS and then look at the network traffic when my connection timed out vs. my connection when it succeeded. In order to understand the results you will need to have a basic understanding of networking. |
|
|
|
zhangn
Starting Member
29 Posts |
Posted - 2010-03-15 : 12:38:14
|
| my problem is with the first connection. For example, whenever I open a new ssms or new excel 2007 windows and try to connect my server from the client side. I will receive Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (Microsoft SQL Server, Error: -2). However, when i connect 2nd or 3rd time, there is no problem so ever. In addition, this problem is not happen, when i connect form the server machine directly. I am really confuse now.... |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
zhangn
Starting Member
29 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
thewebhosting
Starting Member
17 Posts |
Posted - 2010-03-21 : 00:45:54
|
| Hi,Check with these options:* Click to clear the Override connection string time-out value for table designer updates check box for the table designer and for the database designer in SQL Server Management Studio.* Specify a high setting in the Transaction time-out after box for the table designer and for the database designer in SQL Server Management Studio.* Modify the large table by using Transact-SQL statements in Query Editor in SQL Server Management Studio. |
|
|
|
|
Time out error