The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
0answers
14 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: ...
1
vote
1answer
100 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 ...
2
votes
0answers
35 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 ...
2
votes
1answer
106 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 ...
0
votes
1answer
55 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 ...
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
30 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 ...
2
votes
1answer
94 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 ...
0
votes
0answers
48 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 ...
1
vote
0answers
32 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 ...
8
votes
1answer
201 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 ...
2
votes
0answers
76 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 ...
0
votes
1answer
158 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
119 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
83 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 ...
4
votes
1answer
192 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
30 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 ...
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 ...
7
votes
1answer
269 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
139 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 ...
1
vote
1answer
66 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 ...
2
votes
1answer
905 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
1k 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
49 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, ...
1
vote
1answer
65 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
3k 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
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
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: ...
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
82 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 ...
0
votes
1answer
262 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 ...
0
votes
1answer
233 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 ...
1
vote
1answer
1k views

What happens to a transaction if the network connection fails?

What happens to a transaction when the client connection is lost. Example the client is a web application code that starts a transaction to a remote server instance. The client sends the sql code to ...
3
votes
4answers
15k 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 a built a virtual PC with Windows Server 2008 R2 and SQL ...
3
votes
2answers
827 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 ...
2
votes
1answer
775 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 ...
1
vote
1answer
634 views

How to isolate that network is issue of bad query performance [closed]

I would like to know how to isolate SQL Server bad query performance is caused by NETWORK and not the SQL Server. Are there any specific tips and tricks in SSMS, wait types, or specific PerfMon ...
1
vote
1answer
1k views

How Should TCP/IP be configured to allow an external application access to SQL via the same port #?

My SQL Server instance is hosted on an internal network server (10.x.x.x address). It's a named instance currently using dynamic ports. An external application at a third-party hosting location ...
1
vote
1answer
238 views

Access Linked Tables and Their Network Connections

I need to know some simplistic details about how Microsoft Access' linked tables work. I think I know the answer, and this question is more about asking for a confirmation than anything else. A ...
3
votes
0answers
1k 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: ...
0
votes
1answer
506 views

Clients require instance name to connect to clustered instance

We have a clustered instance, say Instance1, assigned its own virtual network name and IP, via Failover Cluster Manager. This instance is configured to listen on port 1433 in SQL Server network ...
2
votes
1answer
3k views

What are the ports and directionality of the TCP connections used in MySQL replication?

I wanted to know how replication works in mysql. Both slave and master have mysql server running say on port 3306. Slave acts like a client and master acts like a server. Does slave always bind to ...
8
votes
3answers
5k views

Does disconnecting the network stop a query?

I recently executed an update query against 100,000 records. I realized I'd made a mistake while the query was running and quickly unplugged the network cable. Does the update query stop ...
0
votes
1answer
88 views

Is SERVICE_NAME forced to be unique per logical database within a network? Would it have sense the opposite?

I like to know your opinion on these two sentences to see if I understood correctly the concept. Put RAC configuration aside, I am talking about logical databases, I understand RAC is like a group of ...
4
votes
3answers
3k views

How do I monitor bandwidth used by SQL Server on port 1433?

I have a single server running a .NET web application and a SQL Server database (2008 Standard). I'm planning to move the database onto a separate server but in order to provision the network hardware ...
1
vote
0answers
615 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
2answers
1k views

Can't use SQL Server database on a networkpath

I am working on a project for a very long time now. It's a .NET application which works with a SQL Server database (.mdf, LINQ to SQL). Now I am almost finished and wanted to run some tests. But ...
2
votes
2answers
3k 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: ...
4
votes
1answer
7k views

Communication link failure for some queries to linked server

I am seeing the following error in SSMS (server has Windows Server 2008 and Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 installed) when running some queries against the linked server, in ...