Hello. I am trying to get up web site that uses a Login control, as explained in John Sharp's book "Microsoft Visual C# 2005 Step by Step", chapter 27. It is supposed to run in Visual Studio 2005's web server, connecting to SQL Server Express 2005 on the same machine. The web site is supposed to store the usernames and passwords in new tables in the database being used.
Everything is fine until I fire up "ASP.NET Web Site Administrator", and as directed click on the Security tab. At that point, it claims it can not connect with SQL Server. I have tried running the aspnet_regsql to create a good connection, but the Web Site Administrator keeps stating that "AspNetSqlProvider" fails the connection test. I have tried different connection strings in the machine.config file. I am running XP/Home SP2, plus SQL Server Express Edition 2005, plus SQL Server Management Studio Express. The Management Studio has absolutely no trouble connecting and disconnecting with SQL Server Authentication, using the same username/ password. Should I be looking at the "connection string" web sites? Or other discussion groups? Is AspNetSqlProvider a specialized service, or is it used by a lot of different people?
