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 |
|
Gyto
Posting Yak Master
144 Posts |
 Posted - 2008-12-04 : 06:37:10
|
Hi there,I am having problems allowing an application to access an SQL Server 2000 database. It works fine on all our machines except one where it can't connect.I installed SQL Server Management Studio Express on the machine to see if that would connect but I got the following error message: I can ping and telnet to the SQL Server from the machine, so there is definitely network connectivity, but it appears no applications can access it.Any ideas?Thanks |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-12-04 : 06:49:15
|
We can't see local pictures.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
Gyto
Posting Yak Master
144 Posts |
Posted - 2008-12-04 : 06:57:27
|
| Oops...silly me....the error message is as follows:Cannot connect to server name.Additional Information:An error has occured while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)(Microsoft SQL Server, Error: 2) |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-12-04 : 07:33:49
|
"does not allow remote connections" should ring a bell, right?
E 12°55'05.63"N 56°04'39.26" |
|
|
|
Gyto
Posting Yak Master
144 Posts |
Posted - 2008-12-04 : 07:43:44
|
| But surely that would not explain why every other machine can access it without any problems? |
|
|
|
Gyto
Posting Yak Master
144 Posts |
Posted - 2008-12-04 : 10:58:15
|
| I should point out the all the other machines that CAN access it are on the same network/subnet etc. with the exact same access rights and they are all using the same SQL Server login to connect. Also, remote connections are definitely enabled.....so I'm stumped..... |
|
|
|
|
|
|
SQL Server Connection Error