Post reply

Need Help in Configuring SQL Server 2005 Standard Edition.

  • January 3, 2007 at 12:21 am

    #171428

    Login failed for user ''. The user is not associated with a trusted SQL Server Connection.

    Ive got this error... I have just installed the SQL Server 2005 Standard Edition. Could anyone encounter and solve this problem.. please til me how to solve this. I google this but couldnt find a reliable solution for this..

    Thanx...!

  • January 3, 2007 at 6:36 am

    #680945

    are you trying to log in as sa or a sql id and it's still only windows security?

  • January 7, 2007 at 10:23 pm

    #681695

    Hello SQL Noob,

    Yes i was trying to log in as 'sa'.

  • January 7, 2007 at 10:33 pm

    #681697

    I think your sql server is using windows authentication only...

    I think you need to change to mixed authentication..

    Windows Authentication mode is the default security mode after a typical installation of SQL Server 2000 or of SQL Server 2005

    http://support.microsoft.com/kb/269587

     

    MohammedU
    Microsoft SQL Server MVP

  • January 7, 2007 at 11:38 pm

    #681706

    yes change your authentication mechanism to mixed mode. Please do the below to change that.

    1. Open enterprise manager

    2. browse to the server and right click properties

    3. move to security tab and change the authentication mode there

    thats all you are done with.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • January 7, 2007 at 11:48 pm

    #681709

    Thanx a lot guys.... Ive been getting knowledge from you... Thanks for the help and hints..

  • January 8, 2007 at 1:02 am

    #681717

    this was the old version. I think this configuration is for SQL 2000. ANyways, Thanks....!

  • January 8, 2007 at 2:36 am

    #681724

    Hello, I initially solve the 2nd part of the error. Now, when i run a test, it now says "Login failed for user 'sa'". What would I do next? Thanks....

  • January 8, 2007 at 11:34 pm

    #681946

    login with a windows account that has sysadmin privilege and change the password for the user sa and then use the new password that u have given. this should work.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • January 9, 2007 at 1:32 am

    #681965

    'sa' is also a member of sysadmin right?...... Do i have to log using Windows Authentication?

  • January 11, 2007 at 11:33 pm

    #682816

    Villeta, yes of course login with a windows account with sysadmin privilege and change the password for 'sa'. my last post also said the same.

     

    "login with a windows account that has sysadmin privilege and change the password for the user sa and then use the new password that u have given. this should work"

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • January 11, 2007 at 11:54 pm

    #682820

    Thanks for the hints guys...! Ive already configured my Server.. The problem is not on the sa account coz whenever I log my SQL to the SQL of other PC, I can access it. I figured it in my registry settings of the server. Thanks a lot guys..

    Also "Sugesh Kumar"-- 'sa' has a sysadmin privilege, so basically I can change its password right? without logging in with another user.

  • January 14, 2007 at 8:23 am

    #683122

    yes of course sa is with sysadmin privilege i thought that u had lost ur sa password and wanted to reset the same. if so u can login with windows aacoount with sa privilege and reset ur password for sa.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

Viewing 13 posts - 1 through 12 (of 12 total)

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