locked
Installing with Named Instance without users interaction RRS feed

  • Question

  • R/s Sir/Madam,

    I am the student of MCA & created a project based on LAN using vb.net & SQL SERVER 2008 R2 with OnlineExam named instance having password as abc@123.com. while I am creating a setup using .Net setup & deployment (VS2010) it installs prerequisites from installation folder but does not create a named instance as I mentioned.

    My problem is that I just want to install SQL SERVER 2008 R2 with named instance but without users interaction. I already tried it from command line(cmd) and even using configuration.ini files, but the problem persists...

    Please, help to make me such things...I request you to help me out of this....please....

    Thanks in advance.

    Amol  Gaikawad,

    Sunday, March 22, 2015 2:59 AM

Answers

All replies

  • R/s Sir/Madam,

    I am the student of MCA & created a project based on LAN using vb.net & SQL SERVER 2008 R2 withOnlineExam named instance having password as abc@123.com. while I am creating a setup using .Net setup & deployment (VS2010) it installs prerequisites from installation folder but does not create a named instance as I mentioned.

    My problem is that I just want to install SQL SERVER 2008 R2 with named instance but without users interaction. I already tried it from command line(cmd) and even using configuration.ini files, but the problem persists...

    Please, help to make me such things...I request you to help me out of this....please....

    Thanks in advance.

    Amol  Gaikawad,

    Sunday, March 22, 2015 3:01 AM
  • Hello,

    it is possible to do slient sql server installation without any user interaction. 

    what is the error\problem you were facing?

    see this link if it helps or post the error you were having

    http://mssqlfun.com/2013/01/29/sql-server-silent-unattended-installation-using-configuration-file/


    Hope it Helps!!

    • Proposed as answer by Michelle Li Sunday, March 22, 2015 1:26 PM
    • Marked as answer by Michelle Li Thursday, April 2, 2015 12:34 PM
    Sunday, March 22, 2015 3:50 AM
  • Hi Amol,

    Don't share any password this is public forum. You told us that you are facing issue but unless you post error message we cannot help you. Please locate installation logs using below link

    https://msdn.microsoft.com/en-us/library/ms143702%28v=sql.105%29.aspx

    Browse the link and look for summary.txt file it would be located at

    C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\log

    Post the content of summary.txt file


    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My Technet Wiki Article

    MVP

    Sunday, March 22, 2015 5:41 AM
  • Amol,

    Please avoid duplicate posts, don't post same question in multiple forums. This is not good practice on forum.

    Moderators please merge it with

    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/de26d4d2-d074-4552-9ea8-130197672d86/installing-with-named-instance-without-users-interaction?forum=sqlexpress


    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My Technet Wiki Article

    MVP

    Sunday, March 22, 2015 5:44 AM
  • As far as I understand, if you want to install the sql server with out any user interaction on GUI is not possible as few screens during installation requires details from the end user.

    Through CMD/Silent : https://msdn.microsoft.com/en-us/library/ms144259.aspx

    If any other issue, as Shanky advised please share the logs.


    Regards, Pradyothana DP. Please Mark This As Helpful if it helps to solve your issue. ========================================================== http://www.dbainhouse.blogspot.in/


    Sunday, March 22, 2015 2:50 PM