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 |
|
Bex
Aged Yak Warrior
580 Posts |
 Posted - 2005-12-13 : 11:36:05
|
| Hello allI have an excel spreadsheet template that connects to sql server on the LAN. Recently, the location of the database has been changed to reside on a server in a datacentre. I can connect to the server through query analyzer using windows authentication. However, when I try to connect to the server through the spreadsheet, I get the following error:connection failed. SQLState:'01000'. SQL server Error:53[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen(Connect()).Connection failed: SQLState:'08001'. SQL Server Error:17. SQL Server does not exist or access denied.I can see the server on the network, and it cannot be a permissions issue as I cannot connect using the sa and pwd either. Does anyone have any resolutions to this?Thanks in advanceHearty head pats |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2005-12-13 : 15:11:14
|
| Did u check the ODBC connection?If unsure delete & create the connection again and use that to connect to the DB by Excel. |
 |
|
|
|
|
|
Problems changing data source for excel queries