- Q & A
- ask question
- log In
- Copyright 2014
- © 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
SQL Express connection string for vb6. Need to connect SQL Server2005 with VB6 i have below code.. i have to change Username and password to open the software. but it is in windows authentication to open,
We have the following set up: Windows Mobile Device with GPRS connection (win empedded handheld 6.5 Prof) Windows Server PC with SQL Server 2012 VPN Network where both devices contained (the cell carrier routes certain IPs inside VPN)
Installed SQL Server 2014, and using MS SQL Server Management Studio, if that matters. Very simple question: how do I get the Import-Export function to actually....work. (I believe I should be using the 32-bit version.)
How to connect to an AlwaysOn Availability Group failover cluster either for SQL Server Management Studio or for a Customer application ? regards
Hi, I am trying to make a new ODBC connection to our company's SQL Server Reporting Services 2012 server to reach an Oracle db, however I've been unsuccessful trying to create the connection string.
How to connect SQL Server 2000 Database over internet? I have written the code as follows: db.Provider = "SQLOLEDB; Data Source=xxx.203.xxx.135,1433; Network Library=DBMSSOCN; Initial Catalog=accinv; User Id=sa;"
Target: Microsoft SQL Server Express Edition with Advanced Services (64-bit) OS: Microsoft Windows NT 6.1 (7601) Version: 10.50.1600.1 I have tried close to 30 various of the following, none of which work, any insight/suggestions would be great appreciated!
Hi,I have developed an application using Visual Studio 2008 on C# for stand-alone device, working under Windows Embedded Compact 7. Application work with SQLCompact 3.5 . using System; using System.Linq;
I have an ASP.NET C# application with a SQL server 2012 database that has consolidated membership provider and application database. I am trying to modify my web config according to the instructions provided by the hostforlife.eu hosting service but I think I'm missing something.
I am trying to connect to sql server 2008 r2 from Excel 2010 (VBA). the process is for internal purposes only. I need to pass an id and password to connect to the db from excel.