Deploying SQL Express Throughout the Organization/Enterprise

What are some recommended methods for deploying SQL Express throughout an entire organization? It appears that Active Directory/GPO deployment is out of the equation.

Thanks,

Shane

hi Shane,

as SQLExpress is SQL Server, and as SQL Server is a service potentially serving lot's of user, SQLExpress is usually installed on a machine available through the whole lan.. all the clients connect to that instance and it answers to all the incoming requests... this is the "traditional" scenario of an enterprise wide database server...

what is your "problem"?

regards

|||

In our case SQL Express needs to be deployed to each PC because the product is used connected and disconnected to the network. Is there a documented or recommended method of deploying SQL Express to each PC?

Thanks,

Shane

|||

hi Shane,

a nice article has been written by Robert Walters including ClickOnce as well..

regards

|||

Andrea,

Thanks for the information. I have seen that article before and it is very good. We are using the ClickOnce bootstrapper but not actually using ClickOnce itself. What I am really looking for is recommendations on pushing SQL Express to PCs in an organization. Active Directory/GPO is commonly used for Windows Installer installations and while SQL Express is a Windows Installer installation under the hood it doesn't appear it would be practical and possibly not even possible to push it out this way. Is this a valid assessment? There are other electronic software delivery tools out there like SMS that may do the job, but we don't have experience with those tools. Would these tools be appropraite for pushing out SQL Express? Has anyone tried this successfully?

Thanks,

Shane

Deploying SQL Express 2005

Hello,
I work for a company that manages computers and their software using Active Directory. One of our packages requires SQL Express 2005, and so far I've been unable to find a good resource online. All I need to do is find a .msi file or a batch script that will install it. Thanks!

Start here http://msdn.microsoft.com/vstudio/express/

Deploy SQL Server Management Studio

Hello,

I need to deploy Server Management Studio by Active directory and I will like to know where I can find the MSI do it. (I didn't find it on the CD)

Thank you for your help

There is no separate msi file for SQL Server 2005 Management Studio. Instead, SQL Server Management Studio is packed in SqlRun_Tools.msi under tools directory.