Questions tagged [connection-string]
The connection-string tag has no usage guidance.
15
questions
0
votes
1
answer
83
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
1
vote
2
answers
9k
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,903
0
votes
0
answers
228
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
6k
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
77
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 ...
- 47
0
votes
0
answers
98
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
368
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
537
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
121
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
475
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
28k
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, ...
- 38.3k
0
votes
1
answer
2k
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 ...
- 3
1
vote
0
answers
722
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 ...
- 5,827