Monday, February 25, 2013

Step by step create Named Instance in SQL Server 2008 R2

To create a Named Instance in SQL Server 2008 R2, You need to follow below mentioned steps...

1. Go to your folder in machine where you have SQL Server 2008 R2 Setup files and file the setup.exe file this is executable file that is used to install SQL Server for you. Do right click on this file and select Run as administrator option from the appeared context menu as mentioned below in Screenshot.




2.  the moment you executed setup.exe file one splash screen will appear for you. There, you can find multiple option like Planning, Installation, Maintenance, Tools, Resources, Advance and last is Options

By Default Planning option is selected on the screen. To create new SQL Server Instance you need to select Installation option...




3. In Installation option, You need to choose  "New Installation or add feature to an existing installation." from the right panel of the screen. 


once you click on this option one splash screen will appear as mentioned below..


4. once current operation is completed, New screen will prompt you  to setup support rules..

Although, you can see all the details on the screen but in case of any fail you can see all details using button Show details >>. when you will click on this button you can see all the relevant details in appeared bottom section on screen.


 If all mentioned rules are passed click on "OK" button. on click of "OK" button again process splash screen will appear for you


In case of fail, You have to choose button Re-run to execute/Validate again..

5. Now your setup is ready to install setup support files on your machine. Press Install button 


You can check the process status as showing in below screenshot...


once process will completed you can see all the status in appeared screen. You should not worried about the warning if any.


So far, Everything looks good. I don't care about the warning..Thus, I'll go ahead and press "NEXT" button.

6. Here, You will get screen "Installation Type" Screen that will allow you to  create new SQL Server Instance for you. You have to select option "New Installation or add shared feature" from the given option on screen. Press "Next" Button


7. In this screen, You need to provide you product key in given input area. by default, it takes from last installation. 


Press "Next" button for next step...

8. In this screen you can find all the licence terms and conditions. Please read carefully and do accept for the successful installation.

Microsoft has given an option to send the feature usage information along with your hardware details to Microsoft.


9. Now you can setup the role for your  instance in below mentioned screen

Press "Next" button

10. In this step you can select or deselect the feature the available features for your instance...




I have selected All and pressed "Next" Button. This will take few minutes to install features for your instance and will notify with "Please Wait" message So please bear with this for the minute..



11. Next setup screen is related to "Installation Rules". Here, i can see all the details with the help of "Show Details >>" button. check the details for the error. If failed count is zero then press "Next" button happily..


12. This is the main step that you need to take for creating new instance in installed SQL Server 2008 R2. Select option "Named Instance" from the given option and provide the name as per your wish for new Instance.


In my case i have given name as "MYSQL" and clicked "Next" button 


13. The next step is related to your disk space requirement that is necessary to complete installation. you can see the details tin screenshot


Press "Next" Button from the bottom panel

14. In this step you can configure your server. Here, you can setup the user account for the SQL Server services and can setup the collation for the Server.


You can select the account as given in list or browse for the another user account..


find the collation setting here you can customize according to your need..Collation you need to change in case if you want to provide support for other language/special symbol those are not supported by current collation..

click on "Next" button after configured your Server for the created instance..

15.  This step allow you to use SQL Server in Mixed mode authentication. here you can provide your password for the administrator user for created instance and add current user as a administrator in instance.





Press "Next" button
16. Setup the Account for the Analysis service in Instance in this step and you can add default/current user 





17. You can do reporting service configuration in this step. If you don't have anything specific for the reporting section then you can choose native/default selected option.

To integrate reporting service with SharePoint you can use second option from the given.

and if you want to install only and don't want to configure select third option.


18. In this step you send your report server error to Microsoft by selecting the check box on screen.



Press "Next" Button

19.  In this section of installation, You can setup installation configuration rules..for more details click on "Show Details >>" button.. You can find details in below area of the screen ..


press "Next" button

20. Ready to Install SQL Server 2008 R2. click on "Install" Button


21. Now your installation will start after setting up all the configurations, roles and settings. Now you have to wait till the complete step.


22. After long waiting time, Your installation completed and you will happy to see below mentioned 
screen in front of you.
 

23. Now you can go to start and run SQL server management studio as Run as administrator

24. Click on "Connect Object Explorer" one dialog box will prompt you to setup your
  •  Server Type
  •  Server Name
  •  Authentication


provide the details in given input area and click on "Connect" button.


25. You will be happy to see your new instance this moment. Here you can create databases, Setup user accounts and more ...


I would like to thanks everyone who has go through this blog. Please provide your valuable feedback about the blog..

Thanks again :)

67 comments:

  1. Thanks for your post , I really appreciate it and its helped so many people.

    Please post some more nice posts....

    ReplyDelete
    Replies

    1. buy office 2016 product key , windows 8.1 product key , win7 keygen , ultimate windows 7 upgrade key free , key windows 7 professional sp1 , windows 7 keygen free , microsoft visio professional 2010 product key , product key windowes 7 , c9QADi

      Delete

    2. win 7 professional genuine activation code free download , windows 7 ultimate keys , windows 10 pro product key sale , windows 7 keystore , windows 8.1 professional key , microsoft office visio professional 2007 product key , windows 7 ultimate sp1 product key free download , windows 7 serials keys , lHvYFT

      Delete
    3. windows 10 professional key , windows 10 serial key finder , windows 10 product key purchase , güncel vista business key , windows 10 activation keys , windows 7 ultimate sp1 keys , windows 10 product key on pc , windows 10 activation grace , wT5ceh

      office 2013 product key

      windows 10 enterprise key

      vmware workstation 11 to buy

      Delete
    4. windows 7 professional sp1 license key , product key windows 7 , free windows home basic upgrade key , sql enterprise , office 2016 activation code , master key for window 7 professional update , windows 10 activation key 10240 , whs 2011 activation key , s3qQlH

      office 2016 registry purchase

      cheap office 2013 key

      microsoft visio professional 2016 order

      cheap windows 10 product key sale

      buy cheap windows 7 product key

      Delete
    5. windows 7 professional sp1 license key , product key windows 7 , free windows home basic upgrade key , sql enterprise , office 2016 activation code , master key for window 7 professional update , windows 10 activation key 10240 , whs 2011 activation key , s3qQlH

      office 2016 registry purchase

      cheap office 2013 key

      microsoft visio professional 2016 order

      cheap windows 10 product key sale

      buy cheap windows 7 product key

      Delete
  2. Thank you very much, this helped big time :)

    ReplyDelete
  3. Very good explanation. thanks for giving right information.

    ReplyDelete
  4. TITLE: Connect to Server
    ------------------------------

    Cannot connect to \MSSQLSERVER .

    ------------------------------
    ADDITIONAL INFORMATION:

    A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid) (Microsoft SQL Server, Error: 87)

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=87&LinkId=20476

    ------------------------------
    BUTTONS:

    OK
    ------------------------------
    i m getting this error whn i try to cnnect ... can any 1 help me out ....??? :-(

    ReplyDelete
    Replies
    1. This comment has been removed by the author.

      Delete
    2. Go to services --> sql server --right click on it --> go to logon --> change permission to local system then you will be able to login with windows authentication to default instance or if you have access to windows authentication enable sa password

      reference got to below link
      http://microsoft-sql-ssis.blogspot.in/2015/09/how-to-enable-sa-user-name-in-sql-server.html

      Delete
  5. Very good composition of steps to install new instance.

    ReplyDelete
  6. Thanks a lot for this blog, it helped me a lot.

    ReplyDelete
  7. This comment has been removed by the author.

    ReplyDelete
  8. Thank you so much. It helped me lot.

    ReplyDelete
  9. Thank you so much for the blog. It helped me a lot.

    ReplyDelete
  10. thanks for your good sample ...

    ReplyDelete
  11. Great Post! - joelcastro.com

    ReplyDelete
  12. Spot on - Thanks!

    ReplyDelete
  13. thank u good information with a step by step manner and thanks alot
    regards
    rama krishna sharma bulusu






    ReplyDelete
  14. Excellent work; thanks!

    ReplyDelete
  15. Excellent and very helpful.

    ReplyDelete
  16. Thank you very good article.

    regards,

    ReplyDelete
  17. Thanks so much for posting. Very helpful.

    ReplyDelete
  18. You just helped a complete stranger to do his job, Thank you very much

    ReplyDelete
  19. We need more people like you on this earth... thank you very much indeed!

    ReplyDelete
  20. Thaaaank youuuu!

    ReplyDelete
  21. the post was very helpful, the images could have been little bigger and better though..

    ReplyDelete
  22. Thanks, This post is worthwhile and helped Lot.

    ReplyDelete
  23. thank you, this is very very useful!!!

    ReplyDelete
  24. Where can I get SQL Server 2008 R2 Setup files? I have SBS 2011 and SQL was part of the package.

    ReplyDelete
  25. Brillient, been searching all over for this, jus a rough and ready instructions.

    ReplyDelete
  26. I had this issue few day ago and couldn't fix it. Thats when I started googling and found a team of friendly people called called ServerBuddies. They provide quality remote server management, including troubleshooting, Server Management, Plesk Support, Server Maintenance, Server Monitoring, Server Troubleshooting and support at a affordable rates. Here are option for Server Management, Server Maintenance, Server Monitoring, Server Troubleshooting, Server Optimization, Plesk Support, Linux Support, cPanel Support and Plesk Support. They are great, I highly recommend to use these guys!

    ReplyDelete
  27. Great guide! Thank you! Cheers Sam

    ReplyDelete
  28. thank you so so much !!
    installing sql server successfully is like you have conquered seven kingdoms.

    ReplyDelete
  29. Very good. Thanks.
    Christian

    ReplyDelete
  30. Good post... really helpful .. thanks
    -Pankaj

    ReplyDelete
  31. I found it very useful...thanks a lot
    --Sagar

    ReplyDelete
  32. Thumbs Up! Very helpful!

    ReplyDelete
  33. Thank you so much its help me a lot :)

    ReplyDelete
  34. Thank You Very Much... I'm new to SQL and had 0 issues adding an instance... You're a legend!

    ReplyDelete
  35. If someone need windows key can go link: https://plus.google.com/104943840156608675702/posts/MbJ2FFbB4uR to got. My key got here and after i used is works properly. Hope can help you.

    ReplyDelete
  36. Hey guys, you can this site to get a valid product key, any kind you want, click here if you need one:

    www.motionkeys.com.

    ReplyDelete
  37. I strongly recommend you this site to get a product key: www.gankings.com. Works perfectly!

    ReplyDelete
  38. Office 2016 Product Key (http://www.windows10keysale.com)


    I want to thank Office 2016 Product Key here, she has won my business and I'll be posting my experience to you and others.
    My old computer crashed days ago. I had to buy a new computer. It costed me much.
    My budget was not much. To purchase a Office 2016 Product Key from MS was not enough. Then I went to Tomshardware, and one guy recommended Office 2016 Product Key (http://www.windows10keysale.com) to me. Their price did attract me. So I decided to try after several emails to Office 2016 Product Key . She was very patient and answered clearly to all my questions. I receved the key immediately after I sent {price} bucks. It worked perfectly. I was very very satisfied.
    I'll be buying from Office 2016 Product Key (http://www.windows10keysale.com) from now on as well.

    Office 2016 Product Key (http://www.windows10keysale.com)

    ReplyDelete
  39. This comment has been removed by the author.

    ReplyDelete
  40. Wonderful Article. Thanks Dharmendra

    ReplyDelete
  41. Recommander les gars un bon site pour obtenir les clés de produit bon marché et authentique pour le bureau: https://plus.google.com/u/0/105276208727413473827/posts , Toutes les versions de clés de bureau peuvent être trouvées ici.

    ReplyDelete
  42. thANK YOUUUUUUUUUUUUUUUUUUUU

    ReplyDelete
  43. За что "спасибо"? Человек просто на кнопку next нажал несколько раз и всё.
    Вт если бы он про каждый параметр написал, да написал, за что это параметр отвечает - вот тогда было бы другое дело.

    ReplyDelete
  44. It is useful to learn how to set and reset a error.Thank you author for posting this kind of error.


    http://www.wikitechy.com/fix-error/fix-unable-to-connect-to-local-instance-of-SQL-Server



    Both are really good.
    Cheers,
    Venkat

    ReplyDelete
  45. I also really appreciate that you decided to do it your way.

    Ecommerce Website Design | Web Development Company Delhi

    Thanks!
    Best regards,
    Domaxy

    ReplyDelete
  46. Thanks for Wonderful Article. 24x7 Server Support provides Server Support and Server Management for all business needs. We also provide Server Security 24*7 and available to solve your server issues within the given time period. For more details visit: server support

    ReplyDelete
  47. i am using 64 bit operating system. could you please send me exact link for sql server 2008 for download. then only i can follow how to install the above explained. please send ASAP.

    ReplyDelete
  48. i unable to get setup.exe file for SQL Server 2008 R2.

    ReplyDelete
  49. i forgot to tell you i am using windows 2010 and 64 bit operating system.

    ReplyDelete
  50. how can i get setup.exe

    ReplyDelete
  51. Thank you very much, I have wasted a few days traying to install but with you tutorial was so easy. I downloaded the sql server r2 from here https://www.microsoft.com/es-ES/download/details.aspx?id=3743

    ReplyDelete
  52. Please keep sharing more and more information about this.This is a good information of the fashion licensing articles and really like your site.
    Southern California Commercial AV Installation & Commercial AV System Los Angeles

    ReplyDelete
  53. Superb post. Thanks for sharing.Very nice and informative post. Thanks for sharing.Pre-Owned Workstations

    ReplyDelete