Registry to store configuration values ?

I try to store a SSIS-configuration value in the registry.

But it's failed. I get a warning, that the registry-key is not found.

What is the syntax ? I have searched in BO,MSDN and Google/Internet ==> nothing.

There is no example.

The syntax of how to specify the name of the registry key is straightforward. See BOL: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/uirfsql9/html/212e52e7-27a7-48bb-8bad-34aa290d2003.htm

If you're asking how to define the syntax of a configuration (i.e. The thing that should be IN the registry key) then that's a bit more difficult. A quick scan of BOl didn't bring anything up. The way I always do it is to create an XML COnfiguration file from within SSIS Designer and then copy and paste the resultant configuration into the registry key.

Hope that halps.

-Jamie

|||

Hey Jamie,

there is no example:

Configuration Type Option = Registry Entry
Specify configuration settings directly
Use to specify settings directly.

Value Description
Registry entry
Type the registry key that contains the configuration information.

I think it is very easy, but I don't know how to type the registry key!

With regedit I have defined a new entry:

HKEY_LOCAL_MACHINE\SOFTWARE\SSIS\Var

Var is a string and contains for example the servername.

What is the syntax in the SSIS-Configuration-Wizard?

You create an XML-Configuration file then you copy and paste the result into the registry key?

The registry key can store only one proberty. The XML-Configuration can store many proberties. You have an example?

Thanks

Loom

|||

It sounds to me as though you have done everything that you need to do. What error are you getting when you try and usee it?

-Jamie

|||

In the german version I get this warning:

Warnung: 0x80012015 bei Package: Der Konfigurationsregistrierungsschlüssel 'HKEY_LOCAL_MACHINE\SOFTWARE\SSIS\Var' wurde nicht gefunden. Für einen Konfigurationseintrag ist ein nicht verfügbarer Registrierungsschlüssel angegeben. überprüfen Sie die Registrierung, und stellen Sie sicher, dass der Schlüssel vorhanden ist.

Translation:

The Configuration-Registry-Key 'HKEY_LOCAL_MACHINE\SOFTWARE\SSIS\Var' was not found.

Loom

|||

The key must be defined in HKCU.

The Value must be stored in the Value key.

HKCU\Configuration\FirstConfig\Value

HKCU\Configuration\SecondConfig\Value

The ConfigString is Configuration\FirstConfig , this is the string you put into the Configuration String field in the Configuration Wizard.

The Registry Configuration assumes the HKCU and Value sections. Everything in between can be whatever you want.

HTH,

K

|||

Kirk,

Is this information in BOL anywhere? If it isn't, it should be.

-Jamie

|||Nah, don't think so. I couldn't find it anywhere...|||

Bingo!

I have tried everything, but not the value key....

To store the configuration in the registry has an advantage compared with an environment-variable. A change in the registry automaticly change your configuration.

A change of an environment-variable has no effect in the BI-Studio. The only way to refresh the variable is: Close the BI-Studio and then reopen it.

And this is a problem for a developer. Environment-variables are not the first choice for switching between Dev / Test / Pro - Servers.

Or I have missed something?

Loom

|||

You're right that you need to shut down BIDS for the EV Config to take effect, but, why does that matter? You can simply change the value of the configured property as though the configuration had been applied.

Again, it's a preference thing. That's why there are several options.

Environment Variables are the only option for Indirect Configurations.

K

|||

There is another option for Indirect Configuration: The SQL-Server option.

The SQL-Server use a normal connection-manager and you can configure the proberties of this connection-manager.

In the FirstConfig you can change the ServerName and the InitialCatalog of the connection-manager.

In the SecondConfig you use the SQL-Server-Option with the changed ServerName/InitialCatalog.

In my opinion it is an indirect configuration too.

Loom

|||

Yep, got that right. Very flexible, yes.

K

|||

Loom wrote:

Bingo!

I have tried everything, but not the value key....

To store the configuration in the registry has an advantage compared with an environment-variable. A change in the registry automaticly change your configuration.

A change of an environment-variable has no effect in the BI-Studio. The only way to refresh the variable is: Close the BI-Studio and then reopen it.

And this is a problem for a developer. Environment-variables are not the first choice for switching between Dev / Test / Pro - Servers.

Or I have missed something?

Loom

Its a matter of opinion isn't it? there isn't one right answer. Personally I think the issue about having to close BIDS isn't really a problem as long as you know about the issue.

I use indirect configurations exclusively. That's just my choice.

-Jamie

|||

I try to use this option to change the "conenction string" property of a Flat file connection, but nothing happens.

What is the correct format of registry Key string to fill the box?

I try :

HKEY_LOCAL_MACHINE\SOFTWARE\ProjectName\Connections\ConnectionString1

and

[HKEY_LOCAL_MACHINE\SOFTWARE\ProjectName\Connections\ConnectionString1]

and

