Tuesday, February 14, 2012

client logins

How come when I make a SQL Server login that login can't be used to login
from my C# application (OLEDBConnection.Open()) or the properties menu
wizard.
Randy
If Windows logins work and SQL logins do not then the server
may be set to Windows Authentication only. You also need to
make sure that you also add the login as a user to whatever
database the app is using and the database user needs the
appropriate permissions. But it could be a lot of different
things. Without any specific error message, it's all just a
guess.
-Sue
SQL Server MVP
On Tue, 4 Apr 2006 19:34:01 -0700, rseedle
<rseedle@.discussions.microsoft.com> wrote:

>How come when I make a SQL Server login that login can't be used to login
>from my C# application (OLEDBConnection.Open()) or the properties menu
>wizard.
>Randy

No comments:

Post a Comment