Can i Protect my Database in Ms-Sql by a Password like in Ms-Access?

[r_mohd]

hi all, can some one help me to protect my database with a strong password like we protected our db in ms access. thanks.

rmshah Developer

[Ashfield]

You can't. SQL Server does not work like that. Take a look at authentication in BOL.

Bob Ashfield Consultants Ltd

[gzali]

i think you can protect your database by right clicking on register server then change sa password,now when someone trying to open database it pop up for password window.

Ghazanfar Ali Programmar (MSTS,MCPD)