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 |
|
simon001
Starting Member
2 Posts |
 Posted - 2005-08-05 : 11:12:29
|
| I get this error on pc's connecting to sql 2000 enterpise databasethe error is completely randomError 40002: 08S01: [Microsoft][ODBC SQL Server Driver]Communication link failureany help would be much appriciatedThanksSimon |
|
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
Posted - 2005-08-05 : 17:03:45
|
quote:
Originally posted by simon001
I get this error on pc's connecting to sql 2000 enterpise databasethe error is completely randomError 40002: 08S01: [Microsoft][ODBC SQL Server Driver]Communication link failureany help would be much appriciatedThanksSimon
What are you attempting to connect with? Have you looked at your connection string? Is it using named pipes or tcp/ip? If it's tcp/ip have you looked at the port# to be sure its correct? Are you using standard or nt authentication?Please provide more info.Thanks,DanielSQL Server DBAwww.dallasteam.com |
 |
|
|
ssrikrish
Yak Posting Veteran
69 Posts |
Posted - 2005-08-05 : 20:31:25
|
| It may also be a firewall issue if you have one. Usually this error occurs if there is no network connectivity to connect to the sql server.--sri |
|
|
|
simon001
Starting Member
2 Posts |
Posted - 2005-08-08 : 10:24:38
|
| We are using an application from sungard called quantum which access the database over a 100mb link between two buildings, only one user is connection using named pipe the rest are using TCP/IP but all users are getting error. we are using NT Authentication |
|
|
|
|
|
|
Communication error