Problems using SQL 2005

I'm going to move this onto a server with SQL 2005 installed. I also happen to have SQL 2005 installed on my home machine, so it seems silly to me to install SQL Express.

I'm following the

Video Series: Visual Web Developer for Beginners video to use login controls. I click on Website-> ASP.NET Configuration, then on the Security tab. I get the following message: "There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the buttom below to be redirected to a page where you can choose a new data store."

"The following message may help in diagnosing the problem: Unable to connect to SQL Server database."

I clicked on the button to choose data store, selected "Select a single provider for all site management data", clicked the radiobutton for AspNetSqlProvider, then clicked test.

I then got the following message: "Could not establish a connection to the database. If you have not yet created the SQL Server database, exit the web site administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider."

I did that. I did it with windows authentication, and with SQL server authentication (as the administrator). I did it with the default database, and with one I created. At some point, a new database was created, aspnetdb, but I can't get the setting right, I can't connect to it.

When I run aspnet_regsql, I get the following message: "You should now configure the provider for membership, profiles, role, personalization and SQL Web event provider to reflect the changes you made in this wizard" and so on...

So what could I be doing wrong? How do I configure this for SQL 2005? Also, the database that's created. Can this be used by all the websites I develop? Or do I need a separate database per website? What are my other options besides SQL or SQL Express? Can I use Access? Anything else?

I would appreciate any help you can give me!

More than likely your server won't accept remote connections. Start here:

http://www.teratrax.com/articles/connecting_sql_server_express.html

Buck Woody

|||http://forums.microsoft.com/msdn/ShowPost.aspx?postid=1117787&siteid=1