Questions tagged [connectivity]

Establishing a connection to a database or database server.

Filter by
Sorted by
Tagged with
1
vote
1answer
1k views

Builtin\Administrators doesn't permit access

I have created a SQL 2016 (Developer) instance on a new build machine. For ease of use, when we do this, we grant Builtin\Administrators sysadmin rights on the instance. This allows all developers on ...
1
vote
1answer
1k views

Why can I use named pipes to connect to SQL Server even if it's been disabled?

Why can I still use named pipes to connect to SQL Server even if it's been disabled? I'm on SQL Server 2016 doing the testing. I have recorded my operation in this youtube video: https://www.youtube....
2
votes
1answer
809 views

AWS DMS connect to on premise SQL Server DB

I am working through the process of migrating a SQL Server 2014 DB to AWS Redshift. I have converted the schema and provisioned a PostgreSQL Redshift instance. Now in AWS-DMS->Create Migration->...
4
votes
1answer
2k views

MSSQL Mirror Configuration Troubleshooting: Witness server forcibly disconnecting every 100 seconds

I recently set up a three servers running MSSQL Server 2016 in a high safety synchronous mirroring configuration. Right now, everything is working normally. Any changes made in the principal are ...
1
vote
1answer
116 views

Sql static port

I am trying to use SQL Server over hybrid connection (Azure). The connection is working, based on tcpping from the Azure console. But I cannot connect to the SQL Server. No logon attempts seen in ...
1
vote
0answers
262 views

Security Concerns ODBC DSN - how well does DSN protect SQL Credentials?

ODBC DSN's have been around for a long time, yet SQL Server still supports them, which says a lot. But I'd like to know, given that this is an older technology, how well are the credentials protected? ...
1
vote
0answers
276 views

SQL Server 2014 - remote login to AOAG named instance, listener port does not work

Your help is greatly appreciated. I spent a few hours trying to troubleshoot this and before I go to the firewall/network possibilities, i would like to check if my setup has any errors I am unable ...
2
votes
0answers
365 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 ...
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 ...
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
936 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
918 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
199 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
674 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 ...
2
votes
1answer
4k 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
752 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 ...
6
votes
3answers
14k 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
840 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
176 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
9k 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
712 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
612 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
545 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 ...
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 ...
2
votes
2answers
985 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
672 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
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 ...
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
8k 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
2k 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
40 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
31 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
81 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
3k 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 ...
2
votes
2answers
1k 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, ...
7
votes
4answers
28k 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 ...
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 ...
1
vote
1answer
2k 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
292 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
11k 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 ...
1
vote
1answer
4k 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
327 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
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 ...

1 2 3
4
5
7