#1
  1. .DOTTY
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2002
    Location
    London
    Posts
    206
    Rep Power
    12

    MS SQL connection problems


    When connecting to a local SQL Server 2000 installation via php 4.3.3 on a Windows Server 2003 machine I get the following error:

    Code:
    Warning: mssql_connect(): message: Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection. (severity 14)
    Can anyone enlighten me as to what's wrong?
    Team Phoenix Rising - All Your Distributed Computing Are Belong To Us!

    "Whoever fights monsters should see to it that in the process he does not become a monster."
    - Friedrich Nietzsche
    .
  2. #2
  3. PHP Rocker
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2003
    Posts
    213
    Rep Power
    11
    search www.mysql.com ??
  4. #3
  5. Moderator Emeritus
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2002
    Location
    Austin, TX
    Posts
    7,186
    Rep Power
    2265
    Originally posted by PunkGo
    search www.mysql.com ??
    Except, he's using MS SQL, not MySQL.

    Is it possible you have the wrong port? Wrong username? Wrong password?
    DrGroove, Devshed Moderator | New to Devshed? Read the User Guide | Connect with me on LinkedIn
  6. #4
  7. No Profile Picture
    The Linux-Girl
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2001
    Posts
    396
    Rep Power
    13
    It's a security level in SQL ..
    You need to make sure that Authentication Level is not set just for Windows, make sure it includes SQL Server as well.
  8. #5
  9. Moderator Emeritus
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2002
    Location
    Austin, TX
    Posts
    7,186
    Rep Power
    2265
    Moved to the MS SQL forum from PHP, as the issue lie mainly in an MS SQL configuration, not the method being employed to connect to the DB from PHP.

    Good luck finding a solution...
    DrGroove, Devshed Moderator | New to Devshed? Read the User Guide | Connect with me on LinkedIn
  10. #6
  11. .DOTTY
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2002
    Location
    London
    Posts
    206
    Rep Power
    12
    Originally posted by PunkGo
    search www.mysql.com ??
    LOL! Very useful, cheers.

    Originally posted by Kaleina
    It's a security level in SQL ..
    You need to make sure that Authentication Level is not set just for Windows, make sure it includes SQL Server as well.
    Ah, great. Thanks.

    Regards,
    Matt.
    Team Phoenix Rising - All Your Distributed Computing Are Belong To Us!

    "Whoever fights monsters should see to it that in the process he does not become a monster."
    - Friedrich Nietzsche
    .

IMN logo majestic logo threadwatch logo seochat tools logo