Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Posts
    12

    Unanswered: IIS SQL Server connection error (urgent)

    I keep getting this error when I try to connect to my SQL Server DB

    Microsoft OLE DB Provider for SQL Server (0x80004005)
    Login failed for user 'Administrator'. Reason: Not associated with a trusted SQL Server connection.

    when I installed SQL Server I set username and password to windows default which is Administrator and no password

    the asp files are on IIS (localhost)

    connstr = "Provider=SQLOLEDB;" &_
    "Data Source=(local);" &_
    "Initial Catalog=ShotWatcher;"&_
    "User ID=Administrator;"&_
    "Password="

    shouldn't this work?

    Please Help

    Justin

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Do you have a SQL Server Standard account called Administrator? Or you're trying to use Windows account with the same name? If it's the latter, - remove User ID and Password attributes and replace them with Integrated Security=SSPI.

  3. #3
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    And in connection string you should specify TRUSTED_CONNECTION=TRUE and try using servername instead of specifying local.

    KBA to more about it.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  4. #4
    Join Date
    Mar 2004
    Posts
    12
    i'll try that, thx

Posting Permissions

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