appSettings at Web.Config

I have been searching for the clue for long time, but I am out of resources.

1. I would appreciate if anyone let me know the difference between using
SSPI and other one on the bottom:





2. Regards to the Password
I am trying to access a stored procedure and apparently I need to have a
connection to the database. I copied one of the examples on the top (second
one), but why they use " ^ " which I am not sure why.
And what if I do not know the password, what do I have to indicate at the
Password= ?

Thanks in advance.
Justin

Re: appSettings at Web.Config

"Justin Doh" wrote in message
news:F847D60F-5122-4B8B-8968-7866AC3CCA0B@microsoft.com...
>I have been searching for the clue for long time, but I am out of
>resources.
>
> 1. I would appreciate if anyone let me know the difference between using
> SSPI and other one on the bottom:
>
>

It's the user-ID and psw a user uses to log into to the Windows O/S computer
and/or to login to a MS network domain to access the database. That also
means the the user's user-id must be established on the database with the
proper rights to access the database. An application running under the
user's Windows Authenticated user-id and psw can access the database based
on Windows Authentication or a application running under that user's Windows
user credentials can access the database.


>
>
>
> 2. Regards to the Password
> I am trying to access a stored procedure and apparently I need to have a
> connection to the database. I copied one of the examples on the top
> (second
> one), but why they use " ^ " which I am not sure why.
> And what if I do not know the password, what do I have to indicate at the
> Password= ?

Some database admins like to make complicated passwords by adding special
characters into the password. In this case, a generic user-id and psw is
made up by the admin so that any application or user that accesses the
database can use the one generic user-id and psw.

psw=Justin or psw=Justin!#12@BB A database like MS SQL Server will allow
user access via authentication Windows Integrated Security or User supplied
user-id and psw.

Database user authentication to access a database is by Windows
Authentication or is done by the supplied user-id and psw that must be given
by the user or supplied in a connection string by the application.