SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

JohnBGood
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???

behrman
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  
 New 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.12 seconds. Powered By: Snitz Forums 2000