Following article demonstrates the steps involved in configuring a trusted SQL Server connection to access data using ADO.NET – Written by Shanthanu
Pre-requisites
1. A local instance of SQL Server has to be setup on the same machine as the IIS
2. Optionally, during setup, the SQL server must be configured to be accessible thro’ Windows Authentication Mode. (It doesn’t matter if you haven’t done so)
Step 1: Creating a Trusted SQL Server Connection
For convenience this discussion assumes that an Administrator account is going to be assigned as the trusted SQL Server Connection. (Please read the note at the end of this paper)
 |
1. Open the SQL Server Enterprise Manager from the Windows Start Menu
2. Navigate to the Security Node under (local)(Windows NT) node that represents the local instance of SQL Server 2000 installed on your computer. 3. Right-Click the LogIns Node and ClickNew Login. 4. In the SQL Server Login Properties dialog for New Login, click the Browse button against the text box marked Name |
|
 |
1. In the next dialog that opens up, select the computer from which the user account has to be chosen from the Drop down list captionedList Names From: Continues… Pages: 1 2
|