Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [connectivity]

Establishing a connection to a database or database server.

Filter by
Sorted by
Tagged with
31 votes
6 answers
39k views

SQL Server compatibility with New TLS Standards

The major browsers are moving beyond SSL3.0 and TLS1.0 . The PCI Security Council has declared an end-of-life date for these protocols to be considered sufficiently strong encryption. We need to move ...
Mark Goldfain's user avatar
8 votes
1 answer
4k views

What are valid connection strings for SSMS login box?

What are valid connection strings for SSMS login box? Every once in a while I will have to connect to an instance of SQL Server with some specific configuration setting or in a DMZ where no host ...
John K. N.'s user avatar
  • 17.9k
11 votes
5 answers
159k views

How to access a SQL Server database from other computer connected to the same workgroup?

I have created a C# application which uses a SQL Server database. I have other computers connected to me and to each other in a workgroup. I have shared my C# application with others. When they open ...
user avatar
30 votes
6 answers
53k views

SQL Server Management studio slow connection or timeout when using Windows Authentication

I'm getting extremely long delays (10~30 seconds) in SQL Server Management Studio 2014 when attempting to connect to a SQL Server 2012 instance over TCP using Windows Authentication. This happens when ...
Jordan Rieger's user avatar
3 votes
1 answer
15k views

Why has my database connection failed?

Recently I have developed software using SQL Server 2012. Now when I try to connect, I get this error message: Cannot connect to AAFI\SQLEXPRESSA network-related or instance-specific error occurred ...
Af'faq's user avatar
  • 131
6 votes
2 answers
3k views

What are all the ways an open transaction will rollback?

When a transaction is opened in SQL Server, what are all of the ways that it can be rolled back? We are currently working with a 3rd party application that is frequently showing open transactions ...
SomeGuy's user avatar
  • 2,013
6 votes
1 answer
2k views

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

I have a linked server based in Italy server_italia that connects to a server based in Oregon USA ORDB1 we are on different but trusted domains. The connection from server_italia to ORDB1 is made ...
Marcello Miorelli's user avatar
17 votes
5 answers
90k views

The specified network name is no longer available

We have an application that access the database (Sql server 2014 enterprise edition). The application calls a stored procedures to access the database. Everything was working fine until recently start ...
Hailegziabher Dechassa's user avatar
15 votes
12 answers
186k views

Error: Cannot Generate SSPI context

When someone tries to connect to a SQL Server instance, the error shows up: It's not possible do generate SSPI context. Yesterday we had a blackout (don't know how to say this expression in ...
Racer SQL's user avatar
  • 7,386
11 votes
2 answers
44k views

Client times out, while MySQL query remains running?

We experienced an issue in which a read-only query, run through MySQL workbench, timed out from a user's UI perspective and remained running on the server (and apparently consuming more and more ...
asthasr's user avatar
  • 243
7 votes
3 answers
100k views

Cannot connect to my local instance

When I connect to my local server, I get this message A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not ...
zey's user avatar
  • 283
3 votes
1 answer
2k views

Rare error lasts only a second "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (146)" 146=ECONNREFUSED

This is a rare error that occurs on Solaris 10, have seen it from Perl, where this line DBI->connect(...) or die "Whoops! $DBI::errstr" outputs Whoops! Can't connect to local MySQL server through ...
700 Software's user avatar
1 vote
1 answer
2k views

How to copy all firewall rules and apply them on a new server?

I often install new SQL Server Servers. Be them production, test or development. There is one thing I still have not automated and it is time consuming: the firewall settings. I know how to ...
Marcello Miorelli's user avatar
0 votes
1 answer
424 views

The service broker is administratively disabled

I have just restored some databases what use service broker from LIVE to staging. it is not working and when I put a profile trace to run it only shows messages related to database id 1 and 4, ...
Marcello Miorelli's user avatar
0 votes
1 answer
527 views

differences in the authentication scheme - could it be because of Kerberos?

I am using this script to check the connections to my sql server: select C.client_net_address, S.host_name, c.session_id, c.net_transport, c.protocol_type, c.auth_scheme, s.program_name from sys....
Marcello Miorelli's user avatar
18 votes
3 answers
56k views

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

When right-clicking on a table and selecting "select top 1000 rows", I get this error: Is there any workaround, other than the obvious upgrade to SQL Server 2014?
Marcello Miorelli's user avatar
14 votes
1 answer
33k views

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

