Solved

sql server 8.0 - Need to access it remotely

Posted on 2006-11-17
7
264 Views
Last Modified: 2010-04-16
Hi Experts,
I need to access a sql server 8.0 database remotely through ip address. I tried some ways reading from other solutions but I could never make it work and actually ended up causing problem so I could not even access it locally.
I need to access the remote sql server database from a webserver as well as I want to be able to access it from a visual basic program running on a machine with internet access.

0
Comment
Question by:uzairp
7 Comments
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 17969644
Hi uzairp,

are the ports (usually 1433 and 1434) open on the firewall?

Cheers!
0
 
LVL 5

Accepted Solution

by:
kumar_jac earned 250 total points
ID: 17970695

Hi,
   1)  First you should find you Static IP of the sql server system
   2.) Then create a sql user and passowrd with rights to the specific database
   3.) Then try connect from it from your local system via query annalyzer
   4.) If you are using windows XP or firwall you have to give rights to that

sql server normally use 1433 port.

0
 

Author Comment

by:uzairp
ID: 17973517
1. I used the IP address of my machine on which the sql server is intalled.
2. I opened ports 1433 and 1434 on the router for that computer
3. Then I tried to connect to that sql database using a sql user and password that had created on that database and got the error "ConnectionOpen(PreLoginHandshake())".
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 5

Assisted Solution

by:sivachirravuri
sivachirravuri earned 250 total points
ID: 17978404
Create a DSN for connecting remote server & use this in your VB program. This is the easiest way for accessing.
0
 

Author Comment

by:uzairp
ID: 17980428
I created a System DSN and used the ip address in the 'Server' field and user/password from the remote machine and still got this error 'ConnectionOpen(PreLoginHandshake())'.
I also tried to use the format 'ip address,1433' in the server field when creating dsn but still could not connect.
0
 

Author Comment

by:uzairp
ID: 17992097
I am somehow still not able to connect even though I followed the steps outlined by kumar_jac. i.e,
1. I have a static IP that I used to create a System DSN
2. opened both both ports 1433,1434 on my router
3. In the "Server Network Utility", made sure that TCP/IP was selected as 'enabled Protocol'.

Does anyone see I am not doing something right OR missing something completely. I have tried everything I know or have read but it still does not work.
0
 

Author Comment

by:uzairp
ID: 18090287
Thanks for your answers. However, I am not able to connect to the remote sql server yet.  Steps given by kumar_jac were helpful for me to start trying in both DSN in sql query analyser (sivachirravuri). In case anyone can still help, please reply here.
I am trying to get a test machine only for this purpose and if I still cannot achieve the connectivity, i will post this question again in a few weeks.
Thank you for trying to help.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article is meant to give a basic understanding of how to use R Sweave as a way to merge LaTeX and R code seamlessly into one presentable document.
If you’re thinking to yourself “That description sounds a lot like two people doing the work that one could accomplish,” you’re not alone.
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…

685 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