Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Mike54
Starting Member
3 Posts |
 Posted - 2012-10-20 : 05:40:34
|
| I am running SQL Express 2008 on a Windows 7 PC and quite often when I try to use my SQL server which is on my local PC I cannot make a connection. Usually after re-booting the PC the connection will be OK. This morning it took 4 re-boots before I could establish a connection. Once established it never loses the connection. The only error message I get is error 40 - Could not open connetion to SQL server.Has anyone else experienced this problem or got any good ideas as to why? |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-10-20 : 09:08:14
|
| I have not experienced this intermittent type of problem. The usual diagnostic steps one goes through (for example, listed here: http://blog.sqlauthority.com/2007/04/23/sql-server-fix-error-40-could-not-open-a-connection-to-sql-server/ ) don't seem to apply in your case, but if you have not already, you may want to look through them nonetheless.How are you trying to connect? From an application, or from SQL Server Management Studio? If you are connecting from an app, you may want to try connecting using SSMS and see if that works. |
 |
|
|
Mike54
Starting Member
3 Posts |
Posted - 2012-10-20 : 09:55:07
|
| When the connectrion fails it doesn't matter whether I am connecting from my VB application or SSMS, no connection till I reboot. |
|
|
|
nicklarge
Starting Member
40 Posts |
Posted - 2012-10-23 : 17:22:19
|
| Could this be a dynamic IP addressing issue, or do you have a static IP address for it, or do you only use localhost? |
|
|
|
|
|
|
Intermittent connection problem