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

Installing multiple instances of SQL Server - Do I need to specify a different port?

As part of a SharePoint installation I am going to install a second instance of SQL Server (i.e. one server running 2 instances of SQL Server).

Do I have to do anything special other than specifying the name of the instance?

What about ports? Can both instances share the same port?
0
dmoss123
Asked:
dmoss123
1 Solution
 
mds-cosCommented:
First off, step back and ask yourself "why am I doing this".  A single SQL instance can easily take care of multiple databases and seperate associated security for each.  So you may be creating additional complexity where it does not need to exist.

For the specific answer to your question, no.  Just set the named instance.

Here is a link that discusses the process of named SQL instanaces a bit further.

http://www.sqlserverfaq.net/2008/05/17/how-to-change-the-dynamic-port-of-the-sql-server-named-instance-to-the-static-port-in-a-sql-server-2005-clustered-instance/
0
 
dmoss123Author Commented:
Sorry, you posted your comments while I was awarding points(i have no more points to give).

Our reasoning is that we do not want to put the SharePoint databases on the same SQL Server instance that runs all of our other databases. However, the box it is running on is set up to use SANs. Our network admin said that setting up another server to use SAN's would be expensive and require fiber optic cabling.

Anyway, we got it set up as a named instance and afterthing is good. Thanks for replying.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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