Configuring MSDE (SQL Server 7) to be accessed from ASP.NET I have begun to do some ASP.NET development, and to get my feet wet I decided to try to use MSDE that was installed when I installed VS.NET Enterprise Edition. I used to do a lot of database programming in my early years, so I naturally looked for the "pubs" database for prepopulated tables/content.
After 30 minutes of searching locally and in news groups, I finally gave up and downloaded an application that would install it. What a pain! Almost all of the samples that I was looking at in Essential ASP.NET used the "pubs" database, but neither VS.NET documentation nor the book gave instructions on how to install/use it.
I then wrote a small ASP.NET application that tried to use the SystemData.IDbConnection to create a connection and then open it with "uid=sa" and password = "" - only to meet with the error: "Not associated with a trusted SQL Server connection". I spent the next 3 hours trying to figure out why I was getting this error and how to fix it - apparently many people have run into the same error.
It turns out that I had to install the SQL Server Enterprise Manager utility so that I could change the security authentication model from "Windows only" to "SQL Server and Windows" (aka mixed mode). Luckily I have access to SQL Server 2000 Developer edition which installs this utility, so I was able to fix the problem. I just wonder how someone would make a change to the security authentication model without this utility, considering that SQL Server 2000 Developer edition isn't free.
3:40:15 PM 
|