"HKEY_LOCAL_MACHINE\SOFTWARE\ProjectName\Connections\ConnectionString1"

The value Key "ConnectionString1" is a String Value that contains the address of file like: C:\input files\Test.csv

Don't Work!!!! What′s wrong?

Thanks

|||

In the registry you have this entry:

HKEY_LOCAL_MACHINE\SOFTWARE\ProjectName\Connections\ConnectionString1\value

In Value you store your connection string

In the SSIS-Configuration the reference is:

SOFTWARE\ProjectName\Connections\ConnectionString1

Loom

Registry to store configuration values ?

I try to store a SSIS-configuration value in the registry.

But it's failed. I get a warning, that the registry-key is not found.

What is the syntax ? I have searched in BO,MSDN and Google/Internet ==> nothing.

There is no example.

The syntax of how to specify the name of the registry key is straightforward. See BOL: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/uirfsql9/html/212e52e7-27a7-48bb-8bad-34aa290d2003.htm

If you're asking how to define the syntax of a configuration (i.e. The thing that should be IN the registry key) then that's a bit more difficult. A quick scan of BOl didn't bring anything up. The way I always do it is to create an XML COnfiguration file from within SSIS Designer and then copy and paste the resultant configuration into the registry key.

Hope that halps.

-Jamie

|||

Hey Jamie,

there is no example:

Configuration Type Option = Registry Entry
Specify configuration settings directly
Use to specify settings directly.

Value Description
Registry entry
Type the registry key that contains the configuration information.

I think it is very easy, but I don't know how to type the registry key!

With regedit I have defined a new entry:

HKEY_LOCAL_MACHINE\SOFTWARE\SSIS\Var

Var is a string and contains for example the servername.

What is the syntax in the SSIS-Configuration-Wizard?

You create an XML-Configuration file then you copy and paste the result into the registry key?

The registry key can store only one proberty. The XML-Configuration can store many proberties. You have an example?

Thanks

Loom

|||

It sounds to me as though you have done everything that you need to do. What error are you getting when you try and usee it?

-Jamie

|||

In the german version I get this warning:

Warnung: 0x80012015 bei Package: Der Konfigurationsregistrierungsschlüssel 'HKEY_LOCAL_MACHINE\SOFTWARE\SSIS\Var' wurde nicht gefunden. Für einen Konfigurationseintrag ist ein nicht verfügbarer Registrierungsschlüssel angegeben. überprüfen Sie die Registrierung, und stellen Sie sicher, dass der Schlüssel vorhanden ist.

Translation:

The Configuration-Registry-Key 'HKEY_LOCAL_MACHINE\SOFTWARE\SSIS\Var' was not found.

Loom

|||

The key must be defined in HKCU.

The Value must be stored in the Value key.

HKCU\Configuration\FirstConfig\Value

HKCU\Configuration\SecondConfig\Value

The ConfigString is Configuration\FirstConfig , this is the string you put into the Configuration String field in the Configuration Wizard.

The Registry Configuration assumes the HKCU and Value sections. Everything in between can be whatever you want.

HTH,

K

|||

Kirk,

Is this information in BOL anywhere? If it isn't, it should be.

-Jamie

|||Nah, don't think so. I couldn't find it anywhere...|||

Bingo!

I have tried everything, but not the value key....

To store the configuration in the registry has an advantage compared with an environment-variable. A change in the registry automaticly change your configuration.

A change of an environment-variable has no effect in the BI-Studio. The only way to refresh the variable is: Close the BI-Studio and then reopen it.

And this is a problem for a developer. Environment-variables are not the first choice for switching between Dev / Test / Pro - Servers.

Or I have missed something?

Loom

|||

You're right that you need to shut down BIDS for the EV Config to take effect, but, why does that matter? You can simply change the value of the configured property as though the configuration had been applied.

Again, it's a preference thing. That's why there are several options.

Environment Variables are the only option for Indirect Configurations.

K

|||

There is another option for Indirect Configuration: The SQL-Server option.

The SQL-Server use a normal connection-manager and you can configure the proberties of this connection-manager.

In the FirstConfig you can change the ServerName and the InitialCatalog of the connection-manager.

In the SecondConfig you use the SQL-Server-Option with the changed ServerName/InitialCatalog.

In my opinion it is an indirect configuration too.

Loom

|||

Yep, got that right. Very flexible, yes.

K

|||

Loom wrote:

Bingo!

I have tried everything, but not the value key....

To store the configuration in the registry has an advantage compared with an environment-variable. A change in the registry automaticly change your configuration.

A change of an environment-variable has no effect in the BI-Studio. The only way to refresh the variable is: Close the BI-Studio and then reopen it.

And this is a problem for a developer. Environment-variables are not the first choice for switching between Dev / Test / Pro - Servers.

Or I have missed something?

Loom

Its a matter of opinion isn't it? there isn't one right answer. Personally I think the issue about having to close BIDS isn't really a problem as long as you know about the issue.

