September 15, 2013 at 4:56 am
Installed SQL Server 2008 R2 and chose to install SSIS, SSRS and SSAS. now I am unable to connect SSRS and SSAS in SSMS.as you can see by attached screen shots,
I navigated to the SQL Server Configuration Manager under the SQL Server menu option in windows. my SQL Server Analysis Services service is running! I have set this to start automatically. (SQl SeverBroser running automatic )
following errors from log file:
(2013/09/08 01:40:09 PM) Message: Failed to initialize SQLSQM timer. One of the following can be the source of the problem: registry doesn't contain all necessary information, server instance name can not be retrieved correctly, failure during timer creation, etc. (Source: \\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.GITS\OLAP\Log\msmdsrv.log, Type: 3, Category: 289, Event ID: 0xC121001B)
(9/8/2013 1:40:09 PM) Message: The file '\\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.GITS\OLAP\Data\CryptKey.bin' could not be opened. Please check the file for permissions or see if other applications locked it. (Source: \\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.GITS\OLAP\Log\msmdsrv.log, Type: 3, Category: 289, Event ID: 0xC1210023)
(9/8/2013 1:40:10 PM) Message: The flight recorder was started. (Source: \\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.GITS\OLAP\Log\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x41210005)
(9/8/2013 1:40:10 PM) Message: Service started. (Source: \\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.GITS\OLAP\Log\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x41210000)
(9/8/2013 1:48:52 PM) Message: The flight recorder was started. (Source: \\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.GITS\OLAP\Log\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x41210005)
(9/8/2013 1:48:52 PM) Message: Service started. (Source: \\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.GITS\OLAP\Log\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x41210000)
(9/8/2013 1:57:54 PM) Message: Service stopped. (Source: \\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.GITS\OLAP\Log\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x41210001)
(9/8/2013 1:58:03 PM) Message: The flight recorder was started. (Source: \\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.GITS\OLAP\Log\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x41210005)
(9/8/2013 1:58:03 PM) Message: Service started. (Source: \\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.GITS\OLAP\Log\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x41210000)
(9/8/2013 2:11:20 PM) Message: Service stopped. (Source: \\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.GITS\OLAP\Log\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x41210001)
(9/8/2013 2:11:27 PM) Message: The flight recorder was started. (Source: \\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.GITS\OLAP\Log\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x41210005)
(9/8/2013 2:11:27 PM) Message: Service started. (Source: \\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.GITS\OLAP\Log\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x41210000)
(9/9/2013 9:09:03 AM) Message: The flight recorder was started. (Source: \\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.GITS\OLAP\Log\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x41210005)
(9/9/2013 9:09:03 AM) Message: Service started. (Source: \\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.GITS\OLAP\Log\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x41210000)
(9/10/2013 10:18:40 AM) Message: The flight recorder was started. (Source: \\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.GITS\OLAP\Log\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x41210005)
(9/10/2013 10:18:40 AM) Message: Service started. (Source: \\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.GITS\OLAP\Log\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x41210000)
(9/11/2013 7:24:20 AM) Message: The flight recorder was started. (Source: \\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.GITS\OLAP\Log\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x41210005)
(9/11/2013 7:24:20 AM) Message: Service started. (Source: \\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.GITS\OLAP\Log\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x41210000)
(9/12/2013 6:32:19 AM) Message: The flight recorder was started. (Source: \\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.GITS\OLAP\Log\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x41210005)
(9/12/2013 6:32:20 AM) Message: Service started. (Source: \\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.GITS\OLAP\Log\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x41210000)
(9/13/2013 7:17:30 AM) Message: The flight recorder was started. (Source: \\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.GITS\OLAP\Log\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x41210005)
(9/13/2013 7:17:31 AM) Message: Service started. (Source: \\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.GITS\OLAP\Log\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x41210000)
(9/13/2013 2:21:47 PM) Message: The flight recorder was started. (Source: \\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.GITS\OLAP\Log\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x41210005)
(9/13/2013 2:21:47 PM) Message: Service started. (Source: \\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.GITS\OLAP\Log\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x41210000)
(9/14/2013 12:46:08 PM) Message: The flight recorder was started. (Source: \\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.GITS\OLAP\Log\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x41210005)
(9/14/2013 12:46:08 PM) Message: Service started. (Source: \\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.GITS\OLAP\Log\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x41210000)
(9/14/2013 12:51:02 PM) Message: The flight recorder was started. (Source: \\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.GITS\OLAP\Log\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x41210005)
(9/14/2013 12:51:03 PM) Message: Service started. (Source: \\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.GITS\OLAP\Log\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x41210000)
(9/15/2013 9:07:02 AM) Message: The flight recorder was started. (Source: \\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.GITS\OLAP\Log\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x41210005)
(9/15/2013 9:07:03 AM) Message: Service started. (Source: \\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.GITS\OLAP\Log\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x41210000)
(9/15/2013 12:33:03 PM) Message: Service stopped. (Source: \\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.GITS\OLAP\Log\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x41210001)
(9/15/2013 12:33:11 PM) Message: The flight recorder was started. (Source: \\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.GITS\OLAP\Log\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x41210005)
(9/15/2013 12:33:11 PM) Message: Service started. (Source: \\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.GITS\OLAP\Log\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x41210000)
(9/15/2013 12:35:11 PM) Message: Service stopped. (Source: \\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.GITS\OLAP\Log\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x41210001)
(9/15/2013 12:35:19 PM) Message: The flight recorder was started. (Source: \\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.GITS\OLAP\Log\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x41210005)
(9/15/2013 12:35:19 PM) Message: Service started. (Source: \\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.GITS\OLAP\Log\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x41210000)
Any ideas as to what is wrong?
NOBODY REMAINS VIRGIN LIFE FU**S EVERY ONE..:exclamation:
September 16, 2013 at 3:57 am
Are the dependent services started? Have you configured the SSRS and SSAS services as part of the installation?
Somehow I get the feeling that only half of the job has been done up until now.
September 17, 2013 at 10:32 am
yes dependent services are started. yes i configured the SSRS and SSAS when installating,
now i am able to deploy reports in local server, report manager url working fine.
ssis connecting fine in ssms, but not able to connect ssrs and ssas in ssms.
please check the log file..error !any ideas greatly appreciated
NOBODY REMAINS VIRGIN LIFE FU**S EVERY ONE..:exclamation:
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply