Posted by Erland Sommarskog on 05/09/07 22:16

M K (ski_freak@earthlink.net) writes:
> Ok a newbie here...
>
> i have a sql server db I got from a book to learn. I am having problems
> with the 'Authentication' mode.
>
> I need a valid id to be authenticated with...
>
> i have a web config file but I am not sure what goes where?
>
> name of server
> MKLAPTOP\VAIO_VEDB
>
> connection
> MKLAPTOP\Mark
>
> i have both sql and windows authentication selected
>...
> value="Server=MKLAPTOP\VAIO_VEDB;UID=MKLAPTOP\Mark;PWD=IPutWindowsPWHere;Database=AspNetJobs"

This won't fly. When you specify UID and PWD, those are user ids and
password for SQL logins, and they don't contain backslashes. To log in
with your Windows login, simply specify "Trusted_connection=Yes" or
"Integrated Security=SSPI". Or nothing at all, since Windows authentication
is the default. But you should include UID and PWD, unless you want to
use SQL authentication.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Output result of query to existing file
• Prev in forum: Re: Narrowed Down Search
• Thread view: Re: Authentication issue

[Reply to this message]