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 |
|
jar21
51 Posts |
 Posted - 2008-10-10 : 08:45:13
|
| for some reason one user has lost their connection to the database, when trying to connect it says "General network error. Check your Documentation" it spits out two numbers 01000 and 08001. I did some googling and a KB recommended I use named pipes instead of tcp/ip ... I havent tried this yet but even if it works I would like to know the reason why this occurred in the first place.. has anyone seen this error before?Enjoy Life This Is Not A Rehearsal. |
|
|
jamie
Aged Yak Warrior
542 Posts |
Posted - 2008-10-10 : 09:58:59
|
| has something recently changed on your server or network ?could be a network / firewall issue you know. |
 |
|
|
jar21
51 Posts |
Posted - 2008-10-10 : 10:19:11
|
| group policy has become screwy.. thats a different issue though...I hope...i believe it may relate to AD replication.... but thats off topic I think.... (I could easily be wrong here)but only one user has this problem...thats why I dont understand below are the exact errors associated:Connection failed:SQL:State: '01000'[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (PreLoginHandshake()).Connection failed:SQLState: '08001'SQL Server:11[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.after rereading this is it possible that the drivers got corrupted?? I'm still clueless |
|
|
|
jar21
51 Posts |
Posted - 2008-10-14 : 08:06:37
|
| Any solutions on this? I've read multiple KB's but it seems they are only similar errors and not the same. |
|
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2008-10-14 : 10:20:54
|
| This link explains cause and resolution:http://support.microsoft.com/kb/195566 |
|
|
|
jar21
51 Posts |
Posted - 2008-10-14 : 13:59:55
|
| Yea - I had gone through those with no success... |
|
|
|
jar21
51 Posts |
Posted - 2008-10-16 : 11:24:35
|
| There was a program blocking other programs from starting.... I suppose it was acting as a firewall what a fabulous waste of software - thanks for the help though! |
|
|
|
|
|
|
[resolved] odbc connection