RE: Block Users from using sql server query analyzer

SSC Guru

Points: 323504

January 28, 2010 at 7:16 am

Lynn is so right; nothing should be using the 'sa' account. seems like you might be a little new to SQL, and that's why you are using sa for your web site; it's actually a trivial thing to create a new user and assign the permissions to the database your website will use.

locking the user 'sa' out of the ability to use management tools would most likely effectively lock YOU out of the database as well.

do you need a GUI or script example on how to create a login and a user, and then assign permissions?

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!