appSettings at Web.Config

[Justin Doh]

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:

<add key="Prod" value="server=SIMSQL123;database=Prod;Integrated
Security=SSPI" />

<add key="Prod" value="User ID=prod_user;Password=prod^user;data
source=SIMSQL1;persist security info=True;initial catalog=Prod" />

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

 

[Mr. Arnold]

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:

<add key="Prod" value="server=SIMSQL123;database=Prod;Integrated
Security=SSPI" />

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.

<add key="Prod" value="User ID=prod_user;Password=prod^user;data
source=SIMSQL1;persist security info=True;initial catalog=Prod" />

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.