Establishing a connection to a database or database server.

learn more… | top users | synonyms (1)

1
vote
0answers
21 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 ...
0
votes
1answer
41 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
58 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
25 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 ...
2
votes
1answer
46 views

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

I have an Azure ASP.net MVC web application wich uses a sql azure db. It was working fine for some months (someday for sopme reason azure changed the name of the server and I had to set that again but ...
1
vote
1answer
68 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 ...
0
votes
0answers
21 views

INFORMIX error on running a Java program

I have been trying to connect to an Informix database using a small program written in Java. The program is working nicely on one of the Informix test servers but running on one of the production ...
0
votes
0answers
41 views

Why do I need local admin rights to access the database via ODBC system DSN?

We have a new SQL Server 2012 instance, and a database called say, testdbase. Logged on as admin, on my Win7x32 PC, I setup a system DSN to the database. The configuration test runs and completes ...
4
votes
1answer
56 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
131 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
72 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/...
0
votes
0answers
29 views

Error connecting from other SQL instance using powershell script

I have a job to run a powershell script that will rebuid fragmented index through source SQL instance to target SQL instance. The poweshell script didn't run due to the following error: Sqlcmd: ...
1
vote
1answer
49 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
29 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 ...
0
votes
1answer
120 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 ...
0
votes
0answers
5 views

What is the advantage of using Spring beans for DB connection?

I am new to java spring and I'm just wondering if placing the db connection in spring beans has a great advantage?
0
votes
1answer
23 views

Communition Link Failure

I want to make a DNS to a sql database by SQL Driver. so I do it as it should be done. I have over hundred Clients with Windows 7 OS. All of them can connect to the database easily just a few of them ...
2
votes
1answer
18 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
103 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 ...
1
vote
0answers
45 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 ...
1
vote
1answer
94 views

-2147205987:[Microsoft][ODBC SQL Server Driver]][SQL Server]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 ...
0
votes
1answer
90 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 ...
0
votes
1answer
143 views

SQL Server slow response when we access from Remote client

We have a SQL Server located in remote location, If we access the server from the same location (internal IP, Same IP as the server is using) the performance is good and we didn't face any problem ...
1
vote
2answers
100 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
1answer
139 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
91 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
28 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
17 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
13 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;" &...
0
votes
1answer
159 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 ...
2
votes
1answer
109 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 ...
1
vote
2answers
41 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, ...
2
votes
1answer
147 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 ...
0
votes
0answers
29 views

Identify MySQL Connection timeout

I am just trying to identify when MySQL drops a connection . For this I initiated a connection to MySQL Port using nc with a timeout value of 7200. $ time nc -w 2 car-005 3306 N 5.5.31-...
3
votes
1answer
185 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 ...
-1
votes
2answers
191 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: ...
1
vote
1answer
173 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 ...
1
vote
1answer
223 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
64 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
59 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
766 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
152 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
210 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 ...
1
vote
0answers
247 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 ...
0
votes
0answers
67 views

MS-Access linked tables Azure intermittent connection failure

I have an MS-Access front-end with linked tables to Azure SQL db. It has been running for about 6 months without any major problems. In the last week I have had increasing intermittent connection ...
1
vote
1answer
159 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 ...
4
votes
2answers
158 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 ...
2
votes
1answer
204 views

Reporting Services will not connect to SQL Server

I have set up a new SQL Server 2014 default instance. In SQL Server 2014 Configuration manager I see my 32 and 64 bit SQL Native Client 11.0 configurations and all protocols, pipes, tcp/ip,shared ...
0
votes
0answers
2k views

ORA-28040: No matching authentication protocol

I'm trying to connect to my RAC database using odbc drivers. While trying I get ORA-28040: No matching authentication protocol I have added this in both client and the server: SQLNET....
0
votes
0answers
183 views

Periodic connection timeouts

I have an application that runs every minute using the Windows Task Scheduler. One of the first things the job does is connect to a SQL Server 2008 instance to record that the application started. A ...