The tag has no wiki summary.

learn more… | top users | synonyms

2
votes
0answers
17 views

MS SQL Server 2012 Failover Cluster connection issue

I was about to give up with this but I'll give it a go here if anyone can help. I've set up a fail-over cluster SQL Server with 2 SQL nodes, Domain controller and file witness. All seems to work ...
0
votes
1answer
13 views

Data exchange between 2 remote postgresql databases

As per subject I'm looking into a reliable way to synchronize 2 tables that have a same structure between two remote postgresql databases. I was thinking about dblink but an not really sure as in the ...
0
votes
1answer
26 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 ...
1
vote
1answer
44 views

How to connect client applications to SQL SERVER 2012 cluster?

Following are the environment Details : Database Server : SQL SERVER 2012 Operating System : Windows Server 2012 Single instance of SQL SERVER 2012 is installed in cluster configuration with 2 ...
0
votes
1answer
50 views

Connection problem after a big impdp

This morning i had a weird problem just opening the SQL developer i cannot connect to my database. I checked the log file of the impdp operation launched before (14G), all the data is imported without ...
0
votes
1answer
95 views

Unable to connect to Mysql at peak time

I have two servers one is application server and another is database server. Continuously I am firing query to mysql. At peak time I get error - Can\'t connect to MySQL server on \'IP Address\' (99) ...
1
vote
0answers
22 views

Turn xact_Abort on for specific applications or user

We have a 3rd party application that requires xact_abort to be turned on, however we have other applications that require it to be turned off. The service that requires it turned on always logs in ...
2
votes
1answer
8 views

Improve Connectivity To MySQL Databases Using Multiple Ports

I have a Ubuntu server with multiple websites, each website connects to its own MySQL database - each of my sites have a number of users accessing/updating the MySQL databases. Currently all my ...
3
votes
1answer
168 views

Mysql database slow responding to connects when having only few concurrent connections

We have a database setup with in master/slave. It runs innodb and its on a 8 core with 32gb. When i run "ab" to do a load test on a website (4 frontend webservers) which does the query's with 10 ...
3
votes
2answers
453 views

Using SQL Server SMO with a Port number

In SSMS if you are connecting to SQL Server instance set to specific port other than 1433 you simply put ",port number" after the instance name. In the same regard if I am using ...
-1
votes
1answer
1k views

How to connect an oracle DB with MySQL workbench?

I am a bit confused: I want to connect an Oracle DB with the application "MySQL Workbench". In order its from Oracle as well I throught that this is possible. But until now Im not able to do so. With ...
0
votes
0answers
687 views

PostgreSQL isn't listen on 5432 in Windows 7

I have a PostgreSQL 9.3.1 DB Server running in Windows 7 Ultimate. I have checked the file postgresql.conf and this lines are uncommented: listen_addresses="*" port=5432 And this is the ...
0
votes
3answers
2k views

Connecting to SQL Server instance through C# [closed]

I made a program, using c# and sql server with sql authentication. It works properly in my device, but after making the program setup file .exe extension using Innosetup, I cannot connect to my ...
1
vote
2answers
184 views

Where can I find the connection string for a DB2 database?

I need to connect an application to my DB2 database. Both application and db are running on the same machine. I've tried this: ...
3
votes
5answers
7k 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 ...
1
vote
0answers
461 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
2answers
2k 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
823 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 ...
0
votes
0answers
70 views

Slow queries after “too many connections” errors

Couple of days ago I had a persistent query running on my website which was taking minutes to complete (I've run it about 3 time) It nearly killed my database, I got 1040 too many connections when I ...
2
votes
0answers
186 views

Linked Server Login Timeout but SqlCmd works

I've got a SQL 2005 SP4 server that connects to a 2008 SP3 instance via linked servers using the SQL Server server type. Every once in a while, one of those linked servers will start throwing login ...
1
vote
1answer
2k views

Unable to connect to SQL server 2008 R2 via Instance name?

I don't understand : I've installed sql server 2008 R2. the installation process asked me for the desired instance name , so I wrote: MSSQLSERVER. after the installation , running Setup Discovery ...
1
vote
0answers
487 views

SQL pre-login handshake connection failure

I'm having an intermittent problem with one of my old SQL 2000 servers. Every once in a while it stops accepting logins. I fix the problem by bouncing sqlservr.exe and then it starts working properly ...
1
vote
0answers
909 views

connect sql server using windows authentication in another pc

I am having sql server 2008 r2 express installed in a PC. I have some other PC which are connected to this pc in a local network.Now those PC connect to my pc's sql server using sql authentication. ...
1
vote
2answers
3k views

ORA-12154 TNS: could not resolve the connect identifier specified with SQLPLUS

I am using Toad to connect my database and its working fine for me . But when i try to connect with the same credential , i am getting the error message as shown below: ORA-12154 TNS: could not ...
0
votes
1answer
350 views

Mysql not closing connections

I have a Java application that configured with a connection pool. I have ensured that the application terminates the connections properly. However when I run this command on mysql command line - ...
0
votes
1answer
73 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?
0
votes
2answers
299 views

Remote database connection problem?

I have two systems with Windows XP. I have installed SQL Server 2005 on a system and tried to use SQL Server Management Studio Express on both to use the database. I am able to use the database on ...