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

heres the web.config
<configuration>

<appSettings>

<add key="constring"

value="Server=MKLAPTOP\VAIO_VEDB;UID=MKLAPTOP\Mark ;PWD=IPutWindowsPWHere;Database=AspNetJobs"
/>

</appSettings>

<system.web>

<compilation debug="true"/>

<authentication mode="Forms" >

<forms name=".ASPNETJOBS"

loginUrl="~/site/password/login.aspx" />

</authentication>

</system.web>

</configuration>

Is there anything else i need to check/change etc.. please keep in mind I am
in learning mode so a good explination would be very helpful...

Thanks in advance,
Mark

M K (ski_freak (AT) earthlink (DOT) net) writes:
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 (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx