question

vishuaaryan avatar image
vishuaaryan asked

how to create sql server instance?

I am using sql server 2008 r2 on windows server2003 with sql server management studio. I want to create more than one instances of sql server for some activity. Is it possible to create more than one instance of server and if yes than how to create this? please provide some joyfull solution.
sql-server-2008-r2instance
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sqlaj 1 avatar image sqlaj 1 commented ·
vishuaaryan, this question has been marked answered. If you still have questions ask another on a new thread. Editing everyday to keep it at or near the top is not helpful.
1 Like 1 ·

2 Answers

·
sqlaj 1 avatar image
sqlaj 1 answered
I have not watched this but it should help. The process is very simple as you will see after installing. https://www.youtube.com/watch?v=9oXqzdHUH4A. I would suggest looking through the links below for more background and understanding of the process. How to Install SQL Server: http://technet.microsoft.com/en-us/library/ms143219(v=sql.105).aspx Considerations for Side-by-Side Instances of SQL Server 2008 R2 and SQL Server 2008 http://technet.microsoft.com/en-us/library/ee210714(v=sql.105).aspx
5 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sqlaj 1 avatar image sqlaj 1 commented ·
Yes, it needs the setup files because you ARE installing a new, side by side installation (instance) of SQL Server.
2 Likes 2 ·
vishuaaryan avatar image vishuaaryan commented ·
I saw all links but they tell how to install and create the server instance in sql server but I have already installed and created one server instance bydefault. Now I want to create another server instance.
0 Likes 0 ·
sqlaj 1 avatar image sqlaj 1 commented ·
Did you watch the video? https://www.youtube.com/watch?v=9oXqzdHUH4A That shows you exactly how to add a "Named" Instance. The other links are for reference.
0 Likes 0 ·
vishuaaryan avatar image vishuaaryan commented ·
yes I watched that link. It shows a complete process simmilar to fresh sql server installation. And this needs to setup file, I think. There should be another process to create instance with less time.
0 Likes 0 ·
vishuaaryan avatar image vishuaaryan commented ·
ok thanks I will try this
0 Likes 0 ·
ecomma avatar image
ecomma answered
If you already install one instance already.Insert the sqlserver cd and following the wizard. 1. The most important section of the installation process that address your problem is:Instance Configuration window. There you select the radio button that says:Name Instance. 2. You specify the name of your instance and continue to your configuration. 3. You can access your instance like this:Your pc name \yourinstancename 4. IF you have issue during login, you shall consider starting sqlserver browser service
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.