dmoss123
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?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.