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 |
|
askcomputer
Starting Member
12 Posts |
 Posted - 2005-12-15 : 23:05:07
|
| Hello EverybodyI am having MS SQL Server 2000 installed on Windows 2000 at our office in India.I am in another city in India and have MS SQL Server 2000 installed on my machine which is Windows 2000 OSnow i want to connect to the Remote MS SQL Server in India office using Enterprise Manager and view the databases.RegardsSantosh Khedkar |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2005-12-15 : 23:15:34
|
| Do you have problem registering the remote SQL Server in the Enterprise Manager ? Can you connect to the remote Server via Query Analyser ?-----------------[KH]Learn something new everyday |
 |
|
|
askcomputer
Starting Member
12 Posts |
Posted - 2005-12-15 : 23:19:19
|
please explain step for remotely connection.quote:
Originally posted by khtan
Do you have problem registering the remote SQL Server in the Enterprise Manager ? Can you connect to the remote Server via Query Analyser ?-----------------[KH]Learn something new everyday
|
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2005-12-15 : 23:29:28
|
| Is both office connected via VPN ?If so then just enter the remote SQLServer IP Addr & Port no when running Query Analyser. For example 192.168.1.1,1433.For Enterprise Manager, click on the left panel tree and select 'New SQL Server Registration'. If you are using wizard mode, enter the ipaddr,portno in the Available server box and click next-----------------[KH]Learn something new everyday |
|
|
|
askcomputer
Starting Member
12 Posts |
Posted - 2005-12-15 : 23:55:52
|
No VPN Connection.quote:
Originally posted by khtan
Is both office connected via VPN ?If so then just enter the remote SQLServer IP Addr & Port no when running Query Analyser. For example 192.168.1.1,1433.For Enterprise Manager, click on the left panel tree and select 'New SQL Server Registration'. If you are using wizard mode, enter the ipaddr,portno in the Available server box and click next-----------------[KH]Learn something new everyday
|
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2005-12-16 : 03:42:59
|
| would this helpBasically there are two ways of viewing your data. If you have MS SQL 2000 installed locally, you could connect via Enterprise manager. (thats if your web host allows you)1. Connect to your MS SQL DB via Client network utility2. You could either use Query Analyzer (if you are familiar with T SQL syntax)3. Connect via MS SQL Enterprise manager. to use this option, once you have connectedThe following step-by-step process guides you through setting up Enterprise Manager to properly register and connect to our SQL server so you can remotely manage your database.Steps to Register Server properly 1) Go to Start/Programs/Microsoft SQL Server/Client Network Utility 2) Make sure TCP/IP is in the Enabled list and on top 3) Click on the ALIAS tab 4) Click ADD 5) Enter 'yourdatabasename' for the Alias 6) Select TCP/IP for the Network Library 7) Change Server Name under Connection Parameters to "sqldb.domain.com" (This depends on your server configuration)(use your domain name), Click OK 8) Click OK again to Close Client Network Utility 9) Go to Start/Programs/Microsoft SQL Server/Enterprise Manager 10) Expand Microsoft SQL Servers 11) Right click on SQL Server Group 12) Select New SQL Server Registration 13) Click Next 14) Highlight 'yourdatabasename' Alias and click ADD 15) Click Next 16) Under Connect Using select SQL Server Login, click Next 17) Enter your username 18) Enter your password 19) Click Next, Click Next again, Click Finish, Click Close Try connecting!!!alternatively, ask your host if they have MS SQL web admin, it runs over .net framework.rgds |
|
|
|
|
|
|
|
|
Problem connecting to remote MS SQL Server 2000