Skip to main content

Questions tagged [connectivity]

Establishing a connection to a database or database server.

Filter by
Sorted by
Tagged with
1 vote
2 answers
1k views

Connect to MS SQL Server

I'm busy setting up a MS SQL Server instance on a Windows Server The server is Windows Server 2012 R2 and the version of MS SQL Server is 2014 Essentials. I've installed MS SQL and created my ...
TheLovelySausage's user avatar
1 vote
1 answer
3k views

ORA-01031: insufficient privileges connecting to standby

I configured a standby database and it worked for a while, but now I noticed that the redo logs thread on standby is far behind the primary. After researching alert log and trace files, I figured out ...
kozlone's user avatar
  • 31
1 vote
2 answers
4k views

Cannot generate SSPI Context

When I try to connect to a SQL Server from my local machine I get the following error: Cannot connect to Computer1\Instance1. The target principal name is incorrect. Cannot generate SSPI ...
Vinesh Senthilvel's user avatar
1 vote
1 answer
145 views

Local SSMS client is not connecting one particular server

My SSMS is not connecting to one particular server say X except X it is connecting to all the other servers. Could not find the root cause for this problem does anyone have idea here? Guy sitting ...
Pரதீப்'s user avatar
1 vote
1 answer
5k views

SQL Server Replication Snapshot Agent login fails

I have setup TRANSACTIONAL REPLICATION from ServerA to ServerB ServerA = Primary Server = SQL Server 2008 R2 Enterprise ServerB = Secondary Server = SQL Server 2008 R2 Standard Edition. I ...
M.Ali's user avatar
  • 1,970
1 vote
1 answer
2k views

Postgresql: When using SSH tunnel, I receive the fe_sendauth: no password supplied error

I am SSH Tunneling to my postgreql server. I have previously successfully configured 9 + win XP dev PCs to connect to this postgresql server, those PCs still connect successfully. I am now setting up ...
Rob's user avatar
  • 11
1 vote
2 answers
17k views

SQL Server Management Studio - connection with SQL Server database engine

This question regards SQL Server 2005 and 2012. I have a database server with two instances of SQL Server. Through SQL Server Management Studio I was able to connect to both instances by providing "...
Deepak Bisht's user avatar
1 vote
1 answer
44 views

What happens if you cancel a job with multiple statements?

If I have a SQL script with multiple Update statements in series. What happens if query device goes offline after completing half the Update Statements? Does it rollback the currently executed Update ...
ADMKE's user avatar
  • 11
1 vote
1 answer
698 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
2 answers
5k views

The listener supports no services - 2 databases on oracle linux 7

I'm running two 12c R2 databases on linux oracle 7.9 I've installed the first database (CDB) and also a listener and both of them were running fine. Then, I've installed another 12c R2 database (CDB2) ...
Andrew T's user avatar
1 vote
1 answer
4k views

Query to Linked Server Ignores Configured Timeout Connection

I need to know where to set the timeout for a login or a query to a linked server. If the server is down I don't want to waste too much time waiting for a timeout. (Our servers are on the same network ...
Robbie's user avatar
  • 61
1 vote
1 answer
2k views

Keep getting "Connected to an idle instance" in 18c when trying to connect to database

I installed Oracle Database 18c yesterday and then installed Oracle Application Express v20.1. Everything was perfect and I was able to work on Apex too. Then I shutdown the computer and today I ...
Pumayk26's user avatar
  • 111
1 vote
1 answer
416 views

Lost SQL credentials and unable to connect to SQL via SQLCMD

I have a machine running SQL 2014 but have neither the windows authentication or sa authentication details due to mismanagement of a previous support team. Having tried logging in to SQL Management ...
Fraz Mahmud's user avatar
1 vote
1 answer
614 views

Unable to connect to oracle user

I have hit a rather frustrating snag in that after installing Oracle 18c. I have been unable to successfully create a user and then connect to it. More precisely I can create the user but the ...
Griffau's user avatar
  • 41
1 vote
1 answer
2k views

How To Access My PostgreSQL Server From Another PC Securely?

I want to be able to connect from any PC anywhere to my Database. Host OS: Windows 10 PostgreSQL: 12.0 Currently all Tutorials say the same: (Thats what i also did) Change listen_addresses to ...
Ojav's user avatar
  • 111
1 vote
1 answer
2k views

Connection to PostgreSQL disconnects every hour regardless of activity

I'm monitoring my PostgreSQL clients using a periodic netstat -an | grep 5432 | grep EST to check the ESTABLISHED status of the connection every 5 minutes. I have noticed that all of the connections ...
edrichhans's user avatar
1 vote
1 answer
11k views

How to resolve an SQL Server "Target principal name is incorrect" error invoked after upgrading from SQL Server 2016 to 2017?

I am experiencing a "Target principal name is incorrect" error after upgrading SQL Server 2016 to 2017. The SQL Server 2016 instance has been uninstalled. The certificate which is registered in SQL ...
Guru Josh's user avatar
  • 253
