Link to home
Start Free TrialLog in
Avatar of dmoss123
dmoss123Flag for United States of America

asked on

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?
ASKER CERTIFIED SOLUTION
Avatar of mds-cos
mds-cos
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of dmoss123

ASKER

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.