There's a couple of blog posts on it out there and it's bitten me a couple of times. If you've got to be disconnected, shared memory will only use the...

I know we've seen issues when the logins were renamed and had to drop the old name and recreate the login with the new name. SQL Server doesn't automatically sync...

You waited until the database was fully decrypted?

MANU (3/1/2009)

---

Add user to windows group named "SQLServer2005MSSQLUser$ServerName$SQLServerInstanceName" and login to machine with that account and login to sql server and try to change the password for "sa" account. Hope...

No, you want a manager_login within your application. Remember, the application is what is trying to get into the SQL Server. Once it connects, SQL Server will handle the mapping...

I didn't realize you had posted again and answered the question in your other message. Please only post in one place. Most of us check the whole board.

If your SQL Server is configured for Windows authentication only, you will not be able to connect with the sa account. Only Windows user accounts and members of Windows security...

Then one of the following is true:

- The SQL Server is set to Windows authentication only.

- The sa account has been disabled.

- The sa account has been renamed.

- You have...

Backups on TDE databases are encrypted, and they will need the certificate and private key in order to decrypt properly. So the answer to your question is no. Here's the...

If you get rid of the ODBC DSN, does it still try to connect to SQL Server? If so, then it's making a direct connection using information stored in the...

If the SQL Server stays up and running, then the setting may change (and you'll still need to figure out what is causing that), but it won't take effect until...

From Books Online:

You cannot set a default schema for a Windows...

If you already have an external scheduler, is there a reason to run it from within SQL Server? You could set up a batch job to call the package. Most...

Are you able to connect locally to the named instances? What operating system is this installed on?

In SQL Server terms:

Login means you can connect to the SQL Server. It does NOT mean you have access to any of the user databases. User means you can connect...