Questions tagged [connectivity]

Establishing a connection to a database or database server.

Filter by
Sorted by
Tagged with
1
vote
2answers
953 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 ...
3
votes
1answer
547 views

Cloned production SQL Server now Windows Authentication doesn't work

I needed to create a test environment for one of our applications that uses SQL Server as its data store. Our sysadmin cloned the existing production server to create the test server. I can connect ...
14
votes
4answers
62k 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 ...
1
vote
2answers
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 ...
1
vote
1answer
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. ...
2
votes
1answer
1k views

Flush Host Connection Blocked, but some connections allowed

We are running Percona MySQL 5.6.30. We've had an issue where a PHP script on a different host was reporting an issue connecting to the database: Database may be down : SQLSTATE[HY000] [1129] Host ...
1
vote
0answers
1k views

Why is my Redo Log Apply service "spotty"?

I have a 12c Dataguard configuration between apple (primary) and orange (physical standby). The following is my entry in ldap: apple= (DESCRIPTION_LIST= (DESCRIPTION= (ADDRESS_LIST= (ADDRESS=(...
0
votes
1answer
298 views

connecting to an oracle sql database from sql developer on the same computer. When the computer is a domain computer

Hi I am trying to do DBA course that requires that I use Oracle database. I am using my corporate pc to do it. I set up the loopback adapter to enable localhost communication and setup the hosts ...
3
votes
0answers
827 views

Connection timeout via AlwaysOn Listener IP on local computer

I have AlwaysOn availability group and it has one Listener IP. I can connect this instance using Listener name but, cannot connect using Listener IP from my local computer. It returns following error ...
3
votes
1answer
5k views

"CREATE FILE encountered operating system error 32" when attempting to attach database

I am having trouble connecting to a database I created in SSMS. Keep in mind this is my first time working with databases. All I've done in this database is create some tables and add a few records. ...
2
votes
1answer
1k views

How can I connect to SQL Server from All IPs?

I have problem with access to SQL server with TCP/IP. I would like to SQL instance accept client from all network adapter that machine has. I go to configuration manager console and enable TCP/IP, ...
1
vote
0answers
1k views

Check Postgres Listener is up/down?

I am using PostgreSQL LISTEN/NOTIFY functionality in Java. So I have made a ListenerBean which is run at Application startup. LISTENER class in java: @Singleton @Startup ...
8
votes
3answers
18k views

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

I have an Azure ASP.net MVC web application which uses a SQL Azure db. It was working fine for some months (someday for some reason Azure changed the name of the server and I had to set that again but ...
3
votes
2answers
1k views

Test SQL Server connection with sqlcmd using machine name

How can I test a connection via machine name as the SQL logon name (ie mydomain\server01$ - as an IIS AppPool would connect) using sqlcmd? I'm having trouble figuring out an application's SQL Server ...
4
votes
1answer
195 views

New SQL Server from backup; application has successful login on 1 database, but fails on another: 0x80040e4d

Our SQL Server crashed and burned, the hard drives destroyed. No hope of recovery. We need to get a very important application working again; this is on a different server. We've set up a new SQL ...
2
votes
3answers
12k views

using tnsnames.ora and sqlplus client without installing oracle 11g server on linux client [closed]

I want to create a connection to remote Oracle server using SQLplus client and tnsnames.ora without installing Oracle 11g server on the Linux client. I used debian and bash script to generate reports ...
1
vote
2answers
780 views

ORA-01017 connecting to example schemas on Oracle VM appliance from Windows host

I'm a software developer and am working on getting an Oracle VM Appliance running for testing purposes (the Database App Development VM with Oracle 12c - http://www.oracle.com/technetwork/community/...
1
vote
1answer
666 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....
0
votes
1answer
894 views

Enabling IPAII protocol disable remote conections. Why?

I have some servers with IPAII protocol enabled with a certain port: I'm using 1433 because a long story. but its working. We can use the default port 1433 AND IPAII ( for PHP developers ) with 1433 ...
0
votes
1answer
2k views

Cannot TNSPING from VirtualBox Client to Oracle Database On Host

I am new to Oracle, attempting to learn about connecting remote clients to an Oracle 12c Database server instance. SUMMARY: I cannot get TNSPING to work from a client machine to a known good database ...
6
votes
1answer
3k 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 ...
2
votes
2answers
1k views

What Microsoft SQL Server 2008 R2 features do you need to install to get OLEDB Provider Linked Table Connectivity?

Which features do you need to install in your SQL Server 2008 R2 instance to get OLEDB Provider Linked Table Connectivity? Specifically I'm trying to install the VFPOLEDB provider. (And something ...
2
votes
0answers
789 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 ...
3
votes
1answer
9k 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 ...
0
votes
1answer
1k views

UFT to SQL Server conecction which is located at different domain

I need to connect to a SQL Server through UFT (Unified Functional Testing) but the problem is SQL Server is present at different domain whereas QTP (HP QuickTest Professional) is present in a ...
1
vote
2answers
1k 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 ...
2
votes
2answers
11k views

Opening MySQL connection is sometimes very slow

I have a very weird issue with an older MySQL server (v5.0.45) and a Java application. From time to time getting a connection from the database takes 7 seconds, 15 seconds, 30 seconds etc (most of ...
0
votes
1answer
3k views

The target principal name is incorrect. Cannot generate SSPI context

When attempting to log on to a SQL Server that lives on a different domain, I get the following error: The target principal name is incorrect. Cannot generate SSPI context. I am using Windows ...
0
votes
1answer
42 views

Setting up PostgreSQL Connection with DBVisualiser

Apologies for the rudimentary question, I'm new to setting up databases. Am aiming to create a new Postgres connection and load some CSV files into a table using DBVisualiser. Working on a Mac running ...
0
votes
1answer
32 views

Allow access to RackSpace database from Vagrant box

we have two developers using Vagrant (which has it's own internal ip like: 10.0.2.0/24). On RackSpace we have a percona database instance. We would like to allow read/write access to that database ...
0
votes
0answers
95 views

Connecting SQL Server using Server IP Address

This works when I try it internally (Within the LAN network) sConnString = "PROVIDER=SQLOLEDB;" & _ "Data Source=192.168.1.200,1433;" & _ "Initial Catalog=MyDB;" &...
1
vote
1answer
4k 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 ...
2
votes
1answer
2k views

How to log connections to the database?

I'm trying to write a small program that is meant to connect to a database over TCP/IP using raw sockets with Python. I can't open a connection so tried to see what's happening on PostgreSQL's side ...
4
votes
2answers
3k views

Use connection string to connect to Azure database from SSMS?

I have a connection string for an Azure database. I'm hoping there is a place in SSMS where I can plop in that string and connect to it. Alternatively, if there is a way to do it with a T-SQL query, ...
8
votes
4answers
40k views

SQL Server access issue

I am trying to connect 3 SQL servers using SSMS from a different landing server. The issue is I am able to connect 1 server but unable to connect other 2. The error I get is below: A connection was ...
3
votes
1answer
2k views

Connect to PostgreSQL from different host

I am facing error while connecting to the PostgreSQL server from different host, I configured both postgresql.conf and pg_hba.conf but unfortunately with no result. So I have installed PostgreSQL on ...
2
votes
3answers
24k 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 ...
1
vote
1answer
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 ...
0
votes
1answer
1k views

SQL Server 2014 All Administrator Accounts Disabled

I made the most ridiculous thing. I accidentally disabled both remote logins and database accesses for the Administrator accounts (including the one with Windows Authentication (Administrator account) ...
0
votes
2answers
576 views

MySQL connection timeouts

Apparently, a former DB administrator configured our main DB server (located in Germany) so that it only would be accessable from certain IPs. Now we just added a new host (which needs to access that ...
1
vote
1answer
13k views

SQL.EXPIRE_TIME in sqlnet.ora

I have set sql.expire_time parameter to 10 which recommends me to keep in my two node RAC database. At times, my application gets the error ORA-3135, therefore I suspect that this parameter could have ...
2
votes
1answer
5k views

Error: 18456, Severity: 14, State: 5; SSMS > Network sever from PC

I just completed my first install of SQL as a server based, Enterprise Edition. I wanted to check it out using SSMS on PC using my Admin Access. But could not connect. For security reasons my ...
1
vote
2answers
596 views

cannot login to MySQL remotely

users and root can log in locally with no problems. No user can login from a remote connection though from remote: [root@yoda:~] # mysql -v --host=r2d2.er.com --user=power --password='burp' power ...
8
votes
2answers
8k 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 ...
3
votes
1answer
2k views

What ciphers need to be enabled to install and run SQL Server 2014 SP1 on Windows 10? [duplicate]

Our organization is trying out Windows 10 and our distribution had some modifications to the ciphers in use due to recent security concerns. As it stands SQL Server 2014 Developer SP1 fails to ...
1
vote
2answers
2k 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 ...
0
votes
3answers
352 views

MySQL Query/Connect to eximstats?

I'm trying to run a report for my clients in real-time. I created a new eximstats user (renamed the old one) with: update mysql.user set password=password("XXXXXXXXX") where user="eximstats"; In ...
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 ...
2
votes
0answers
2k views

PostgreSQL FATAL canceling authentication due to timeout

I have a PostgreSQL 9.4 Database running on my CentOS 7 Server. This database has only ever been available to users on the LAN, however recently I needed to make it available to users outside the LAN ...
3
votes
1answer
844 views

MySQL very long-running queries

I have a quite large db (800+Mb dump file) that I imported to my local server. It's a Wordpress db from witch I need to extract certain posts. There are around 160,000 posts inside. Currently I'm ...

1
4
5
6 7 8