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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 DSN from Access not working after domain change

Author  Topic 

chapm4
Yak Posting Veteran

58 Posts

Posted - 2013-01-29 : 14:02:05
Have a sql2008 server. There is an Access app that is used from lab computers to send data to the sql server. Started having issues 3 weeks ago with timeouts. Pings from and to the box showed the same thing. When I looked at server this morning saw it was on workgroup and not joined to the domain as all other pc's in plant are. I joined it to the domain and now the dsn's from the lab are not working. Errors showing it cannot connect to the database. Still using the same sql account.

Any ideas? We have tried setting up new dsn's but doesn't work.

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2013-01-30 : 08:29:11
Have you check the DSN details - confirm they are correct.?
Some other ideas in : http://www.sqlserver-dba.com/2012/05/cannot-connect-to-sql-server.html

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -