Deploying SQL Server Express 2005.

Printable View

Nov 26th, 2008, 06:32 AM
artstar

Deploying SQL Server Express 2005.

Hello:

I have converted my database and application to now use SQL Server Express 2005.

What do I need to deploy SQL Server Express 2005 and get it setup on the clients pc without any inter-action from them?

Thanks for any information.
Dec 3rd, 2008, 09:49 AM
dilettante

Re: Deploying SQL Server Express 2005.

You might get started by reading through Embedding SQL Server Express into Custom Applications.

Some people also recommend using Microsoft Component Installer Software Development Kit for Windows (x86) Version 2.0 for assisting in this.

Note that SQL Server Express 2005 is being sunsetted. SQL Server 2008 Express.
Dec 21st, 2008, 12:48 PM
isnoend07

Re: Deploying SQL Server Express 2005.

I have a access db that i put in a resource file, it only gets used if not present.
Resource file info: http://support.microsoft.com/kb/q194409/
Don't know about what routine needs to get SQL Server Express 2005 running in this manner, but the resource could hold the physical db
Dec 21st, 2008, 01:23 PM
dee-u

Re: Deploying SQL Server Express 2005.

Quote:

Originally Posted by isnoend07

I have a access db that i put in a resource file, it only gets used if not present.
Resource file info: http://support.microsoft.com/kb/q194409/
Don't know about what routine needs to get SQL Server Express 2005 running in this manner, but the resource could hold the physical db

It is not easy as you think it is. You need to install the server so get access to the database itself, if you only attach the database files (.mdf & .ldf files) then you cannot do much about it if the server (or engine) itself has not been installed.