Why doesn't my DSN work - SQL Server Forums

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

SQL Server 2005 Forums

SQL Server Administration (2005)

Why doesn't my DSN work

Author

Topic

JohnBGood
Starting Member

48 Posts

Posted - 2010-01-07 : 10:45:15

I successfuly restored a customer's database onto my Database server. I'm logged into the machine as a domain admin and sql server admin.

Within Enterprise Manager I have full rights on this database. I set up a DSN that points to the database (user is SA) and I have a MS Access 2007 application with linked tables that points to the DSN.

When I try to refresh my table in Access, i get this error

"Connection Failed: SQLSTate: '08004'
SQL Server Error: 4060
Server rejected the connection; Access to selected database has been denied."

I started a SQL profile and sure enough I see a "login Failed for user 'sa'

What gives???

behrman
Yak Posting Veteran

76 Posts

Posted - 2010-01-09 : 12:00:10

The file is an MDB. I have tried the following:

Take the current SQL database offline
Open the MDB and select the linked table manager
Select a table and click OK
I then get a Connection Failed SQLState 08004 SQL Server Error 4060 error
Click OK and I then get an SQL server login window.
I select the new server and click OK.
I get a message telling me that All selected linked tables were refreshed.
If I then double click the linked table I get an error that the connection
to the original server has failed.

What I would really like is to simply link the tables via an ODBC source
that I define via the control panel.

RAQ Report: Web-based Excel-like Java reporting tool

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources