Forcing SQL delete SA user, and create a new user

  • I have a database, i protect it by deleting user SA in sql server. After that i create new user with sa premission. So no body can enter my database with user sa.

    But if you reinstall sql server, user sa will be create, that cause you can enter my database without permission. I don't know how to do.

    In my mind had an idea. When some one import my database to their sql system. There is an procsdure in my database force sql server delete user sa first, create new user with sa premission in the second, and third import database.

    please so me how to do that

  • Why go through all that trouble? Just give SA a secure password.

    -Bill

  • And use oddball characters as this makes the hash encryption crack a less likely to succeed.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • I agree that a password should be created. We delete sa? Doesn't make sense.

    Steve Jones

    sjones@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/sjones

Viewing 4 posts - 1 through 3 (of 3 total)

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