SQL Error 4060 Server rejected the connection ACCESS to SQL Server 2008

• jplorey

  SSC Veteran

  Points: 278

  More actions

  January 31, 2012 at 1:01 pm

  #254597

  Have an application that needs to link to a table in SQL Server 2008 Express form ACCESS 2010 using following command:

  DoCmd.TransferDatabase acLink, "ODBC Database", "ODBC;Driver={SQL Server}; Server=salespos1\SQLExpress; Database=salesdb; Uid=sa;Pwd=kinetic", acTable, "Transaction_Table", "Transaction_Table"

  I get an "SQL Server error 4060

  Server rejected the connection: Access to the selected databse has been denied."

  I can ping the server by name and IP address, and I can get to the database using SQL Server Management Studio. Been tryng to solve this for a month. Been all over connection strins etc.

  Any help would be greatly appreciated.

  Thanks

  jpl

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  January 31, 2012 at 1:48 pm

  #1440954

  Did you really post your sa password on a public forum? If so, you need to change it now.

• jplorey

  SSC Veteran

  Points: 278

  More actions

  January 31, 2012 at 2:19 pm

  #1440965

  That and other things were changed to protect the innocent.

  jpl