I noticed the Oracle database download page has two groups of clients for users to download. There is a thing called "client" and has 32-bit version and 64-bit version. Also, there is a thing called "...
Just a learner's user avatar
13 votes
3 answers
30k views

Tracking Down Application Timeout Errors in SQL Server

SQL Server 2008 SP3 How do I track down these timeout errors ? The errors are displayed on an intranet dashboard used specifically for error reporting in IIS. My suspicion is that there is a ...
Craig Efrein's user avatar
  • 9,640
11 votes
1 answer
16k views

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

Is there a simple way to reconnect a query window that is "not connected" to the original connection that was used by that query without manually picking the server name needed? If I click the Connect ...
David Hiltenbrand's user avatar
8 votes
2 answers
9k views

Classic ASP Connection to SQL Server 2014 without TLS 1.0 using ADODB.Connection

With TLS 1.0 being disabled in the name of PCI compliance, I'm unable to get a 32-bit Classic ASP application working. Per MS / Stack Exchange recommendations, I've installed: SQL Server 2014 SP1 ...
userx's user avatar
  • 131
7 votes
1 answer
24k views

Connection AlwaysOn AG Listener Problem

I'm a newbie for microsoft technologies and I'm having problems in connectivity part for SQL Server 2014. This is probably an easy issue but I'm stuck. I've 4 servers. One of them is the Active ...
erdimeola's user avatar
7 votes
3 answers
4k views

Can't connect to SQL Server 2017 Local DB shared instance

I cannot connect to a SQL Server 2017 (14.0.1000.169) Local DB shared instance. I tried on a laptop that previously had some SQL Server Express and stuff that I all have uninstalled. And also on a ...
Leojet's user avatar
  • 73
6 votes
1 answer
7k views

Connection Timeout Expired without apparent network issue

We have one particular SQL Server which is intermittently timing out when accepting connections. The issue is consistent throughout the day, but occurs at a very low incidence. How can I continue to ...
Mitch's user avatar
  • 2,638
6 votes
5 answers
41k views

Can't connect to remote SQL server from some machines

Our web server uses SQL Server 2008 R2. I have one development machine that connects to it with the IP address through SSMS and when testing my aspx website. I have several other machines though that ...
David Kroll's user avatar
5 votes
2 answers
16k views

SQL Server Named Instance is not listening on Port 1434

We just installed SQL Server 2016 on a Windows 2016 server. I am having issues connecting to the Named Instance of that server. I have noticed that the server isn't listening on port 1434 either. ...
kaitlyn's user avatar
  • 583
5 votes
1 answer
9k views

Connect to SQL Server using windows authentication from another PC without Active Directory

I have SQL Server 2008 R2 Express installed on a PC. I have some other PCs that are connected to this PC on a local network. Currently, those PCs connect to SQL Server using SQL Authentication, ...
Navaneet's user avatar
  • 913
4 votes
1 answer
4k views

Connection Timeouts and Failed Database Connections on AWS RDS

Environment details - Amazon RDS running PostgreSQL 9.3.14, db.r3.xlarge, IOPS 2000, 500 GB Issue - Numerous java.sql.SQLTimeoutException: Timeout after 30000ms of waiting for a connection and java....
gvatreya's user avatar
  • 203
3 votes
2 answers
15k views

Unable to connect to remote SQL Server instance after thorough troubleshooting

I am at the end of my rope troubleshooting a remote SQL Server connection problem. I am a DBA but not a networking expert. Certain information below has been sanitized using "x" in place of a letter. ...
MasterOfNone's user avatar
3 votes
0 answers
3k views

Server Local Connection Provider has stopped listening on local pipe due to a failure

All, I'm looking at a database where every so often, connections to it will fail. The event viewer and SQL Logs have the following error in them: Server local connection provider has stopped ...
The Great Laughter's user avatar
3 votes
1 answer
11k views

Cannot execute as the database principal because the principal “guest” does not exist

