0
votes
2answers
71 views

SQL server performance over long distance

Is it reasonable to expect decent performance from a SQL server connected via fiber private WAN - 5000 km's away. The carrier is telling us that this network is the 'best' possible, and will ...
1
vote
0answers
83 views

Make other VMs show in Network on windows server in Azure

I'm deploying a desktop app that connects to a remote database. standard 2-tier setup, but it's not a web app. People will log in via RemoteApp. But I'm having trouble getting the app instances in ...
4
votes
1answer
269 views

Network traffic to server keeps dropping out

I have a production server that is responsible for controlling a factory. The server runs a number of control applications and a SQL server. The problem I have is that one of the applications that ...
0
votes
0answers
40 views

Unable to connect to SQL Server over SSL

I am unable to connect to a SQL Server over SSL. This is the current setup: A server at my location sends data to an external service (SQL Server 2008) using SSL. We are using Websense and an ASA for ...
1
vote
0answers
30 views

Server network communication stalls

I'm running SBS 2008 as a file server, SQL server, IIS7 Server, and Exchange server, and very recently I am getting some very confusing stalls on it. During these "stalls," file services will cause ...
1
vote
1answer
117 views

Failover clustering or Network Load Balance on windows server

I have 2 servers with Windows 2008 R2 standard OS. I need to create a cluster in case on of the servers goes down ; so the other one will continue provide services. The services we mostly use are a ...
1
vote
2answers
137 views

Spoof database connection to be local instead of remote

I am trying to connect one of our clients "as is" programs to a remote database instead of a local one, they think that they have coded it to work that way, but for some reason the program crashes ...
0
votes
1answer
67 views

Troubleshooting SQL Connectivity on Azure

I am setting up a virtual server network on Azure. 1) Active Dir - Windows Server 2012 Datacenter 2) SQL Server - Windows Server 2012 Datacenter 3) App Server - Windows Server 2008 R2 Datacenter ...
1
vote
2answers
685 views

Creating shared folder between to servers

I need to create an SQL log shipping between 2 databases, The source is on an AWS EC2 instance running Windows Server 2008 R2 and SQL Server 2008 The destination is on an Azure VM running Windows ...
1
vote
4answers
484 views

TCPing reports 20ms latency between Web Farm and DB

We have a IIS web farm sitting in a DMZ connecting to a MSSQL DB(Windows Cluster). After troubleshooting some performance problems we stumbled upon strange network behavior. We wanted to test network ...
0
votes
1answer
207 views

SQL Server 2008 intermitent error 40 running parallel queries

Here's our setup : We are using Red Gate SQL Multi-Script to run queries on our ~1000 databases which reside on a single SQL Server 2008. SQL Multi Script can be configured to run queries in ...
0
votes
1answer
115 views

unable to connect to remote sql server from SHDSL router

Got a new leased line network to our office that came with a SHDSL router (Watson). Currently, we are unable to use Sql Server management studio to connect to remote Sql databases. It errors out ...
0
votes
1answer
159 views

Can you a virtual service account access the network in workgroup

By default SQL Server Uses a virtual account for the sql server service: NT SERVICE \ MSSQLSERVER which is a Virtual Account. I know you can give this account nework access in a domain by adding ...
3
votes
1answer
992 views

How do I network this Windows Failover Cluster and MongoDB Replica Set? (diagram inside)

As you can see, my two Windows Server Failover Cluster (WSFC) nodes have three network interfaces each, which connects them to three different networks : A public network A private network ...
0
votes
2answers
351 views

Why is SQL Server limiting speed to/from one database from IIS

I am having troubles with SQL server (or IIS, but I am pretty sure its SQL) I have posted before with a more vague question, however its still happening and I have some more detailed information. ...
0
votes
1answer
469 views

PC can't log into SQL Server on different peer network

I have a basic peer network (WORKGROUP) with PCs connected to sql server 2008 on a Windows 7 machine. I took one XP pc and the server home and connected to the server with no problems. When I plugged ...
2
votes
0answers
2k views

Why can't I connect on port 445?

I need to collect baseline performance data on a SQL Server running on Windows Server 2008 R2. When I open perfmon on my computer running Windows 7 and try to add counters from the remote server, I ...
0
votes
1answer
76 views

Basic Windows networking questions

Basically I got started looking into this because I got tired of just selecting stuff like NETWORKSERVICE just to make things magically work across our network, and wanted to learn more about what is ...
0
votes
1answer
432 views

Connect to SQL Server 2005 In Different Network

I need a help on SQL Server Remote Connection Issue. I have Windows Vista with SQL Server 2005 installed.I need client to connect to my system. My client is in VB6 uses SQL Native Client.Clients which ...
1
vote
2answers
256 views

How to I properly measure the network performance of SQL Server across a WAN?

We're in the process of migrating a number of servers to a different data center. As a stop gap measure, we've moved a set of web servers to the new data center and have left their supporting SQL ...
2
votes
1answer
333 views

Suggested or Best practices for network architecture for ASP.net web application

Currently I have one server that runs an ASP.net web application (on IIS) and this is also running a SQL Server database. I am getting more and more traffic and soon I will need to increase the ...
1
vote
2answers
511 views

Cannot connect from Linux to SQL Server through a firewall

I need to connect from a Debian GNU/Linux webserver to an SQL Server database which is hosted on a Windows machine within an organization's local network. The person in charge of the database server ...
0
votes
1answer
117 views

Cannot connect into WindowsXP on VMWare Fusion by IP

I have a SQL Server instance running on VMWare Fusion (WinXP) on my Mac. My development environment is on the Mac itself and my test server is failing to connect over the divide. VMWare is configured ...
0
votes
1answer
151 views

How to check which port to enable on Windows Server 2008 Firewall

I have an application which supposed to be launch from a client machine, but every time I launch it, it shows me an error saying "Failed to talk to database". By the way it is a .Net application and ...
2
votes
5answers
2k views

SQL Server 2008 R2 transactional replication over VPN

I'm having difficulty setting up replication over a VPN. I have a SQL Server 2008 R2, Enterprise Edition database on a Windows 2008 R2 Server. SQL Server is running on a non-standard port. I have ...
0
votes
1answer
855 views

SQL Server 2005 ASYNC_NETWORK_IO waits: can we just increase network buffer size? (How?)

We have a SQL Server 2005 (64-bit Std) on Win2k3 R2. We're seeing a disproportionate number of ASYNC_NETWORK_IO waits that (seem to) result in unavailability of the database, which slows or hangs our ...
0
votes
1answer
56 views

Server reverts to PPP Adapter IP, breaks sql connections

Here is the issue. Server 1 loses connection via sql to Server 2. Each time this happens I notice that pinging Server 2 from Server 1 shows it resolves the IP to the address of its PPP Adapter IP. ...
1
vote
2answers
530 views

Is connecting to sql server 2008 r2 express remotely a secure connection?

I am connecting to a Windows 2008 R2 Server with SQL Server 2008 R2 Express installed. I am connecting through a remote connection, not on the same LAN. I am connecting to the SQL Server 2008 R2 ...
0
votes
3answers
215 views

Estimate daily network IO between 2 servers

I have 2 servers : a database server (SQL Server 2008, called server A) and an application server (called server B) which send SQL queries to the first one. They are actually in the same LAN, but we ...
0
votes
6answers
1k views

Setting up a network e-mail server

My boss just asked me to buy a new server for our office network. I know next to nothing about servers and networking, so I need someone to point me in the right direction. He said he wants this to ...
0
votes
1answer
276 views

SQL ERROR: Verify that the instance name is correct and that SQL Server is configured to allow remote connections?

I am getting following error while connecting to my local Sql Express. An error has occurred. Details of the exception: A network-related or instance-specific error occurred while establishing a ...
4
votes
2answers
3k views

how does ping resolve to ipv4 on one machine, but ipv6 on another?

Background I have two environments, TEST and STAGE. I use Microsoft Distributed Transaction Coordinator (MS DTC) with two linked 2008 SQL servers. A SQL job runs every couple of minutes and ...
0
votes
1answer
40 views

SQL Server: error when connecting

(migrated from stackoverflow) The application I'm using tries to connect SQL Server named instance running on a dedicated database server. Here's the error I'm getting: The TCP/IP connection to the ...
2
votes
2answers
2k views

How to connect to IIS and SQL Server Express on Windows 7 host from XP Mode

I am running IIS and SQL Server 2008 Express on my Windows 7 host, and I'd like to be able to connect to them in XP Mode. My host machine is not a part of a domain, only a workgroup. So far, I've ...
0
votes
2answers
897 views

SQL instance through F5 BigIP VIP

We have a SQL 2008 clustered named instance Server01\instance02. The port is set to static 1466. We'd like to be able to connect using the name through a F5 Big IP Virtual IP. We've set up a VIP ...
1
vote
3answers
200 views

Windows Server 2003 can't see Vista machine

I've got a real PITA problem that I'm sure has a really simple solution. I have a Windows Server 2003 machine that needs to be able to see the network name of a Vista box - but refuses to. It can see ...
1
vote
2answers
496 views

“Connection failed” error when trying to telnet into SQL Server

I have an SQL Server running on a computer, and I'm trying to access it from another computer in the same local network (potentially VPN, since it's located in a datacenter). The point is that I can't ...
1
vote
2answers
1k views

MS Access gets Disconnected

I have MS Access 2003 application connected to SQL Server 2005 with linked tables. Starting from yesterday when I open a linked tabled and leave it open for a while (5~10 minutes) then the database ...
3
votes
6answers
5k views

SQL Server 08 Express error when connecting to localhost - “Timeout expired”. Works with ::1 or 127.0.0.1

EDIT New info: Navigating to localhost:1434 in Chrome gives me an "ERR_EMPTY_RESPONSE", while other ports give me an "Oops! This link appears to be broken". So it seems to binding ok there? So ...
0
votes
1answer
81 views

SQL Server Remote Query TCP Error

We are in the process of moving to a new hosting provider and after setting up a very simple database in SQL Server 2005, I noticed that if I wait more than 10 seconds or so between running queries ...
1
vote
6answers
8k views

Can't connect to sql server 2008 named instance

I have sql server 2005 and 2008 running on a server on my local (and very straightforward) network. Using sql management studio 2008 and visual studio 2008, I can connect over the network to the 2005 ...
0
votes
4answers
6k views

How can I set up port forwarding for SQL Server 2005?

Subject :how to use port forwarding Internet------> Router in my network ------->LocalMachine (Windows 2003) -->Sqlserver2005 How can I access SQL Server through the internet via a router ...
1
vote
2answers
555 views

Can't connect to MSSQL Server 2000 with “IP Address” but works with server “hostname”

this happens after applying the SP3 on MSSQL Server 2000, I just can connect with SA login or DOMAIN\Administrators (built in) users, How can I reenable the Integrated Security connection? Hey Hey... ...
0
votes
2answers
7k views

TCP/IP packet loss network testing (in context of PingPlotter)

My question may be pretty basic TCP/IP / router based, but I need to couch it in terms of a Winpcap application pingplotter that I have used. One of the features I did use in my last place of work ...
0
votes
2answers
71 views

Designing AD Domain for SQL Server in multiple third-party locations

I have an application that uses SQL Server where I plan on deploying four instances to four different third-party dedicated hosting providers. The databases will replicate between each other. So, does ...
0
votes
1answer
261 views

How can I figure out where a connection is dying?

We have a MSSQL database configured in a cluster (fail-over). It's working fine for its intended purpose, but we can't seem to monitor availability via OpsView: check_tcp -H $HOSTADDRESS$ -p 1433 ...