Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vedjha
Posting Yak Master
228 Posts |
 Posted - 2009-01-13 : 06:26:36
|
| hello, I m using SQL 2005, My client will use Database offline.I have created a user horizon for database "DB1". It is SQL Authentication. User id=hori1 and password =123 It runs successfully on Client's computer.If any technical person (not from our Organization) goes there and shut down the server from Enterprise Manager. Then They can easily copy Database and use it. so plz.. help me to make it more secure...Ved Prakash Jha |
|
|
vedjha
Posting Yak Master
228 Posts |
Posted - 2009-01-13 : 07:38:53
|
| it's urgent plz..........Ved Prakash Jha |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-01-13 : 07:40:01
|
See Books Online about encryption.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
vedjha
Posting Yak Master
228 Posts |
Posted - 2009-01-13 : 08:13:15
|
| plz give me link references...Ved Prakash Jha |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-13 : 09:05:10
|
| http://www.databasejournal.com/features/mssql/article.php/3483931/SQL-Server-2005-Security---Part-3-Encryption.htm |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-13 : 10:47:55
|
quote:
Originally posted by vedjha
hello, I m using SQL 2005, My client will use Database offline.I have created a user horizon for database "DB1". It is SQL Authentication. User id=hori1 and password =123 It runs successfully on Client's computer.If any technical person (not from our Organization) goes there and shut down the server from Enterprise Manager. Then They can easily copy Database and use it. so plz.. help me to make it more secure...Ved Prakash Jha
You can't shut down server from Enterprise Manager ,only stop services of SQL server if you are admin in box. |
|
|
|
|
|
|
Plz help me, respect of Sql security