I have both 8 and 2005 installed on a windows 2003 server. However from a remote machine I can only see the 2005 instance. Is there a configuration I have missed or is this not possible?
mssql8 AND mssql 2005
Collapse
X
-
Try to name it without slash. I doubt though it'll help. I once experienced a very funny problem with my replication whereby the distributor wouldn't connect to the subscriber. I had to enable Naming Pipes on the subscriber via the SQL config console to fix it. Just a thought.Originally posted by kitspidYes. I wonder if I should name it something else maybe it doesn;t like that name. Maybe OldSQL?Comment
-
Tried the name pipes didn;t help. Don;t think I can rename it as the machine is called server which is where that comes from shoulf just be server2003 to connect. Going to move this db to a different machine and not worry about it anymore. Chalk it up to a 2005 quirk I think.Comment
Comment