Hi Friends...
When I put connection string of sql server in .net in which we type "Integred Security=true", If we put "Integrated Security=False" or "Integreted Security=sspi" then what is te effect of these Integrated Security ? Please Explain ?
Loading

Amit MaheshwariPosted Nov 21, 2011, 3:56 PM
if you are using integrated security true it will take default your admin information whatever you provide at the installation time but if you are taking it false then you should have to provide your username and password if you does'nt then it will give an error.
Actually If we specified a username & pwd in connection string and we are using Integrated Security=SSPI (means windows authentication for SQL Server), its not gonna be used anywhere. So there is no meaning to specified username & pwd in connection string if we are using windows authentication for sql server. So by default It will run under the ASPNET Account. So to resolve this issue we need to create a user machinename\ASPNET in database if not exists and need to give a proper rights to that user.
thanks.
Vineet Kumar SainiPosted Nov 21, 2011, 4:13 PM
karthik vPosted Nov 21, 2011, 4:09 PM
What exactly does these mean in the connection string
Provider=SQLOLEDB
Persist Security Info=True
providerName =System.Data.SqlClient
VulpesPosted Nov 21, 2011, 2:12 PM