I am trying to create a website which has some pages limited to logged in users. I can make it work on my local machine but cannot work out how to point to a remote database.

I have created the remote SQL database using regsql, the command looks like this:

"C:\Windows\Microsoft.NET\Framework64\v4.0.30319\aspnet_regsql.exe -S "Server" -U UserName -P Password-A all -d database"

I guess this worked as when I look at my database I can see all the relevant tables, Users, Roles Membership etc.

I then click on Configure ASP.NET to use the administration tool. I tried to set up using Internet as the security option and this tells me to go onto the provider tab. I go to the Provider tab and all I can do is click on test which fails ans tells me to go to regsql which I have already done.

I have 2 connection strings on my web.config, one for the login details and one for a simple gridview which looks at the Users data.

The strings are:

add name="ApplicationServices" connectionString="data source="mssql.aspnethosting.co.uk, 14330";Initial Catalog=elmirawe_Database;Integrated Security=SSPI;User Instance=true; User ID=name;Password=pword" providerName="System.Data.SqlClient"/>

add name="ConnectionString1" connectionString="Data Source="mssql.aspnethosting.co.uk, 14330";Persist Security Info=True;User ID=name;Password=pword" providerName="System.Data.SqlClient"/>

ConnectionString1 works fine but the Application Services won't work with the Admin tool.

What have I missed out?? Any idea what I can do to fix it?



edit delete
are you sure?
asked Sue Edmonds

0 answers

Post an answerbut please login first

Post Answer
  1. Please login to post answer


Similar Questions