Mega Search
23.2 Million

Sign Up

  Page [1]



Make a donation  
Configuring SPN for Instances on two different SQL servers u  
News Group: microsoft.public.sqlserver.server 

Looking for some clarity on my situation.   I have two SQL instances for separate environments.  These two instances use the same domain service account.

When I check the SPNs for both instances, Instance A and Instance B, I have six listed out for each one.  When I check the SPNs for the service account I only have MSSQLServer SPNs created for one of the instances, so MSSQLSvr/Instance A.   There is not one for Instance B.  

Now I'm obviously thinking I need to manually create the MSSQLServer SPNs for my Instance B.

Shouldn't that be correct?  Any issues with doing that?

thx
Vote for best question.
Score: 0  # Vote:  0
Date Posted: 9-Jan-2014, at 3:05 PM EST
From: m
 
Re: Configuring SPN for Instances on two different SQL serve  
News Group: microsoft.public.sqlserver.server 
เมื่อ วันศุกร์ที่ 10 มกราคม ค.ศ.. 2014, 6 นาฬิกา 5 นาที 34 วินาที UTC+7, m_hig...@hotmail.com เขียนว่า:
> Looking for some clarity on my situation.   I have two SQL instances for separate environments.  These two instances use the same domain service account.
> 
> 
> 
> When I check the SPNs for both instances, Instance A and Instance B, I have six listed out for each one.  When I check the SPNs for the service account I only have MSSQLServer SPNs created for one of the instances, so MSSQLSvr/Instance A.   There is not one for Instance B.  
> 
> 
> 
> Now I'm obviously thinking I need to manually create the MSSQLServer SPNs for my Instance B.
> 
> 
> 
> Shouldn't that be correct?  Any issues with doing that?
> 
> 
> 
> thx
Vote for best answer.
Score: 0  # Vote:  0
Date Posted: 11-Jan-2014, at 6:41 PM EST
From: m
 
Re: Configuring SPN for Instances on two different SQL serve  
News Group: microsoft.public.sqlserver.server 
เมื่อ วันศุกร์ที่ 10 มกราคม ค.ศ.. 2014, 6 นาฬิกา 5 นาที 34 วินาที UTC+7, m_hig...@hotmail.com เขียนว่า:
> Looking for some clarity on my situation.   I have two SQL instances for separate environments.  These two instances use the same domain service account.
> 
> 
> 
> When I check the SPNs for both instances, Instance A and Instance B, I have six listed out for each one.  When I check the SPNs for the service account I only have MSSQLServer SPNs created for one of the instances, so MSSQLSvr/Instance A.   There is not one for Instance B.  
> 
> 
> 
> Now I'm obviously thinking I need to manually create the MSSQLServer SPNs for my Instance B.
> 
> 
> 
> Shouldn't that be correct?  Any issues with doing that?
> 
> 
> 
> thx
Vote for best answer.
Score: 0  # Vote:  0
Date Posted: 11-Jan-2014, at 6:44 PM EST
From: m