Interested to Buy Any Domain ? << Click Here >> for more details...
How To Make password Protected SQL Server 2005 Database
i.e when i open SQL Server database then ask for password.
- 1 Answers
- 5586 Views
- I also Faced
- E-Mail Answers
To some extent what you can/should do to restrict direct
access depends on you application and deployment
requirements, and what type of direct access you are trying
to prevent. For instance, if you are sole administrator of
all machines that the app will be deployed on, you may be
able to restrict access by locking down the SA password and
dissallowing access to the DB files via the filesystem.
If, on the other hand, you are not the admin, it will be
pretty much impossible to completely block direct access
against a determined admin. The databases can always be
copied via the filesystem to another machine with a useable
SA account.
Even if you are not the admin of the machine, there are
some things you can do to avoid casual access outside of
the app itself. Here is an article that talks about
securing your connection string:
http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/dnnetsec/html/THCMCh14.asp
You can also use an application role for server-side
permissions. See:
http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/adminsql/ad_security_89ir.asp
| Is This Answer Correct ? | 5 Yes | 2 No |
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
What are sparse columns?
How many full-text indexes can a table have?
what's the maximum size of a row? : Sql server database administration
What is difference between inner join and join?
WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN SQL SERVER?
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
How can you insert null values in a column while inserting the data?
Is port 1433 secure?
What is the difference between TRUNCATE and DROP?
After recovering the database by using tail log backup.How to verify the data has been sucessfully restored or not.?
What do you mean by an execution plan? Why is it used?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
