- 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
My backup database of sql server 2012 has been damaged. How can i restore backup file in sql server 2012?
Hello, I am a newbe to programming. Is there a way to connect to multiple databases using ADO. I'm currently using the following string to connect to one database. dbname1 = "FireReportingTest"
I've got some long running data profiling queries that I am running against a SQL Server 2008 DB. Here is the connection string that I am using with the .NET System.Data.SQLClient provider.
Hi, I have created my Sql database in my local server using sql authentication..Created windows application using vb.net.When i install my setup file in my networks computers it runs successfully..but
Connection string to SQL Server 2012 "LocalDB" April 2, 2014 Hello, Could I get a little help on my very first attempt to write an app with code that connects to my own database table on my own computer. Using Windows8.1, Visual Studio 2013 Express bundled with SQL Server2012 Express localDB.
Now I'm using oledb in order to database connection on the c/c++ application program. Provider=SQLOLEDB;Data Source=127.0.0.1,1433; FailoverPartner=Partner_datbase_server_name;Database=databasename;User Id=id;Password=password;Network=DBMSSOCN;
hello .. im developing vb.net windows application with sqlserver 2008 database but i face aproblem with multi client lied in different location .. since making a network between them is costly ..
I have one directory website which is up and running and using the sql server 2000 database thru Godaddy. I recently made a duplicate of this website as I plan to start a new directory.
Hi, Is there a way to communicate with MSSQL directly avoiding the ODBC. I have been advised to use MSSQL Native Client which uses ODBC, OLE and ADO techniques. But is there a direct communication possible.
Hello, I would like to create a database and add tables from VBA. Can someone help me ? I have tried the following code with no sucess :( Dim str Dim conn, rst Set conn = CreateObject("ADODB.Connection")