Installing MSDE

Hi All,

I need help installing MSDE. I am using Windows XP. When I download it and try to set the password with the Command Prompt, it doesn't work. When I setup XP my username became the Admin. When I open the Command Prompt, it defaults into my documents and setting - I can't get a C:\ prompt. My login is the Admin and the old Administrator account isn't listed anywhere on my computer. Am I screwed? Do I have to reinstall XP and have the seperate Admin account? Please help.

Thanks,
TonyOK - I got it installed. When I rebooted the Icon came up but it's not connecting. It says there is no Service available. How do I set up a Service? I am running IIS5 on Windows XP Pro.

Installing MSDE

Someone please tell me how to install MSDE. I am somewhat unfamiliar with the command prompt - I'm using XP Professional. I need to set "SAPWD."

I have tried "setup SAPWD="" security=SQL" but I don't believe I'm doing it right.Did you modify the Setup.ini file that is in the same directory as the MSDE Setup.exe so that it looks something like this.

[Options]
INSTANCENAME=SomeInstanceName
SECURITYMODE=SQL
SAPWD=whatever

After you change these settings you should re-install MSDE.

This link may help|||I got it set up, thanks.sql

Installing MS SQL Server Engine

Hi everybody.
I was trying to install MS SQL Server Engine this morning. At the command prompt I typed setup SAPWD=password SECURITYMODE=SQL (where password was my password). After running the MSI I got the following error:

Product: Microsoft SQL Server Desktop Engine -- Setup failed to configure the server. Refer to the server error logs and setup error logs for more information.
The Event ID is 1013.
Can anybody tell me how to install this program. Thanks in advance for any help.

Try turning on the verbose logging (with the/L*v switch) when installing to see more information about the error you are receiving:

> setup.exeSAPWD=password SECURITYMODE=SQL /L*v C:\MSDE_setup.log

For reference, here are the installation instructions for MSDE:Installing Desktop Engine.sql

Installing and Configuring Reporting Services using the Command Prompt

Hello, I have a question regarding installing SQL Express with Advanced Services from the command prompt. I am executing a .cmd file which has the following syntax:

start /wait setup.exe /qb INSTANCENAME=Tim ADDLOCAL=SQL_Engine,Connectivity,RS_Server,RS_Web_Interface SAPWD=1StrongPassword_2 SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=0

Yet, after the installation when I run the Reporting Services configuration tool, none of the settings for Reporting Services are set. I would like to be able to install Reporting Services from the command prompt and have it use the default settings for creating a default website just like you can through the User Interface using the Setup.exe but cannot seem to figure out what I am missing in my .cmd file?

I would appreciate any help anyone can provide.

Tim

I suspect that you are wanting to deploy Reporting Services with your application.

If so, these resources may be helpful:

SQL Server 2005 UnAttended Installations
http://msdn2.microsoft.com/en-us/library/ms144259.aspx
http://msdn2.microsoft.com/en-us/library/bb264562.aspx
http://www.devx.com/dbzone/Article/31648

|||

Thanks Arnie, this is great!

Tim

Installation Path

Anyone know how to get MSDE to prompt for a different
install location ?
Tia,
hi Dave,
"Dave S" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:1e28901c45514$31062650$a101280a@.phx.gbl...
> Anyone know how to get MSDE to prompt for a different
> install location ?
you can not prompt, but you can set a fixed different location for both
binaries and data files...
http://msdn.microsoft.com/library/de...stsql_84xl.asp
2 parameters for the boostraper setup.exe installer are available for this,
DATADIR="data_folder_path"
TARGETDIR="executable_folder_path"
please remember that some binary stuff sill be placed anyway in \Program
Files\ folder, that's to say the common executable for all instances like
SQL-DMO...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply