Error in connection with remote Sql Enterprise manager

• Jignesh-226311

  SSC Veteran

  Points: 216

  More actions

  August 9, 2005 at 1:47 am

  #165552

  Hi All,

  I am working on one site where I am using MS-Access as the backend. Now, I have to convert database from Access to SQL Server. I had sucessfully transfered local access database in my local SQL server by DTS Import/Export Wizard. But When I try to connect to the remote SQL server, it gives me error message as "SQL Server does not exists or Access denied".

  With the suggestions from the hosting company, I had installed Service Pack 3a but still the connection problem continues.

  Can any one please help me to sort the problem out.

  Thanks in advance,

  Regards,

  Jigs

• Joseph Fallon

  SSCommitted

  Points: 1669

  More actions

  August 10, 2005 at 2:56 am

  #580941

  Make sure you have a login on the remote server (you'll have to get someone to check this for you).