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 |
|
muralidaran_r
Starting Member
13 Posts |
 Posted - 2008-07-18 : 01:30:33
|
| Hi allWe have developed a product using sql server 2005 express/standard as backend. We are selling to various customers. We dont want to give access to view are modify Tables,SPs and design.After installing SQL server, I am running a sql script to modify SA user and to create new application user names with password and we pack this part as MSI files.I want to restrict windows authentication. the databases should be only accessed thru Applications.Please Help to do this. |
|
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
Posted - 2008-07-18 : 02:21:17
|
| Will removing any system accounts do the trick? eg BUILTIN\Administrators |
 |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2008-07-18 : 03:13:40
|
| You can create SP's "with encryption" to hide their contents. MAKE SURE however you are using a "source control" system so that you can have a private copy saved in readable text.I don't think customers however would appreciate you requiring them to remove "BUILTIN\ADMINistrators" automatically in order to use your software. There may be a good reason to do so.....but it should be a local business "choice". |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-18 : 09:43:47
|
quote:
Originally posted by muralidaran_r
Hi allWe have developed a product using sql server 2005 express/standard as backend. We are selling to various customers. We dont want to give access to view are modify Tables,SPs and design.After installing SQL server, I am running a sql script to modify SA user and to create new application user names with password and we pack this part as MSI files.I want to restrict windows authentication. the databases should be only accessed thru Applications.Please Help to do this.
Learn about Encryption in SQL 2005. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-19 : 01:06:24
|
| >> Will removing any system accounts do the trick? You can't remove sql service account. |
|
|
|
|
|
|
Restrict windows authentication