Just to confirm, both SQL Servers, the old and new, are in the domain correct?

If so, please run both of these from a cmd shell prompt on one of the...

which one, or both?

I suspect you're running into an issue where there is a registered SPN for the new server. What is the SQL Server service running as on the new server? Is...

Excellent, that was what I was hoping.

Renamed 3 more accounts today.

Last week,...

How is it going?

Sure, delete the SPN Kerberos is issuing tickets on.

Why would you want to do this by the way? Kerberos is preferred over NTLM as its viewed as more secure and...

Per this article each user connection to SQL Server 2005 uses Approximately (3 * network_packet_size + 94 KB).

I say 200 idle connections is nothing for a machine with those specs,...

I rarely recommend it, but in this case I would try bouncing the server.

Not sure what you're saying here.

But, my question is, if a server is...

Script Task Examples

Script Component Examples

That's great! I still kind of want to know if Joe Wu's post on ALTER LOGIN checks out or not 😉

Absolutely it makes a difference. Not all cloud solutions are created equal. With SQL Database on Windows Azure you get database redundancy as part of the platform.

In terms of database...

It depends on the cloud platform. Are you talking about Windows Azure w/ SQL Database, or one of the others?

Grasping now...

Are you using Kerberos or NTLM? I am thinking cached tickets.

Have you tried bouncing the SQL service? The server?

Jack Corbett (7/10/2012)

---

I agree with Grant.

The only issue with Extended Events on 2008 is that there are some key events that aren't available in Extended Events...