Cant install MSDE - Get message about Strong Passwords

Hi, I am a newbie when it comes to SQL. At work I was
handed a 4 inch thick book titled, 'Microsoft SQL Server
2000', and a book on just the learning SQL language. Im
trying to spend time at work learning this but I have many
other functions and work to take care of. So I asked my
boss and he told me that if I wanted to be able to
continue studying at home that I would need to download
the free version of SQL Server which is called MSDE and is
available to download from Microsoft. So I went home and
downloaded it. Here is the problem...When I try to
install it using SETUP.exe, I get a message informing me
that a SA password is required to install the program. I
have no Idea what that is except that is refered to as a
strong password.
At that point it tell me I need to use some other thing to
supply a SA password and then it will continue to install
the program. I think its expecting me to already know a
bit about SQL which I dont, and also expects me to know
how to install a program via command lines which I dont.
Does anyone know what i'm talking about here, and if so,
what is the laymans, easiest way to accomplish what it is
the istall program wants me to do? Please dont refer me
to some microsoft informational document. I tried that
last night and all it did was confuse me, as they assume
that I know more than I do. I just want to be able to
install the MSDE program on my home computer and once
thats done Ill probably need some hints on how to set up
MSDE to be run for the first time...like how to make it
look at a database thats local. From there on I can muddle
throught the actual learning process on my own.
Thanks in advance for your help!
Tim
Tim,
ReadmeMSDE2000A.htm comes with your download and it talks about common
installation problems.
To install MSDE, you need to supply a strong pasword for sa (something that
is not empty). You can open a DOS prompt, change to the MSDE setup.exe
directory and run 'setup SAPWD=<yourpassword>'
Thanks,
Amy
| Content-Class: urn:content-classes:message
| From: "Tim" <twilliams@.indicopublic.com>
| Sender: "Tim" <twilliams@.indicopublic.com>
| Subject: Cant install MSDE - Get message about Strong Passwords
| Date: Wed, 7 Apr 2004 12:02:42 -0700
| Lines: 32
| Message-ID: <19ab501c41cd2$e7a4bea0$a401280a@.phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MIMEOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcQc0uekPVanx5LCRE+b6Cmo5Vvz2Q==
| Newsgroups: microsoft.public.sqlserver.msde
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.msde:13487
| NNTP-Posting-Host: tk2msftngxa12.phx.gbl 10.40.1.164
| X-Tomcat-NG: microsoft.public.sqlserver.msde
|
| Hi, I am a newbie when it comes to SQL. At work I was
| handed a 4 inch thick book titled, 'Microsoft SQL Server
| 2000', and a book on just the learning SQL language. Im
| trying to spend time at work learning this but I have many
| other functions and work to take care of. So I asked my
| boss and he told me that if I wanted to be able to
| continue studying at home that I would need to download
| the free version of SQL Server which is called MSDE and is
| available to download from Microsoft. So I went home and
| downloaded it. Here is the problem...When I try to
| install it using SETUP.exe, I get a message informing me
| that a SA password is required to install the program. I
| have no Idea what that is except that is refered to as a
| strong password.
| At that point it tell me I need to use some other thing to
| supply a SA password and then it will continue to install
| the program. I think its expecting me to already know a
| bit about SQL which I dont, and also expects me to know
| how to install a program via command lines which I dont.
| Does anyone know what i'm talking about here, and if so,
| what is the laymans, easiest way to accomplish what it is
| the istall program wants me to do? Please dont refer me
| to some microsoft informational document. I tried that
| last night and all it did was confuse me, as they assume
| that I know more than I do. I just want to be able to
| install the MSDE program on my home computer and once
| thats done Ill probably need some hints on how to set up
| MSDE to be run for the first time...like how to make it
| look at a database thats local. From there on I can muddle
| throught the actual learning process on my own.
| Thanks in advance for your help!
| Tim
|

Cant get SQL Server Express to install

I'm using the disk that came with my Visual Web Developer for Dummies book. It installed on my XP Home machine, but when installing on my XP Pro machine, the fourth step, SQL Server Express, it fails. I cleaned up my hard drive (about ten gigs of free space), I followed the steps herehttp://msdn.microsoft.com/vstudio/support/readme/default.aspx to uninstall everything dot net related. Rebooted, checked my control panel, etc. Tried to install. It just fails. No error message.

Can anyone give me an idea of where to start?

Thanks

Try to install the version on msdn rather then on the CD and see if it works. Here is the link for the download.

http://msdn.microsoft.com/vstudio/express/sql/download/default.aspx

|||

Ha ha ha. Never quit.

Banging my head against the wall, or trying to get this thing to work?

I was thinking about my gov't issued perpetual virus scan, and thought I'd disable it. And then some time ago I had to do something (that never worked) regarding permissions to the INETPUB folder. And another source also suggested a direct download. Which is what I'll try next. I think I'll try it first in the 'repair' mode if it's available (as it is on the disk - it recognizes that the first three options installed properly and offers up the fourth).

|||

Success!

I had already disabled the virus scan, and so don't know if that had anything to do with it. But the download of just the SQL Server says it was successful. My dot net 2.0 framework was detected (it must be installed first), and it sailed thru like it should have in the first place.

As I think I mentioned in my first post, installation on my other laptop (wife's) with XP Home went perfect from the disk. A little weird that my old standby wouldn't work with it, but I'll accept it. And get started with what appears to be some very cool stuff.

|||I came across an issue on installing. When operating from the disk in the Visual Web Developer for Dummies book, the SQL Server just failed. No messages. When downloading from MicroSoft, I got a message that the c:\program files\microsoft sql server folder couldn't be compressed. So, while that message was up, I went thru explorer to change the properties of it. More than a few times, exe and dll files came up that were in use and couldn't be uncompressed. I finally hit the ignore all button and hoped for the best. When it was finished, I went back to the installation routine and hit continue. And it appears to have worked.