Connection error to a database in SQL Server 2000

• Rushdi Basir

  SSChasing Mays

  Points: 653

  More actions

  June 14, 2006 at 12:20 pm

  #90225

  Hi,

  We are using DSN-less ODBC tables in MS Access  to connect to SQL Server (using windows authentication). One of our user is getting an error "Server rejected the connection. Access to selected database has been denied" for 2 of our databases. It works fine for other databases. Only change happened recently is a domain-name migration for the users, but only this user is having the problem for certain databases.

  Any help would be appreciated.

  Thanks,

  R

• June 19, 2006 at 8:00 am

  This was removed by the editor as SPAM

• SQLBill

  SSC Guru

  Points: 51440

  More actions

  June 19, 2006 at 8:48 am

  #644630

  Check to see that they have permission to access the databases.

  -SQLBill