Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

restricted user error Expand / Collapse
Author
Message
Posted Thursday, July 2, 2009 12:59 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 6, 2009 12:11 AM
Points: 2, Visits: 22
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
Post #746022
Posted Thursday, July 2, 2009 1:36 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, April 22, 2014 6:56 AM
Points: 1,330, Visits: 1,434
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
Post #746035
Posted Thursday, July 2, 2009 10:02 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 6, 2009 12:11 AM
Points: 2, Visits: 22
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
Post #746759
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse