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 |
|
bubberz
Constraint Violating Yak Guru
289 Posts |
 Posted - 2006-07-12 : 13:19:52
|
| Hello!I'm trying to figure out how to store the username/password for each of our 16 different database for our web app.The server admin has already created a sample entry with the aspnet_setreg tool to the Northwind db on our SQL server.My question is how do I go through and enter the 16 different username/password combos for the 16 dbs since right now there are already username and password keys for this Northwind db?Would it be like:aspnet_setreg -k:"SOFTWARE\FirstTier\DotNet\Security\ASPNET_SETREG" -c:server=mysrvr;uid=uid1234;pwd=pwd1234;database=db1aspnet_setreg -k:"SOFTWARE\FirstTier\DotNet\Security\ASPNET_SETREG" -c:server=mysrvr;uid=uid1234;pwd=pwd1234;database=db2aspnet_setreg -k:"SOFTWARE\FirstTier\DotNet\Security\ASPNET_SETREG" -c:server=mysrvr;uid=uid1234;pwd=pwd1234;database=db3..etcThanks! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-07-12 : 13:28:37
|
| Since this is ASP.NET, wouldn't you store the connection strings in a config file?Tara Kizeraka tduggan |
 |
|
|
|
|
|
username / pswd via aspnet_setreg tool