HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
\Instance Names\SQL\ - create a SZ entry with name=[your sql instance
name], where value = MSSQL10.MSSQLSERVER
\MSSQL10.MSSQLSERVER\MSSQLSERVER - create 3 optional SZ entries:
DEFAULTDATA <- path to your sql data folder
DEFAULTLOG <- log folder
BACKUPDIRECTORY <- backup folder
As I mentioned in other forum - 64bits OS known to have difficulties with 32
bits win32 registry retrieval functions. lotta lucks to you.
Post by Ken FlorianHi Rusty WSM,
Any chance you could provide a few more specific directions on all the
registry alterations required to make this work?
- SBS 2008 64 and SQL 2008 on single box.
- SQL 2008 paths changed at install time to point to different hard drive
e:\*.*
- MOA 2009
Post by Rusty WSMHi GTSageDev,
Bravo! you are on the right work-around path (as opposed to my earlier post
in other forum.thread below). If you've customed setting/config paths, You
need to add appropriate registry under mssmlbiz branch.
Post by GTSageDevAs a matter of interest, does SQL Server 2008 have a registry entry in
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL?
If not, try adding one (eg. MSSMLBIZ RegSz MSSQL.1 or as appropriate). Does
that resolve the problem?
Post by BrentonUngerLooks like we've discovered a bug using OA2009 w/ Sql Server 2008.
http://social.microsoft.com/Forums/en/whatforum/thread/75616bc2-b153-4db5-b184-ba3ed599d262
Obviously downgrading Sql Server would not be in Microsoft's marketing
strategies. Does anyone have any more information on this problem?
.