Please post the connectionstrings element of your web.config or machine.config so that we can hazard a guess at the possible cause of the error.
Also, are you sure your SQL Server service is started when you try to run the website manager? On Mar 10, 5:35 am, jjh <[email protected]> wrote: > 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?
