restricted user error

  • pramodsalgaonkar

    SSC Enthusiast

    Points: 140

    i have installed sql server 2005 personal on win xp sp2 local system as admin user and want 2 use sql server for restricted user , but it is giving an error

    sql query analyser

    unable to connect to server

    server: msg 18456, level 16, state 1

    login failed for user

    please help

  • John H Marsh

    SSChampion

    Points: 11671

    Hello,

    Could you please check the SQL Server Log for a corresponding error and post it? In particular you should get a more meaningful value for “State”.

    Regards,

    John Marsh

    www.sql.lu
    SQL Server Luxembourg User Group

  • pramodsalgaonkar

    SSC Enthusiast

    Points: 140

    when i log in as restricted user on taskbar server starts but when i go to start--> microsoft sel server -> query analyser a dialog appears and when i select windows authentification it gives the error

    unable to connect to server

    server msg 18456, level 16, state 1

Viewing 3 posts - 1 through 3 (of 3 total)

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