Component Database on SQL2000 Non-Default Instance

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there. Does anybody know whether Component Database can be installed on
a SQL Server 2000 (a remote server) in another Database Instance, other than
the Default Instance ?

I have another ODBC entry that uses a non-default instance, so it shows up
as SERVERNAME\INSTANCENAME.

Anyone know ?
 
Jeff,

Do you mean you want to rename the XPe database (MantisSQLDB)?
I don't think you can easily do that as the name is hardcoded in the XPe Tools.
 
No, we're rolling from the Eval Studio into Licensed (bought from bSQUARE
actually) and I'm looking to create a new DB on a faster server - from dual
PII450s to Quad Xeon 700s - that hosts like 7 other DBs. The Default
instance of SQL is being used by a legacy application that requires the
Default DB.

JC
 
Jeff,

Sorry.. I was not thinking clear enough when I read your original post.

I don't know how you can change the instance. Since the SQL Server connection string is built in the XPe tools (hardcoded) you
cannot easy change the instance by adding it to the server name there.

You can try changing the "ServerName" value under [HKLM\SOFTWARE\Microsoft\Windows Embedded] key. Maybe this will do the trick if
you set it to something like "SERVERNAME\INSTANCENAME" (or SERVERNAME.INSTANCENAME).
 
I don't think I need to try and change it, because I'm OK to scrap my
component DB and start fresh when we get the Licensed. I only have two
Components so far, one is from a pmq file and the other only contains about
eight files so I can easily recreate it. I'm more asking whether Embedded
Studio either works on or supports non-Default Instance.

JC
 
Jeff,
I don't think I need to try and change it, because I'm OK to scrap my
component DB and start fresh when we get the Licensed. I only have two
Components so far, one is from a pmq file and the other only contains about
eight files so I can easily recreate it. I'm more asking whether Embedded
Studio either works on or supports non-Default Instance.
Click to expand...


It is mentioned here what's supported (just the server name, no instances mentioned):
http://msdn.microsoft.com/library/en-us/xpehelp/html/dbconChangingDatabaseServerLocation.asp

I gave you the reg.setting so that you could try making it working with non-default instance.
It is obviously not supported.
 
Back
Top