Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2003
    Posts
    3

    Unanswered: Not associated with a trusted SQL Server connection

    I installed Microsoft SQL Server 2000. And I'm trying to connect to my database, but no matter what I do, I get the following message:

    Login failed for user 'me'. Reason: Not associated with a trusted SQL Server connection.

    Can anyone help me!???

  2. #2
    Join Date
    Oct 2002
    Posts
    369

    Question Re: Not associated with a trusted SQL Server connection

    RE:
    Q1 I installed Microsoft SQL Server 2000. And I'm trying to connect to my database, but no matter what I do, I get the following message: Login failed for user 'me'. Reason: Not associated with a trusted SQL Server connection. Can anyone help me!???

    A1 Maybe.

    Some things to consider and / or check may include:

    Are Sql Services running? Is server security configured for Sql Server and Windows or Windows (only) authentication?

    Is the server on a domain?

    Is the accessing workstation on the domain?

    Is me an account in the domain or is me a workstation account?

    Is me a windows account or a standard sql server login account - to check for the existance of a Me login see (EM --> Security --> Logins: If me exists there, does it show the account as using windows or sql server authentication) ?

    Does the me login have Database Access enabled for the desired databases?

    {More detatiled information (including what has been attempted, etc.), makes it easier to provide more useful / helpful feedback.}

  3. #3
    Join Date
    Jan 2003
    Posts
    3

    Re: Not associated with a trusted SQL Server connection

    Yes Sql server is running. And server security is configured for Windows authentication only.

    No I don't believe the server is on a domain, and neighter the accessing workstation.

    I believe Me is a worksation account.

    Me is a standard sql server login account, and the account is using a sql server authentication.

    And yes, the me login has Database Access enabled for the desired databases.

    Thanks!

    Originally posted by DBA
    RE:
    Q1 I installed Microsoft SQL Server 2000. And I'm trying to connect to my database, but no matter what I do, I get the following message: Login failed for user 'me'. Reason: Not associated with a trusted SQL Server connection. Can anyone help me!???

    A1 Maybe.

    Some things to consider and / or check may include:

    Are Sql Services running? Is server security configured for Sql Server and Windows or Windows (only) authentication?

    Is the server on a domain?

    Is the accessing workstation on the domain?

    Is me an account in the domain or is me a workstation account?

    Is me a windows account or a standard sql server login account - to check for the existance of a Me login see (EM --> Security --> Logins: If me exists there, does it show the account as using windows or sql server authentication) ?

    Does the me login have Database Access enabled for the desired databases?

    {More detatiled information (including what has been attempted, etc.), makes it easier to provide more useful / helpful feedback.}

  4. #4
    Join Date
    Dec 2002
    Location
    Czech Republic
    Posts
    249

    Re: Not associated with a trusted SQL Server connection

    ...server security is configured for Windows authentication only...
    So you cannot use sql server authentication.

  5. #5
    Join Date
    Feb 2002
    Posts
    2,232
    Well, you answered your own question when you responded to DBA saying 'And server security is configured for Windows authentication only.' - Right click the server and click on properties. Choose the security tab and select 'SQL Server and Windows' for authentification if you need to use sql authentification.

  6. #6
    Join Date
    Jan 2003
    Posts
    3
    Thanks guys I figured it out too:-)

    Originally posted by rnealejr
    Well, you answered your own question when you responded to DBA saying 'And server security is configured for Windows authentication only.' - Right click the server and click on properties. Choose the security tab and select 'SQL Server and Windows' for authentification if you need to use sql authentification.

Posting Permissions

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