restricted user error

  • 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

  • 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

  • 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 2 (of 2 total)

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