InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 17:20:58 GMT20http://www.sqlservercentral.com/Forums/Topic746022-119-1.aspxwhen 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 serverserver msg 18456, level 16, state 1Thu, 02 Jul 2009 22:02:38 GMTpramodsalgaonkarhttp://www.sqlservercentral.com/Forums/Topic746022-119-1.aspxHello,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 MarshThu, 02 Jul 2009 01:36:49 GMTJohn H Marsh http://www.sqlservercentral.com/Forums/Topic746022-119-1.aspxi 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 serverserver: msg 18456, level 16, state 1 login failed for user please helpThu, 02 Jul 2009 00:59:48 GMTpramodsalgaonkar