May 13, 2009 at 7:34 pm
Hi all,
I have Window 2003 Server with SQL Server 2005 Enterprise edition. I now need to install an SQL Server 2005 Standard Edition on the same machine as an Named Instance. Is this possible ..???
Requesting to let me know asap. Also pls let me know if replication can be done on the named instance servers..??
Rgrds
Balaji
May 13, 2009 at 7:41 pm
You don't want to go mixing editions on the same windows installation; indeed I would expect the SQL setup to fail if you tried to do this.
Simply run your SQL Enterprise setup again and install a new instance along side your existing one.
Yes, you can replicate between your instances.
--
Andrew Hatfield
May 13, 2009 at 7:53 pm
Ok.....but when i try to create a new publication on a named instance it says could not connect to the instance Server1\Instance1. Is there any setting that iam missing...???
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply