Windows verification string

1: Set the database connection string to the following format:
Provider = sqloledb.1; Integrated Security = sspi; persist Security info = false; initial catalog = database name; Data Source = IP Address
2: Ensure that the client and database server have the same user and password
3: the database server user belongs to the Administrators group.
4. Set the Authentication Mode on the database server to Windows.

 

 

Set in Web. config (during windows verification)

Define a connection string in a class file
String pr_conn = configurationmanager. connectionstrings ["northwindconnectionstring"]. connectionstring;

String pr_ SQL = "database query statement ";
Sqldatasource pr_ds = new sqldatasource (pr_conn, pr_ SQL );
Return pr_ds.select (datasourceselectarguments. Empty );