What is SQL authentification?

[lehuong]

Hi all,
What is SQL authentification? and how to set it up on the web.config in order to user it?
Thanks a lot
lehuong

 

[Craftor]

Someone can correct me here if I am wrong but SQL Authentication is when you use a SQL login name and password as opposed to a Windows login name and password to access a SQL Server.

To set it up in web.config - you could just add a connection string as a key in the <appSettings> section in your web.config and return this from your code e.g.

<add key="ConnectionString" value="data source=YOURSERVER;initial catalog=YourDatabase;user id=sa;password=password;" />

You can then access this key in code as follows:

string connStr = System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]

Hope this helps!

Craftor

 

[lehuong]

Thanks,
I think you are right. but how about the authentification mode? Is it a mode = "Forms" Or "Windows"?

<authentication mode="Forms" >
</authentication>
<authorization>
<deny users="?" />
</authorization>
</system.web>

Thanks
lehuong

 

[Craftor]

Aah what you're looking that is your application's authentication. That has nothing to do with SQL authentication, unfortunately.

 

[lehuong]

Thank you very much!
lehuong