I use indirect configurations exclusively. That's just my choice.

-Jamie

|||

I try to use this option to change the "conenction string" property of a Flat file connection, but nothing happens.

What is the correct format of registry Key string to fill the box?

I try :

HKEY_LOCAL_MACHINE\SOFTWARE\ProjectName\Connections\ConnectionString1

and

[HKEY_LOCAL_MACHINE\SOFTWARE\ProjectName\Connections\ConnectionString1]

and

"HKEY_LOCAL_MACHINE\SOFTWARE\ProjectName\Connections\ConnectionString1"

The value Key "ConnectionString1" is a String Value that contains the address of file like: C:\input files\Test.csv

Don't Work!!!! What′s wrong?

Thanks

|||

In the registry you have this entry:

HKEY_LOCAL_MACHINE\SOFTWARE\ProjectName\Connections\ConnectionString1\value

In Value you store your connection string

In the SSIS-Configuration the reference is:

SOFTWARE\ProjectName\Connections\ConnectionString1

Loom

Registry to store configuration values ?

I try to store a SSIS-configuration value in the registry.

But it's failed. I get a warning, that the registry-key is not found.

What is the syntax ? I have searched in BO,MSDN and Google/Internet ==> nothing.

There is no example.

The syntax of how to specify the name of the registry key is straightforward. See BOL: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/uirfsql9/html/212e52e7-27a7-48bb-8bad-34aa290d2003.htm

If you're asking how to define the syntax of a configuration (i.e. The thing that should be IN the registry key) then that's a bit more difficult. A quick scan of BOl didn't bring anything up. The way I always do it is to create an XML COnfiguration file from within SSIS Designer and then copy and paste the resultant configuration into the registry key.

Hope that halps.

-Jamie

|||

Hey Jamie,

there is no example:

Configuration Type Option = Registry Entry
Specify configuration settings directly
Use to specify settings directly.

Value Description
Registry entry
Type the registry key that contains the configuration information.

I think it is very easy, but I don't know how to type the registry key!

With regedit I have defined a new entry:

HKEY_LOCAL_MACHINE\SOFTWARE\SSIS\Var

Var is a string and contains for example the servername.

What is the syntax in the SSIS-Configuration-Wizard?

You create an XML-Configuration file then you copy and paste the result into the registry key?

The registry key can store only one proberty. The XML-Configuration can store many proberties. You have an example?

Thanks

Loom

|||

It sounds to me as though you have done everything that you need to do. What error are you getting when you try and usee it?

-Jamie

|||

In the german version I get this warning:

Warnung: 0x80012015 bei Package: Der Konfigurationsregistrierungsschlüssel 'HKEY_LOCAL_MACHINE\SOFTWARE\SSIS\Var' wurde nicht gefunden. Für einen Konfigurationseintrag ist ein nicht verfügbarer Registrierungsschlüssel angegeben. überprüfen Sie die Registrierung, und stellen Sie sicher, dass der Schlüssel vorhanden ist.

Translation:

The Configuration-Registry-Key 'HKEY_LOCAL_MACHINE\SOFTWARE\SSIS\Var' was not found.

Loom

|||

The key must be defined in HKCU.

The Value must be stored in the Value key.

HKCU\Configuration\FirstConfig\Value

HKCU\Configuration\SecondConfig\Value

The ConfigString is Configuration\FirstConfig , this is the string you put into the Configuration String field in the Configuration Wizard.

The Registry Configuration assumes the HKCU and Value sections. Everything in between can be whatever you want.

HTH,

K

|||

Kirk,

Is this information in BOL anywhere? If it isn't, it should be.

-Jamie

|||Nah, don't think so. I couldn't find it anywhere...|||

Bingo!

I have tried everything, but not the value key....

To store the configuration in the registry has an advantage compared with an environment-variable. A change in the registry automaticly change your configuration.

A change of an environment-variable has no effect in the BI-Studio. The only way to refresh the variable is: Close the BI-Studio and then reopen it.

And this is a problem for a developer. Environment-variables are not the first choice for switching between Dev / Test / Pro - Servers.

Or I have missed something?

Loom

|||

You're right that you need to shut down BIDS for the EV Config to take effect, but, why does that matter? You can simply change the value of the configured property as though the configuration had been applied.

Again, it's a preference thing. That's why there are several options.

Environment Variables are the only option for Indirect Configurations.

K

|||

There is another option for Indirect Configuration: The SQL-Server option.

The SQL-Server use a normal connection-manager and you can configure the proberties of this connection-manager.

In the FirstConfig you can change the ServerName and the InitialCatalog of the connection-manager.

In the SecondConfig you use the SQL-Server-Option with the changed ServerName/InitialCatalog.

In my opinion it is an indirect configuration too.

Loom

|||

Yep, got that right. Very flexible, yes.

K

|||

Loom wrote:

Bingo!

I have tried everything, but not the value key....

