Thursday, March 22, 2012

authentication mode

will not let me connect using SQL Server authentication
mode?
If you're using SQL Server's authentication mode you need to be sure to add
a login for the user ID to SQL Server and grant that login rights to the
database that it needs to access. If you;re connecting from an ADO or
ADO.NET application you also need to pass the user ID and password to SQL
Server as part of the connection string.
Michael Otey
"denise" <anonymous@.discussions.microsoft.com> wrote in message
news:2b93001c4691a$a4309510$a601280a@.phx.gbl...
> will not let me connect using SQL Server authentication
> mode?
|||Check to see if your server is in Mixed Mode. Meaning that it will accept
both Standard Authentication and
WIndows Authentication.
This article covers MSDE which is basically points to the same place in the
registry.
319930 How To Connect to Microsoft Desktop Engine
http://support.microsoft.com/?id=319930
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
sql

No comments:

Post a Comment