Re: Deploying SQL 2005 Express

These should help:


http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/sseoverview.asp
Express Overview
http://msdn2.microsoft.com/en-us/library/ms165672.aspx Comparing Express
with MSDE
http://msdn.microsoft.com/sql/default.aspx?pull=/library/en-us/dnsse/html/sqlexpuserinst.asp
User Instances
http://www.datamasker.com/SSE2005_NetworkCfg.htm Configuring Express
for Remote Access
https://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx
Configuring Remote Access
http://www.kbalertz.com/Feedback_914277.aspx Configuring SQL2005 for
remote access
http://msdn.microsoft.com/sql/express/default.aspx?pull=/library/en-us/dnsse/html/emsqlexcustapp.asp
Embedding Express in Apps


--
Andrew J. Kelly SQL MVP


"Locus" <Locus@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B36357AF-818C-4263-B8D2-4BC677F9F5A3@xxxxxxxxxxxxxxxx
I have an an application using MSDE. I currently install it by using the
MSDE
bootstrap installer.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmsde/html/msdedepl.asp

It works well for me.

I like to migrate to SQL 2005 Express and use the pre-requisites feature
in
Visual Studio deployment. I have a few problems:
1. I want to set some parameters for the pre-requisites set up. How and
where I can set these? Parameters I like to set are instance, installall,
disablenetwork, security mode and sapwd.
2. After the set up, I like to attach mdf and ldf file to SQL 2005
Express.
I have not successfully able to attach. The mdf and ldf files I build
using
SQL 2000 server and the location of the files I place is the program
installed location of my application. Do they has to be built by SQL
Server
2005, or in specific directory? Or possibly other reason to my failure.

-- Locus



.

Relevant Pages