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 |
|
Cruiser859
Starting Member
45 Posts |
 Posted - 2005-06-17 : 11:20:52
|
| HiI am trying to install service pack 4 MSDE on a Windows XP Pro for production purposes.When I go to cmd and type the setup commend it tells me I must install windows applications from the control panel. But when I go to the control panel to install it it tells me this:A strong SA password is required for security reasons. Please use SAPWD switch to supply the same. How do I use a SA password if I can't create it through the cmd string?Thanks |
|
|
Help Desk
Starting Member
10 Posts |
Posted - 2005-06-23 : 15:10:39
|
| You shouldn't have to install this from the control panel. The only time when you might have to is when you are running Terminal Services or Citrix.Regardless, you can setup all this information in an INI file. MS's site should have more about it.www.dotdesk.com Help Desk |
 |
|
|
sbt1
Yak Posting Veteran
89 Posts |
Posted - 2005-07-11 : 12:38:54
|
| although you get the error message, it still installs ok.To change the password, open a command prompt window, and type:osql -U sa -P (enter)1>sp_password @old=null, @new='newpassword', @loginame='sa' (enter)2>go (enter)note how loginame is spelled, it's NOT loginname.hth |
|
|
|
|
|
|
Installing MSDE on XP PRO