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 |
|
wumpus33
Starting Member
1 Post |
 Posted - 2010-02-19 : 10:27:46
|
| Hi.We have Windows XP, Access 2003.We use an Access Frontend to connect to an SQL Server (Windows Server 2003).We use a System DSN on the client (with a named Pipe) to connect to our Server named TRS30.Now, due to a network redesign we had to change the IP Address of the SQL Server to something new.And now we have a connection Issue, if I start my Access frontend it says: Error on ConnectionSQL State 01000SQL Server Error 10061ConnectionOpen (Connect())SQL State 08001SQL Server Error: 17Microsoft-OBDC SQL Server Driver TCP/IP Sockets SQL Server does not exist or denied Access.The thing is, when i try the TEST Connection from the OBDC Control Panel, I use a System DSN Named Pipes connection and the test says TEST SUCESSFULLY.When I ping my sql server TRS30 I get the right, new ip address back.The SQL Server process is running ok and it is listening on Port 445 correctly (I did a port scan).I did not write the Access Database Frontend file.Do I need to change something in the Access DB file itself as well?Surely if the Test connection works it should work? To no avail, when I open my access db file, I get the failure connection message.Any ideas please?the wumpus |
|
|
DaleTurley
Yak Posting Veteran
76 Posts |
Posted - 2010-02-19 : 10:54:24
|
| What result does SELECT @@SERVERNAME produce on the SQL Server? |
 |
|
|
subhash chandra
Starting Member
40 Posts |
Posted - 2010-02-21 : 06:50:54
|
| Open the Linked Table Manager in Database Tools menu and then update all linkes. This will refresh all table links with new connection settings.Regards,Subhash Chandrahttp://SQLReality.com/blog/ |
|
|
|
|
|
|
Connection Issue