MSDE 2000, make sure you have the special Service Pack 3 for MSDE 2000. You
can get it from <a href="http://www.microsoft.com/sql/downloads/2000/sp3.asp">here</a></li>
- <li>For those that only have MSDE installed. You can change the authentication mode \r
- from Windows Only Authentication to SQL Server and Windows Authentications (also knows as Mixed-mode authentication)\r
- via the <a href="http://support.microsoft.com/default.aspx?scid=kb;en-us;Q322336&sd=tech#4">registry</a></li>. It is\r
- the LoginMode you need to change. By default,\r
- MSDE is installed with Windows Only Authentication. If you want SqlClient to work with MSDE via SQL Server authentication, you will\r
- need to change the setting. Otherwise, you wil have to use NT Authentication.</a>\r
- \r
- <li>If using MSDE, you might need to create a new user with password. Give\r
- this user access to various databases in this MSDE instance. Also, for each\r
- database, give this new user at least SELECT access to the various tables you want\r
- to retrieve data from.</li>\r
- \r
- <li>If you have Enterprise Manager, you can easily change the authentication mode\r
- for both MSDE and Microsoft SQL Server. To change the authentication mode in \r
- Enterprise Mananger, select the instance, right-click on it, and select properites.\r
- The SQL Server properties dialog for that instance will pop up. Choose the Security\r
- tab. Change the Authentication from Windows Only to SQL Server and Windows. If\r
- the instance of your database does not show up in Enterprise Manager, Register first\r
- by selecting the Action menu and choosing New SQL Server Registration.</li>\r
+ <li>For those that only have MSDE installed. You can change the authentication mode
+ from Windows Only Authentication to SQL Server and Windows Authentications (also knows as Mixed-mode authentication)
+ via the <a href="http://support.microsoft.com/default.aspx?scid=kb;en-us;Q322336&sd=tech#4">registry</a></li>. It is
+ the LoginMode you need to change. By default,
+ MSDE is installed with Windows Only Authentication. If you want SqlClient to work with MSDE via SQL Server authentication, you will
+ need to change the setting. Otherwise, you wil have to use NT Authentication.</a>
+
+ <li>If using MSDE, you might need to create a new user with password. Give
+ this user access to various databases in this MSDE instance. Also, for each
+ database, give this new user at least SELECT access to the various tables you want
+ to retrieve data from.</li>
+
+ <li>If you have Enterprise Manager, you can easily change the authentication mode
+ for both MSDE and Microsoft SQL Server. To change the authentication mode in
+ Enterprise Mananger, select the instance, right-click on it, and select properites.
+ The SQL Server properties dialog for that instance will pop up. Choose the Security
+ tab. Change the Authentication from Windows Only to SQL Server and Windows. If
+ the instance of your database does not show up in Enterprise Manager, Register first
+ by selecting the Action menu and choosing New SQL Server Registration.</li>
<li>Located at mcs/class/System.Data/Test is a test for System.Data.SqlClient
named SqlTest.cs and you could use this as a basis for your test.</li>