How to change AspNetSQLProvider from SQLExpress to SQL2K. And why do I get this error?
Posted on 2007-03-19
I keep ketting this error when I try to implement the AspNetSQLProvider in the ASP.NET 2.0 Config tab of IIS.
I created an AJAX-exnable web solution (not a web application). I first created a website (192.168.0.154), and pointed it to the folder that the above soltion was later placed in.
I then went into the ASP.NET 2.0 Tab in IIS, clicked on Global, and entered a connection name and string for LocalSQLServer. I changed the login management to Forms, pointing to login.aspx page.
In VS2005, I clicked on the ASP.NET Web Application Configuration web page button, and selected the Provider Management link. I click on the 'single provider' link, and click on test. I get the following response:
Successfully established a connection to the database.
So, I KNOW I have a successful connection for the LocalSQLServer (I DO NOT WANT TO USE SQLEXPRESS. I am using SQL2K, which is why I changed it).
When I go to click on the 'Security' tab in the ASP.NET Application Provider Configuration web page, I get the following error:
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 button below to be redirected to a page where you can choose a new data store.
The following message may help in diagnosing the problem: Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.
Now, it's obvious that somewhere, this stupid VS2K5 or IIS or something was supposed to populate the database I pointed to with a bunch of asp_membership tables and stored procs--which if obviously DID NOT DO.
So, after searching for about an hour on the web, finding zero answers of anyone that knows how to deal with or fix this problem, I am here to offer an expert 500 big ones to help solve this problem for me.
Thanks in advance for your help. I wish I had become a plumber instead of a programmer.