To store the configuration in the registry has an advantage compared with an environment-variable. A change in the registry automaticly change your configuration.

A change of an environment-variable has no effect in the BI-Studio. The only way to refresh the variable is: Close the BI-Studio and then reopen it.

And this is a problem for a developer. Environment-variables are not the first choice for switching between Dev / Test / Pro - Servers.

Or I have missed something?

Loom

Its a matter of opinion isn't it? there isn't one right answer. Personally I think the issue about having to close BIDS isn't really a problem as long as you know about the issue.

I use indirect configurations exclusively. That's just my choice.

-Jamie

|||

I try to use this option to change the "conenction string" property of a Flat file connection, but nothing happens.

What is the correct format of registry Key string to fill the box?

I try :

HKEY_LOCAL_MACHINE\SOFTWARE\ProjectName\Connections\ConnectionString1

and

[HKEY_LOCAL_MACHINE\SOFTWARE\ProjectName\Connections\ConnectionString1]

and

"HKEY_LOCAL_MACHINE\SOFTWARE\ProjectName\Connections\ConnectionString1"

The value Key "ConnectionString1" is a String Value that contains the address of file like: C:\input files\Test.csv

Don't Work!!!! What′s wrong?

Thanks

|||

In the registry you have this entry:

HKEY_LOCAL_MACHINE\SOFTWARE\ProjectName\Connections\ConnectionString1\value

In Value you store your connection string

In the SSIS-Configuration the reference is:

SOFTWARE\ProjectName\Connections\ConnectionString1

Loom

Registry Size

I am getting the error "Windows cannot load the profile.
Please increase the registry size and restart the
computer". Can I delete the unused profiles
from "HKEY_LOCAL_MACHINE\Software\Microsoft\Windows
NT\CurrentVersion\ProfileList" to make more space
available in the registry and maybe offset this error?Just curious, what does this have to do with SQL Server?
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Ron Snow" <anonymous@.discussions.microsoft.com> wrote in message
news:23f6601c45ee4$c42e0040$a401280a@.phx.gbl...
> I am getting the error "Windows cannot load the profile.
> Please increase the registry size and restart the
> computer". Can I delete the unused profiles
> from "HKEY_LOCAL_MACHINE\Software\Microsoft\Windows
> NT\CurrentVersion\ProfileList" to make more space
> available in the registry and maybe offset this error?

Registry Size

I am getting the error "Windows cannot load the profile.
Please increase the registry size and restart the
computer". Can I delete the unused profiles
from "HKEY_LOCAL_MACHINE\Software\Microsoft\Windows
NT\CurrentVersion\ProfileList" to make more space
available in the registry and maybe offset this error?
Just curious, what does this have to do with SQL Server?
http://www.aspfaq.com/
(Reverse address to reply.)
"Ron Snow" <anonymous@.discussions.microsoft.com> wrote in message
news:23f6601c45ee4$c42e0040$a401280a@.phx.gbl...
> I am getting the error "Windows cannot load the profile.
> Please increase the registry size and restart the
> computer". Can I delete the unused profiles
> from "HKEY_LOCAL_MACHINE\Software\Microsoft\Windows
> NT\CurrentVersion\ProfileList" to make more space
> available in the registry and maybe offset this error?

Registry Size

I am getting the error "Windows cannot load the profile.
Please increase the registry size and restart the
computer". Can I delete the unused profiles
from " HKEY_LOCAL_MACHINE\Software\Microsoft\Wi
ndows
NT\CurrentVersion\ProfileList" to make more space
available in the registry and maybe offset this error?Just curious, what does this have to do with SQL Server?
http://www.aspfaq.com/
(Reverse address to reply.)
"Ron Snow" <anonymous@.discussions.microsoft.com> wrote in message
news:23f6601c45ee4$c42e0040$a401280a@.phx
.gbl...
> I am getting the error "Windows cannot load the profile.
> Please increase the registry size and restart the
> computer". Can I delete the unused profiles
> from " HKEY_LOCAL_MACHINE\Software\Microsoft\Wi
ndows
> NT\CurrentVersion\ProfileList" to make more space
> available in the registry and maybe offset this error?

Registry settings for service account permissions

We are trying to configure registry settings to allow sql server service to run on a service account in SQL Server 2005. The registry has changed quite a bit from SQL 2000, and we are missing a setting in the software keys that causes sql server service not to start. If we apply permissions to all of HKEY_LOCAL_MACHINE/SOFTWARE, then the service starts, however company security policies do not allow this. Are there any specific keys we should look at, other than the obvious Microsoft/Microsoft SQL Server and Microsoft/MSSQL keys, in which we have already granted permissions to the service account?

Thanks,

Dave

Manually changing the service account is not a supported operation. Changing the service account should only be done via the SQL Server Configuration Manager tool. For further questions about this tool, you can use the SQL Server Tools General forum.

Thanks
Laurentiu

registry replication consistency in MSCS

