March 25, 2008 at 10:11 pm
Hi,
Currently I am setting up a new SQL 2005 ent.server(64-bit) on Win 2003 ent(64-bit). I would like to create two instances one named and one default. My physical server has nic cards assigned with different IP address. Now I want to create the default instance to use nic1 and named instance to use nic2 for any network activites.
Would appreciate any help
Thanks and rgds,
M
March 27, 2008 at 9:38 am
I believe you can accomplish this by using the SQL Server Configuration Manager tool.
Start > All Programs > Microsoft SQL 2005 > Configuration Tools> SQL Configuration Manager
Select the instance name you want to configure under "SQL Server 2005 Network Configuration" You will see a protocal name "TCP/IP" make sure that is enabled, and then choose "properties" You have options in there to define the IP address, and port number.
Make sure your SQL Browser Service is running so clients can find the named instance, if they don't specify the port number in the connection.
Let me know if that helps.
July 9, 2008 at 3:45 pm
Is it possible to set a named instance to an ip address, and remove the need to specify the instancename or port?
In my scenario I have a Win server "SERVER1" IP 10.2.1.1.
I install 2 SQL named instances SERVER1\DEVDB & SERVER1\QADB, which by default run on dynamic ports, say 2058 & 2067
I then add 2 new IPs to the server NIC : 10.2.1.2 & 10.2.1.3
I want to be able to set the IPs so that they reference the named instances
i.e.
10.2.1.2 -> SERVER1\DEVDB which is same as 10.2.1.1\DEVDB which is same as 10.2.1.1:2058
and 10.2.1.3 -> SERVER1\QADB which is same as 10.2.1.1\QADB which is same as 10.2.1.1:2067
Have tried settings in SQL Server Configuration Manager tool, but all that seems to do is set alternative IPs for the base server, in my case 10.2.1.1.
Kev
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply