Viewing 15 posts - 1 through 15 (of 20 total)
September 5, 2017 at 7:19 am
Yes, i am somewhat familiar with profiler, just dont know what to trace?
February 8, 2016 at 12:09 am
MysteryJimbo (1/24/2014)
If I wanted to delivery changes to a subscriber after every snapshot is delivered (regardless of what...
January 24, 2014 at 5:14 am
Never mind, i solved it
turns out that SQL 2012 soes not give the SA role to NT AUTHORITY\SYSTEM group but SQL 2008 does, and since netbackup is using the local...
January 14, 2014 at 3:23 am
a restart of the affected server solved the problem =/
October 22, 2013 at 4:44 am
Well... that is what made me post this in the first place, it really didnt say much in the event log and nothing in the SQL Server errorlog...
but the...
October 22, 2013 at 3:11 am
adb2303 (9/19/2013)
So, are you saying that the services are running under a local machine account? If not, the SPN's registered against the machine are irrelevant. If the services...
September 25, 2013 at 5:33 am
muthyala_51 (9/19/2013)
September 25, 2013 at 5:29 am
No, the clusternodes does not have a MSSQLSvc SPN to them.
the 4 Cluster nodes all have:
WSMAN/SERVER1
WSMAN/SERVER1.domain.com
MSServerClusterMgmtAPI/SERVER1.domain.com
MSServerClusterMgmtAPI/SERVER1
TERMSRV/SERVER1.domain.com
TERMSRV/SERVER1
HOST/SERVER1
HOST/SERVER1.domain.com
the instances all have:
MSSQLSvc/VIRTUALSERVERNAME.domain.com:INSTANCENAME
MSSQLSvc/VIRTUALSERVERNAME.domain.com:<dynamic port>
MSSQLSvc/VIRTUALSERVERNAME:<dynamic port>
MSSQLSvc/VIRTUALSERVERNAME:INSTANCENAME
In AD,...
September 19, 2013 at 4:38 am
thanks for the reply
i have done all this and it works on 3 out of 4 hosts in our cluster, if i move the instance to node 4 it stops...
September 18, 2013 at 7:49 am
UPDATE:
we found that the virtual networkname for the instance didnt have delegate trust for kerberos, so i enabled it, also we added the same SPNs as before but without .domain.com...
September 18, 2013 at 4:34 am
i will look into that, thanks!
May 23, 2013 at 2:40 am
why didnt i think of that? =)
probably because all instances are not installed on all the clustered nodes!
its on my "to do" list though...
thanks!
May 23, 2013 at 2:33 am
im sorry if i was unclear.
4 servers in a cluster
we need to apply microsoft security updates from our WSUS server.
the way i do it now:
move all clustered instances from server...
May 22, 2013 at 4:47 am
Viewing 15 posts - 1 through 15 (of 20 total)