Hi,
I'm using MSCS registry checkpointing to make sure my application data
written in registry will be available to other nodes when they become online.
I was wondering if the checkpoint operation is synchronous to the registry
write or is it possible that the registry write would be acknowledged but the
checkpoint would be delayed?
If the second option is possible than how can I guarentee that if a power
failure occurs right after the registry write was acknowledged that the
checkpoint was indeed written to quorum and would be available for the second
node when it becomes online?
Hi
Well, if your SAN and servers are not on UPS, and you have a power failure,
the OS might be in the middle of a write, resulting in a partial write. This
may lead to corruption in the registry or quorum drive.
If you have a cluster for high availability, you should have a reliable
power system, or at least a way to shut it down in an orderly fashion once
the UPS goes onto low power.
Unless you have an orderly server shutdown, don't expect anything to be 100%
once it comes up.
Why are you using the registry to persist data? Databases or XML files do
the job better.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"smadar" <smadar@.discussions.microsoft.com> wrote in message
news:4BB152CC-4455-4CDF-91D2-B39EEF2D1D6D@.microsoft.com...
> Hi,
> I'm using MSCS registry checkpointing to make sure my application data
> written in registry will be available to other nodes when they become
> online.
> I was wondering if the checkpoint operation is synchronous to the registry
> write or is it possible that the registry write would be acknowledged but
> the
> checkpoint would be delayed?
> If the second option is possible than how can I guarentee that if a power
> failure occurs right after the registry write was acknowledged that the
> checkpoint was indeed written to quorum and would be available for the
> second
> node when it becomes online?
|||Hi,
Let me clarify my question:
My worries are not on the shutdown scenario, but on the behavior of the
checkpoint mechanism.
I'm using the win32 reg function: ZwSetValueKey (from my driver) to set a
key registered with a cluster resource.
If this call returns success can I assume that the data was already written
to a checkpoint on the quorum device? Is it synchronous to the registry write
or the quorum may be updated in a later time?
Thanks.
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> Well, if your SAN and servers are not on UPS, and you have a power failure,
> the OS might be in the middle of a write, resulting in a partial write. This
> may lead to corruption in the registry or quorum drive.
> If you have a cluster for high availability, you should have a reliable
> power system, or at least a way to shut it down in an orderly fashion once
> the UPS goes onto low power.
> Unless you have an orderly server shutdown, don't expect anything to be 100%
> once it comes up.
> Why are you using the registry to persist data? Databases or XML files do
> the job better.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "smadar" <smadar@.discussions.microsoft.com> wrote in message
> news:4BB152CC-4455-4CDF-91D2-B39EEF2D1D6D@.microsoft.com...
>
>

Registry read in Reporting Services

Hello. I am trying to get the machine name in a Reporting Services 2000
report. I thought I would put this in the registry and read it from a
function in the custom code. Here is my first attempt:
Public Function GetMachineName
On Error Resume Next
Dim WshShell
Set WshShell = WScript.CreateObject("WScript.Shell")
Return WshShell.RegRead("HKLM\Software\Something\MachineName")
End Function
This gives a build error: Let and set are no longer supported. OK, so I take
out the set on line 3. Then it says "WScript" is not declared. I'm pretty
sure this is valid code. I got it from Windows Script Host 2.0 Documentation.
Does Reporting Services support using the WScript functionality? Thanks in
advance.I tried to do the same thing with SRS 2005 and VS 2005 but I get the error
message listed below.
'Read reg key value
my.computer.registry.GetValue(myPath, "RegKeyName", Nothing)
Error: Unhandled exception: Request for permission of type
'System.Security.Permissions.RegistryPermission
To get around this, you can do one of two things:
1. Use "Reg Query" command to read the registry and set a variable to the
the computer name
2. Use an HTA front end which will use VBScript to read the machine name and
then use the /v to pass the machine name variable from either step above.
I have an HTA front end for this very same issue so send me an email if you
want a copy.
Hope this helps!
Rafael
"Justin30519" <Justin30519@.discussions.microsoft.com> wrote in message
news:81784CFA-B08F-4CCE-85F3-C855EE8CFC7D@.microsoft.com...
> Hello. I am trying to get the machine name in a Reporting Services 2000
> report. I thought I would put this in the registry and read it from a
> function in the custom code. Here is my first attempt:
> Public Function GetMachineName
> On Error Resume Next
> Dim WshShell
> Set WshShell = WScript.CreateObject("WScript.Shell")
> Return WshShell.RegRead("HKLM\Software\Something\MachineName")
> End Function
> This gives a build error: Let and set are no longer supported. OK, so I
> take
> out the set on line 3. Then it says "WScript" is not declared. I'm pretty
> sure this is valid code. I got it from Windows Script Host 2.0
> Documentation.
> Does Reporting Services support using the WScript functionality? Thanks in
> advance.

Registry Permissions for on demand pull subscription