Recently moved SQL Server from a desktop to a virtual machine and now facing the below error message while connecting to SQL Server using SQL Authentication. -2147205987:[Microsoft][ODBC SQL Server ...
user91041's user avatar
3 votes
1 answer
869 views

SQL Server 2012 Always On AG - DBEngine Service account locking

I am having a strange issue and am hoping you guys might be able to help! Problem: I have a 2 node SQL Server 2012 Availability Group Cluster utilising a FSW. Both nodes are using the same DBEngine ...
Sam Partridge's user avatar
2 votes
1 answer
7k views

how to Enable these Windows Firewall rules using powershell?

I have a few servers where I see a blue question mark on the sql server service, as per the picture below. This is the solution: Enabling these Windows Firewall rules did the trick for me Windows ...
Marcello Miorelli's user avatar
2 votes
0 answers
3k views

Cannot connect remotely to a named instance

So, I have two servers (ServerA and ServerB) that I've set up with Windows Server 2008 R2 and SQL Server 2008 R2. My goal is to replicate between these two in a failover fashion (with ServerC as a ...
Nathan C's user avatar
  • 167
2 votes
3 answers
32k views

Browse for Servers does not display local instance

I just installed SQL Server and SQL Server Management Studio but it doesn't show anything in servers list and I don't know how to connect to it. This shows that I have installed SQL Server: But ...
Waleed's user avatar
  • 141
2 votes
1 answer
4k views

Allow remote access to Oracle 12c

After finishing the installation of Oracle 12c on Centos 7, now I try to allow access on my PC (via SQL Developer) to the server. The problem is that when I do: lsnrctl status I get this error: TNS-...
Grapain Gaming's user avatar
2 votes
0 answers
998 views

Include HostName in ODBC System DSN Connection

Not sure if this is a question for here or if it should go on Stack Overflow. If SO is a better fit, please migrate it. Our finance team uses Dynamics GP. Occasionally we need to track the query that ...
Greg's user avatar
  • 3,252
1 vote
0 answers
107 views

sql server connectivity broke down to server after its IP address has moved to a subnet. How to restore its connectivity?

I a server called Vermont on a different domain, with a trust relationship. I can ping the server there. But when I try to connect to it, from my SSMS I get the following error: I used to connect ...
Marcello Miorelli's user avatar
1 vote
1 answer
509 views

Keyword not supported: 'statslog_on'

I am trying to connect to a SQL 2017 instance via SSMS 18.2 with the 'Additional Connection Parameters' StatsLog_On=Yes;StatsLogFile=C:\Temp\TestODBC.txt The documentation at Using Connection String ...
James Jenkins's user avatar
1 vote
1 answer
1k views

How to show the Availability group listener instead of the nodes?

I have just installed a sql server availability group, always on, with 2 servers, SQLPROD1_TS and SQLPROD2_TS as you can see on the picture below: select distinct rcs.database_name, ar....
Marcello Miorelli's user avatar
1 vote
1 answer
679 views

Cannot connect to remote instance

I try to connect to a remote windows server that has a SQL Instance running using SQL Authentication via my local SSMS and this the error I get: Cannot connect to 123.123.123.123\WIN-ODF1AGSBGZ A ...
Offir's user avatar
  • 127
1 vote
1 answer
437 views

MySQL configuration to connect to multiple local applications [closed]

I've installed FreeRADIUS, MySQL and FreeRADIUS management (a web-based app) on the same machine, with both FreeRADIUS and FreeRADIUS management using same user to connect MySQL. My problem is when I ...
JOGOOL's user avatar
  • 13
1 vote
0 answers
3k views

SQL pre-login handshake connection failure

I'm having an intermittent problem with one of my old SQL 2000 servers. Every once in a while it stops accepting logins. I fix the problem by bouncing sqlservr.exe and then it starts working properly ...
Elijah W. Gagne's user avatar
0 votes
1 answer
988 views

Remote computer can't connect to instance with backslash

We are migrating two instances of SQL Server 2008 on a Win7 machine to SQL Server 2019 on a Win10 server. The old server had two instances: 123.123.123.123 and 123.123.123.123\ABC. We had no ...
Koughdur's user avatar
0 votes
1 answer
3k views

Unable to connect to specific instance of Oracle RAC

I did several operations by connecting successfully to all 4 instances but suddenly during one of the jobs, it failed with a TNS error. I checked the connect from SQL and one of the nodes is giving an ...
Bharath's user avatar
  • 47
0 votes
1 answer
2k views

I cannot get my data source to connect to an SQL Server named instance using SSRS Report Builder

I have a report in SSRS and I want to update the data source to use a named instance instead of the default instance. The server host will remain the same. I thought this would be easy. I simply ...
cleverpaul's user avatar
0 votes
2 answers
3k views

Users who are connected into the database

I need some help on how to find all the users that are connected to one of my database. I should check this on weekends to find out all the users that connected during the week. Thank you.
alexsilviu05's user avatar