You're going to have to look in the code to determine sServerName. This is in the application, not SQL Server.

Serious question here... is there a reason the SQL Server...

Are the credentials the same in all cases?

Reading what you've written, are both the web server and the SQL Server dual homed? Sounds like it when you say both have...

When you say the administrative ID, is that a Windows account? Does it match either the cluster service account or the SQL Server service account? You didn't mention where the...

Yes. You can do so through the use of linked server or the use of certain remote query recordset commands (OPENQUERY, OPENROWSET).

Approach it from a role-based security perspective. Build the Windows groups around business roles (system administrator, legal secretary, sales rep, etc.). This will allow those groups to be reused in...

The password field is actually two hashes, one of which is the password in all uppercase. That's how SQLCrack and NGSSquirrel are able to brute force the password faster. They...

I just tested and even if you are explicitly mapped, if you have sysadmin access in anyway, you still map in as dbo. Check to see if you have sysadmin...

Is your login a member of the sysadmin fixed server role? If so, unless explicitly set otherwise, you automatically map into the database as dbo.

There are quite a few examples in the scripts about how to run against multiple databases. Here's what you need to find the tables the public group has no permissions...

Microsoft acknowledges the auto-repair option requiring single user mode in SQL Server 2000 as a bug. It affects all versions.

BUG: Database Maintenance Plan on System Databases...

If you don't need the alias, you shouldn't use it. Only reason is if another problem shows up, whoever is doing the troubleshooting might forget or not know the alias...

SQL Server requires exclusive use of whatever port it's listening on. Therefore, if you have multiple instances on a server, each will require its own port. By default, SQL Server...

Check with your admins for the user rights settings. Make sure they don't have specified values for Log on as a service. If they've set something in any of the...

You don't have to do a full reinstall. You can run rebuildm. This will allow you to select a new collation. However, it does replace master, msdb, and model. You'll...

Sounds like you need a network sniffer. There are a whole host of them. the Sniffer (tm) product I know recognizes some of the TDS packets correctly, or at least...