View Single Post

   
  #4 (permalink)  
Old 02-29-2008, 07:09 AM
Simon Hayes
 
Posts: n/a
Default Re: Remote access to sql database...permissions

"Cannot open database requested in login 'TsHelpDesk'" suggests that
either the database doesn't exist, or the login you're using has no
access to it. You say you're connecting to a "remote" database, but the
connection string seems to be local - could that be the issue?

If not, I would check that the login you're using has been granted
access to the database with sp_grantdbaccess.

Simon

Reply With Quote