Problems deploying SSRS2005 security extension example

Dear All,
I've been trying to deploy the security extension example from
Microsoft for SSRS2005 and have encountered the following errors when
I access the reports virtual directory (although the pages/
UILogin.aspx page comes up)
- Report Server Web App reports that the report server is not
responding.
- Report Server reports that it cannot access (access denied)
accessing the dll file.
Can anyone help me with this?
Config File Segments:
________________________________________________________________________
rsmreportserver.config (file exists when I do a dir command on the
path in the type attribute)
<Security>
<Extension Name="Forms"
Type="Microsoft.Samples.ReportingServices.CustomSecurity.Authorization,
Microsoft.Samples.ReportingServices.CustomSecurity" >
<Configuration>
<AdminConfiguration>
<UserName>prime</UserName>
</AdminConfiguration>
</Configuration>
</Extension>
</Security>
<Authentication>
<Extension Name="Forms"
Type="Microsoft.Samples.ReportingServices.CustomSecurity.AuthenticationExtension,
Microsoft.Samples.ReportingServices.CustomSecurity" />
</Authentication>
_____________________________________________________________________
rssrvpolicy.config
<CodeGroup
class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust">
<IMembershipCondition
class="UrlMembershipCondition"
version="1"
Url="$CodeGen$/*"
/>
</CodeGroup>
<CodeGroup
class="UnionCodeGroup"
version="1"
Name="SecurityExtensionCodeGroup"
Description="Code group for the sample security extension"
PermissionSetName="FullTrust">
<IMembershipCondition
class="UrlMembershipCondition"
version="1"
Url="C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\ReportServer\bin
\Microsoft.Samples.ReportingServices.CustomSecurity.dll"
/>
</CodeGroup>
_____________________________________________________________________
rsswebapplication.config (note xxx=actual hostname)
<UI>
<CustomAuthenticationUI>
<loginUrl>/Pages/UILogon.aspx</loginUrl>
<UseSSL>False</UseSSL>
</CustomAuthenticationUI>
<ReportServerUrl>http://xxx/reportserver</ReportServerUrl>
</UI>
_____________________________________________________________________
_____________________________________________________________________
ReportServer WebApp Log
w3wp!library!1!12/3/2007-18:28:01:: i INFO: Initializing WatsonFlags
to default value of '1064' because it was not specified in
Configuration file.
w3wp!library!1!12/3/2007-18:28:01:: i INFO: Initializing
WatsonDumpOnExceptions to default value of
'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException'
because it was not specified in Configuration file.
w3wp!library!1!12/3/2007-18:28:01:: i INFO: Initializing
WatsonDumpExcludeIfContainsExceptions to default value of
'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException'
because it was not specified in Configuration file.
w3wp!library!1!12/3/2007-18:28:01:: i INFO: Initializing
SecureConnectionLevel to default value of '1' because it was not
specified in Configuration file.
w3wp!library!1!12/3/2007-18:28:01:: i INFO: Initializing
DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!1!12/3/2007-18:28:01:: i INFO: Initializing
WebServiceUseFileShareStorage to default value of 'False' because it
was not specified in Configuration file.
w3wp!ui!1!12/3/2007-18:28:05:: e ERROR: The report server is not
responding. Verify that the report server is running and can be
accessed from this computer.
w3wp!ui!1!12/3/2007-18:28:06:: e ERROR: HTTP status code --> 500
--Details--
Microsoft.ReportingServices.UI.Global+RSWebServiceWrapper
+CantCommunicateWithReportServerException: The report server is not
responding. Verify that the report server is running and can be
accessed from this computer.
at
Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String
methodname)
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
at
Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
level)
at
Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
sender, EventArgs args)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnInit(EventArgs e)
at System.Web.UI.Page.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!1!12/3/2007-18:28:07:: e ERROR: Exception in ShowErrorPage:
System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean
preserveForm)
at
Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean
preserveForm)
at
Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg)
_________________________________________________________________________
ReportServer Log
w3wp!runningjobs!7!12/3/2007-18:28:04:: i INFO: Database Cleanup (Web
Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
w3wp!runningjobs!7!12/3/2007-18:28:04:: i INFO: Running Requests
Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!7!12/3/2007-18:28:04:: i INFO: Running Requests DB
timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!7!12/3/2007-18:28:04:: i INFO: Memory stats update
timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!extensionfactory!7!12/03/2007-18:28:04:: e ERROR: Exception
caught instantiating Forms report server extension:
System.IO.FileLoadException: Could not load file or assembly
'Microsoft.Samples.ReportingServices.CustomSecurity' or one of its
dependencies. Access is denied.
File name: 'Microsoft.Samples.ReportingServices.CustomSecurity'
at System.Reflection.Assembly.nLoad(AssemblyName fileName, String
codeBase, Evidence assemblySecurity, Assembly locationHint,
StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean
forIntrospection)
at System.Reflection.Assembly.InternalLoad(AssemblyName
assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark,
Boolean forIntrospection)
at System.Reflection.Assembly.InternalLoad(String assemblyString,
Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean
forIntrospection)
at System.Reflection.Assembly.Load(String assemblyString)
at
Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.LoadAssembly(String
name)
at
Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.CreateExtensionObject(Extension
extConfig)
WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM
\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind
failure logging.
To turn this feature off, remove the registry value [HKLM\Software
\Microsoft\Fusion!EnableLog].
.
w3wp!library!7!12/03/2007-18:28:04:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The report server has encountered a configuration error. See the
report server log files for more information., Could not load
Authentication extension;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The report server has encountered a configuration error. See the
report server log files for more information.
w3wp!library!7!12/03/2007-18:28:06:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The report server has encountered a configuration error. See the
report server log files for more information., Could not load
Authentication extension;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The report server has encountered a configuration error. See the
report server log files for more information.
w3wp!library!8!12/3/2007-18:29:04:: i INFO: Catalog SQL Server Edition
= Developer
w3wp!library!7!12/3/2007-18:38:04:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
running jobs, 0 persisted streams
__________________________________________________________
Thanks, HerbHi
Ive got the same problem, but only on windows server 2003 using ssl. It runs
fine untill i install a ssl certificate, then it gives me a similar error. *.
ReportingServices.CustomSecurity* file not found.
If i reverse the ssl certificate, the problem remains. The same stuff works
fine on win xp with ssl though, and on win server 2003 without ssl. How did
you resolve this?
thanks
Leon
url:http://www.ureader.com/msg/115713209.aspx

problems at beginning of set up

Before I get into the project that I actually need working I'm trying to get through an example or two provided by microsoft.

I'm using the Flights sample from http://msdn2.microsoft.com/en-us/library/ms160889.aspx

I've downloaded the files and follow the instructions but quickly ran into trouble. I select the configuration file, enter the needed information, check the 'enable instance after it is created' box, and click okay. This takes a couple minutes but finishes without errors. I then try the register step. I enter my login information for the computer I'm using and use windows authentication. After click okay here's the error I get:

Registering Instance - FlightInstance

- Updating registry entries (Success)

- Installing Windows Service (Error)

Messages

Required information could not be retrieved from the registry. This usually indicates a problem with setup, configuration, or security. (Microsoft.SqlServer.NotificationServices)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=NSEventStrings&EvtID=ErrorReadingRegistryParameters&LinkId=20476

ADDITIONAL INFORMATION:

Required information could not be retrieved from the registry. This usually indicates a problem with setup, configuration, or security. (Microsoft.SqlServer.NotificationServices)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=NSEventStrings&EvtID=ErrorReadingRegistryParameters&LinkId=20476

- Installing performance counters (Stopped)

I'm running Microsoft SQL Server Management and here's the info from Help->About

Microsoft SQL Server Management Studio 9.00.1399.00
Microsoft Analysis Services Client Tools 2005.090.1399.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600

Any clues?

Try this,

Go to Control panel-->Administrative tools-->Services

You should see your new service listed [with an NS$ prefix]. Right click-->Properties. Go to the "Log on" tab and set a valid "Log on" to the service. Once you do that, you should be good to go. [You may return to Management studio and start the service from there]

|||

I'm afraid this didn't work.

The service isn't listed. There is nothing with a NS$ prefix.

|||Am I using the correct NotificationServicesHost? I'm using the full name of the computer I'm using.|||Registering an applications typically does three things. It creates the appropriate registry entries, creates a windows service to run the various SSNS components, and then it creates the performance counters to monitor the services.

From the output you shared it appears that the registry entries were created on the computer, but that the service could not created. That's why you don't have anything listed in Services.

If you were able to successfully create the instance, then the ICF and ADF should be fine.

My guess is that it's either a problem with the security context under which you are attempting to register the instance or it's a problem with the registry itself.

How are you logged into the computer and into SQL Server Management Studio?

Joe|||

I'm a domain member and should have access to everything on this computer (although it's possible there are areas that I can set permissions to have access but haven't yet). I am a member of the administrators group on this computer. I connnect to my local machine with sql server management with windows authentication.

It's quite possible that I need permissions somewhere and can set them to what I need.

|||

If it's an indicator of anything...

When I try to follow these instructions: http://msdn2.microsoft.com/en-us/library/aa259267(SQL.80).aspx

I receive the error 'nscontrol' is not recognized as an internal or external command, operable program or batch file

|||Hi! I was getting this same error and was pulling my hair out until I figured out that Notificaton Services wasn't completely installed!

Turns out, the base install of SQL Server 2005 partially installs Notification Services, which allows it to compile the ICF/ADF files into an NS Instance Database, but not install and run the NS$InstanceName Windows Service that you need to process the events. I was getting the same error when trying to execute the nscontrol register command, so I think your post down below about that command not being valid is a good indicator that this is indeed your problem.

To check if it is properly installed, and to install it if not, you need to go to Control Panel>Add/Remove Programs, then scroll through the list till you to get to Microsoft SQL Server 2005, then click on the Change... button. In the setup that follows, click Next until you get to the page where you can select which SQL Server components to install. Check the box next to "Notification Services", click Next and finish the installation. You wont need to reboot your server. Once the install completes, go ahead and try your operation again.

Hope it helps!

Andy C | Pranakhan
Avanade, Inc.
|||Have you tried re-installing SSNS?|||

Does anyone have any additional information for this issue? I've gone through all of the steps provided and still nothing works. I've used all of the accounts from LOCAL SERVICE, NETWORK SERVICE, SYSTEM, etc. and nothing works. I keep getting the error "Required information could not be retrieved from the registry". My databases all get created withough issue it's just when I try to register the service it blows up.

TIA

Ian

problems at beginning of set up

Before I get into the project that I actually need working I'm trying to get through an example or two provided by microsoft.

I'm using the Flights sample from http://msdn2.microsoft.com/en-us/library/ms160889.aspx

I've downloaded the files and follow the instructions but quickly ran into trouble. I select the configuration file, enter the needed information, check the 'enable instance after it is created' box, and click okay. This takes a couple minutes but finishes without errors. I then try the register step. I enter my login information for the computer I'm using and use windows authentication. After click okay here's the error I get:

Registering Instance - FlightInstance

- Updating registry entries (Success)

- Installing Windows Service (Error)

Messages

Required information could not be retrieved from the registry. This usually indicates a problem with setup, configuration, or security. (Microsoft.SqlServer.NotificationServices)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=NSEventStrings&EvtID=ErrorReadingRegistryParameters&LinkId=20476

ADDITIONAL INFORMATION:

Required information could not be retrieved from the registry. This usually indicates a problem with setup, configuration, or security. (Microsoft.SqlServer.NotificationServices)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=NSEventStrings&EvtID=ErrorReadingRegistryParameters&LinkId=20476

- Installing performance counters (Stopped)

I'm running Microsoft SQL Server Management and here's the info from Help->About

Microsoft SQL Server Management Studio 9.00.1399.00
Microsoft Analysis Services Client Tools 2005.090.1399.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600

Any clues?

Try this,

Go to Control panel-->Administrative tools-->Services

You should see your new service listed [with an NS$ prefix]. Right click-->Properties. Go to the "Log on" tab and set a valid "Log on" to the service. Once you do that, you should be good to go. [You may return to Management studio and start the service from there]

|||

I'm afraid this didn't work.

The service isn't listed. There is nothing with a NS$ prefix.

|||Am I using the correct NotificationServicesHost? I'm using the full name of the computer I'm using.|||Registering an applications typically does three things. It creates the appropriate registry entries, creates a windows service to run the various SSNS components, and then it creates the performance counters to monitor the services.

From the output you shared it appears that the registry entries were created on the computer, but that the service could not created. That's why you don't have anything listed in Services.

If you were able to successfully create the instance, then the ICF and ADF should be fine.

My guess is that it's either a problem with the security context under which you are attempting to register the instance or it's a problem with the registry itself.

How are you logged into the computer and into SQL Server Management Studio?

Joe|||

I'm a domain member and should have access to everything on this computer (although it's possible there are areas that I can set permissions to have access but haven't yet). I am a member of the administrators group on this computer. I connnect to my local machine with sql server management with windows authentication.

It's quite possible that I need permissions somewhere and can set them to what I need.

|||

If it's an indicator of anything...

When I try to follow these instructions: http://msdn2.microsoft.com/en-us/library/aa259267(SQL.80).aspx

I receive the error 'nscontrol' is not recognized as an internal or external command, operable program or batch file

|||Hi! I was getting this same error and was pulling my hair out until I figured out that Notificaton Services wasn't completely installed!

Turns out, the base install of SQL Server 2005 partially installs Notification Services, which allows it to compile the ICF/ADF files into an NS Instance Database, but not install and run the NS$InstanceName Windows Service that you need to process the events. I was getting the same error when trying to execute the nscontrol register command, so I think your post down below about that command not being valid is a good indicator that this is indeed your problem.

To check if it is properly installed, and to install it if not, you need to go to Control Panel>Add/Remove Programs, then scroll through the list till you to get to Microsoft SQL Server 2005, then click on the Change... button. In the setup that follows, click Next until you get to the page where you can select which SQL Server components to install. Check the box next to "Notification Services", click Next and finish the installation. You wont need to reboot your server. Once the install completes, go ahead and try your operation again.

Hope it helps!

Andy C | Pranakhan
Avanade, Inc.
|||Have you tried re-installing SSNS?|||

Does anyone have any additional information for this issue? I've gone through all of the steps provided and still nothing works. I've used all of the accounts from LOCAL SERVICE, NETWORK SERVICE, SYSTEM, etc. and nothing works. I keep getting the error "Required information could not be retrieved from the registry". My databases all get created withough issue it's just when I try to register the service it blows up.

TIA

Ian

problems at beginning of set up

Before I get into the project that I actually need working I'm trying to get through an example or two provided by microsoft.

I'm using the Flights sample from http://msdn2.microsoft.com/en-us/library/ms160889.aspx

I've downloaded the files and follow the instructions but quickly ran into trouble. I select the configuration file, enter the needed information, check the 'enable instance after it is created' box, and click okay. This takes a couple minutes but finishes without errors. I then try the register step. I enter my login information for the computer I'm using and use windows authentication. After click okay here's the error I get:

Registering Instance - FlightInstance

- Updating registry entries (Success)

- Installing Windows Service (Error)

Messages

Required information could not be retrieved from the registry. This usually indicates a problem with setup, configuration, or security. (Microsoft.SqlServer.NotificationServices)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=NSEventStrings&EvtID=ErrorReadingRegistryParameters&LinkId=20476

ADDITIONAL INFORMATION:

Required information could not be retrieved from the registry. This usually indicates a problem with setup, configuration, or security. (Microsoft.SqlServer.NotificationServices)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=NSEventStrings&EvtID=ErrorReadingRegistryParameters&LinkId=20476

- Installing performance counters (Stopped)

I'm running Microsoft SQL Server Management and here's the info from Help->About

Microsoft SQL Server Management Studio 9.00.1399.00
Microsoft Analysis Services Client Tools 2005.090.1399.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600

Any clues?

Try this,

Go to Control panel-->Administrative tools-->Services

You should see your new service listed [with an NS$ prefix]. Right click-->Properties. Go to the "Log on" tab and set a valid "Log on" to the service. Once you do that, you should be good to go. [You may return to Management studio and start the service from there]

|||

I'm afraid this didn't work.

The service isn't listed. There is nothing with a NS$ prefix.

|||Am I using the correct NotificationServicesHost? I'm using the full name of the computer I'm using.|||Registering an applications typically does three things. It creates the appropriate registry entries, creates a windows service to run the various SSNS components, and then it creates the performance counters to monitor the services.

From the output you shared it appears that the registry entries were created on the computer, but that the service could not created. That's why you don't have anything listed in Services.

If you were able to successfully create the instance, then the ICF and ADF should be fine.

My guess is that it's either a problem with the security context under which you are attempting to register the instance or it's a problem with the registry itself.

How are you logged into the computer and into SQL Server Management Studio?

Joe|||

I'm a domain member and should have access to everything on this computer (although it's possible there are areas that I can set permissions to have access but haven't yet). I am a member of the administrators group on this computer. I connnect to my local machine with sql server management with windows authentication.

It's quite possible that I need permissions somewhere and can set them to what I need.

|||

If it's an indicator of anything...

When I try to follow these instructions: http://msdn2.microsoft.com/en-us/library/aa259267(SQL.80).aspx

I receive the error 'nscontrol' is not recognized as an internal or external command, operable program or batch file

|||Hi! I was getting this same error and was pulling my hair out until I figured out that Notificaton Services wasn't completely installed!

Turns out, the base install of SQL Server 2005 partially installs Notification Services, which allows it to compile the ICF/ADF files into an NS Instance Database, but not install and run the NS$InstanceName Windows Service that you need to process the events. I was getting the same error when trying to execute the nscontrol register command, so I think your post down below about that command not being valid is a good indicator that this is indeed your problem.

To check if it is properly installed, and to install it if not, you need to go to Control Panel>Add/Remove Programs, then scroll through the list till you to get to Microsoft SQL Server 2005, then click on the Change... button. In the setup that follows, click Next until you get to the page where you can select which SQL Server components to install. Check the box next to "Notification Services", click Next and finish the installation. You wont need to reboot your server. Once the install completes, go ahead and try your operation again.

Hope it helps!

Andy C | Pranakhan
Avanade, Inc.
|||Have you tried re-installing SSNS?|||

Does anyone have any additional information for this issue? I've gone through all of the steps provided and still nothing works. I've used all of the accounts from LOCAL SERVICE, NETWORK SERVICE, SYSTEM, etc. and nothing works. I keep getting the error "Required information could not be retrieved from the registry". My databases all get created withough issue it's just when I try to register the service it blows up.

TIA

Ian

problems at beginning of set up

Before I get into the project that I actually need working I'm trying to get through an example or two provided by microsoft.

I'm using the Flights sample from http://msdn2.microsoft.com/en-us/library/ms160889.aspx

I've downloaded the files and follow the instructions but quickly ran into trouble. I select the configuration file, enter the needed information, check the 'enable instance after it is created' box, and click okay. This takes a couple minutes but finishes without errors. I then try the register step. I enter my login information for the computer I'm using and use windows authentication. After click okay here's the error I get:

Registering Instance - FlightInstance

- Updating registry entries (Success)

- Installing Windows Service (Error)

Messages

Required information could not be retrieved from the registry. This usually indicates a problem with setup, configuration, or security. (Microsoft.SqlServer.NotificationServices)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=NSEventStrings&EvtID=ErrorReadingRegistryParameters&LinkId=20476

ADDITIONAL INFORMATION:

Required information could not be retrieved from the registry. This usually indicates a problem with setup, configuration, or security. (Microsoft.SqlServer.NotificationServices)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=NSEventStrings&EvtID=ErrorReadingRegistryParameters&LinkId=20476

- Installing performance counters (Stopped)

I'm running Microsoft SQL Server Management and here's the info from Help->About

Microsoft SQL Server Management Studio 9.00.1399.00
Microsoft Analysis Services Client Tools 2005.090.1399.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600

Any clues?

Try this,

Go to Control panel-->Administrative tools-->Services

You should see your new service listed [with an NS$ prefix]. Right click-->Properties. Go to the "Log on" tab and set a valid "Log on" to the service. Once you do that, you should be good to go. [You may return to Management studio and start the service from there]

|||

I'm afraid this didn't work.

The service isn't listed. There is nothing with a NS$ prefix.

|||Am I using the correct NotificationServicesHost? I'm using the full name of the computer I'm using.|||Registering an applications typically does three things. It creates the appropriate registry entries, creates a windows service to run the various SSNS components, and then it creates the performance counters to monitor the services.

From the output you shared it appears that the registry entries were created on the computer, but that the service could not created. That's why you don't have anything listed in Services.

If you were able to successfully create the instance, then the ICF and ADF should be fine.

My guess is that it's either a problem with the security context under which you are attempting to register the instance or it's a problem with the registry itself.

How are you logged into the computer and into SQL Server Management Studio?

Joe|||

I'm a domain member and should have access to everything on this computer (although it's possible there are areas that I can set permissions to have access but haven't yet). I am a member of the administrators group on this computer. I connnect to my local machine with sql server management with windows authentication.

It's quite possible that I need permissions somewhere and can set them to what I need.

|||

If it's an indicator of anything...

When I try to follow these instructions: http://msdn2.microsoft.com/en-us/library/aa259267(SQL.80).aspx

I receive the error 'nscontrol' is not recognized as an internal or external command, operable program or batch file

|||Hi! I was getting this same error and was pulling my hair out until I figured out that Notificaton Services wasn't completely installed!

Turns out, the base install of SQL Server 2005 partially installs Notification Services, which allows it to compile the ICF/ADF files into an NS Instance Database, but not install and run the NS$InstanceName Windows Service that you need to process the events. I was getting the same error when trying to execute the nscontrol register command, so I think your post down below about that command not being valid is a good indicator that this is indeed your problem.

To check if it is properly installed, and to install it if not, you need to go to Control Panel>Add/Remove Programs, then scroll through the list till you to get to Microsoft SQL Server 2005, then click on the Change... button. In the setup that follows, click Next until you get to the page where you can select which SQL Server components to install. Check the box next to "Notification Services", click Next and finish the installation. You wont need to reboot your server. Once the install completes, go ahead and try your operation again.

Hope it helps!

Andy C | Pranakhan
Avanade, Inc.
|||Have you tried re-installing SSNS?|||

Does anyone have any additional information for this issue? I've gone through all of the steps provided and still nothing works. I've used all of the accounts from LOCAL SERVICE, NETWORK SERVICE, SYSTEM, etc. and nothing works. I keep getting the error "Required information could not be retrieved from the registry". My databases all get created withough issue it's just when I try to register the service it blows up.

TIA

Ian

problems at beginning of set up

Before I get into the project that I actually need working I'm trying to get through an example or two provided by microsoft.

I'm using the Flights sample from http://msdn2.microsoft.com/en-us/library/ms160889.aspx

I've downloaded the files and follow the instructions but quickly ran into trouble. I select the configuration file, enter the needed information, check the 'enable instance after it is created' box, and click okay. This takes a couple minutes but finishes without errors. I then try the register step. I enter my login information for the computer I'm using and use windows authentication. After click okay here's the error I get:

Registering Instance - FlightInstance

- Updating registry entries (Success)

- Installing Windows Service (Error)

Messages

Required information could not be retrieved from the registry. This usually indicates a problem with setup, configuration, or security. (Microsoft.SqlServer.NotificationServices)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=NSEventStrings&EvtID=ErrorReadingRegistryParameters&LinkId=20476

ADDITIONAL INFORMATION:

Required information could not be retrieved from the registry. This usually indicates a problem with setup, configuration, or security. (Microsoft.SqlServer.NotificationServices)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=NSEventStrings&EvtID=ErrorReadingRegistryParameters&LinkId=20476

- Installing performance counters (Stopped)

I'm running Microsoft SQL Server Management and here's the info from Help->About

Microsoft SQL Server Management Studio 9.00.1399.00
Microsoft Analysis Services Client Tools 2005.090.1399.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600

Any clues?

Try this,

Go to Control panel-->Administrative tools-->Services

You should see your new service listed [with an NS$ prefix]. Right click-->Properties. Go to the "Log on" tab and set a valid "Log on" to the service. Once you do that, you should be good to go. [You may return to Management studio and start the service from there]

|||

I'm afraid this didn't work.

The service isn't listed. There is nothing with a NS$ prefix.

|||Am I using the correct NotificationServicesHost? I'm using the full name of the computer I'm using.|||Registering an applications typically does three things. It creates the appropriate registry entries, creates a windows service to run the various SSNS components, and then it creates the performance counters to monitor the services.

From the output you shared it appears that the registry entries were created on the computer, but that the service could not created. That's why you don't have anything listed in Services.

If you were able to successfully create the instance, then the ICF and ADF should be fine.

My guess is that it's either a problem with the security context under which you are attempting to register the instance or it's a problem with the registry itself.

How are you logged into the computer and into SQL Server Management Studio?

Joe|||

I'm a domain member and should have access to everything on this computer (although it's possible there are areas that I can set permissions to have access but haven't yet). I am a member of the administrators group on this computer. I connnect to my local machine with sql server management with windows authentication.

It's quite possible that I need permissions somewhere and can set them to what I need.

|||

If it's an indicator of anything...

When I try to follow these instructions: http://msdn2.microsoft.com/en-us/library/aa259267(SQL.80).aspx

I receive the error 'nscontrol' is not recognized as an internal or external command, operable program or batch file

|||Hi! I was getting this same error and was pulling my hair out until I figured out thatNotificaton Services wasn't completely installed!

Turns out, the base install of SQL Server 2005partially installs Notification Services, which allows it to compile the ICF/ADF files into an NS Instance Database, but not install and run the NS$InstanceName Windows Service that you need to process the events. I was getting the same error when trying to execute thenscontrol register command, so I think your post down below about that command not being valid is a good indicator that this is indeed your problem.

Tocheck if it is properly installed, and to install it if not, you need to go toControl Panel>Add/Remove Programs, then scroll through the list till you to get toMicrosoft SQL Server 2005, then click on theChange... button. In the setup that follows, click Next until you get to the page where you can select which SQL Server components to install.Check the box next to "Notification Services", click Next and finish the installation. You wont need to reboot your server. Once the install completes, go ahead and try your operation again.

Hope it helps!

Andy C | Pranakhan
Avanade, Inc.
|||Have you tried re-installing SSNS?|||

Does anyone have any additional information for this issue? I've gone through all of the steps provided and still nothing works. I've used all of the accounts from LOCAL SERVICE, NETWORK SERVICE, SYSTEM, etc. and nothing works. I keep getting the error "Required information could not be retrieved from the registry". My databases all get created withough issue it's just when I try to register the service it blows up.

TIA

Ian

Problem: Global DB connection using web.config

I spent a lot of time trying to fix this. I followed example from the web and I ALWAYS GET THE SAME PROBLEM

System.InvalidOperationException: The ConnectionString property has not been initialized.

What I am missing? I really need to fix this. Can anyone help me?

Thanks

In my web.config
<appSettings
 <add key="connectionstring" value="server=homesvr02;uid=sa;pwd=database=Property"/>
</appSettings
In my asp.net page
<%@. Page Language="VB" %>
<%@. Import Namespace="System.Configuration" %>
<%@. import Namespace="System.IO" %>
<%@. import Namespace="System.Data" %>
<%@. import Namespace="System.Data.SQLClient" %
 Dim strConn As String = ConfigurationSettings.AppSettings("ConnectionString")

MY ERROR

System.InvalidOperationException: The ConnectionString property has not been initialized.Please show the rest of your code.

Are you creating an instance of SqlConnection?

Are you setting it's ConnectionString property?|||Little error :-)

See this line:

::<add key="connectionstring"
::value="server=homesvr02;uid=sa;pwd=database=Property"/
and then this line:

::Dim strConn As String = ConfigurationSettings.AppSettings("ConnectionString")

I know you come from a VB background - in XML, though casing does matter.

connectionstring != ConnectionString.|||good call there thona. I would have missed that. I think everyone proper cases everything.|||1.
<thona>
::Dim strConn As String = ConfigurationSettings.AppSettings("ConnectionString")

I know you come from a VB background - in XML, though casing does matter.

connectionstring != ConnectionString.
</thona
<KraGiE>
good call there thona. I would have missed that. I think everyone proper cases everything.
</KraGiE
* Well, a quick test using VB.NET and C# said otherwise.

Tricky or Inconsistency. Who would expect that? :-D

* C#
Response.Write(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]);

* VB.NET
Response.Write(System.Configuration.ConfigurationSettings.AppSettings("ConnectionString"))

Both gives

server=homesvr02;uid=sa;pwd=database=Property

2. Can you guys do a quick test to see too?

3. web.config

<?xml version="1.0" encoding="utf-8"?>
<configuration>
 <appSettings>
 <add key="connectionstring" value="server=homesvr02;uid=sa;pwd=database=Property"/>
 </appSettings>

|||phouc is right. on both 2002 and 2003. impressive. twice in one day. remarkable

Problem: Deployment works, but processing does not

Hi,

I am working with the 'Using SQL Server Data Mining" book, and am trying to deploy and process the 'MovieClick' example in chapter 3. Here is my problem: I am able to create the Data source, the source view, the data mining structure and data mining models (Decision trees and Bayes). When I select 'Buil - Deploy solution' all scripts are successfully deployed to the server, but once the processing start the application nothing happens. I see the that BI is trying to do something, or waiting for something. I can see a text that '0 cases are read'. The app does not time out, and i have to cancel the deployment.

Please let me know how to address this. I have followed the instructions in the book step-by-step (twice already), and I have the same problem. I have done the 'Adventure Works' data mining tutorials, and they work ok.

Any hint?

Thanks,

Doriak

Update on this issue.

