Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2003
    Posts
    21

    Unanswered: ADO Connection Failing

    Error:
    Microsoft OLE DB Provider for SQL Server error '80040e4d'
    Login failed for user 'administrator'.
    /ssconn.asp, line 12


    Code:
    oConn.Open "Provider=sqloledb;" & _
    "Network Library=DBMSSOCN;" & _
    "Data Source=198.107.136.50,1433;" & _
    "Initial Catalog=GradeTrax;" & _
    "User ID=administrator;" & _
    "Password=password"

    Your much wanted advice:

  2. #2
    Join Date
    Jul 2003
    Location
    SoCal
    Posts
    721
    Usually there isn't an "administrator" account in SQL Server. The default admin account is called "sa". Unless you created an account named "administrator", you won't be able to connect. Secondly, are you positive "password" is the password for that account?
    That which does not kill me postpones the inevitable.

  3. #3
    Join Date
    Mar 2003
    Posts
    21
    where do I manage this account, all I see is dba.

  4. #4
    Join Date
    Jul 2003
    Location
    SoCal
    Posts
    721
    Enterprise Manager > Console Root > Microsoft SQL Servers > (Your SQL Server Group) > (Your Database) > Security > Logins
    That which does not kill me postpones the inevitable.

  5. #5
    Join Date
    Mar 2003
    Posts
    21
    thanks dude, I made it in. What's the best way to get up to speed quickly with SQL Server? I'm well versed in Access but I'm ready for the next level up.

Posting Permissions

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