- 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
Getting a related error Microsoft SQL Server Native Client 10.0 error '80004005' Invalid connection string attribute /index.asp, line 44 Below is line 44. Running server 2008 with a DSN nmo idea what this syntax problem is?
I have many applications wrote by visual I want to work SQL server, I have many tries to connect but fails, I need help to connect to SQL server by VFP 9.
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; This connection I don't know what is myServerAddress? please explain me!! thank you.
I am new to c# web DB programing . I have tried to write a registration form . Here the DB connection part: The remarks part are my tries to make it work (which did not) .
I have several (more than 100) Excel reports (files) that use the same data connection file. The data connection file connects to SSAS 2012 Tabular Model.
I am having issues getting failover working with mirrored databases. Below is my information on driver I am using and connection string info. Any help would be greatly appreciated!
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