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 |
|
ramlalasah
Starting Member
2 Posts |
 Posted - 2012-04-05 : 04:11:16
|
| hi all,i m not able to connect sql server 2000 remotely which is installed on public IP..pls suggest what is still i need to configurethanx |
|
|
Xiez
Starting Member
13 Posts |
Posted - 2012-04-06 : 18:17:55
|
| Kind of a shot in the dark here, but I'm guessing it's something to do with the user info. Are you using Sql Server authentication and are you sure the user is in the security section and has rights? |
 |
|
|
ramlalasah
Starting Member
2 Posts |
Posted - 2012-04-08 : 00:34:43
|
| thanx for reply,actually we are using vb.net application for connection and we are able to connect under LAN but not able to connect if database server on different range of IP..i mean public IP..there is user in security section and full access |
|
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2012-04-08 : 11:12:55
|
| When you say public IP - do you mean public as in from the internet? If so, I would recommend that you don't do that - it opens your system up to all kinds of security risks. |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-04-09 : 04:09:18
|
| Can you ping the ip?Can you connect using another client , such as SQLCMD? or SSMS?Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
not able to connect sql server 2000 remotely