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 |
|
coder
Starting Member
16 Posts |
 Posted - 2007-08-12 : 08:37:40
|
| Hi, I have a database app that deploys with sql 2005 express to each end-user. I would like to install sql 2005 express using Windows Authentication only. In this case, should I bother to set an sa password? And if I do set the sa password, how would I go about making sure that the sa password is different for every installation of sql express? Would it be recommended to save every end-user's sa password (possibly tens of thousands of passwords) just in case sql maintenance needs to be done on their computer? Any help would be greatly appreciated. Thanks! |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-08-12 : 09:28:19
|
As a local admin on windows, you can get access to the sql server express anyway and change the sa password.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
coder
Starting Member
16 Posts |
Posted - 2007-08-12 : 10:23:06
|
Hi Peso, Thanks for the info. =) How does the local admin change the sa password? Is there any easy way? Thanks!quote:
Originally posted by Peso
As a local admin on windows, you can get access to the sql server express anyway and change the sa password.
E 12°55'05.25"N 56°04'39.16"
|
|
|
|
askben
Starting Member
8 Posts |
Posted - 2007-08-12 : 10:28:36
|
| You can use sp_password.sp_password 'old_password', 'new_password', 'login'sp_password [ [ @old = ] 'old_password' , ] { [ @new =] 'new_password' } [ , [ @loginame = ] 'login' ]------------Ben Miller |
|
|
|
coder
Starting Member
16 Posts |
Posted - 2007-08-12 : 11:03:55
|
Hi, Thanks for the sp. I was wondering if it's necessary to specify an sa password at all? I know that by the book you're supposed to do it for msde, but is this necessary or recommended for sql2005 even if you are using Windows Authentication? Thanks!quote:
Originally posted by askben
You can use sp_password.sp_password 'old_password', 'new_password', 'login'sp_password [ [ @old = ] 'old_password' , ] { [ @new =] 'new_password' } [ , [ @loginame = ] 'login' ]------------Ben Miller
|
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-12 : 12:02:05
|
| Still need to set sa password since you can easily enable sql authentication by modifing registry. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-08-12 : 14:47:18
|
Or use SSMS (as local admin on windows) to change password for SA account, without having to know the old password.Also, I am not convinced customers like software to be installed on their machines without knowing the "master" password.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
|
|
|
|
|
sa password recommended for end user?