Questions tagged [network]
The network tag has no usage guidance.
177
questions
2
votes
1
answer
6k
views
Attaching / creating database on network drive - Access is denied
I have two computers, computer A is with SQL Server but has no space left, the other is computer B which has free space.
I'd like to create a new database on computer B. This is what I've done so far:...
- 121
2
votes
1
answer
2k
views
Is there any impact to changing IP address of MySQL Server?
We are changing the network and the IP addresses will be changing.
Will there be any impact to MySQL running on the server?
I don't use the IP address to reference the server. Instead I use the ...
- 155
2
votes
2
answers
4k
views
SQL Server Express 2014: Network Access
I have SQL Server Express running on one (virtual) machine running Windows 8.1, but I cannot connect to it from another.
I have followed the instructions on https://msdn.microsoft.com/en-us/library/...
- 2,579
3
votes
2
answers
2k
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, ...
- 143
1
vote
2
answers
263
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 ...
- 111
7
votes
3
answers
30k
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, ...
- 1,774
0
votes
1
answer
42
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 ...
1
vote
0
answers
98
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,692
1
vote
0
answers
36
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 ...
1
vote
1
answer
1k
views
High data traffic from MySQL server to web server [closed]
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 ...
- 111
2
votes
0
answers
268
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 ...
- 512
3
votes
1
answer
2k
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 ...
- 245
2
votes
1
answer
739
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 ...
- 186
2
votes
1
answer
944
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 ...
- 7,274
1
vote
0
answers
96
views
SQL AlwaysOn Availability Groups network performance [closed]
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 ...
- 41
8
votes
1
answer
2k
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,219
2
votes
0
answers
520
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 ...
- 171
1
vote
0
answers
43
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 ...
- 777
4
votes
1
answer
23k
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 ...
- 15.6k
4
votes
2
answers
658
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 ...
2
votes
1
answer
13k
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 10.8.101....
- 189
4
votes
1
answer
450
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 ...
- 163
0
votes
1
answer
136
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 ...
- 113
7
votes
1
answer
975
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 ...
- 73
0
votes
2
answers
1k
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
2
answers
217
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 ...
- 111
2
votes
1
answer
11k
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)
...
- 135
16
votes
3
answers
4k
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 ...
- 353
0
votes
1
answer
85
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, ...
- 101
2
votes
1
answer
172
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,913
4
votes
2
answers
16k
views
Best practices for service name / aliases in tnsnames
I have this idea that service names / aliases given to connections descriptors 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 ...
- 703
4
votes
1
answer
6k
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?
- 165
0
votes
2
answers
5k
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: 192.168.3.103
...
- 31
0
votes
2
answers
5k
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 ...
- 649
0
votes
1
answer
94
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 ...
- 115
0
votes
1
answer
1k
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 ...
- 1
0
votes
1
answer
1k
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
5
votes
2
answers
10k
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 ...
- 741
7
votes
4
answers
39k
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 ...
- 1,453
3
votes
2
answers
2k
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 ...
user1771538
3
votes
1
answer
2k
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 ...
- 31
1
vote
1
answer
2k
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 ...
- 157
1
vote
1
answer
3k
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,913
1
vote
1
answer
690
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 ...
- 125
5
votes
0
answers
3k
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" ...
0
votes
1
answer
941
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 ...
- 373
5
votes
1
answer
13k
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 ...
16
votes
3
answers
23k
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 processing ...
- 169
0
votes
1
answer
118
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 ...
- 523
4
votes
3
answers
8k
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 ...
- 789