SQL SERVER with VS2010 Login

Hi,

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=&quot;mssql.aspnethosting.co.uk, 14330&quot;;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=&quot;mssql.aspnethosting.co.uk, 14330&quot;;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?

cheers

Sue