Questions tagged [connectivity]

Establishing a connection to a database or database server.

Filter by
Sorted by
Tagged with
30
votes
6answers
32k 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 ...
11
votes
5answers
146k 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 ...
3
votes
1answer
13k 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 ...
8
votes
9answers
70k 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 ...
4
votes
1answer
2k 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 ...
24
votes
4answers
35k 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 ...
9
votes
1answer
37k 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 ...
7
votes
3answers
74k 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 ...
3
votes
1answer
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 ...
10
votes
3answers
41k 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 ...
5
votes
2answers
2k 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 ...
6
votes
1answer
4k 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 ...
17
votes
3answers
49k 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?
8
votes
2answers
7k 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 ...
8
votes
3answers
24k 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 ...
7
votes
1answer
21k 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 ...
8
votes
1answer
6k 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 ...
3
votes
1answer
8k 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 ...
2
votes
0answers
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 ...
2
votes
1answer
2k 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-...
1
vote
1answer
2k 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 ...
1
vote
1answer
475 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 ...
0
votes
1answer
2k 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 ...
0
votes
2answers
18k 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 ...
3
votes
1answer
2k 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....
2
votes
0answers
675 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 ...
2
votes
1answer
1k 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 ...
1
vote
1answer
427 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 ...
1
vote
0answers
40 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 ...
0
votes
1answer
52 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 ...
0
votes
1answer
375 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 ...