Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Can't remotely access MSSQL database

Posted on 2010-11-12
2
Medium Priority
?
466 Views
Last Modified: 2012-05-10
Hi!

I have a desktop application that I run under Windows 7 Professional.
I have never had a problem remotely accessing a MSSQL database that we have on a remote server running Server 2003 until I upgraded Plesk from 9.5.3 to 10.0.1
The installation of Plesk is trashed.
Anyway I can open the database when I RDC to the remote server using MSSQL 2008 locally installed on the remote server and the data is in tact.
I think somehow the port is being blocked.
Unfortunately, I can get to the firewall that Plesk manages.
I looked at the protocols for the MSSQL and they look unchanged.
I am basically getting an access denied when I try to access the database remotely through TCP.
Any ideas how I can fix this?
Can I access the firewall somewhere else?
Also I looked in the log and there is no mention of a denial when I try to connect.
0
Comment
Question by:TrueBlue
2 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 1000 total points
ID: 34120547
yes, this sounds like a firewall on either the server, the client or somewhere in between.
http://www.experts-exchange.com/A_1881.html

you might need the firewall guys indeed to solve this ...
0
 
LVL 16

Assisted Solution

by:EvilPostIt
EvilPostIt earned 1000 total points
ID: 34120856
Also make sure you have enabled SQL Server for remote connections as below. Although i would say this is more likely to be a firewall issue.

http://support.microsoft.com/kb/914277
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

927 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question