Title:
worked like a charm
Name:
Dave
Date:
2012-02-10 11:28:58 AM
Comment:
Great job. Still works even after all these years
|
Title:
SQL Server 2008 remote connection
Name:
Bud Aaron
Date:
2010-06-15 3:42:51 PM
Comment:
For a complete step by step set of instructions for enabling remote connections on SQL 2008 try here:
http://videotutors.net/SQLServer2008RemoteAccess.aspx
|
Title:
Please Help me
Name:
Alkesh Nayak
Date:
2010-06-02 1:42:28 PM
Comment:
My Sql Server Is On windows server2003,
I want to access it via internet.
What will be the pre- requirment of my Project in asp.net and vb.net.
I am new in this field.
|
Title:
hi
Name:
chirag
Date:
2010-03-10 3:54:42 AM
Comment:
please give discription in deep.
the solution you have given is not enough. & it is meaning less
anyone can't understand using this tutorial
so change your style
|
Title:
Thanks for article
Name:
Kuldeep bhojak
Date:
2009-10-28 6:56:35 PM
Comment:
This is very useful article
|
Title:
connect to RDP
Name:
amar
Date:
2009-06-05 2:32:03 AM
Comment:
Thank u.
|
Title:
Remote Access
Name:
Manish.M.Meshram
Date:
2009-05-13 3:34:19 AM
Comment:
Hello,
My Sql Server Is On windows server2003,
I want to access it via internet.
What will be the pre- requirment of my Project in asp.net and c#.net.
I am new in this field.
Thanks for your Kind Reply
manish.m.meshram@gmail.com
|
Title:
SQl 2000 not connecting to remote server
Name:
Mike
Date:
2009-03-10 6:37:50 AM
Comment:
Hello;
Please can some one help me. I have installed sql server 2000 in the office server and tried connecting through querry analyser and ent manager but i am experiencing eror saying server does not exist. Meanwhile i have configured the client network utility and server network utility on both ends.
I tried telnet server_ip 1433 and no connection.
Pls advice me on what to do. My client and server os is Win Xp.
Thanks
Mike
|
Title:
Excellent - Solved my confusion!
Name:
TJ Benoit
Date:
2009-01-13 3:14:51 PM
Comment:
Thank you! This was exactly what I needed..
|
Title:
Re: SQL Server connection error
Name:
Desiree
Date:
2008-12-09 1:08:50 PM
Comment:
Hi,
You will need to have the SQL server name or IP address to properly connect.
~Desiree
|
Title:
SQL Server connection error
Name:
Ram
Date:
2008-12-09 2:10:53 AM
Comment:
hi
I'm trying to create the new alias name.but it is not taken the name.it is giving the error."server name is not correct" i finding this error.how do find out to connect to the my local database without knowing server name.
|
Title:
Remote SQL server connection error
Name:
Neelesh Soni
Date:
2008-11-24 4:01:50 AM
Comment:
Hi,
I am trying to connect to a remote SQL server in Australia.
using ODBC, I am using the IP address of server, they have enabled connection for remote access, but I m getting error that server does not exists, but I am able to ping the server.
please help
thanks.
|
Title:
Re: doesn't work
Name:
A
Date:
2007-11-26 12:16:51 PM
Comment:
Hi,
I will need you to explain what you are doing in further detail before I can provide additional direction on connecting to the remote SQL Server. One thing to check is the connection to the remote SQL Server. Open a command prompt and ensure you can telnet to it on the SQL port by typing "telnet server_ip 1433" (be sure to put the actual server ip address in place of "server_ip"). If you are able to connect, everything should work properly otherwise the connection is blocked and that will need to be solved first. I hope this helps.
Regards,
Desirée
|
Title:
doesn't work
Name:
A
Date:
2007-11-25 8:42:58 AM
Comment:
Thanks for a very nice article.
I followed the procedure as described above but in the last step after clicking on finish button nothing happens but my sql server window gets closed. I again open sql server window to see no change.This is repeatedly happening.
Please Help.
Thanks in advance.
|
Title:
Wonderful
Name:
G
Date:
2007-09-25 12:18:39 AM
Comment:
Wonderful...Very Useful.
|
Title:
Connecting Sql 2000 Database To visual studio and also i need the code snippet to save ,modify,delete and also for graph generation.
Name:
saranya
Date:
2007-09-04 1:09:59 PM
Comment:
This is an informative article for all of us in i.t field
|
Title:
Re: to move the site from one server to another or database is moved from one server to another
Name:
Desiree
Date:
2007-05-29 10:45:50 AM
Comment:
Hi,
There are several changes that are needed when moving a website or a database to another location/server. There are so many factors to consider, it's hard to give a list of things that are needed. Are you moving the website to a web host? If so, they will provide you with the information and tools you need to start uploading your website content and database to their servers so you can test before updating DNS to point to the new location. If your website content uses any absolute paths, you may want to consider changing them to relative (http://www.ibdhost.com/help/path/). Connecting to the database at the new location is as simple as updating the connection string to point to the server once the data has been uploaded. I hope this helps.
Regards,
Desirée B. Harris
Windows 2000 MCDBA
|
Title:
to move the site from one server to another or database is moved from one server to another
Name:
Pavan Kumar.P
Date:
2007-05-28 7:55:45 AM
Comment:
Hai to Everybody,
I want to create a website with several webpages in ASP.NET in my own computer and also providing some ODBC Connections to Database that I have to call in Application serverat some other place.If will change the path of webpages that automatically updated when the client reads this websiteI want to move this website to different application servers.What is the approach I have to implement..waiting for the response
|
Title:
unable to connect to yahoo's games rooms
Name:
george koutsodontis
Date:
2007-05-06 8:23:49 AM
Comment:
hello all.
i am connected with my son's computer via lan cable.I can open all sites but my problem is that i cant get into the yahoo's game rooms.it says unable to connect to server..
i was getting into rooms right away with my son's pc before using the lan cable.is something wrong with the yahoo's game server or there is something i must do.
please give me a hand to solve my problem.
thank you very mucm
plaster1946@yahoo.com or ford1979g@yahoo.com
|
Title:
Re: Connection Breaks
Name:
Desiree
Date:
2007-05-03 10:32:04 AM
Comment:
Hi,
I recommend starting a constant ping to the remote SQL Server while you are working. When you get disconnected, check your pings to see if it is your internet connection. If it is, you will want to contact your ISP. If it isn't, I recommend contacting the network administrator for further assistance. I hope this helps.
Thank you,
Desiree B. Harris
ORCS Webteam
|
Title:
Connection Breaks
Name:
Giri
Date:
2007-05-03 2:32:47 AM
Comment:
getting disconnected from sql server while working. Some time the connection is okey. But in some time it fails is it network problem sql?
|
Title:
help
Name:
mash
Date:
2007-03-24 6:00:31 PM
Comment:
Hello gentle men!
1st I would like to thank for your cooperations.
My problem is that:
How can I connect to a sql server databse on a remote computer using a vb.net code, like that I use the following code to connect to a local computer using the following code:
"server=localhost;uid=sa;pwd=test;database=lifedb"
|
Title:
not useful
Name:
saran
Date:
2007-01-24 7:48:44 AM
Comment:
i have installed sqlserver and clienttools in my system and i want to connect a server that has the ip '216.157.145.63'.
and my system is getting internet connection via proxy(using free proxy software).the ip server not connecting.i configured in sql server as u told above.
|
Title:
oneofdev
Name:
email me if the problem exist
Date:
2007-01-09 1:12:42 AM
Comment:
oneofdev@yahoo.com
|
Title:
sql connection doubt
Name:
one of devs
Date:
2007-01-09 1:10:27 AM
Comment:
Hi,
i used Proxifier 2 or 2.5,
and it solved,
EntManager send its data to localhost
and proxifier redirects it to a
Socks Proxy server,
i connected to a database by this solution,
hope to be use full
|
Title:
sql connection doubt
Name:
Scott Forsyth
Date:
2006-12-28 2:46:42 PM
Comment:
Hi sql doubt,
Your network administrator would need to help with that. Generally speaking though, if your proxy server is on the client side (the side using Enterprise Manager), then you probably don't need to worry as long as your firewall/router allows outgoing connections. If it is on the inside, then you will need to set up your NAT server or set up a route on your router to forward port 1433 to the SQL Server computer.
|
Title:
sql connection doubt
Name:
sql doubt
Date:
2006-12-27 8:50:06 AM
Comment:
i am using internet through a proxy server in a network.then how can i connect using a ip address to a domain
|
Title:
Problem connecting with alias vs IP
Name:
creekau
Date:
2006-11-16 4:17:04 AM
Comment:
The problem is that I can connect to a remote server with IP directly, but when i try to use an alias it won't connect. I used the same ms sql server kit to both of the servers(with SP4). I filled correctly the ip's of the remote server, i have connextion, the firewall is off, all settings are ok(i think), but still won't work with alias. It has to work with alias becaose the replications use the alias name.
10x
|
Title:
mmm
Name:
Palmant0
Date:
2006-11-06 2:27:54 PM
Comment:
You are the chairman of the Remote SQL Server Company.thx a lot
Dude.
|
Title:
RE: Sql Server is not running
Name:
Desiree
Date:
2006-09-01 3:55:05 PM
Comment:
Hi,
It sounds like you should check the server properties to ensure the SQL Server service is running and configured properly. Another thing to try is pasting the exact error into Google to see if you find any useful information/articles. It's likely that other people have experienced the same issue and have solved it. I hope this helps.
Desiree
|
Title:
Sql Server is not running
Name:
Thaneshwar Jaglan
Date:
2006-09-01 3:37:18 AM
Comment:
Explanation is very clear and concise but I got the connection failed error while connecting to remote sql server after registraion.IP adrress, password and user id are correct. It Gives me the message" remote sql server is not knowing to run"
|
Title:
RE: still showing error
Name:
Desiree
Date:
2006-08-31 8:33:59 AM
Comment:
Hi,
It's likely that the server name and/or IP address you are using to connect to the SQL Server is incorrect. Try opening a command prompt and try to telnet to the server on port 1433 (type "telnet servername 1433" [without quotes] - replace servername with the actual server name). If it doesn't connect you will need to get the correct server name, IP address and/or port.
~Desiree
|
Title:
still showing error
Name:
kiran
Date:
2006-08-31 6:56:16 AM
Comment:
hi
summary is good but i tried above procedure but showing error message... Sql server doesnot exists or access denied
pls do need ful help... send solution to above url
|
Title:
CEO
Name:
Anil Gupta
Date:
2006-08-31 1:04:01 AM
Comment:
This article was really helpful
|
Title:
A lot of thanks
Name:
JAGAT SINGH
Date:
2006-08-26 7:08:08 AM
Comment:
good articals and mor help full
|
Title:
Re: Dr
Name:
Desirée
Date:
2006-08-03 8:33:02 AM
Comment:
Hi Simon,
I'm glad you found the article helpful. Have a great day!
~Desirée
|
Title:
Dr
Name:
Simon - Estona Internet Marketing Ltd
Date:
2006-08-03 2:37:00 AM
Comment:
Thank you folks! This kind of thing can waste hours of time when first attempting it and not knowing what you don't know but these instructions got straight to the point and worked perfectly.
|
Title:
denis
Name:
akulay
Date:
2006-07-31 10:37:09 AM
Comment:
Denis Akulay @ this is helpful
|
Title:
System Administrator
Name:
Tracy
Date:
2006-07-25 2:56:55 PM
Comment:
I had never done this before. This article walked me straight through the process without a hitch! Seems like it is hard to find helpful articles that get straight to the point, but this one proves me wrong. I like it!
Thanks!
|
Title:
Remote Sql Server Connection
Name:
Desiree
Date:
2006-06-22 8:31:38 AM
Comment:
Try using Microsoft's Web Data Admin Tool:
http://www.databasejournal.com/features/mssql/article.php/3330301
~Desiree
|
Title:
Remote Sql Server Connection
Name:
Abhishek Pushker Pandey
Date:
2006-06-22 7:38:40 AM
Comment:
Dear Sir,
I have a query regarding remote SQL Server Connection in C#.Net. Let me exlain you the scenario. A company has two branches in two different cities. Let it be CityA and CityB. CityA holds the Server Machine on which a SQL Server is installed and running. CityB wants to connect to SQL Server running at CityA. But make sure that both of these use only internet to communicate. Moreover, SQL Server is not running on a web server or intranet scenario. Please help !!!
|
Title:
Mr
Name:
Pawel
Date:
2006-06-21 5:22:42 AM
Comment:
Thank you for the help - most useful! :)
|
Title:
Yeah!
Name:
Glauber Exorcista
Date:
2006-05-30 4:12:07 PM
Comment:
Yeah, it worked pretty fine! Thanks Ben!
|
Title:
TY
Name:
IronManKo
Date:
2006-05-30 4:09:26 PM
Comment:
Thank you for this :)
it will help me greatly in the coming days as i am currently setting up a game server for knight online with the help of a few others, and need them to have remote access to the database :)
|
Title:
nice to read
Name:
vin_chattu
Date:
2006-05-23 5:53:23 AM
Comment:
I cleared my doubt..thank uuuuu
|
Title:
Thanks for the article
Name:
Mani
Date:
2006-05-23 4:33:49 AM
Comment:
cheers.. that was helpful
|
Title:
Connect to Remote database
Name:
Steve Schofield
Date:
2006-05-02 10:16:31 AM
Comment:
From what you are describing, you need to check with your Proxy or Firewall administrator to see if they can forward or open port 1433. This is the port SQL Enterprise manager uses.
|
Title:
Unable to Connect
Name:
Irfan Aslam Bhatti
Date:
2006-05-02 9:11:46 AM
Comment:
Dear,
I still unable to Registrater the SQL Server on the Remote location. Please tell me if I can connect it under proxy environment.
Looking forward,
bye
|
Title:
Thanks
Name:
Shibu Antony C
Date:
2006-05-01 4:40:04 AM
Comment:
Thank u very much it's really usefull. i was searching for this.
shibu
|
Title:
Incredibly helpful
Name:
Scott Barnett
Date:
2006-03-31 11:34:26 PM
Comment:
This was incredibly helpful. Thank you.
|
Title:
Hats off to you!
Name:
Nisar
Date:
2006-03-29 10:30:39 AM
Comment:
Hey Benjamin,
You have posted one of the coolest article. This has resolved my night mare about remote connectivity with SQL as all other articles were too complex. You did a great job and it really reflects.
|
Title:
MS SQL Sever
Name:
Madhu
Date:
2006-03-27 7:52:40 AM
Comment:
Hi,
This article is most useful. Very informative. Cleared my many doubts.
Thanks
Madhu
|
Title:
Re: Do it in Code?
Name:
Desiree
Date:
2006-03-20 4:44:20 PM
Comment:
Hi Larry,
This article is specific to accessing a database remotely using Enterprise Manager / SQL Utilities for administration. What exactly are you trying to accomplish by using code? If you are referring to accessing the database data via remote queries, then, yes, that can be done via code. But, you'll need to search google (or another search engine) to find the answer to this as there are a number of ways to do this.
I hope this helps.
~Desiree
|
Title:
Do it in Code?
Name:
Larry George
Date:
2006-03-20 4:19:28 PM
Comment:
Is there anyway of doing this in Code? Like C#
|
Title:
Connecting to a Remote SQL Server
Name:
Md. Yousuff
Date:
2006-03-08 2:36:14 AM
Comment:
It is really helpful, straight to the point.
Excellent !!
Thanks Benjamin Higgins.
|
Title:
Adding SQL Server
Name:
Steve
Date:
2006-03-02 1:07:19 AM
Comment:
I would verify port 1433 is open on your local firewall or router. This generally is the issue. Also make sure the port 1433 is also open to the server.
|
Title:
Not working
Name:
samir
Date:
2006-03-02 12:00:41 AM
Comment:
Still it is not working Access denied error
|
Title:
Mr.
Name:
Varun
Date:
2006-02-16 3:19:49 AM
Comment:
Most helpful, and easy to use and implementation
|
Title:
RE: Nice
Name:
Desiree
Date:
2006-02-15 11:50:37 AM
Comment:
Hi Rama Krishna,
I'm not sure I understand your question. In order to connect to a remote SQL Server you must have either the server name or IP Address. If you have the server IP address, you can use it in place of the server name. If this doesn't answer your question, please further explain your problem. Thanks.
~Desiree
|
Title:
Nice
Name:
rama Krishna
Date:
2006-02-13 7:00:05 AM
Comment:
Hai I want how to configration to my remote sql server. but i know where it is.so would u pls expain to me in remote sql server. that is without our LAN
|
Title:
Connecting to remote sql server
Name:
Steve Schofield
Date:
2005-12-12 8:23:34 AM
Comment:
Hi,
I would verify port 1433 is open on your local firewall or router. This generally is the issue. Also make sure the port 1433 is also open to the server.
Steve
|
Title:
Still can't connect
Name:
Burhan
Date:
2005-12-12 7:32:48 AM
Comment:
well the article is fine, but i am not being able to connect. it keeps on saying 'SQL Server doesnot exists or access denied'. Is this due to some network security?
(I am sure that the IP , username and password are correct.)
|
Title:
thanx
Name:
cobra
Date:
2005-11-30 2:06:19 AM
Comment:
The article is really nice.I am also facing a problem while connecting to a remote server.This thing i want knowing .Thanx
COBRA
|
Title:
Mr
Name:
Marcel
Date:
2005-11-02 5:02:10 AM
Comment:
Nup, still dosnt work
|
Title:
Excellent !!! 10Dots.Net
Name:
Mario
Date:
2005-10-15 2:59:47 PM
Comment:
Excellent article, concise and exactly right. Now I am connected!
|
Title:
Excellent
Name:
Sas
Date:
2005-09-16 11:22:32 PM
Comment:
Excellent summary. Really useful. Thanks Benjamin.
|
Title:
mr
Name:
denisianum
Date:
2005-07-15 12:44:14 PM
Comment:
thx man.you are the only one that has talked about this on da net,it looks like.
denis
|
Title:
Thanks for the article
Name:
Bryce
Date:
2005-07-04 7:50:37 PM
Comment:
Most helpful, straight to the point.
Cheers
|
