December 13, 2011 at 9:31 pm
How to set passward of database in SQLSERVER 2008 so when ever in any Mode Authentication/Mixed Mode user try to go in database it asks for passward
When backup taken and restoration of database take place it also
should ask passward
is it possible in sqlserver 2008?
December 13, 2011 at 9:39 pm
I am not sure what you intend to ask. From what I could understand about your requirement, it is not an option available in SQL Server. SQL Server asks for Authentication info when the user tries to connect to the server (assuming the user is coming from SSMS), then everytime the user does something on that instance of SQL Server, it will not ask password to enter..
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 13, 2011 at 11:54 pm
There is no Such option, We have to restrict user @ Login level.
December 14, 2011 at 12:30 am
How to set passward of database in SQLSERVER 2008 so when ever in any Mode Authentication/Mixed Mode user try to go in database it asks for passward
SSMS will ask only once for SQL Logins at the time of connection. It won't ask for password for Windows Logins.
When backup taken and restoration of database take place it also should ask passward
SQL Server will not ask for password for backups. BUT in backups if you have provided password SQL Server will expect it at the time of restore. Please mind it Backup passwords are independent of Login passwords.
Now I have few questions. What exactly you want to achieve? What are your security requirements? Are these questions for knowledge update or you having any requirements?
December 14, 2011 at 2:32 am
My Problem was :
1 : No user/dba can access to database SQLSERVER without passward
2 : User/dba should not enter into database by Windows Authentication
3: No User can restore it on any other server
ANSWERS :
1 : NOT CLEAR
2 : IF I DELETE NT USER THEN USER NOT ENTER BY WINDOWS AUTHENTICATION ( NEED SUGGESTION AM I RIGHT)
3 : ANSWER OK
December 14, 2011 at 2:45 am
1 : No user/dba can access to database SQLSERVER without passward
disable / drop windows login (in SQL Server)
2 : User/dba should not enter into database by Windows Authentication
same as above.
3: No User can restore it on any other server
Grant permissions to limited users. Enable TDE, it requires Certificate to be restored in order to get access to database.
BTW Restoring Database on others servers is sometimes required. Rethink on this requirement.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply