restricted user error

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Testing Center » SQL Server Security Skills » restricted user error

restricted user error

Rate Topic

Display Mode

Topic Options

Author

Message

pramodsalgaonkar

Posted Thursday, July 02, 2009 12:59 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, July 06, 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

John H Marsh

Posted Thursday, July 02, 2009 1:36 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, February 28, 2013 1:54 AM
Points: 1,325, Visits: 1,376

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

pramodsalgaonkar

Posted Thursday, July 02, 2009 10:02 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, July 06, 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 »

Permissions