Installing with MSDE on XP

I would like to install MSDE in Windows XP Professional. When I tried
to install it gave me an error A strong SA password is required for
security reasons. Please use SAPWD switch
I do not know how it handle this error if you can please let me how to
install in XP.
Step by Step process.
Thanking You
Your's Truly
Raj
hi Raj,
Raj wrote:
> I would like to install MSDE in Windows XP Professional. When I tried
> to install it gave me an error A strong SA password is required for
> security reasons. Please use SAPWD switch
> I do not know how it handle this error if you can please let me how to
> install in XP.
> Step by Step process.
Setup.exe is a boostrap intaller for MSDE and accepts parameters you can
provide at the command line as long as in a companion .Ini file..
at
http://msdn.microsoft.com/library/de...stsql_84xl.asp
you can find the list of all supported parameters...
please open a DOS command window and navigate to the folder hosting the
setup.exe file...
there you can run setup.exe with all the parameters of your choice..
- usually you have to provide the SAPWD parameter to specify a strong
password for the "sa" builtin login in order to protect it from both
internal and external attacks..
specify then
SAPWD=your_strong_password
- additional parameters let you specify if you want a named instance or a
default instance... specify
INSTANCENAME=your_instance_name
if you want a named instance...
- another parameter let you specify if you want to allow remote connections
from other PCs in your lan to your MSDE instance.. specify
DISABLENETWORKPROTOCOLS=0
if you need this feature...
- by default, MSDE is installed allowing only WindowsNT authenticated
connections and preventing standard SQL Server authenticated ones.. more on
this at http://support.microsoft.com/default...b;en-us;325022
you can specify
SECURITYMODE=SQL
to allow mixed mode security, thus allowing both WInNT integrated security
and standard SQL Server authenticated connections..
- the final important parameter is
/L*v "c:\msdelog.txt"
where you will allow verbose logging of the installation process, resulting
in a text file of about 2mb for a successfull installation you can inspect,
in case of problems, for
RETURN VALUE 3
entries... about 10 lines before each entry some (sometime cryptic)
description of the problwm will be reported..
so, if you like to install a "named instace" named "Raj" with mixed security
and enabled network protocols for remote connections you can run setup.exe
boostrap installer providing all parameters as
c:\..\>setup.exe /qb INSTANCENAME=Raj SECURITYMODE=SQL
DISABLENETWORKPROTOCOLS=0 SAPWD=your_strong_password /L*v "c:\msdelog.txt"
you can later manage your installed instance via the native character tool
oSql.exe as described at
http://support.microsoft.com/default...;EN-US;q325003 or use a
third party tool, both commercial or free, like the ones listed at
http://www.microsoft.com/sql/msde/partners/ or
http://www.aspfaq.com/show.asp?id=2442... google for further..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Installing SQLXML Bulk Load through Code

Hi all,
I am using SQL XML Bulk load to add data from XML into my database.Is there a way where in i can install the basic dlls required for simply the process of copying data from XML Bulk load without having to go about physically installing the SQLXML bulk loa
d...
Any help would be greatly appreciated...
thanx,
regards,
Kalpna
************************************************** ********************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
HI
i am little confused by ur question. Do u want to do the buklload from multiple machines other than ur machine?
Thanks
Mathew
|||no...i want that during the time of installation ...my application should just register the entries required for my application...what i mean by this is that rather than installing the whole SQL XML bulk load i simply register the relevant Dlls on the m
achine where the application doing the bulk load will be hosted...
ne help wud be of great use...
thanx,
regards,
Kalpna
************************************************** ********************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

Installing SQL 7 SP4 is a Domain are domain accounts required

When installing SQL 7 (non clustered) on a server is it neccessary to use
domain accounts.
e.g. We have a web server that is part of the workgroup "workgroup" this web
server is to access via the application on it the SQL database that resides
on a separate server (also in "workgroup") is it neccessary to create a
domain and have both these servers as members?
Thank youThere is no domain account for a workgroup topology. You will want to use
sql login for your authentication.
-oj
http://www.rac4sql.net
"Bruce Gilbert" <bruce.gilbert@.cgi.com> wrote in message
news:%23GsIqzCDEHA.2424@.TK2MSFTNGP09.phx.gbl...
> When installing SQL 7 (non clustered) on a server is it neccessary to use
> domain accounts.
> e.g. We have a web server that is part of the workgroup "workgroup" this
web
> server is to access via the application on it the SQL database that
resides
> on a separate server (also in "workgroup") is it neccessary to create a
> domain and have both these servers as members?
> Thank you
>|||To answer you question specifically. You do not need a domain. However, all
connectivity to the SQL Server machine will either have to be done with SQL
authentication or passthrough authentication (the same NT user and password
on both the client and SQL Server machine)
Rand
This posting is provided "as is" with no warranties and confers no rights.