Solved

Can't remotely access MSSQL database

Posted on 2010-11-12
2
461 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Do you have a plan for Continuity?

It's inevitable. People leave organizations creating a gap in your service. That's where Percona comes in.

See how Pepper.com relies on Percona to:
-Manage their database
-Guarantee data safety and protection
-Provide database expertise that is available for any situation

Question has a verified solution.

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

While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
This article provides a convenient collection of links to Microsoft provided Security Patches for operating systems that have reached their End of Life support cycle. Included operating systems covered by this article are Windows XP,  Windows Server…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

631 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