Can't connect to SQL via OLE DB

Results 1 to 2 of 2

Thread: Can't connect to SQL via OLE DB

  1. #1
    Svein Guest

    Default Can't connect to SQL via OLE DB

    Every time I try to connect to the SQL Server, I get this message:<BR><BR>Microsoft OLE DB Provider for SQL Server error &#039 80004005&#039 <BR><BR>Login failed for user &#039Svein&#039. Reason: Not associated with a trusted SQL Server connection. <BR><BR>I&#039m using this connection string:<BR>connectme.Open "Provider=SQLOLEDB; Data Source=sound01; Initial Catalog=sql; User ID=Svein; Password=xxxxxx"<BR><BR>Could it be due to that the web site is on drive E: and the SQL server on drive D:?<BR>-- In that case, how do I resolve this????<BR><BR>Any suggestion would be appreciated.<BR><BR>Svein

  2. #2
    Join Date
    Dec 1969

    Default RE: Can't connect to SQL via OLE DB

    It&#039s an issue with the *NT Domain user* not being trusted by the SQL datasbase or something along those lines. Are you incharge of the DB? If so, try setting up a new user in *SQL* and use that user in your connection string<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts