Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Mastan
Starting Member
5 Posts |
 Posted - 2006-11-30 : 07:04:49
|
| HiI’m using SQL Server 2000; also I have a static IP address. I would like to assign IP address to SQL Server for access the particular database anywhere using IP address. Are you getting what I’m saying? See some of hosting companies allows to access SQL Server through IP address. like I want to do. So much I tried to that. But I cant. I used likeClient Network Utility --> Alias --> ADD --> Server Name : <myip>After done that, I tried to access from other system which is using another network & IP. In the Query analyzer I put myip & password. But I unable to access my SQL Server, also unable to ping.Please anyone help me. How to do this? Knows like a drop,Unknown like a Ocean. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-11-30 : 07:15:48
|
| Do you have a firewall installed?Peter LarssonHelsingborg, Sweden |
 |
|
|
Mastan
Starting Member
5 Posts |
Posted - 2006-11-30 : 07:16:44
|
| noeven I uninstalled Antivirus tooo.... :(Knows like a drop,Unknown like a Ocean. |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-11-30 : 07:17:59
|
| If you are unable to ping to that IP, how do you expect to connect to SQL Server on that IP.Harsh AthalyeIndia."Nothing is Impossible" |
|
|
|
Mastan
Starting Member
5 Posts |
Posted - 2006-11-30 : 07:25:22
|
| yes unable to ping, pls help me how to do that? but that is static IP address. Knows like a drop,Unknown like a Ocean. |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-11-30 : 07:27:01
|
| If you have no firewall in place and cannot ping the IP then you have a routing issue, not a sql server issue.-------Moo. :) |
|
|
|
Mastan
Starting Member
5 Posts |
Posted - 2006-11-30 : 07:30:36
|
| then what wrong with me? how to connect?Knows like a drop,Unknown like a Ocean. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-11-30 : 08:06:47
|
| I would check all network cables, from your machine, through patch panels, switches and routers and back to the sql server machine to see if there is a connection.Peter LarssonHelsingborg, Sweden |
|
|
|
|
|
|
|
|
How set IP address