Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Why doesn't my DSN work
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

48 Posts

Posted - 01/07/2010 :  10:45:15  Show Profile  Reply with Quote
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???

Yak Posting Veteran

76 Posts

Posted - 01/09/2010 :  12:00:10  Show Profile  Visit behrman's Homepage  Reply with Quote
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000