Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Can we Create sql server instance through script? Expand / Collapse
Author
Message
Posted Friday, July 12, 2013 11:19 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, June 15, 2014 10:33 PM
Points: 22, Visits: 80
Hi,

I am using SQL server 2008 standard edition. Is there a way to create a new server Instance by a script except the default instance.?

Thanks.


Regards,
Jigneshal
" Stretch Your Limit Little Beyond Your Limit....! "
Post #1473281
Posted Saturday, July 13, 2013 5:05 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 8:43 AM
Points: 223, Visits: 1,720
Yes, run setup.exe from cmd
http://msdn.microsoft.com/en-us/library/ms144259%28v=sql.100%29.aspx
eg:
Setup.exe /qs /Action=Install /Features=SQLEngine /InstanceName=NewInstanceName /SQLSYSADMINACCOUNTS="domain\sysadmin" /IAcceptSQLServerLicenseTerms

Post #1473288
Posted Tuesday, July 23, 2013 2:48 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, June 15, 2014 10:33 PM
Points: 22, Visits: 80
Still not clear that, is there any way to create it using scipt?

Regards,
Jigneshal
" Stretch Your Limit Little Beyond Your Limit....! "
Post #1476419
Posted Tuesday, July 23, 2013 3:32 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 8:43 AM
Points: 223, Visits: 1,720
Now I don't know what is not clear in adding the setup.exe with proper parameters in script. What kind of script do you mean? What do you want to achieve?
Post #1476433
Posted Tuesday, July 23, 2013 5:19 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 7:44 AM
Points: 12,910, Visits: 32,015
via TSQL, the best answer is no, you cannot install a new SQL instance via TSQL.
it has to be done from the operating system side, with the example parameters supplied above, as a .cmd or .bat file, or simply inline in a cmd window.

there are edge cases, where if you are running the right user for the SQL service, you could call xp_cmdshell and it might work, but it's not worth the trouble to track down all the errors and issues to make it work.

additionally, it is exceedingly rare you need to install additional instances if you already have an instance in place, so I'm wondering what the real issue is on this question.


Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1476504
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse