Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: Thursday, December 10, 2015 4:43 AM
Points: 22, Visits: 84
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: Yesterday @ 2:38 AM
Points: 269, Visits: 2,381
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: Thursday, December 10, 2015 4:43 AM
Points: 22, Visits: 84
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: Yesterday @ 2:38 AM
Points: 269, Visits: 2,381
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: Today @ 1:56 PM
Points: 14,437, Visits: 37,837
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

--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Post #1476504
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse