Local Computer has Visual Studio 2008 installed
Shared Hosting Account has Windows 2003
Shared Hosting Database account has MSSQL Server 2005 (REMOTE DB
SERVER)
1) Created a new Website on Visual Studio (VS)
2) From VS Command Prompt I ran aspnet_regsql
3) I entered the IP of the remote databse server, username, password
and Database Name
4) Logged into the remote DB server and could find the appropriate
tables are created (11 tables)
eg
dbo.aspnet_aplications
dbo.apsnet_users, etc...
5) In web.config of the local computer
<connectionStrings>
<clear />
<add name="LocalSqlServer"
connectionString="server=XX.XX.XX.XX;user
id=MYUSERNAME;password=MYPASSWORD;database=MYDATABASE"/>
</connectionStrings>
Also edited...
<authentication mode="Forms" />
6) I clicked WEBSITE > ASP.NET Configuration
7) When I select the Security Tab, 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: The EXECUTE
permission was denied on the object 'aspnet_CheckSchemaVersion',
database 'MyDBName', schema 'dbo'.
8) On this page there is a button called Choose Data Store, I clicked
that
Your application is currently configured to use the provider:
AspNetSqlProvider
9) Clicked "Select a single provider for all site management data"
10) There is link "Test", next to AspNetSqlProvider
11) I clicked that and "Successfully established a connection to the
database"
What could be the issue??
