The tag has no wiki summary.

learn more… | top users | synonyms

4
votes
1answer
895 views

Ports necessary for Oracle 11g Replication across a firewall?

We have two Oracle 11g Enterprise Edition servers that need to replicate data via Oracle streams. However, the two servers are on untrusted domains and connect via a VPN. On end of the connection is ...
0
votes
1answer
1k views

Connect to Oracle DB 9i using SSH TUNNEL via putty

I am trying to connect to an Oracle database behind NAT. Therefore I create an ssh tunnel using putty. This is the network information: global IP example: 122.54.34.12 LAN IP example: ...
0
votes
1answer
61 views

When I convert the linked tables to local tables I got this error?

Referential integrity cannot be enforced between linked tables and local tables. Enforcement of referential integrity will be dropped on all relationships between tables converted to local and tables ...
3
votes
0answers
715 views

Once more about SQL Server virtual accounts

Let me reboot my question on SQL Server virtual accounts permissions The (same) MSDN article on the same version 2012 of SQL Server "Configure Windows Service Accounts and Permissions" states: ...
3
votes
0answers
563 views

Network issues with sql server

There are two servers on co-location. First is Windows Server Standard 2008 R2 SP1. Second is Windows Server 2012 + Sql Server Standard 2012 SP1. First server has a task with a report against tables ...
1
vote
0answers
38 views

Network connection from old application to SQL Server 2008 R2 lost once in a while

I have put this question on serverfault.com as well, but since the problem concerns connecting to SQL Server, I will also put it here. We are trying to migrate an Axapta 2.5 database from SQL Server ...
1
vote
0answers
494 views

SQL Server Configuration Manager 2012 - TCP/IP, unable to set IP All = No

I have a 4-node SQL Server 2012 SP1 cluster, and under Network Configuration -> TCP/IP -> Protocol (tab), I am able to switch Listen All from Yes to No. However, when I hit OK (or Apply), I get the ...
1
vote
0answers
437 views

SQLPlus times out when connecting to an Oracle XE database on another PC

I'm having the strangest issue. I have a very basic (I think) setup of an Oracle 11G database on one Hyper-V VM, and the Oracle 11G client on another VM. Although I'm able to access the database on ...
1
vote
0answers
238 views

Sybase anywhere sql server connection problems

in my work we have a software system based on sybase adaptive server any where version 6 installed on a windows server 2008. the system work fine but after a period of time from system start problems ...
0
votes
0answers
9 views

SSAS firewall / restricted direct database use

We want to open ports 2382 / 2384 for users in AD group A (they are supposed to read SSAS data via a sharepoint frontend only). That can be easily done with the windows server firewall, I guess. ...
0
votes
0answers
43 views

What should be the ideal network configuration for a Postgresql Streanming Replication and PgPool HA setup

I have the following configuration using Pgpool, Postgresql with streaming replication. Pgpool is used for load balancing and automatic failover. .-----. .--------. | | ...
0
votes
0answers
22 views

Database for large dynamic network graph - best practise?

I am constructing a MySql database which is to contain data for a large network graph. There will be thousands of nodes and ten thousands of edges. The nodes and edges will be assigned a category. ...
0
votes
0answers
36 views

Migrating a SQL NetName Between Clusters

Instance A is a default SQL Server 2005 instance on a two-node Windows 2003 cluster. Instance B is a default SQL Server 2012 instance on a two-node Windows 2008 R2 cluster. The application team is ...