April 18, 2003 at 4:41 pm
installing the sp3 from "SQL2KDeskSP3.exe" downloaded from microsoft, i receive this error msg: "A strong SA password is required for .... Please use the SAPWD switch to supply the same...." Installation is terminated.
i want to install the desktop engine (i dont any in my machine).
hope you can help me, im just a newbie 🙂
AUXilliary COMmunication 1
April 19, 2003 at 7:00 am
If you already have MSDE installed, use any of the client tools to connect to it (isql, osql, isqlw) and execute the following query:
EXEC sp_password @loginame = 'sa', @new = '<password>'
Selecting a password in place of <password>. Then you should be able to apply the service pack. We found this was the easiest method on a couple of our MSDE installs. Keep in mind, you will need to log in as the equivalent of a sysadmin so far as MSDE is concerned (if the sa account doesn't have a password, use it).
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
April 19, 2003 at 1:45 pm
tnx for the reply...
i dnt have any previous msde installed and solve my own problem. i just use the command:
setup.exe blanksapwd=1
AUXilliary COMmunication 1
April 21, 2003 at 6:47 am
You need to set a strong password for the SA account!!!! That's why SP 3 requires it. If you do not give SA a password you are VERY vulnerable to the SLAMMER WORM!!!!!
-SQLBill
April 21, 2003 at 6:55 am
Just a clarification:
SQL Spida (SQL Snake, etc) and the worm before it hit blank sa passwords.
SQL Slammer goes after the SQL Server listener service on UDP/1434. It doesn't care about the sa account.
You want to set a password because by default MSDE is running under the context of LocalSystem. That's an account that has more privileges on the local box (when you add them all up) then even Administrator (or whatever you renamed it to).
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
April 21, 2003 at 7:50 am
thanx for informing me.
i already install msde w/ a blank password. it goes well. and its only for learning purposes.
now, i just want to get tutorials about msde. do u know some sites guys?
AUXilliary COMmunication 1
April 21, 2003 at 7:53 am
See my post above for setting the password after you've got it installed. This is something you will want to do, learning purposes or not.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
April 29, 2003 at 5:18 am
I'm having the exact same problem - can't install because I don't have an SA password. Where do I run this command from? Thanks!
quote:
tnx for the reply...i dnt have any previous msde installed and solve my own problem. i just use the command:
setup.exe blanksapwd=1
April 29, 2003 at 6:41 am
On the box itself, you can get a command-line interface by using osql.exe (isql.exe doesn't come part of MSDE). Alternately, you can access the box using Query Analyzer as you would any other SQL Server. Since you know the sa password is blank, logging in should be easy. Then just change the password using sp_password and you're set.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
April 29, 2003 at 7:29 am
Bosco,
Try setup.exe /upgradesp sqlrun blanksapwd=1 /l*v c:\msde2000_sp3.log
April 29, 2003 at 10:56 am
Tried: setup.exe /upgradesp sqlrun blanksapwd=1 /l*v c:\msde2000_sp3.log
- it gave me invalid command.
Tried: setup.exe blanksapwd=1 - installation proceeded without error but nothing shows up in start menu and web matrix project says I do not have sql server installed. also tried running osql.exe but got an error msg saying it wasn't a valid program (or something).
any other ideas?
quote:
Bosco,Try setup.exe /upgradesp sqlrun blanksapwd=1 /l*v c:\msde2000_sp3.log
April 29, 2003 at 11:14 am
When in doubt, go grab the SQL Server Critical Update tools to patch the MSDE. It works when the normal installs don't. We've had to use it on a couple of MSDE packages where I work. Everything else failed.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
April 29, 2003 at 11:54 am
Are you running standard MSDE or customized MSDE that comes from your verdor's application? What application is it?
April 29, 2003 at 12:48 pm
I'm trying to install: "SQL2KDeskSP3.exe" downloaded from microsoft. I used the installation instructions on microsoft's site and it installed without error but does not show up in start menu and does not work within Web Matrix Project (new web development tool by MS to develop asp.net).
quote:
Are you running standard MSDE or customized MSDE that comes from your verdor's application? What application is it?
April 29, 2003 at 1:09 pm
Ok, "SQL2KDeskSP3.exe" is only be used for Microsoft standard MSDE version. For example, when install .NET Framework SDK, a customized MSDE is also be installed. A special SP3 for this customized MSDE has to be downloaded and installed. Similar example to MSDE used for content server too.
I don't know whether asp.net Web Matrix is part of Microsoft .NET Framework SDK. If it is, you should download special MSDE SP3 from Microsoft.
Or call Microsoft to clarify.
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply