"Bet you a dollar that you've done one or more of the following: pushed for standardized server names, spent hours writing SQL Server maintenance related TSQL scripts that are SQL...

You'll need the setspn utility. You can get it here:

SETSPN download on MS's site

I've run it from XPSP3 and Server 2003. You just need an account with sufficient rights to...

Looks like I'm going to answer my own question:

The answer is to delete the SPNs from the machines

Deleting the SPNs from the service account results in no access using windows authentication.

Again - anyone got any suggestions?

Since nobody has replied I am going to try removing the SPNs from the domain based service account and see what happens.

Four pages of comments and no has yet to mention the Rocky Horror Picture Show?

/ Let's do the time warp again!

// Oh no! Did I just give a clue to...

For work this could be valuable - if it's tweaked for the purpose at hand (like tracking code changes).

For personal life though - "Dear Diary...." for the hyper-anal-retentive :sick:

Have you looked at ManageEngine's Application Monitor?

"Firehose about to rock (AC/DC)"???:Whistling:

http://www.kissthisguy.com/ ?:-D

Finally got it figured out - SQL express at least really, really, REALLY hates it if you have any .NET other than 3.5 sp1 installed even if 3.5sp1 was the...

I am having the same issue with SQL 2008 Express. I tried to install the SP1 for it (my original install of 2008 express w/ advanced services was before sp1...

You must not be an auditor. You don't perform an audit to "catch people", although that will happen. You perform an audit to ensure that the way you are doing...

"I think auditing is the best way to handle things, or rather, the best way to detect issues. Give people some autonomy, some freedom, and then when things do wrong,...