"Justin Doh" <JustinDoh [at] discussions.microsoft.com> wrote in message
news:F847D60F-5122-4B8B-8968-7866AC3CCA0B [at] 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:
>
> <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 [at] 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.
