Install a New Instance of SQL server

Question

1.00/5 (1 vote)

See more:

Hi,

I have a windows server that contains an sql server installed on it for a specific department.
I want to add my database to the sql server but, the admin refused because this sql server serves another department and he said I need to install my own server.

My question is: can I install sql server for my department on the same server without affecting their databases? if I installed the sql server again, will it overwrites their sql server or not? if not how can I do that? is there something special or any option to allow me to do that?

Thank you,
Missa

Posted 12-Sep-13 1:07am

Brainy Girl

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ZurdoDev · Answer 1 · 2013-09-12T01:28:00

During the install of SQL server it will ask you for an instance name. If you give it a new name it will install a separate instance than what they are using.

It sounds like your admin is overreacting but perhaps they have a policy in place that requires this.

Just go through the install and put in a new instance name and you'll be fine. It won't affect (other than disk space and other resources) the other SQL.