none
Named Instance of Sql Server 2012 RRS feed

  • Question

  • I am in process of creating setup file for my application(ASP.NET) with sql server as database.

    During application(asp.net application) installation process I need to install named instance of SQL server and pass the parameter like username password(which are required for sql server instance) progammatically. Is it possible.

    Also, do we need to have complete sql server setup for installing SQL server named instance.

    Currently, I am using SQL Express edition. Want to know if I have sql server 2012(not express edition) with 5 licence, then installing named instance will be calculate as one licence(if there is one default instance and one named instance then the licence used will be 2 or 1).

    Friday, August 9, 2013 12:23 PM

Answers

  • Hello,

    On one hand you can use command parameter for a silent installation of SQL Server; see Install SQL Server 2012 from the Command Prompt

    Other option is to use a config file. When you follow the installation wizard, it creates this config file for you at the end, before you commit the installation. See Install SQL Server 2012 Using a Configuration File

    Regarding licensing please contact a MS sale partner / licensing specialist.

    For information regarding to license, please call 1-800-426-9400, Monday through Friday, 6:00 A.M. to 6:00 P.M. (Pacific Time) to speak directly to a Microsoft licensing specialist. For international customers, please use the Guide to Worldwide Microsoft Licensing Sites to find contact information in your locations


    Olaf Helper

    [ Blog] [ Xing] [ MVP]


    Friday, August 9, 2013 12:29 PM
  • I'll take a shot at the different questions here:

    "During application(asp.net application) installation process I need to install named instance of SQL server and pass the parameter like username password(which are required for sql server instance) progammatically. Is it possible."

    Yes, of course.  Take a look at the documentation and samples for installing SQL Server from the command prompt.  This shows examples for supplying an instance name (using /INSTANCENAME) as well as username and password for SQL Authentication.

    http://msdn.microsoft.com/en-us/library/ms144259.aspx

    "Also, do we need to have complete sql server setup for installing SQL server named instance."

    All instances of SQL Server have "names".  The difference between the default instance and a named instance is merely that a default instance is named "MSSQLServer" and you connect by using the machine name only as opposed to <machine name>\<instance name>.  For both named or default instances, you need to run setup. 

    "Currently, I am using SQL Express edition. Want to know if I have sql server 2012(not express edition) with 5 licence, then installing named instance will be calculate as one licence(if there is one default instance and one named instance then the licence used will be 2 or 1)."

    My assumption would be that this is 2 licenses, but for all licensing questions, people in the forums will direct you to a licensing specialist since any reply here will not hold up in an audit.  To speak to a specialist, call 1-800-426-9400, Monday through Friday, 6:00 A.M. to 6:00 P.M. (Pacific Time).

    Thanks,
    Sam Lester (MSFT)


    http://blogs.msdn.com/b/samlester

    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you. This can be beneficial to other community members reading the thread.

    Friday, August 9, 2013 12:41 PM
    Moderator

All replies

  • Hello,

    On one hand you can use command parameter for a silent installation of SQL Server; see Install SQL Server 2012 from the Command Prompt

    Other option is to use a config file. When you follow the installation wizard, it creates this config file for you at the end, before you commit the installation. See Install SQL Server 2012 Using a Configuration File

    Regarding licensing please contact a MS sale partner / licensing specialist.

    For information regarding to license, please call 1-800-426-9400, Monday through Friday, 6:00 A.M. to 6:00 P.M. (Pacific Time) to speak directly to a Microsoft licensing specialist. For international customers, please use the Guide to Worldwide Microsoft Licensing Sites to find contact information in your locations


    Olaf Helper

    [ Blog] [ Xing] [ MVP]


    Friday, August 9, 2013 12:29 PM
  • I'll take a shot at the different questions here:

    "During application(asp.net application) installation process I need to install named instance of SQL server and pass the parameter like username password(which are required for sql server instance) progammatically. Is it possible."

    Yes, of course.  Take a look at the documentation and samples for installing SQL Server from the command prompt.  This shows examples for supplying an instance name (using /INSTANCENAME) as well as username and password for SQL Authentication.

    http://msdn.microsoft.com/en-us/library/ms144259.aspx

    "Also, do we need to have complete sql server setup for installing SQL server named instance."

    All instances of SQL Server have "names".  The difference between the default instance and a named instance is merely that a default instance is named "MSSQLServer" and you connect by using the machine name only as opposed to <machine name>\<instance name>.  For both named or default instances, you need to run setup. 

    "Currently, I am using SQL Express edition. Want to know if I have sql server 2012(not express edition) with 5 licence, then installing named instance will be calculate as one licence(if there is one default instance and one named instance then the licence used will be 2 or 1)."

    My assumption would be that this is 2 licenses, but for all licensing questions, people in the forums will direct you to a licensing specialist since any reply here will not hold up in an audit.  To speak to a specialist, call 1-800-426-9400, Monday through Friday, 6:00 A.M. to 6:00 P.M. (Pacific Time).

    Thanks,
    Sam Lester (MSFT)


    http://blogs.msdn.com/b/samlester

    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you. This can be beneficial to other community members reading the thread.

    Friday, August 9, 2013 12:41 PM
    Moderator