To configure an on-demand pull subscription, the domain user account used by
the SQL Server Agent service must have full control permissions on the
registry key: HKLM\Software\Microsoft\Microsoft SQL
Server\80\Replication\Subscriptions. When I attempt to use the registry
editor to configure the permissions, the subscriptions portion of the key is
not present. I am running Win 2000 Server and SQL Server 2000. I am logged on
as an administrator, and I have sucessfully created a merge publication and a
push subcription. Any thoughts on what may be my problem? What SQL process
creates the subscriptions entry in the registery?
Tom McAvoy, MCP
The subscriptions portion of the key can be filled in by using reg files,
but the preferred way of doing it is having Windows Synchronization Manager,
or the ActiveX Controls make these changes.
When you create your push (only through the procs), or you pull (procs or
wizards), ensure you select on demand pull. This will register your
subscription and make the necessary registry entries.
If you did not do this, you will have to configure your pull subcription
withing WSM.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Tom McAvoy" <TomMcAvoy@.discussions.microsoft.com> wrote in message
news:7E02406B-F211-49F4-B1FD-41C2B6127F4A@.microsoft.com...
> To configure an on-demand pull subscription, the domain user account used
by
> the SQL Server Agent service must have full control permissions on the
> registry key: HKLM\Software\Microsoft\Microsoft SQL
> Server\80\Replication\Subscriptions. When I attempt to use the registry
> editor to configure the permissions, the subscriptions portion of the key
is
> not present. I am running Win 2000 Server and SQL Server 2000. I am logged
on
> as an administrator, and I have sucessfully created a merge publication
and a
> push subcription. Any thoughts on what may be my problem? What SQL process
> creates the subscriptions entry in the registery?
> --
> Tom McAvoy, MCP
|||Hillary, thank you for the response. I am unable to create the 'on-demand
pull' subscription due to the lack of permissions on the registry key. I
receive an 'access denied error'. I don't have the exact error info
avaialble right now. I'll review the problem on Monday and post more complete
error info.
"Hilary Cotter" wrote:

> The subscriptions portion of the key can be filled in by using reg files,
> but the preferred way of doing it is having Windows Synchronization Manager,
> or the ActiveX Controls make these changes.
> When you create your push (only through the procs), or you pull (procs or
> wizards), ensure you select on demand pull. This will register your
> subscription and make the necessary registry entries.
> If you did not do this, you will have to configure your pull subcription
> withing WSM.
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "Tom McAvoy" <TomMcAvoy@.discussions.microsoft.com> wrote in message
> news:7E02406B-F211-49F4-B1FD-41C2B6127F4A@.microsoft.com...
> by
> is
> on
> and a
>
>
|||It seems that you need to be a power user or admin on the machine you are
trying to pull the subscription to.
Also the account which is doing the pulling should be in the PAL.
"Tom McAvoy" <TomMcAvoy@.discussions.microsoft.com> wrote in message
news:8518A10B-BFB3-4C4D-A6E4-8A605F129C22@.microsoft.com...
> Hillary, thank you for the response. I am unable to create the 'on-demand
> pull' subscription due to the lack of permissions on the registry key. I
> receive an 'access denied error'. I don't have the exact error info
> avaialble right now. I'll review the problem on Monday and post more
complete[vbcol=seagreen]
> error info.
> "Hilary Cotter" wrote:
files,[vbcol=seagreen]
Manager,[vbcol=seagreen]
or[vbcol=seagreen]
used[vbcol=seagreen]
registry[vbcol=seagreen]
key[vbcol=seagreen]
logged[vbcol=seagreen]
publication[vbcol=seagreen]
process[vbcol=seagreen]

Registry name

trying to manually uninstall sql 2005. Everything is gone but FullText
Search in the services. Does anyone know what is the registry name for that
service. Am unable to find anything
thx
stoney
http://support.microsoft.com/kb/909967
If this does not work, I would urge you to open a support incident with PSS.
If you must do it manually in a totally unsupported way, remove these
registry keys.
Note that rather than removing these registry keys put an x infront of the
guid
HKEY_CLASSES_ROOT\AppID\{68C6D318-77E0-11D5-8528-00C04F68155C}
HKEY_CLASSES_ROOT\CLSID\{68C6D37C-77E0-11D5-8528-00C04F68155C}
HKEY_CLASSES_ROOT\CLSID\{68C6D37D-77E0-11D5-8528-00C04F68155C}
HKEY_LOCAL_MACHINE\SOFTWARE\Classes\AppID\{68C6D31 8-77E0-11D5-8528-00C04F68155C}
HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{68C6D37 C-77E0-11D5-8528-00C04F68155C}
HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{68C6D37 D-77E0-11D5-8528-00C04F68155C}
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Services\Full
Text
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\Eventlog\Application\msftesql
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.X\MSSearch
Where X is your instance number,
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSFTESQLInst Map\X
Where X is your instance number,
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\msftesql
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\msftesqlIDX
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"stoney" <stoney@.discussions.microsoft.com> wrote in message
news:B37D935D-9832-406D-BF7C-20417FA61A4B@.microsoft.com...
> trying to manually uninstall sql 2005. Everything is gone but FullText
> Search in the services. Does anyone know what is the registry name for
> that
> service. Am unable to find anything
> thx
> stoney

