Skip to main content

Questions tagged [connection-string]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
80 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 ...
BaltoStar's user avatar
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 ...
Riley Major's user avatar
  • 1,903
0 votes
0 answers
227 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 ...
Roman DotNetDev's user avatar
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 ...
microsoftvamp's user avatar
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 ...
dexon's user avatar
  • 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 ...
MrVimes's user avatar
  • 629
2 votes
1 answer
366 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 ...
AxD's user avatar
  • 133
0 votes
1 answer
531 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....
mcv110's user avatar
  • 75
0 votes
1 answer
118 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 ...
mcv110's user avatar
  • 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 ...
mcv110's user avatar
  • 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 '(...
mcv110's user avatar
  • 75
2 votes
2 answers
473 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 ...
Teebs's user avatar
  • 121
3 votes
2 answers
27k 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, ...
J.D.'s user avatar
  • 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 ...
Ata Tiba's user avatar
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 ...
Aleksey Vitsko's user avatar