I have tried the same project with the same instructions on a different machine, and I have the same issue. What it is worse, is that now once BI tries to kick the processing and it does not work, Visual Studio freezes so that I have to kill the process.

Doriak

|||

Hi,

Could somebody please help clarifying this?

Thanks,

Doriak

|||

You might be hitting a bug that occurs on single-proc systems. You can work around by changing some server settings using SQL Server Mgmt Studio. See this thread for details: http://www.sqlserverdatamining.com/DMCommunity/Newsgroup/2131.aspx

|||

Raman,

Thank you for the answer. The link you provided helped me to resolve the configuration issue. I am also working with a 1 CPU system for development purposes. I would like only to ask the team to provide updated documentation on configuration for typical scenarios as this was nowether to find in the BOL.

Thank you again. And now, back to mining :)

Doriak

Problem: "joining" data from two tables

Hi,

I'm a quite newbie with sql. I have problem with joining data from two tables. I think that example will describe it in the best way.

Table 1:
Date Data1
12.12.2000 3
13.12.2000 4
15.12.2000 6

Table 2:
Date Data2
12.12.2000 4
14.12.2000 8
15.12.2000 9
16.12.2000 4

Result (this is a thing that i need)
Date Data1 Data2
12.12.2000 3 4
13.12.2000 4 (0)
14.12.2000 (0) 8
15.12.2000 6 9
16.12.2000 0 4

Numbers in () are values that does not really exist in tables 1 or 2, but they are understood as zero. If I use
select table1.date, data1, data2 from table1,table2 where table1.date=table2.date
result does not contain rows (dates) that where _not_ in both tables.

-Timowhat you want is a FULL OUTER JOIN:select coalesce(Table1.Date,Table2.Date) as Date
, coalesce(Table1.Data1,0) as Data1
, coalesce(Table2.Data2,0) as Data2
from Table1
full outer
join Table2
on Table1.Date = Table2.Date|||Thanks, it works now.

Problem with XQuery Syntax

I'm storing addresses in an XML address column, and I need to be able
to do partial searches...
For example...
declare @.tAddress table (Address xml DEFAULT '<Address Record />' )
INSERT INTO @.tAddress (Address)
VALUES ('<AddressType name="Shipping">
<AddressRecord StreetLine1="111 Main"
City="Houston"
State="TX"
ZipCode = "11111" />
</AddressType> ');
A single address could have multiple address types (billing and
shipping) and multiple entries for each one.
I know how to query for an exact match on a column...
SELECT Address FROM @.tAddress WHERE
Address.exist('/AddressType/AddressRecord[ @.City = "Houston" ]') =1
However...I'm getting errors when I try to use a contains (in the
same way I'd use a City Like '%ous%'
How would I code a contains on any particular column?
Thanks!
KevinFollow-up...
I tried the following:
SELECT * FROM @.tAddress
where
address.exist('/AddressType/AddressRecord/City/text()[contains(.,"Houston")]
')
= 1
It doesn't bomb, but it generates zero results.
I'm sure I'm missing something, but don't know what.
Kevin|||Try this
SELECT * FROM @.tAddress
where
address.exist('/AddressType/AddressRecord [contains(@.City,"Houston")]')
= 1|||On 10 Mar 2006 12:08:09 -0800, markc600@.hotmail.com wrote:

>Try this
>SELECT * FROM @.tAddress
>where
>address.exist('/AddressType/AddressRecord [contains(@.City,"Houston")]')
>= 1
THAT WORKED!!!!!
You're the man!!!!!!!!!!!
THANK YOU!!!!!!!
Kevin

Problem with values returned by Calculated Member

Dear Friends,

I have a problem with CM:

Example

Row Field1 Field2 Field3 Total

1 31662 1 14,75 467014,5

2 250000 1 6,94 1735000

Total for each row= Field1*Field3 / Field2

The value I want for Calculated Member is Total1 + Total 2, 2202014,5, but the value is wrong... The calculated member gives me the value from: SUM Field1* SUM Field3 / SUM Field2, 3054624,39

The MDX:

[Measures].[Open Pos]*[Measures].[New Price]/[Measures].[Fx Rate Rep Cur]

And all the measures are with AggregateFunction as SUM...

Where is the problem? How can I calculate each row in spite of the sum?

Thanks!!

More help to you:

29-12-2006 BANCO PASTOR SA 31662 1 14,75 467.014,50 29-12-2006 GALP ENERGIA SGPS SA B 250000 1 6,94 1.735.000,00

For the date 29.12.2006 I want the calculated member with the value 2202014,5

And currently I'having the value 3054624,39.

|||Is the required calculation Sum(Field 1 * Field 3) / Sum (Field 2)? If so, try adding a calculated column to the DSV that does the (Field 1 * Field 3) calculation. Add this as a new measure, with Sum as the aggregation function. Then your calculated measure will be (New Measure) / (Field 2).|||

for the date 29-12-2006 I need to calculate each line of fact Table...

Example:

Date Field1 Field2 Field3 EachRow 29-12-2006 100 1 5 500 29-12-2006 200 1 4 800 29-12-2006 300 1 2 600 Correct 1900

As I did, in Calculated Member, the value returned is not 1900, but is 2200!! :-(

29-12-2006 600 3 11 2200

Understood?

Thanks!

|||

Then just add the entire calculation ( (Field 1 * Field 3) / Field 2 ) as a calculated column in your DSV. Create a new measure on that column, and set the AggregationFunction to SUM.

Anytime you need something calculated at the fact level, it's usually best to either add it to fact table directly, or include it in the DSV.

|||But field1 is a named calculation, and I cant use this value to create a new named calculation... :-(|||You should be able to replicate the calculation for Field1 in your new calculated column.|||

How can I do it?

When I am creating the second named calculation, in the expression textbox I wrote: [Field1]+1

and returned me the error message: Invalid column named 'Field1'

Field1 is a named calculation... :-(

|||Copy the expression from Field1 into Field2, and add the additional calculations that need to be performed.|||

The problem is that the calculations in named calculation Field 1 is not so simple...

yeh.. but I understood that is no possible call a NC from another NC... thanks!

Problem with uploading data SQL

Hello,

I have problem:

My *.txt file is like it:
"
12345612345678123
abcdefabcdefghabc
" etc.

i want upload data into table (for example TEST) i want to sql read this
file and automatically upload to table.(as job for example)
but i have 3 columns and i dont know how to separate this text to 3 diffrent
text columns

1 column | second column | third column
-------------
123456 | 12345678 | 123
abcdef | abcdefgh |abc

PLEASE HELP ME, i dont know how to do it.

Robert KlomaHi Robert,

i'm using the following stored proc (sp) for this. I suggest to use field
separators to make it
easier to separate the columns. This sp can be executed by a job.
The imported file should look like this:

1234;abcd;1212
321123;kdkdkd;121233

In the sp you have to replace CPRave15 with your database name.

Hope it helps.

Michael Zankl
http://www.zankl-it.de
Berlin

SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

/*
================================================== ==========================
==
Syno: imports file specified in @.UNCPathFileName into a table, specified
in @.DBTable
Use ';' as fieldterminator in the imported file

REMARKS:
- User, who runs this SP, has to be a member of SysAdmin
or BulkAdmin
- User must have Insert-Permission on specified Table or
has to be a member of db_owner

TEST:

DECLARE @.RC int,
@.UNCPathFileName varchar(1024),
@.DBTable varchar(128)

SET @.UNCPathFileName = '\\Absrv02\Components\Debitoren.csv'
SET @.DBTable = 'cprSYSMD_DebImp'

EXEC @.RC = cprIMP_File @.UNCPathFileName, @.DBTable
PRINT @.RC

select * from cprsysmd_debimp
--delete from cprSYSMD_DebImp

Author: MZA, http://www.zankl-it.de, 14.01.2003
================================================== ==========================
==
*/
CREATE PROCEDURE cprIMP_File @.UNCPathFileName varchar(1024),
@.DBTable varchar(128)
AS

DECLARE @.RetVal int,
@.Cmd varchar(8000)

--Example
-- BULK INSERT CPRave15.dbo.cprSYSMD_DebImp
-- FROM '\\Absrv02\Components\Debitoren.csv'

SET @.Cmd = '
BULK INSERT CPRave15.dbo.' + @.DBTable + '
FROM ''' + @.UNCPathFileName + '''
WITH (FIELDTERMINATOR = '';'')' --<== IMPORTANT: use a fieldterminator in
imported file

--print @.Cmd
EXEC (@.Cmd)

SET @.RetVal = @.@.ROWCOUNT

RETURN @.RetVal

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

"Robert K" <rkloma@.hotmail.com> schrieb im Newsbeitrag
news:bi1qj0$etr$1@.news.onet.pl...
> Hello,
> I have problem:
> My *.txt file is like it:
> "
> 12345612345678123
> abcdefabcdefghabc
> " etc.
> i want upload data into table (for example TEST) i want to sql read this
> file and automatically upload to table.(as job for example)
> but i have 3 columns and i dont know how to separate this text to 3
diffrent
> text columns
> 1 column | second column | third column
> -------------
> 123456 | 12345678 | 123
> abcdef | abcdefgh |abc
> PLEASE HELP ME, i dont know how to do it.
> Robert Kloma
>
>|||"Robert K" <rkloma@.hotmail.com> wrote in message news:<bi1qj0$etr$1@.news.onet.pl>...
> Hello,
> I have problem:
> My *.txt file is like it:
> "
> 12345612345678123
> abcdefabcdefghabc
> " etc.
> i want upload data into table (for example TEST) i want to sql read this
> file and automatically upload to table.(as job for example)
> but i have 3 columns and i dont know how to separate this text to 3 diffrent
> text columns
> 1 column | second column | third column
> -------------
> 123456 | 12345678 | 123
> abcdef | abcdefgh |abc
> PLEASE HELP ME, i dont know how to do it.
> Robert Kloma

One option is to create a staging table with one column, load the data
into that table without changing it, then insert into the final table
like this:

insert into dbo.TEST (col1, col2, col3)
select left(StagingColumn, 6), left(StagingColumn, 8),
left(StagingColumn, 3)
from dbo.StagingTable

Simon|||hello, thank you for hint but:

i want to read this data
My *.txt file is like it:
"
1234567890

" etc

1 column | second column | third column
-------------
12 | 3456 | 789

how to do it ,

> One option is to create a staging table with one column, load the data
> into that table without changing it, then insert into the final table
> like this:
> insert into dbo.TEST (col1, col2, col3)
> select left(StagingColumn, 2), left(StagingColumn, 4),
> left(StagingColumn, 4)
> from dbo.StagingTable

the result is of this is
1 column | second column | third column
-------------
12 | 1234 | 1234