Registry name

trying to manually uninstall sql 2005. Everything is gone but FullText
Search in the services. Does anyone know what is the registry name for that
service. Am unable to find anything
thx
stoneyhttp://support.microsoft.com/kb/909967
If this does not work, I would urge you to open a support incident with PSS.
If you must do it manually in a totally unsupported way, remove these
registry keys.
Note that rather than removing these registry keys put an x infront of the
guid
HKEY_CLASSES_ROOT\AppID\{68C6D318-77E0-11D5-8528-00C04F68155C}
HKEY_CLASSES_ROOT\CLSID\{68C6D37C-77E0-11D5-8528-00C04F68155C}
HKEY_CLASSES_ROOT\CLSID\{68C6D37D-77E0-11D5-8528-00C04F68155C}
HKEY_LOCAL_MACHINE\SOFTWARE\Classes\AppI
D\{68C6D318-77E0-11D5-8528-00C0
4F68155C}
HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSI
D\{68C6D37C-77E0-11D5-8528-00C0
4F68155C}
HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSI
D\{68C6D37D-77E0-11D5-8528-00C0
4F68155C}
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Mi
crosoft SQL Server\Services\Full
Text
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControl
Set\Services\Eventlog\Application\ms
ftesql
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Mi
crosoft SQL Server\MSSQL.X\MSSearch
Where X is your instance number,
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
FTESQLInstMap\X
Where X is your instance number,
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControl
Set\Services\msftesql
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControl
Set\Services\msftesqlIDX
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"stoney" <stoney@.discussions.microsoft.com> wrote in message
news:B37D935D-9832-406D-BF7C-20417FA61A4B@.microsoft.com...
> trying to manually uninstall sql 2005. Everything is gone but FullText
> Search in the services. Does anyone know what is the registry name for
> that
> service. Am unable to find anything
> thx
> stoney

Registry name

trying to manually uninstall sql 2005. Everything is gone but FullText
Search in the services. Does anyone know what is the registry name for that
service. Am unable to find anything
thx
stoney:)http://support.microsoft.com/kb/909967
If this does not work, I would urge you to open a support incident with PSS.
If you must do it manually in a totally unsupported way, remove these
registry keys.
Note that rather than removing these registry keys put an x infront of the
guid
HKEY_CLASSES_ROOT\AppID\{68C6D318-77E0-11D5-8528-00C04F68155C}
HKEY_CLASSES_ROOT\CLSID\{68C6D37C-77E0-11D5-8528-00C04F68155C}
HKEY_CLASSES_ROOT\CLSID\{68C6D37D-77E0-11D5-8528-00C04F68155C}
HKEY_LOCAL_MACHINE\SOFTWARE\Classes\AppID\{68C6D318-77E0-11D5-8528-00C04F68155C}
HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{68C6D37C-77E0-11D5-8528-00C04F68155C}
HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID\{68C6D37D-77E0-11D5-8528-00C04F68155C}
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Services\Full
Text
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application\msftesql
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.X\MSSearch
Where X is your instance number,
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSFTESQLInstMap\X
Where X is your instance number,
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\msftesql
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\msftesqlIDX
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"stoney" <stoney@.discussions.microsoft.com> wrote in message
news:B37D935D-9832-406D-BF7C-20417FA61A4B@.microsoft.com...
> trying to manually uninstall sql 2005. Everything is gone but FullText
> Search in the services. Does anyone know what is the registry name for
> that
> service. Am unable to find anything
> thx
> stoney:)

Registry Keys

hi,
does anyone know the registry location of
1. sqlservr.exe
2. which controls switching between 6.5 and 7.0 or 2000.
thanx.
sajal.Hi,
1. sqlservr.exe
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServer]
Key is "ImagePath" - Value will be the path and the SQLSERVR.exe
2. I am not sure about that key...Search the registry for "vswitch.exe"
Thanks
Hari
MCDBA
"Sajal Kumar" <skumar3@.metlife.com> wrote in message
news:1af8201c41eb6$15a4f5b0$a101280a@.phx.gbl...
> hi,
> does anyone know the registry location of
> 1. sqlservr.exe
> 2. which controls switching between 6.5 and 7.0 or 2000.
> thanx.
> sajal.

Registry Keys

hi,
does anyone know the registry location of
1. sqlservr.exe
2. which controls switching between 6.5 and 7.0 or 2000.
thanx.
sajal.
Hi,
1. sqlservr.exe
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servi ces\MSSQLServer]
Key is "ImagePath" - Value will be the path and the SQLSERVR.exe
2. I am not sure about that key...Search the registry for "vswitch.exe"
Thanks
Hari
MCDBA
"Sajal Kumar" <skumar3@.metlife.com> wrote in message
news:1af8201c41eb6$15a4f5b0$a101280a@.phx.gbl...
> hi,
> does anyone know the registry location of
> 1. sqlservr.exe
> 2. which controls switching between 6.5 and 7.0 or 2000.
> thanx.
> sajal.
|||hi hari,
i also found it here as well
hkey... > software > microsoft > windows > currentversion > app paths >
sqlservr.exe
looks like it is listed under as an app also.
could not find vswitch.exe when i searched the registry.
thanx v much.
sajal.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

Registry Keys

hi,
does anyone know the registry location of
1. sqlservr.exe
2. which controls switching between 6.5 and 7.0 or 2000.
thanx.
sajal.Hi,
1. sqlservr.exe
& #91;HKEY_LOCAL_MACHINE\SYSTEM\CurrentCon
trolSet\Services\MSSQLServer]
Key is "ImagePath" - Value will be the path and the SQLSERVR.exe
2. I am not sure about that key...Search the registry for "vswitch.exe"
Thanks
Hari
MCDBA
"Sajal Kumar" <skumar3@.metlife.com> wrote in message
news:1af8201c41eb6$15a4f5b0$a101280a@.phx
.gbl...
> hi,
> does anyone know the registry location of
> 1. sqlservr.exe
> 2. which controls switching between 6.5 and 7.0 or 2000.
> thanx.
> sajal.|||hi hari,
i also found it here as well
hkey... > software > microsoft > windows > currentversion > app paths >
sqlservr.exe
looks like it is listed under as an app also.
could not find vswitch.exe when i searched the registry.
thanx v much.
sajal.
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!

Registry key setting for MS SQL Server

I am installing my application thru Installshield Professional 5. How
to know whether MS SQL Server is installed or not on the machine on
which i am installing my application. What is the registry key thru
which we can find this."harish" <harishksh@.yahoo.com> wrote in message
news:ff46df6e.0401090401.732c0ecb@.posting.google.c om...
> I am installing my application thru Installshield Professional 5. How
> to know whether MS SQL Server is installed or not on the machine on
> which i am installing my application. What is the registry key thru
> which we can find this.

Have a look at points 12 and 13 in this KB article:

http://support.microsoft.com/defaul...6&Product=sql2k

Simon

Registry Key for SQL Server 2005 Surface Area Configuration...

Whitch registry key should be set to allow Local and remote connections in SQL Server 2005 Surface Area configuration?May I know why you need this explicit value to update, as it is not good in terms of updating registry key on fly.

registry key for sql server 2000

I would like to know what is the registry key where is written that SQL Server 2000 is installed and the registry key where is the path to the data folder (master database) on Windows Server 2003. thanks
IrinaI would not answer registry key part of your question but the Master database can be accessed in Enterprise Manager and the data files are in Data Folder in Microsoft SQL Server folder in the programs folder in Win2003. Hope this helps.

Registry information

All,
If I wanted to establish the versions of a SQL Server installs
programatically throughout my domain, what in your opinion would be the best
method WITHOUT connecting to SQL. I can connect to each machine without
issue, but I need to now gather the information on SQL.
I've been looking at registry keys, but am not confident this can provide
the information I need. Can anybody please advise?
Many Thanks
Adam
--
Adam J WarneYou can get the version info from registry. But it's messy, probably not
supported, and changes from version to version. If all possible, I'd try to
get the version info from within the SQL instance usign the SERVERPROPERTY
function. (I'd reason that if you can access registry directly, you probably
should be able to get a login to access the SQL instances for their verison
info. But then having the login for the SQL instances is a different
practical story.)
Having said that, if you really want to get the version info from registry
for SQL2000, you may find it here (No guarantee and you need to verify it
yourself):
1. Get the installed instances from HKLM\Software\Microsoft\Microsoft SQL
Server\InstalledInstances
2. Loop through the registry entries for the installed named instances to
get their versions
HKLM\Software\Microsoft\Microsoft SQL
Server\<InstanceName>\MSSQLServer\CurrentVersion\CSDVersion
For SQL2005, look in:
HKLM\Software\Microsoft\Microsoft SQL
Server\MSSQL.<#>\MSSQLServer\CurrentVersion\CurrentVersion
Again, it's better not to directly lookup registry for the SQL verison info.
Linchi
"Adam Warne" wrote:
> All,
> If I wanted to establish the versions of a SQL Server installs
> programatically throughout my domain, what in your opinion would be the best
> method WITHOUT connecting to SQL. I can connect to each machine without
> issue, but I need to now gather the information on SQL.
> I've been looking at registry keys, but am not confident this can provide
> the information I need. Can anybody please advise?
> Many Thanks
> Adam
> --
> Adam J Warne