1 vote
1 answer
3k views

The connection was recovered and rowcount in the first query is not available. Please execute another query to get a valid rowcount

I get the error message as appears in the title and seen below when running a query against one of our SQL databases. The error seems to be consistent with this specific query when trying to return ...
Krishn's user avatar
  • 373
1 vote
2 answers
532 views

Connection denied from Java application

I try to connect from my little Java class to Oracle11g database and connection was refused with a SQL error. From client (SQL Developer) connection works. This is the ERROR when I try to run java ...
Federica Forte's user avatar
1 vote
1 answer
43 views

Source of Entry in Postgres

I want to make a small web app using Postgres as database. Is there a way to accept database access if and only if the SQL command is coming from my app, blocking any other access to the database?
Hasan A Yousef's user avatar
1 vote
1 answer
1k views

Slow connection to SQL Server both locally and by client

Yesterday I was experiencing extremely slow connectivity to the SQL Server with connections via management studio taking 5+ seconds where normally connecting to the server occurs within seconds. This ...
Krishn's user avatar
  • 373
1 vote
1 answer
6k views

SSIS 2016 Access Denied

I followed below steps after SQL Server and Integration Services, but I am still getting an error. I added SQL service account in Microsoft SQL Server Integration Services 13.0 properties which is ...
Sandeep's user avatar
  • 11
1 vote
2 answers
640 views

Oracle 12c connection configuration errors [closed]

I've installed Oracle 12c, and I'm trying to create a connexion using SQL Developer but I've got errors. Here is the parameters after installation and users parameters: Like in the photo, the port ...
devhicham's user avatar
  • 119
1 vote
2 answers
4k views

Can't login with Workbench

I use Ubuntu 16.04 and MySQL 5.7.16 and trying to connect from Windows10 with Workbench; My aim is to be able to login from any computer, anywhere --- I have no intention to allow only one IP. I get ...
user avatar
1 vote
2 answers
1k views

What determines the maximum number of concurrent connection to SQL Server 2016 Express

After some googling, there seems to not have a straight forward answer to the question. MSDN Forum mentions it depends on CPU, Memory usage, database size etc. Could someone help explain or perhaps ...
KMC's user avatar
  • 131
1 vote
1 answer
1k views

domain group permissions issue

I just installed SQL server 2016 on a new 2012r2 vm. During the SQL installation I added the domain admin group and my domain account to the SA role. After the installation, I can connect using SSMS. ...
Norm's user avatar
  • 11
1 vote
1 answer
851 views

Database Mail stops working after browser service stopped

After stopping the browser service on a 2-node SQL Server failover cluster system, the Database Mail component stopped working. It fails and creates log entries as follows: Microsoft.SqlServer....
Magier's user avatar
  • 4,797
1 vote
2 answers
2k views

Database connectivity issue in SSIS

I have created a Connection manager in my SSIS project for database connectivity.I choose SQLClient Data Provider and select SQL server authentication mode for login.Test connection succeeded. In ...
Sukhjeevan's user avatar
1 vote
2 answers
6k views

Unable to login to SQL Server using SSMS and SQL agent failing

I have SQL Server 2008 R2 ENT insalled on Windows server 2008 R2 ENT. I am unable to login to SQL Server locally after the installation. Getting below error: Connection handshake failed. An OS call ...
SQLPRODDBA's user avatar
  • 1,908
1 vote
1 answer
81 views

MySQL connectivity error

I have a MySQL database on a Linux server that I am able to access through putty logging into servers terminal. When I try to connect to the MySQL database remotely, I get the error: Lost ...
Jasjyot Singh Jaswal's user avatar
1 vote
3 answers
11k views

Connection problem different errors .net application

We have a SQL Server with some relational databases. We have another webserver with applications which communicate with the databases. We have an issue with one of our customers. We get some errors ...
user65948's user avatar
1 vote
1 answer
513 views

Error connecting to 10.0.17-MariaDB-1~trusty

I'm having problem connecting remotely to my MariaDB server. I've tried more or less everything, and can open a socket with nc(nc myserver 3307) but with the mysql (mariadb) client I only get the ...
Fredrik Erlandsson's user avatar
1 vote
1 answer
5k views

ODBC SQL Server driver on Linux/nginx

Writing here because really can't figure out what to do. I have a site located at ftp server. And now it moves to a new server based on Linux/nginx. And everything is fine except SQL Server ODBC ...
Frankie Drake's user avatar
1 vote
2 answers
2k views

Not able to connect to non-default oracle database after reboot

I have installed Oracle 11g r2 on Centos. On initial setup it installed database named INFA for me.I setup listener.ora and tnsnames.ora for INFA and on reboots all I had to do was run lsnrctl start ...
Auguster's user avatar
  • 143
1 vote
1 answer
5k views

Oracle 11g R2 on CentOS 6.3, and Net Configuration Assistant

