If the Alias is the same as the server/server+instance name, try removing that alias and see if it resolves.

Unless you have a bonafide functionality reason why you couldn't use trusted connections (such as a web server sitting in the DMZ, which wouldn't be on the domain), the recommendation...

Is Shared Memory enabled as a protocol for the SQL Server instance? Is it enabled as a Client Protocol and listed first in the protocol order?

The short answer is no, you can't put in anything to prevent them from querying the data if you want them to do those other things. However, you can monitor...

Then it sounds like something is running to change it back. If it's a SQL Server 2008 server, check to see if there is a Policy that is checked at...

Mike Levan (2/26/2009)

---

I was able to check for the owners and change ownership, now i am deleting the login from the server, but deleting it from the server may not...

Miz Zahan (2/26/2009)

---

I have 2 database servers with identical setup..

In one server, I got SSPI error, etc. I solved this by setspn and now connections are using Kerberos

However, in the...

Video (works in SQL Server 2008 as well):

How to recover from being locked out of a SQL Server 2005 database

Basically you stop SQL Server. You restart it in single user...

It's not impossible. You just can't perform the operation in reverse. It's like if you put a piece of paper through a high speed shredder. You aren't going to be...

There have been reports of it changing when SP3 was applied and I saw another post here on SSC about the latest security update. Is it a consistent thing? Can...

Posted it as a blog post so it would be easier to find in the future. This works for SQL Server 2005 and above.

Determining if a Server Principal Owns Database...

SQL Server MVP Aaron Bertrand has posted about seeing this behavior when installing SQL Server 2005 SP3:

My latest SP3 experiences - two thumbs acting like divining rods

Not seeing a connect...

Is this true of every database? Also check to see if the user has CONTROL DATABASE rights by querying sys.database_permissions. If the permissions are implicit (coming from the server level),...

If the only Windows group was BUILTIN\Administrators, this is a Windows group that is local to the physical server. In that case, being in a different domain shouldn't matter at...

That should work. But if you're using a local account, what is generating the SSPI errors? SQL Agent trying to start up and connect or the jobs themselves when they...