Hi, I'm trying to configuremysite membership/roles using the web site configuration tool. But when I click the security optiopn in the tool tab I get: 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'. Ive already amened the connection string namein my web config to 'LocalSqlServer' <remove name="LocalSqlServer"/> <add name="LocalSqlServer" connectionString="Data Source=sql2k501.discountasp.net;Integrated Security=false;Initial Catalog=SQL2005_192986_inv01;User ID=SQL2005_192986_inv01_user;Password=myPasswordHere"providerName="System.Data.SqlClient" /> I've seen an article on the knowledge base about configuringthe membership/role provider so it must be supported in our SQL Server right? Anybody got any ideas? Cheers
Ignore me. didn't read the article properly as usual. In case anybody else gets this I just ran: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>aspnet_regsql.exe -S sql2k501.disc ountasp.net -U SQL2005_192986_inv01_user -PmyPasswordHere -A all -d SQL2005_192986_ inv01
