arghosrho
asked on
SQL power shell install script
im facing a relativley complicated situation and i was wondering if somebody has experience with this issue.
i need to deploy SQL server to about 20 servers. and im requested to build a Powershell script that handles all of this at once.
what i need to do is a script that does the following.
1-create a diffrent AD- user name and password for every server.
2-creates a text file for the usernames and passwords that has been created.
3-use these accounts to deploy SQL on every server with the right service accounts that has been created.
its a bit complicated and i really can use pointers or ideas from experts who has done this before.
i need to deploy SQL server to about 20 servers. and im requested to build a Powershell script that handles all of this at once.
what i need to do is a script that does the following.
1-create a diffrent AD- user name and password for every server.
2-creates a text file for the usernames and passwords that has been created.
3-use these accounts to deploy SQL on every server with the right service accounts that has been created.
its a bit complicated and i really can use pointers or ideas from experts who has done this before.
You can use the ability of using a configuration file to install SQL Server. With that you just need to distribute the configuration file with the SQL Server setup media and then pass the service account as parameter.
ASKER
can u please give me an example of how to do that?
im sorry if im asking too much
im sorry if im asking too much
ASKER
the main idea is we have 20 servers and each and every one must have its own AD service account and password.
we need to push a button in RES and get this completed.
we need to push a button in RES and get this completed.
The information I've provided should be enough for you to start.
If you have a specific question about the solution, feel free to ask but please don't ask me to do the work for you.
If you have a specific question about the solution, feel free to ask but please don't ask me to do the work for you.
ASKER
that is never the intention i have the scripts and everything needed already.
what im looking for is the missing link of how to pass the username as a variable. thas all. that is the issue i need help with. not exactly making the script or making the file. i have all of that ready and tested
what im looking for is the missing link of how to pass the username as a variable. thas all. that is the issue i need help with. not exactly making the script or making the file. i have all of that ready and tested
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
actually i think i found it.
i managed to create a powershell script to create usernames and passwords and finally added all the information to a final line in the script that should trigger the installation.
this is basically what it leads to.
\
.\setup.exe /CONFIGURATIONFILE=<config file location> /SQLSVCACCOUNT=$ADaccount /SQLSVCPASSWORD=$SVCPASSWO RD /IACCEPTSQLSERVERLICENSETE RMS
you think this will do the trick?
i managed to create a powershell script to create usernames and passwords and finally added all the information to a final line in the script that should trigger the installation.
this is basically what it leads to.
\
.\setup.exe /CONFIGURATIONFILE=<config
you think this will do the trick?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
i will try the solution and let you know.