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 |
|
mohdrashid
Starting Member
23 Posts |
 Posted - 2005-07-08 : 21:42:55
|
| Hi all,i have this senario:i have a web server running ms sql (server name abc). I have set up the user in the win 2000 and sql security on the webserver. the user id and passwords on my work station (win pro xp) is as the web server and sql.I creating a new server group using the ip address of the web server (top level group).there after i created a new server registration using windows security. but i was unsuccessful in registration. I can ping the server from my workstation. so is it possible to connect from my workstation to the server abc via the enterprise manager?thanks in advance.rashid |
|
|
gavinj1999
Starting Member
1 Post |
Posted - 2005-07-09 : 03:01:06
|
| RashidEnsure That you have port 1433 opened at both the server and client, be cautious with this and if possible give only authorised workstations access to this port on the serverRegardsGavin |
 |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-07-10 : 17:21:57
|
| are these machines on a windows domain?Sean RoussyPlease backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own.I am available for consulting work. Just email me through the forum. |
|
|
|
|
|
|
Connecting remotely.