Change registry keys regarding to SQL and Moving databases

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Maggie (Maggie_at_discussions.microsoft.com)
Date: 12/10/04 

Date: Fri, 10 Dec 2004 11:57:03 -0800

Platform: Window2003 ent Failover Clustering SQL Server 2k ent sp3a.
I need change some registry keys regarding to SQL, such as:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
Do I need change on all the nodes one by one?

Previously, after non-clustered default installation, I always referenced
http://support.microsoft.com/default.aspx?scid=kb;EN-US;224071 and
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q240867 to Move SQL
Server databases to a new location.
However, I have new windows2003 SQL server 2k sp3a setup with external
shared storage. I need relocate databases and full text indexes. I'm not
sure which way I shall follow to moving database files or change registry
keys.

Relevant Pages

  • Re: 2005 Enterprise sp 2 install fails - 11009
    ... For the reason why I recommend that you try a domain admin account is to avoid any potential permission issues on some registry keys or some ... Once you finished installing SQL Server 2005 SP2, you may change it back to your normal user. ... Also I reviewed the hotfix log and found the following error message: ...
    (microsoft.public.sqlserver.setup)
  • Re: Change registry keys regarding to SQL and Moving databases
    ... How about Registry keys? ... that location must be a disk resource that the SQL Service resoure ... > Senior Database Administrator ... > I support the Professional Association for SQL Server ...
    (microsoft.public.sqlserver.clustering)
  • Re: error 14354 - sevice account priveleges
    ... Probably something went wrong with the install where some registry keys are ... Otherwise check the service account for SQL Server to make sure it ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Sever Agent
    ... the SQL Server service doesn't have permissions to the registry keys ... Server doesn't have permissions on the registry keys, ...
    (microsoft.public.sqlserver.tools)
  • Re: Best way to detemine default data directory from TSQL?
    ... After you install SQL Server 2000, when you open the SQL Server Properties ... the Database Settings tab, the path for Default data directory and Default ... screen, the relevant registry keys are created, and the CREATE DATABASE ...
    (microsoft.public.sqlserver.programming)