Error with Downloading MSDE

Dear All,
I am new to SQL I download "sql2ksp3" to my laptop (Window Xp Pentium III) and then I start to setup MSDE:

>> setup SAPWD=pass SECURITYMODE=SQL

After I run this command it gives me the following statment!!!

Setup failed to configure the server.Refer to the server error logs and setup error logs for more information.

Please help me what i have to do to make this stuff works!!

Sincerely
Henok::Please help me what i have to do to make this stuff works!!

I hate to tell you, but this starts with reading the error message. And following the isntructions it provides.

See:

::Setup failed to configure the server.Refer to the server error logs and setup error logs for
::more information.

Tells you to go to the sever error logs and the setup error logs and get more information.

Now, without this information, I do not really see how we could help you. Maybe if my crystal ball version 22332233 is finally delivered, but until then at least I actually do rely on you getting the errors our of your computer.

Are you sure that pass and securitymode are correct, btw? I NEVER had to run setup with any parameters.|||Have you installed MSDE before this, and you're just upgrading your current instance?

check out this tutorial on MSDE installation:
A Beginner's Guide - Installing MSDE
|||To DL the MSDE Engine I would first Download This file... Latest Update, From memory the file you listed above is the SP3 for SQL Server and not the desktop install.

<<http://www.microsoft.com/downloads/details.aspx?FamilyID=413744d1-a0bc-479f-bafa-e4b278eb9147&DisplayLang=en>>
MSDE SP3a Download.|||I had the same problem because I, too, read the installation instructions that shipped with MSDE.

I used the following command:
setup SAPWD="bubba"

If you choose to use theSECURITYMODE switch, you won't need to encloseSQL in quotations.

Good luck!
John|||David,

Thanks for pointing us (at least me) to a nice artilce. I could over come this issue and it works fine for me. Thank you.

Error while trying to create a new connection in Visual C# Express 2005

Hi, the other day i decided to download and install C# Express and SQL Server Express 2005. I created a new project in C# Express then I decided to practice with database connectivity so I tried to create a new connection, in the wizard I specified SQL Server Authentication, typed the user name and password and when I pushed the button "Test Connection" I recieve this error message "Failed to generate a user instance of SQL Server. Only an integrated connection can generate a user instance. The connection will be closed". I also have tried Windows Autentication, but it displays a more complex error that says something about the database file being used by other process. I have been trying to solve this problem, but nothing works. I think I need some help.

While adding a Data Source in VB2005EE I also got this error which you received:

"Failed to generate a user instance of SQL server. Only an integrated connection can generate a user instance. The connection will be closed."

Solution that worked for me:

On the "Add Connection" Dialog, click the "Advanced" Button. Go to the Property "User Instance" under "Source". Change the value to "False" & you are done.

Error while trying to create a new connection in Visual C# Express 2005

Hi, the other day i decided to download and install C# Express and SQL Server Express 2005. I created a new project in C# Express then I decided to practice with database connectivity so I tried to create a new connection, in the wizard I specified SQL Server Authentication, typed the user name and password and when I pushed the button "Test Connection" I recieve this error message "Failed to generate a user instance of SQL Server. Only an integrated connection can generate a user instance. The connection will be closed". I also have tried Windows Autentication, but it displays a more complex error that says something about the database file being used by other process. I have been trying to solve this problem, but nothing works. I think I need some help.

While adding a Data Source in VB2005EE I also got this error which you received:

"Failed

to generate a user instance of SQL server. Only an integrated

connection can generate a user instance. The connection will be closed."

Solution that worked for me:

On

the "Add Connection" Dialog, click the "Advanced" Button. Go to the

Property "User Instance" under "Source". Change the value to "False"

& you are done.