Skip to main content
19 votes
Accepted

Reconnect "not connected" query windows in SSMS to original connection

In SSMS, if you run a query in a disconnected window, it will attempt to re-connect to the prior connection. You will get an error, then the window will reconnect. If you run a query like SELECT 1;, ...
AMtwo's user avatar
  • 16.2k
17 votes
Accepted

Does SSMS use ODBC?

SSMS doesn't use ODBC drivers to connect to SQL Server databases. It uses the .Net Framework driver. You cannot choose which driver it uses as it is hard-coded in the application. But why would you ...
Pierre's user avatar
  • 381
14 votes
Accepted

What's the differences between the two version of oracle client download file, "client" and "client home"?

LINUX.X64_193000_client.zip is a fully featured installer where you can choose what to install and where, then the installer copies the files to the destination and registers the client. LINUX....
Balazs Papp's user avatar
  • 40.8k
12 votes

SQL Server Error while creating User

The error message is stating that SQL Server cannot locate a login named Hiru, or you do not have the privilege required to create a user. The SQL Server security model consists1 of a server-level ...
Hannah Vernon's user avatar
  • 70.2k
11 votes

The specified network name is no longer available

Sounds like spotty DNS resolution issues or long running queries. For DNS trouble-shooting As a Band-Aid and trouble-shooting aid add and entry to the hosts file on your app servers (not the SQL ...
Sting's user avatar
  • 2,788
10 votes
Accepted

"login failed for user " on SQL Azure from azure hosted web application

The problem turned out to be in the connection strings. There are some things you need to consider. First of all there is an option in the publish wizard in Visual Studio in the Settings tab called ...
Ricker Silva's user avatar
10 votes
Accepted

Static DAC ports for named instances

Taken from the Microsoft Support site: To configure a static port for the specialized Dedicated Administrator Connection (DAC), you must update the registry key that corresponds to your instance. For ...
Hannah Vernon's user avatar
  • 70.2k
9 votes
Accepted

Error message - view server state permission was denied - when connecting to SQL Server 2014 using SQL Server 2012 Management Studio

Just for reference, this problem seems to be related to this Connect bug: Cannot view properties of database when using db owner account - by Jimmy Rudley Posted by Microsoft on 7/9/2013 at 2:47 ...
taborda's user avatar
  • 106
9 votes
Accepted

PgAdmin 4 - How to connect to database using unix socket via ssh tunnel?

That should work fine with the correct ssh command. To forward from a local Unix socket to a remote one runs ssh -L /tmp/.s.PGSQL.5555:/var/run/postgresql/.s.PGSQL.5432 -N laurenz@dbserver Then you ...
Laurenz Albe's user avatar
  • 53.4k
8 votes
Accepted

Client application disconnects from database/s it is connected to after 10 minutes of inactivity

pgAdmin keeps throwing up a connection timeout every 10 minutes or so. I would think that the problem might be related to a router (or, in some cases, a stateful firewall) between your pgAdmin client ...
joanolo's user avatar
  • 13.5k
8 votes

Connect to SQL Server over Internet

The recommended way to do this is to set up a VPN between the two sites. The steps to do this vary depending on the particular firewall/router being used. If a VPN cannot be used, the following ...
8 votes
Accepted

How to access a SQL Server database using another user with permissions in the same intranet

You can open SSMS as her Windows user account by doing either of the following: Right click the SSMS shortcut while holding the SHIFT key. Click on Open as another user and enter the other users ...
George.Palacios's user avatar
8 votes
Accepted

SQL Server on Ubuntu - An existing connection was forcibly closed by the remote host after reboot

MSSQL expects OpenSSL v1.0 while Ubuntu 18+ uses OpenSSL 1.1, resulting in a OpenSSL version mismatch. The solution is to symlink ssl v1.0 as below: Stop SQL Server sudo systemctl stop mssql-server ...
Dawoodjee's user avatar
  • 498
8 votes
Accepted

SQL Server trusted connection additional security

The feature designed to help in this scenario is Application Roles. With an Application Role you can allow the user to connect to the target database, but not be able to run any queries until the ...
David Browne - Microsoft's user avatar
7 votes

The specified network name is no longer available

This is not a database issue. There is no change on database side that can resolve this issue. This error is caused by high network bandwidth or error in your application. I would suggest you to ...
user1987's user avatar
7 votes
Accepted

Cannot connect Power BI Desktop to Azure SQL!

To get around this problem, notice that "Windows" is highlighted at the left of the dialog box. I clicked on Database, entered the database credentials, and then it worked.
John's user avatar
  • 186
7 votes
Accepted

Connecting to a local MS SQL Server from a GUI client

If you are running the GUI on the same machine as the mssql-server service, then you can use localhost for the address (127.0.0.1). If you are running the GUI from a different workstation, you'll ...
Hannah Vernon's user avatar
  • 70.2k
7 votes
Accepted

how to Enable these Windows Firewall rules using powershell?

You would use the Enable-NetFirewallRule cmdlet: Enable-NetFirewallRule -Name "WMI-WINMGMT-In-TCP", "WMI-RPCSS-In-TCP" In order to find the relevant rule names (in order to enable it), you can ...
Josh Darnell's user avatar
  • 29.4k
7 votes

SQL Server trusted connection additional security

A possible solution is to create a server logon trigger that would check the app_name(). I created the following server trigger on my local instance and tried to connect via ODBC. The connection was ...
Scott Hodgin - Retired's user avatar
6 votes

SQL Server Named Instance is not listening on Port 1434

Some additional investigation is needed here. First, it is possible that you are filtering out too much of the netstat output in your findstr filter. Instead of "processID", check for the port number ...
Solomon Rutzky's user avatar
6 votes

SQL Server 2016 Availability Groups Named Pipes?

From the documentation on Listeners, Client Connectivity, Application Failover An availability group listener consists of a Domain Name System (DNS) listener name, listener port designation, and ...
Tom V's user avatar
  • 15.7k
6 votes
Accepted

how to stop using sql server login credentials in a linked server?

I don't know if you got this resolved or not, but after recently going through our own (re)discovery of the requirements to get delegation running, I figured I could at least provide an answer in the ...
John Eisbrener's user avatar
6 votes
Accepted

Official documentation for all connection string parameters

Connection string keywords for Microsoft-supplied SQL Server drivers vary by API. The documentation is included with the API-specific driver documentation. Below are links to the official Microsoft ...
Dan Guzman's user avatar
  • 28.3k
5 votes

The connection is broken and recovery is not possible - sql server error

This is an old thread but this was the first hit on Google so I'm going to add my experience here. I was using SQL Server 2014 Enterprise while remote connected to the server. I was attempting to ...
630's user avatar
  • 305
5 votes
Accepted

What are valid connection strings for SSMS login box?

There are various possibilities and I will try to answer them according to the numbered questions. Valid connection strings for the SSMS login box are: 1st instance Using the host name SERVERNAME ...
John K. N.'s user avatar
5 votes

"login failed for user " on SQL Azure from azure hosted web application

I struggled for 2 days to figure out why I'm getting a "Login failed for user 'null'" error message even though my connection string is correct and I'm able to connect to the DB server via SSMS. ...
Jen's user avatar
  • 51
5 votes
Accepted

Why does psql open two tcp connections to PostgreSQL?

This double connection depends on whether a password has to be submitted by the client (according to pg_hba.conf) and, if yes, whether the -W option is passed to psql. In fact avoiding that second ...
Daniel Vérité's user avatar
5 votes

SQL Server Error while creating User

First create a global login under Security -> Logins Then add the user in Databases -> Database -> Security -> Users
CharithJ's user avatar
  • 151
5 votes
Accepted

Not authorized on test to execute command

Turns out that I was missing a /authDBName in my connection string. It should be this: mongodb://myUser:[email protected]:27017,SG-staging-43334.servers.mongodirector.com:...
now_world's user avatar
  • 191
5 votes
Accepted

cannot connect to SQL Server using local 127.0.0.1 address unless the login user has sysadmin role

TCP 1434 is usually the default port for Dedicated Admin Connections, requiring sysadmin. That explains why the connection succeeds with a sysadmin role member but fails with a minimally privileged ...
Dan Guzman's user avatar
  • 28.3k

Only top scored, non community-wiki answers of a minimum length are eligible