I am using sqlserver 2005 i want to implement security on database that no user can open my database with window authentication. How can i set other password for my newer database.
Thanks in advance.
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Pardeep MalikPosted May 1, 2012, 7:18 AM
but i think sql is more secure. i have publish a website on private server and upload my database there. Is any one can open my database on that server? Elaborate it for me thanx in advance.
Pardeep Malik
Christofel HakimPosted Jan 16, 2012, 4:11 AM
To Set another password of your database:
GoTo SQL server management studio and login with sys admin account:
[Database Server Name] -> Security -> Logins.
You can add, remove or modified SQL Server logins in this module.