Questions tagged [connection-string]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
-1 votes
0 answers
29 views

Is it possible to capture the connection string used to connect to SQL Server

I have recently taken over a number of SQL Server 2008 databases that are configured with mirroring. I understand there are some applications that connect using the "Failover Partner" option ...
user avatar
1 vote
1 answer
64 views

Official documentation for all connection string parameters

I've been hunting for this information for years now but I don't seem to be able to find it: Is there any documentation available on docs.microsoft.com providing a table with all valid connection ...
user avatar
  • 123
0 votes
0 answers
86 views

dbeaver connection cannot change driver properties schema

For the dbeaver connection, edit connection (Athena JDBC, i.e. AWS daata lake), "driver properties" tab: I cannot change driver properties schema field (default) anymore. This used to be ...
user avatar
0 votes
1 answer
111 views

Breaking down SSIS keystring values for connection manager between Server2000 and Server20008

I have an SSIS package between a SQL2000 and SQL20008 server that cannot connect since migrating to VM. The SSIS package runs a data transfer between the two servers using 3 Connection manager strings....
user avatar
  • 75
0 votes
1 answer
57 views

Can SSIS packages call other SSIS packages in the connection string?

I am running an SSIS package that transfers data from one (SQL2008) server to another (SQL2000). However after P2V conversion the SQL2008 server cannot execute an SSIS package due to a user ...
user avatar
  • 75
1 vote
1 answer
166 views

Able to connect with connection manager but SSIS package does not authenticate

I have an SSIS package that connects MSSQL2008 server to MSSQL2000 and pulls data off the 2000 server and transfers it to the 2008 server. The 2000 server was recently virtualized and since then the ...
user avatar
  • 75
2 votes
1 answer
797 views

How do SSIS connection strings send passwords?

I have a SQL server that pulls data from another SQL server via SSIS. We recently converted the server targeted by SSIS to VM. Since the VM conversion I have been getting "login failed for user '(...
user avatar
  • 75
2 votes
2 answers
288 views

Does it matter which database you connect to when querying across multiple databases?

I'm building a Sharepoint application with Nintex workflow that runs a single SQL query over multiple databases (on the same MS SQL server). Does it matter which database I specify in the connection ...
user avatar
  • 121
1 vote
2 answers
5k views

How to connect to a local SQL Server instance by IP Address in SQL Server Management Studio? [duplicate]

I'm writing some test code that is required to connect to a local SQL Server instance (SQL Server 2017 - Developer Edition) by IP address. I have the SQL Server instance up and running on my machine, ...
user avatar
  • 24.2k
0 votes
1 answer
898 views

SQL Server Linux(Ubuntu) Connection Options

In general SQL Server Connection Protocols allows three different connection protocols: TCP/IP Named Pipes Shared Memory in linux by default installation we can connect to the SQL Server ...
user avatar
1 vote
0 answers
425 views

How to hide SQL Server connection string and SQL login password from Developers

We are using Microsoft Azure App Services to host some of our Web Apps. Web Apps connect to on-premises SQL Server over hybrid connections. When new Web App needs access to the on-prem SQL Server, a ...
user avatar