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 |
|
SKinsey
Starting Member
1 Post |
 Posted - 2010-08-04 : 03:40:16
|
| Hi,I've posted this here but it really relates to both 2000 and 2008. I have a copy of sql2000 on my remote server that I connect to via TCP/IP. So in enterprise manager I can put the IP address of the server in and it connects straight to the default instance.However I also have sql 2008 express on there as I want to experiment with migration. I can't figure out how I can connect to the 2008 instance through IP as the IP address and the port on the server connect right into 2000.I've looked through the IP settings on both the 2000 server utiility and the configuration manager for 2008 but I cant' see a way to allow connections to both servers through IP.Can anyone help?Thanks |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2010-08-18 : 07:06:07
|
| check the instance name...my guess your 2000 would be default and using just the ip address works, check the sql server configuration manager to verify the instance name--------------------keeping it simple... |
 |
|
|
|
|
|
Remote access to separate instances