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
