Cluster Log

000015a0.00001cac::2011/06/07-19:04:59.218 INFO [RES] Network Name <SQL Network Name (XXX)>: adapter Public (2)

000015a0.00001cac::2011/06/07-19:05:02.823 INFO [RES] Network Name <SQL Network Name (XXX)>: [cxl::Pinger-"XXX"] Host registered, but no records of...

If you see this thread could you please go to my MS Connect request and vote it up?

https://connect.microsoft.com/SQLServer/feedback/details/674454/name-resolution-not-yet-available

similar posts

http://www.sqlservercentral.com/Forums/Topic947360-1292-1.aspx?Update=1

http://www.sqlservercentral.com/Forums/Topic612919-391-1.aspx?Update=1

similar here

http://www.sqlservercentral.com/Forums/Topic1100990-1550-1.aspx?Update=1

I blogged about what I did to solve the problem here

http://jonmorisissqlblog.blogspot.com/2011/04/configure-policy-to-checks-that.html

similar here

http://www.sqlservercentral.com/Forums/Topic1100990-1550-1.aspx?Update=1

I blogged about what I did to solve the problem here

http://jonmorisissqlblog.blogspot.com/2011/04/configure-policy-to-checks-that.html

I spent most of my day figuring this out so I decided to create a blogger account:

http://jonmorisissqlblog.blogspot.com/2011/04/configure-policy-to-checks-that.html

Thanks I actually saw that and it doesn't do what I'm trying to do.

I've tried this:

Facet: Server Installation (not mentioned in that link)

@WindowsUsersAndGroupsInSysadminRole = Array('builtin\administrators')

The array that gets returned...

I recall reading that if you upgrade from 2005 to 2008 and don't rebuild with full population that the 2005 word stemmers are used vs. the 2008 word stemmers.

Did you...

Thanks!

I just looked into Syed's post and that's for send mail not database mail. The DB mail equivalent it

USE msdb ;

GO

EXECUTE dbo.sysmail_stop_sp ;

GO

waitfor delay '0:00:05'

go

EXECUTE dbo.sysmail_start_sp ;

GO

I tried this...

Doesn't the fact the, "Kerberos ticket expiration" mean the correct answer is NO?

They cannot continue to log into SSMS indefinitely.

Does this help?

http://msdn.microsoft.com/en-us/library/ms142491%28v=SQL.100%29.aspx

Even Better!

You only need to restart sql agent

DENY CREATE PROCEDURE

http://msdn.microsoft.com/en-us/library/ms186915.aspx