Deploying SQL Server Express 2005.

[artstar]

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.

[dilettante]

You might get started by reading through Embedding SQL Server Express into Custom Applications (http://msdn.microsoft.com/en-us/library/bb264562.aspx).

Some people also recommend using Microsoft Component Installer Software Development Kit for Windows (x86) Version 2.0 (http://www.microsoft.com/downloads/details.aspx?familyid=2A5E4EBC-651C-40AA-9525-1810AF47C317&displaylang=en) for assisting in this.

Note that SQL Server Express 2005 is being sunsetted. SQL Server 2008 Express (http://www.microsoft.com/express/sql/download/).

[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

[dee-u]

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.