- Copyright 2013
- © ConnectionStrings.com
- All Rights Reserved
- Powered by CSAS
- With support from Contributing Developers and Windward Reports
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?
Sue0 asked Sue Edmonds