• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 701
  • Last Modified:

Creating a new instance of MS SQL server

Greetings. I would like to ask you guys on how to create a new instance of sql server.

i have a ms sql2000 server on a windows 2000 advance server. our it consultant before created an instance on that server. Now, i would like to add a new instance on that same server. how?
2 Solutions
Just run SQL Server installation setup on the server and you will see an option something like 'new instance'.    It really is as simple as that.    You will need to restart the server after the install.  

You should make sure there are enough resources on the server to deal with another instance.   You should also throttle back the max memory setting in each SQL Server instances' properties.   Otherwise each instance will compete.  Also leave enough RAM free for the operating system.


Please visit this web site and read the article.


elatagawAuthor Commented:
Thank you guys. That really help me here.

More power.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now