Viewing 15 posts - 616 through 630 (of 6,105 total)
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...
March 2, 2009 at 9:19 am
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...
March 2, 2009 at 8:10 am
You waited until the database was fully decrypted?
March 2, 2009 at 8:07 am
MANU (3/1/2009)
March 1, 2009 at 1:41 pm
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...
March 1, 2009 at 1:39 pm
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.
March 1, 2009 at 5:50 am
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...
March 1, 2009 at 5:48 am
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...
February 28, 2009 at 10:02 pm
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...
February 28, 2009 at 9:51 pm
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...
February 28, 2009 at 9:47 pm
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...
February 28, 2009 at 9:44 pm
From Books Online:
DEFAULT_SCHEMA cannot be specified for a user who is mapped to a Windows group, a certificate, or an asymmetric key.
You cannot set a default schema for a Windows...
February 28, 2009 at 9:43 pm
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...
February 28, 2009 at 9:39 pm
Are you able to connect locally to the named instances? What operating system is this installed on?
February 28, 2009 at 3:45 pm
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...
February 28, 2009 at 3:22 pm
Viewing 15 posts - 616 through 630 (of 6,105 total)