Article ID: 3835, created on Feb 8, 2008, last review on Apr 17, 2012

  • Applies to:
  • Helm 4


I have 2 SQL Server instances on the same machine. One is SQL 7 and the other is SQL 2000. I have setup separate services for each, but Helm is creating all new databases under the SQL 7 instance. Is there some way I can specify the instance?
Unfortunately there is no way for Helm to add databases on multiple instances of SQL. It will only create them on the "Default Instance" of SQL.
The only way around it would be to have SQL installed on two seperate machines (which would require an additional server license). On each machine you would then setup the respective SQL versions as "Default Instances".

0331e0e4efc12686c3f22fc2cdda9f03 152090ff5e9a05ea7e1cf0c248449638 6311ae17c1ee52b36e68aaf4ad066387

Email subscription for changes to this article
Save as PDF