Questions tagged [connection-string]
The connection-string tag has no summary.
17 questions
0
votes
1
answer
153
views
Lookup what SQL connection string did the client use to connect
I have an onpremise SQL database server, to which, many applications connect to.
Created CNAME record for the server and instructed users to change it in their app connection string too. Most of them ...
- 265
0
votes
1
answer
249
views
MS SQL Server Availability group listener port setup
There are a lot of useful, similar questions on this topic, as well as this part of the documentation (https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/availability-...
0
votes
1
answer
238
views
Connection string for a successful SSMS connection
In SSMS v19 I can successfully connect/login to a SQL server that is listening on the default port 1433
Server : server.env.domain.com,1433
Authentication : SQL Auth
And I can query any of the ...
- 99
2
votes
2
answers
15k
views
SQL Server Connection String - MultiSubnetFailover True or Yes?
The MultiSubnetFailover option in database connection strings controls how the client attempts to connect to a database server, especially when multiple IPs are available.
There is conflicting ...
- 1,955
0
votes
0
answers
320
views
Connection String requires AttachDbFilename property
I'm trying to use SQL Server LocalDb to store the database by connection string. During first connection to the database I have an error about connecting to the database. In SSMS it is opening. To fix ...
3
votes
1
answer
8k
views
cannot connect to SQL Server using local 127.0.0.1 address unless the login user has sysadmin role
problem
i am trying to connect to the server using Microsoft ODBC Driver 17 for SQL Server through sqlcmd setting the -S (server) option pointing at 127.0.0.1,1434. i have confirmed this is the ...
0
votes
0
answers
95
views
Failover - azure. Connection string
I've got a primary and secondary database that i've just configured a Failover group.
My question is:
Can existing connection still connect directly to the DB, or do i need to change all connection ...
- 67
0
votes
0
answers
110
views
Remove requirement to specify [default] MS SQL port in vb and vbscript connection strings
I need to 'swap' an old database server (Windows Server 2008, SQL Server 2005) with a newer/better one (Windows Server 2012, SQL Server 2008) I tested this swap yesterday and everything worked on the ...
- 629
2
votes
1
answer
457
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 learn.microsoft.com providing a table with all valid connection ...
- 133
0
votes
1
answer
607
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....
- 75
0
votes
1
answer
159
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 ...
- 75
1
vote
1
answer
1k
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 ...
- 75
2
votes
1
answer
4k
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 '(...
- 75
2
votes
2
answers
562
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 ...
- 121
3
votes
2
answers
34k
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, ...
- 41.1k