Post reply

Cannot login to SQL Server with the SQL authentication

  • May 13, 2008 at 10:49 am

    #186478

    I've been setting users for SQL servers for a year and this is the first time happened to me.

    I am trying to set a new login/password/user with SQL server authentication on a new server.

    I set up a fresh test database, new login and user for that database. I don't get any error, just confirmation that user was created OK.

    After I disconnect and try to connect again to the SQL Server with the SQL server authentication using this user/password, I get an error that user is not associated with the trusted SQL server connection. User name and password are correct.

    I do the same thing on an old server and everything works fine.

    I checked Surface Area configuration, remote connections are set to allow local and remote connections.

    What can be the reason that SQL server users do not work?

  • May 13, 2008 at 11:08 am

    #814680

    are you using local accounts or ad logins?

  • May 13, 2008 at 11:48 am

    #814708

    I am SMART!

    I found that SQL server should be set to the mixed authentication mode.

    Right click on server name, properties, security, set to mixed authentication mode, no only windows.

  • May 13, 2008 at 1:40 pm

    #814763

    not talking about that i was wondering if your windows authentication is just local to some user accounts on your database machine or remote to some ad controller

  • May 15, 2008 at 2:26 pm

    #816135

    can u connect to the server using any other windows login,

    means u r having this problem with any windows login or just this specifice one.

    ..>>..

    MobashA

  • December 17, 2011 at 1:31 am

    #1422796

    I have got the same problem as well

    When I connect using the username/password in SQLServer Management Studio it works fine

    When I use the same username/password in an app to connect to the server I get the error message

    SqlConnection connection = new SqlConnection ("server=localhost; uid=test; pwd=test; database=test");

    connection.Open();

    I have the server configured for mixed mode authentication

    Any help would be appreciated.

  • December 17, 2011 at 1:46 am

    #1422798

    Please don’t hijack the thread. Start a new thread for your problem. We will try to provide a solution.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply