The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
1answer
16 views

Connecting to MySQL VM remotely (Azure Resource Manager)

I have a VM setup in Azure (running Windows Server 2012 R2) with MySQL 5.7 installed. I am trying to access this using MySQL Workbench - which when running on the server works perfectly. However, ...
0
votes
0answers
6 views

Python and SQL exception handling when internet cuts out

I have a python temperature monitoring program that runs every 30 seconds on my raspberry pi, and uploads the data to an SQL server. I am using try: and except: however this doesn't handle if the ...
1
vote
1answer
124 views

High data traffic from MySQL server to web server

I have one webserver running Magento : Community Edition 1.7.0.2 and a separate machine with MySQL 5.5.42 on it. Both machines are EC2 instances. I am seeing huge unexpected data traffic from the ...
0
votes
1answer
126 views

unable to connect to specific instance 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 ...
1
vote
2answers
29 views

MySQL Replication issues on server placed in different continents

I am running 2 cpanel servers with MySQL Replication set on them, one in france the other in US. Running a database hungary site. Replication was setup to load balance as well as for failover reason ...
2
votes
2answers
75 views

Does UDP Port 1434 need to be open for named instances with static TCP?

I have built a named instance which is running on a static port, 50101. The network guys have opened the port on the firewall to allow incoming connections. I have asked them open UDP port 1434 too, ...
0
votes
1answer
15 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
34 views

Untrusted domain error connecting to another group in workgroup SQL Server 2014

I have two computers connected in a workgroup that are sharing files and folders. When I try to access the SQL Server of the other computer I get the same error from both. Login failed. The ...
1
vote
0answers
25 views

Slow query speed using workstation processed joins with 100 Mbps connection speed?

In a department where they were complaining that a report was being run slowly, I jumped on one of the empty machines there and tried it out. It took a good 6 and 15 seconds to run. Run from a ...
1
vote
0answers
28 views

Sync job issue, maybe network related?

I have a job that syncs rows in a table between a production server and four other servers. The problem is the job runs perfect on three servers, taking less than 2 seconds. On the fourth server, it ...
5
votes
4answers
17k views

Changing IP address of SQL Server 2008 R2

I would like to know if there are any dangers or relevant precautions before changing the IP address of a SQL Server 2008 R2 box. We have built a virtual PC with Windows Server 2008 R2 and SQL Server ...
0
votes
0answers
41 views

SQL server is replicating to wrong subscriber

I have a publication which is intended to push data to a subscriber over the internet from a remote server to our onsite local subscriber but it ends up on a wrong subscriber.Here is the scenario: ...
0
votes
2answers
3k views

Connect to Oracle DB 9i using SSH TUNNEL via putty [closed]

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: ...
2
votes
1answer
212 views

SQL Bulk Insert Impersonation issue

I am running Microsoft SQL Server 2012 SP on a Windows Server 2008 R2 Standard SP1 box. The SQL Server service is running as a simple windows domain user (nothing special, no admin rights, etc.) I am ...
2
votes
0answers
54 views

How to avoid Network issues for SQL Server 2012 AlwaysOn

I have SQL Server 2012 and have setup AlwaysOn for High Availability. The infrastructure is on Azure VM's. After moving to this setup, we are frequently observing Network issues which either causes ...
1
vote
1answer
79 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 ...
0
votes
0answers
15 views

Optimise communication to check record status

Imagine an universe full of products. I have an app that electronically marks products and saves this status into the server DB. The app may be used from different devices so each one will mark ...
2
votes
1answer
139 views

Fast local backup - Very slow backup via Network

Since last week, i'm having this problem. Backups are taking forever to be done if I make them via Network. If I backup the database to a local disk ( or N'nul' ) it's very fast. It's strange ...
2
votes
1answer
46 views

SQL Native Client and network disconnects

Does the SQL Native Client provide support for maintaining a persistent connection over the network at the driver level if there is a momentary network disconnect like a 999 error? Our applications ...
0
votes
0answers
61 views

Startup Oracle Database with an NFS mount on the control file

I currently have an Oracle Database which works just fine on 1 server. I want to share the folder which contains its' control file to another server via an NFS mount. However when mounted I get ...
8
votes
1answer
232 views

Does RSS Profile have an effect on SQL Server with NUMA setup?

I'm curious whether the RSS Profile which is default NUMAStatic on Windows 2012 R2 could/should be changed for SQL Server with a NUMA setup. Has anyone done performance benchmarks on high load SQL ...
1
vote
0answers
38 views

SQL AlwaysOn Availability Groups network performance

Our customers are asking to implement our products while configuring AlwaysOn Availability Groups ( between two FCI with Asynchronic commit ). The DR server is geographically far from the Production ...
2
votes
0answers
86 views

Networking (classmate like) website database model

I am working on a project that consists in building a networking website like the Classmate web site. I have proposed a database model based on the social media database model presented on the ...
1
vote
0answers
21 views

Postgres with no clients still chatty on network

This may be a non-issue but I was doing some network monitoring on my Mac and noticed that PostgreSQL (9.4.4) was still sending and receiving packets even when I'm not aware of any clients (localhost ...
3
votes
2answers
912 views

SQL Server Configuration Manager 2012 - 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 ...
0
votes
1answer
311 views

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

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 ...
4
votes
1answer
201 views

Is this a sane model for a network provisioning system?

I'm sketching out a model for a network setup, where I have the following conditions: There are multiple nodes which contains a number of switches each. Each switch has multiple services, which may ...
0
votes
1answer
251 views

How to configure SQL Server Port on multiple instances?

I have a server called SQLDWDEV01, with 2 instances: default and UAT. To the default instance that uses port 1433, everything works fine. However, the UAT instace, which I configured according to ...
4
votes
2answers
130 views

How to backup MS SQL Server databases off-site?

Microsoft SQL Server supports backing up to remote network locations only by means of UNC names the SQL Server (and user account it's running under) has access to. Is it possible to create backups ...
1
vote
1answer
102 views

How to grant access to IP range in Postgres?

I would like to configure my Postgres DB to be accessed by any IP 10.8.101.*. I know I have to create a rule in pg_hba.conf but I'm not sure what it should look like. My LAN IP is currently ...
0
votes
1answer
32 views

Connection to a MySQL server fails after server restart

Until this morning I could connect via Sequel Pro to one of our networked machines that has the MySQL server on it. Today, however, it's another story: when I am trying to connect, it times out. Even ...
1
vote
1answer
642 views

High Network usage on SQL Server port [duplicate]

Possible Duplicate: Find out what queries are causing the biggest amount of network traffic We are getting over 90 Mbps from SQL Server to each web servers on port 1433. We are using ...
4
votes
1answer
11k views

command or query to ping SQL server

I have 2 windows 7 machines on a very high security domain one acting as a server, the other as a client. Each box has a SQL Server Express 2005 database and application "A", however I'm only using ...
2
votes
1answer
795 views

SQL Server connection fails over VPN

I have an OpenVPN network consisting of VPN server (Linux), client (win8) and SQL Server (win 2008 server, SQL Server 2005), I'm trying to (of course) connect client to server. When I try to connect ...
0
votes
0answers
19 views

App with ETL like operations - pull back small sets or one large set?

The problem Have an application that needs to provide back a result set from a normalized database into a single result sheet that is highly normalized for processing changes in excel. Must be ...
5
votes
1answer
2k 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 ...
3
votes
1answer
873 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 ...
7
votes
1answer
320 views

Can SQL Server be configured to backup to a network share through a separate NIC?

We're in the process having our SQL Server instances backup to a network share, but our network admins want to try and divert the bandwidth from the backups through a different network segment. I was ...
0
votes
2answers
168 views

Best practices for generating a tnsnames.ora entry

I need to integrate some scripts that export and import data from Oracle databases. They are shell scripts that rely on the TNS name being set up (e.g., scott/tiger@tns). The application owners are ...
2
votes
1answer
3k views

Connection to localhost dramatically slower than to network server

I have an Excel VBA application that connects to a SQL Server 2008 R2 database through ADODB. When I'm on the network at work, the connection is almost instantaneous. When I am at home working with ...
0
votes
1answer
253 views

Access Database that is shared with my company on a network drive..When I copy and paste it to my desktop there linked some how?

I have an Access Database that is shared with my company on a network drive..When I Click on the drive and copy and paste it to my desktop and make changes to it the database that is on the drive also ...
2
votes
1answer
1k views

Can you put a SQL DB on a NAS? [closed]

Can you put a SQL DB on a NAS drive? For example can I put the PostgreSQL DB "files" on a Sinology NAS or am I better to leave everything on a "real" PC? (like, say, a regular PC server running Linux) ...
13
votes
3answers
2k views

Will increased network latency cause table locks in MS SQL Server?

If I'm making a single call to a SQL Server database over a high-latency network, will table locks occur due to that latency? Say I query table A for some records, and SQL Server has to return that ...
0
votes
1answer
50 views

Does SQL Server handle databases on SMB shares different than on Hard Drives?

Does it, for example, automatically recover from network hiccups, perhaps? If so, would masking the file share under a symbolic link change that behavior, or does SQL support symlinks to file shares, ...
2
votes
1answer
79 views

What methodology is being used to poll SQL instances when using sqlcmd with the -L switch?

I've discovered that issuing sqlcmd -L from the console of a SQL host in my network only reveals other instances on the same subnet. It used to reveal all instances on the network so I was wondering ...
1
vote
2answers
4k views

Best practices for service name / aliases in tnsnames

I have this idea that service names / aliases given to connections descritors in a tnsnames.ora (not the one in the server that dblinks use, but the one for the public) file should in no way be ...
2
votes
2answers
4k views

How to connect to Oracle 11g using “Navicat for Oracle”?

My Oracle 11g Enterprise Manager runs like this: I have taken the following screen-shot after my Oracle installation has been completed: I have the following Oracle-related services running: ...
2
votes
1answer
1k views

Does Oracle run queries to completion after SQLdeveloper disconnects?

The query is a CREATE TABLE t as SELECT .....; statement. Can I reliably count on Oracle to complete this after I disconnect? After I re-connect, how can I check on the status of this query?
0
votes
1answer
2k views

How to resolve “Error log file size is increasing in mysql 5.5” issue w/o restarting mysql

I have an Ubuntu server with MySQL 5.5 installed. In /var/lib/mysql a .err file is kept on updating with these warnings only: [Warning] IP address '234.22.11.221' could not be resolved: Temporary ...
0
votes
1answer
84 views

XML Network Call to Application from SQL Server 2005

We don't really have a DBA here, just a semi-experienced SQL Developer and me. I've only got about a year's experience myself and we're the only programmers for our small business. We're trying to ...