question

gerryLynn avatar image
gerryLynn asked

Login timeout once only, then works

Hey there. We're running SQL Server 2008 on our server machine. One Win7 client PC (mine as it happens) times out on the initial connection (on initial opening of the front end program) - but then (with a retry) it connects and runs just fine ???. It occurs whether using Management Studio or any of our ADODB based office programs, but it only happens on my PC. My login works fine on other machines and other logins have the same problem on this machine so it's obvious the problem lies in my PC but we're running out of things to look for. We've given the network hardware and the drivers the once over and everything is fine there. We suspect network settings but that's where our experience gets a bit lightweight. Has anyone else experienced (and successfully solved) this issue, or are there any suggestions as to where we should be looking. Thanks.
logintimeout
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
R2d2 avatar image
R2d2 answered
it sounds like a network related problem. Hi GerryLynn, You could check out the article on Stackoverflow: http://stackoverflow.com/questions/17192784/sporadic-sql-connection-timeouts Check with SQL Server configuration Manager ports of your SQL server and then check from your client machine if TCP/IP & UDP can be reached or if something is blocking your request. Regards R2d2
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

gerryLynn avatar image gerryLynn commented ·
Thanks very much R2d2. We're going to check that out shortly. Will post back what we find.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.