April 27, 2011 at 6:33 am
Im trying to configure mirroring using a second NIC for Sql 2008 (10.0.4000.0) on windows server 2008 R2. Im having issues when I enable the second NIC. Following the instructions on http://blogs.msdn.com/b/sqlblog/archive/2009/07/17/how-to-configure-sql-server-to-listen-on-different-ports-on-different-ip-addresses.aspx
It appears that after I follow the steps, the automatic SPN registration against the public facing for the port number fails to work.
Before I make the changes I see this in the error log (SPN reg for instance and port)
The SQL Server Network Interface library successfully registered the Service Principal Name (SPN) [ MSSQLSvc/xxx.xxx.xxx:PORTNUM ] for the SQL Server service.
The SQL Server Network Interface library successfully registered the Service Principal Name (SPN) [ MSSQLSvc/xxx.xxx.xxx:INSTANCENAME] for the SQL Server service.
However after I enable the second NIC I only get this registering against Instance Name. Does this mean I have to now enable the SPN manually?
April 27, 2011 at 10:04 am
Make the NIC Teaming then use same for mirroring,it will manage load automatically on both NIC
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
April 27, 2011 at 10:13 am
Thanks for the response, I would like to try but it uses a separate NIC for the purposes of network routing. This mirror setup is over WAN so its important to route traffic over a separate pipe.
May 2, 2011 at 6:10 am
blakmk (4/27/2011)
However after I enable the second NIC I only get this registering against Instance Name. Does this mean I have to now enable the SPN manually?
If you are running SQL Server service as a domain account, you need to manually create the SPN for SQL Server using the setspn command.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply