Solved

Can't remotely access MSSQL database

Posted on 2010-11-12
2
457 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 250 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 250 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Select - identify record discrepancies 1 30
SQL 2014 missing dll from Bin? 3 31
SQL Syntax 6 36
Delete old Sharepoint backups 2 11
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

735 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