Is possible to install Sql server 2005 Automatically

sathishmca · Post by **sathishmca** » Mon Jul 20, 2009 3:03 am

Hello Friends

Is possible to install the sql server 2005 automatically without help of the end user.

i want to create a setup file with sql server 2005 automatically install the all process include the instance name what i am given..

if the end user to install the setup file, without end user cannot modify or change anyone to installing the sql server 2005.

if this possible means...can you explain me..how can it will do? and give a sample project or sample link to learn..

thank you...

please give a quick reply....

ALive · Post by **ALive** » Mon Jul 20, 2009 4:55 am

Hi!

Of course it is possible. You can provide the Instance Name along with 'sa' password. And non of the info should be required from user. But as for the password, imo, it's not correct. Hardcoded passwords - could lead to a security breach. Especially for build in 'sa' login.

Can you rephrase this sentence:
if the end user to install the setup file, without end user cannot modify or change anyone to installing the sql server 2005.

As for how to do it. Open sql2005 (or 2008) script and modify it's contents. You can also use visual designer to specify Instance Name and 'sa' password.

P.S. Don't forget to tell your customers what 'sa' password is

Hope this helps!

sathishmca · Post by **sathishmca** » Mon Jul 20, 2009 7:13 am

Thank you for your reply

is possible to automatically install sqlserver using installaware.

if possible means which control shall i use..

or u mentioned visual designer , where will the software available.

thank you