This is my first time installing Oracle 11g R2 on Linux. I followed all the instructions in the Oracle documentation, but in the installation process, the Net Configuration Manager is failed. I ...
UNIX's user avatar
  • 119
1 vote
1 answer
207 views

Is it possible to use Native Clients from previous releases to connect SQL Server 2012?

Is it possible to use SQL Server Native Clients from previous SQL Server releases (e.g. SQL Server 2008 R2 Natice Client) to connect SQL Server 2012 database?
jrara's user avatar
  • 5,343
1 vote
2 answers
119 views

Can't connect to named instance from remote server

I have researched a lot on this issue but can't seem to find a solution for it. I have a named instance created on a server but I can't connect using the Servername\InstanceName. I am using SQL ...
kaitlyn's user avatar
  • 583
1 vote
0 answers
79 views

Windows authentication on remote client accessing SQL Server 2022 with SSMS [duplicate]

I have installed SQL Server 2022 on Windows Server 2019 Datacenter, and applied the March SQL Server 2022 Cumulative Updates. Also installed on the server is SSMS 18.12.1 and 19.0.2. On a remote ...
K Harrison's user avatar
1 vote
1 answer
1k views

Connection rejected on MySQL server (error 10060)

I have a small database on a server in my LAN that I try to access remotely via ODBC. Currently, I am making a program in Visual Basic to access, retrieve and display data from the server to an Excel ...
SuperRamen's user avatar
1 vote
0 answers
331 views

Windows Suspending PostgreSQL Process

Scenario: Customer’s system VM running Windows Server Standard 2019, 16GB RAM, Intel Xeon Gold 5122 @ 3.6GHz (2 processors 4 virtual processors) PostgreSQL starts and runs fine for 5 minutes - 2 ...
StillLearnin's user avatar
1 vote
0 answers
113 views

Testing SQL connections with UDL file

I am testing SQL connectivity between a SQL server (windows server 2000) and client PC that has no SQL tools installed (windows 2000 SP4). The client PC runs a java application that needs to connect ...
mcv110's user avatar
  • 75
1 vote
0 answers
2k views

How to configure the client certificate in Power BI desktop to authenticate with mutual TLS

I am trying to connect to a private data source from Power BI desktop. Data source has its own trusted root authority. I created my personal certificate and private key signed by this root CA. I ...
Parth_patel's user avatar
1 vote
1 answer
4k views

Can Microsoft JDBC Driver 4.0 connect to SQL Server 2019 and perform DML without issue?

The SQL version compatibility BOL article advises that the minimum compatible JDBC driver version for SQL Server 2019 is 7.4. Can an older JDBC driver still connect to SQL Server 2019? Or can only the ...
Pixelated's user avatar
  • 1,434
1 vote
0 answers
6k views

"The client and server cannot communicate, because they do not possess a common algorithm" error

The full error message is: System.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the login process. (provider: ...
boggy's user avatar
  • 427
1 vote
0 answers
206 views

2020-07-29T07:44:29.817503Z 108716 [Note] Aborted connection 108716 to db:

We are getting continuously logs in mysql error logs 2020-07-29T07:46:56.534666Z 111536 [Note] Aborted connection 111536 to db: '' user: '' host: '' (Got an error reading communication packets) we ...
devops's user avatar
  • 23
1 vote
0 answers
2k views

database mirror - A connection attempt failed because the connected party did not properly respond after a period of time

I have database mirror set up in one of my servers and all seems to be fine, however, from time to time I get this error message in the logs: --Execute it on Primary/Secondary server EXEC ...
Marcello Miorelli's user avatar
1 vote
0 answers
93 views

SSMS Connect to remote SQL instance with Windows Authentication

I have a remote SQL instance (Microsoft SQL Server 2016 (SP2-CU3) (KB4458871) - 13.0.5216.0 (X64) I can connect to the instance fine locally on the box through SSMS using both Windows and SQL ...
medina's user avatar
  • 197
1 vote
0 answers
1k views

Aborted connections (Erros reading communication packets)

I set up a new Database Server over a SQL Dump with innoDB MYSQL 5.7 from MYSQL 5.6. The Server running external with many sleeping SMTP connections over 1 Mio a day. I made the server open for ...
Peter's user avatar
  • 11
1 vote
0 answers
29 views

Impact of changing server machines names with SQL Server 2016 Standard in mirror state

It's an enterprise network domain. Two existing Windows server 2016 machines, one each for SQL Server 2016 Standard edition and other is also SQL Server 2016 Standard edition in a passive mirror ...
dotnetavalanche's user avatar
1 vote
1 answer
5k views

DNS lookup failed with error: '11001(No such host is known.)'

I have a server in the USA that should connect to one of our servers in Europe through service broker. The server in Europe is an Availability group, whose listener is called sqlst. when I run the ...
Marcello Miorelli's user avatar

1
3 4
5
6 7
9