Questions tagged [connection-strings]

13 questions
120
votes
8 answers

How can I figure out my LDAP connection string?

We're on a corporate network thats running active directory and we'd like to test out some LDAP stuff (active directory membership provider, actually) and so far, none of us can figure out what our LDAP connection string is. Does anyone know how we…
Allen
  • 1,443
  • 3
  • 11
  • 8
6
votes
3 answers

Does the password get sent in the clear when connecting to Sql-Server?

I was asked this today and I honestly did not know the answer. If you connect using a connection string without sspi to a server is there any way a 3rd party can intercept on the wire the password used to log in? "Data Source=MyServer;Initial…
Scott Chamberlain
  • 1,445
  • 2
  • 21
  • 37
4
votes
6 answers

SQL Server 2008 login problem with ASP.NET application: Failed to open the explicitly specified database

I am running SQL Server 2008 Express Edition on Windows Server 2008 with an ASP.NET application which must access the server. The ASP.NET application is associated with an application pool that runs on the NetworkService account. This account in…
eulerfx
  • 151
  • 1
  • 1
  • 6
2
votes
2 answers

Can I use failover partner in the connection string for non-mirroring SQL server set up?

I have set up two SQL server instance with IPs say x.x.x.x and y.y.y.y. On the application level when specifying connection to SQL server, can I specify the connection string as below jdbc:sqlserver://x.x.x.x:port;…
2
votes
0 answers

Failover_Partner connection in file DSN not working

I have an application which uses file DSNs to connect to a central database server. This database server is mirrored onto a secondary server, and in the event of a failover, it is my understanding that adding a line in the file DSN…
2
votes
1 answer

nodejs postgresql database connection string

Is there a way where I can specify(include) both the master and slave server in nodejs db (postgresql) connecetion string in a replicated envirnment? My aim is 'if master is down then the read/write should go to the slave'
Ajo Augustine
  • 1,252
  • 4
  • 16
  • 21
1
vote
1 answer

IIS not picking up inherited connection strings

So this question is a duplicate of: IIS 7.5 - why my config file is not picked up but there was no answer on there and IIS Connection String not being inherited had an answer but the accepted answer didn't help me. We have junction pointers set up…
Ben Black
  • 111
  • 3
1
vote
1 answer

Trouble Publishing an MVC4 site on HostGator

I have been working on a C# MVC4 website and trying to publish it to a Host Gator shared Windows hosting account. They are running both MSSQL 2008 and mySql. We have run into some trouble when trying to get the site to work. First of all we are…
sec_goat
  • 169
  • 1
  • 1
  • 13
1
vote
1 answer

Which is more secure - windows authentication or encrypted config sections?

I recently had this discussion with a colleague. We need to secure the connection strings that are in our .config files (for SOX compliance) and found two options: Encrypt the connection string configuration sections Use windows authentication with…
Oded
  • 267
  • 2
  • 16
1
vote
1 answer

what's the port number of mysql

I'm trying to connect mysql with vb.net, I've already downloaded the mysql connector-net. And installed it. But I don't know what is the port number , server address of mysql. Its needed in the connection string. Please…
user28233
  • 125
  • 1
  • 3
  • 12
0
votes
2 answers

How to configure IIS 10 to read from local SQL database file?

I have been trying to deploy original ASP .NET Web Application using MVC template with authentication via a local SQL database file. So far, I am able to get it to work on my computer. When I publish it to a folder on a remote server, I can't seem…
Ice Drake
  • 25
  • 1
  • 1
  • 9
0
votes
1 answer

ASP.NET Application Connection String and SQL Server Security / Permissions

I am deploying an ASP.NET application and SQL Server (2008) database on a live (production) server. The physical server is running both SQL Server 2008 and IIS 7 - it is provided by a hosting company and is not part of our internal network. I have a…
0
votes
0 answers

Enter Azure SQL Connection String in App Settings w/ PowerShell

I've deployed an Azure Web App and Azure SQL Database using PowerShell. At the moment I have the following code with a dummy value that sets a sql connection string for my web app: $connectionStrings = @{ "sqlConnection"= @{ …