You are correct, system databases are every bit as important. But in my environment they do not require as aggressive a backup schedule. So i basically run 2...

Thanks for the suggestion regarding "Enterprise Architect" I will investigate it.

Like a lot of us in the MS-SQL DBA world, I do not have the luxury of being a...

More Cores and RAM will be a great advantage, but I was bitten by this. In my environment the SAN was the bottle neck, and we saw a degradation...

I found an answer to my question here.

Is there anything like "countif"?

Here's the expression.

=SUM( IIF( Fields!MyField.Value = 0,0,1))

Thanks, that makes sense. I was already planning on changing to a pull model instead of push. It just makes sense to let the subscriber(s) get the data...

Nils Gustav Stråbø (12/2/2011)

---

I can't find any information anywhere that says anything about the SPN name being MSSQLSERVER. It has always been MSSQLSvc, ref http://msdn.microsoft.com/en-us/library/ms191153.aspx

The service account does not need...

Thanks you, i will look into it.

MSSQLSERVER/server.domain is what was registered when the service restarted after correcting the account permissions.

There are not duplicate registrations for the server.

Despite what the netadmins are telling me, I think the...

Yes, that one got us on the right path as well as the other earlier post. It's odd that the SPN does come up when I ask SETSPN to...

Sorry Gang, the holiday got in my way. 😉

So here's the update. I've rebooted with no success.

Here's a quick recap.

SQL Server A: AUTH_SCHEME = NTLM

SQL Server B:...

Dev (11/22/2011)

---

When the Database Engine service starts, it attempts to register the Service Principal Name (SPN). If the account starting SQL Server doesn’t have permission to register a...

No error messages, it's simply connecting using NTLM.

I forgot to add I'm runnin SQL 2008 R2 in Windows Server 2008 R2. Somehow I managed to post this in the 2005 forum. :Whistling: Sorry about that....

Eddie, thanks for the advice on the Instant File Initialization. I'll check with the server admins and see what we can do.

Also, thanks for the info on the times....

We are currently using Idera SQL Diagnostic Manager and have been happy with it's performance. Also their support has been good when we have had issues, or when we have...