- 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
How do you connect to a SQL server hosted at Amazon RDS via ADO? More specifically, I need to connect via Dreamweaver's Custom Connection String. The format used for virtually hosted instances of SQL Server Express do not seem to work. I get an "unidentified error" message.
Hi everyone, I'm currently doing some research on the MS SQL native client for ODBC driver's security. I would like to seek details on how secure is ODBC driver in MS SQL Native client?
I am executing SSIS packages that override the Connection string by submitting new connection parms from batch execution of the package using dtexec.
I have an sql server command, calling a stored procedure. actually the problem happens with all types of commands but this is my test only. 1- i have tested calling the procedure from inside SQL server management studio, it took 34 Seconds to execute.
I am trying to develop an MVC app on my local computer and I have huge troubles opening a connection to my database. At the same time, I am able to run SQL scripts and they work just fine.
I have a web page that imports translations from a spreadsheet using Microsoft.ACE.OLEDB.12.0; The process works almost flawlessly, except that Japanese (and likely Korean and Chinese) can not be imported with this method.
Hi, Help!! How do I use a variable in a select statement in vba? This is a standard query Select IngredientID, Quantity, from Recipes where RecipeID = 7 This is what I would like to do, but do not know how to.....
web.config connection string to SQL named instance on cluster works for some time and suddenly stops working. I do the stops start of app pool and it is working again, but after some time (of inactivity) it stops working!!!
I want to use multiple DSN connection string in my web.config file. But its giving error as default driver not specified. Any one please help me
Hello guys I was directed to this site as THE place to find information on how to write the connection string I need. I am still quite new at this coding stuff so any help would be appreciated.