SQL Server Error: 4060 
Author Message
 SQL Server Error: 4060

i preface this message with apologies.  i'm not someone who uses
access very often, and i'm only an SQL dba on a fundamental level.
here's my situation:

an ms access database was created by an individual in my company,
since retired.  this database contains a macro that runs several
queries.  the primary function being to connect to an existing SQL
database, retrieve specific pieces of data, and update the ms access
database.

the SQL database has been migrated from SQL7 to SQL2k.
in the process, the database instance and database name were changed.

when you run the ms access macro, a dialogue window pops up.
contains...

Data Source:   DATABASE
Login:         loginname
Password:      [blank]

enter the password, receive following error...

SQLState: '08004'
SQL Server Error: 4060
Server rejected the connection; Access to selected database has been
denied.

have successfully created an ODBC connection to DATABASE, using SQL
authentication and 'loginname'.  connection tests ok.

am able to log into SQL database using query analyzer and 'loginname'.

'loginname' has LOGIN to database and rights to database.

and that's where i'm stuck.
not being an access person, i can't find where in the queries that it
selects its data source.  i don't even know if that's the root of the
issue.  my only assumption is that since the queries are getting the
data source from somewhere, they may also be assuming a database name
that no longer exists.

i'm not going to be able to re-create the ms access database, the
queries, or the macro... but i think i can redirect what's already
here.

any help is greatly appreciated.



Tue, 02 Aug 2005 19:27:51 GMT  
 SQL Server Error: 4060
The connection string rarely (almost never) appears directly in a saved
query. More frequently it is in the table properties and requires relinking
(Tools ... Database Utilities ... Linked Table Manager) or directly in code.
It's difficult to guess, but I'd first try looking for connection strings in
macros or modules.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access


Quote:
> i preface this message with apologies.  i'm not someone who uses
> access very often, and i'm only an SQL dba on a fundamental level.
> here's my situation:

> an ms access database was created by an individual in my company,
> since retired.  this database contains a macro that runs several
> queries.  the primary function being to connect to an existing SQL
> database, retrieve specific pieces of data, and update the ms access
> database.

> the SQL database has been migrated from SQL7 to SQL2k.
> in the process, the database instance and database name were changed.

> when you run the ms access macro, a dialogue window pops up.
> contains...

> Data Source:   DATABASE
> Login:         loginname
> Password:      [blank]

> enter the password, receive following error...

> SQLState: '08004'
> SQL Server Error: 4060
> Server rejected the connection; Access to selected database has been
> denied.

> have successfully created an ODBC connection to DATABASE, using SQL
> authentication and 'loginname'.  connection tests ok.

> am able to log into SQL database using query analyzer and 'loginname'.

> 'loginname' has LOGIN to database and rights to database.

> and that's where i'm stuck.
> not being an access person, i can't find where in the queries that it
> selects its data source.  i don't even know if that's the root of the
> issue.  my only assumption is that since the queries are getting the
> data source from somewhere, they may also be assuming a database name
> that no longer exists.

> i'm not going to be able to re-create the ms access database, the
> queries, or the macro... but i think i can redirect what's already
> here.

> any help is greatly appreciated.

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.455 / Virus Database: 255 - Release Date: 2/13/2003


Wed, 03 Aug 2005 14:37:48 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Acc2k adp/SQL serverv7: trapping SQL server errors

2. Acc2k adp/SQL serverv7: trapping SQL server errors

3. Accessing SQL SERVER Database without SQL server installed

4. sql server connect. Migration Access->sql server

5. access and sql-server: realtion in db / was german posting: sql-server und datenbankbeziehungen

6. Accessing SQL SERVER Database without SQL server installed

7. Accessing SQL SERVER Database without SQL server installed

8. Access to SQL server - ISAM error -Macro error

9. System Error 126 SQL Server ODBC Error

10. Import Data into SQL Server from Excel error


 
Powered by phpBB® Forum Software © phpBB Group