SQL Server Service Manager Question
Feb 19, 2006When I open up the SQL Server Service Manager I see 3 Servers in the drop down list box.
The third one does not exist. How can I remove it from the drop down list box?
Thanks
ADVERTISEMENT
Help! Enterprise Manager Turns SQL Server Service Manager Off
Dec 6, 2006IF someone can assist me. Everytime I load up enterprise manager the service manager turns off. And the enterprise manager can't connect to the local database. But everytime i turn it back on and try to connect again it shuts it off and around and around we go. Help would be appreciated. Thanks.
View 2 Replies View RelatedSQL Server Service Manager
Oct 22, 2007Where is the icon for the SQL Server Service Manager? I'm reading the Access 2003 Bible and I want to test accessing SQL Server, and I'm not sure where it installs that. Thanks!
View 8 Replies View RelatedSQL Server Service Manager With Instance Name
Aug 3, 2004I installed MSDE2000 with named instance on top of MSDE 7.0 and rebooted the system. The “SQL Server Service Manager” comes up with default server( MSDE7.0).
But I need “SQL Server Service Manager” has to come up with new instance name and the new server automatically after reboot.
I didn’t see any problem in connecting to instance name if I choose it from the server list. But user wants to see the server with instance name by default when system restarts. Do you have any idea about this?
Thank you,
Sri
Problems Running Enterprise Manager And Service Manager
Jul 20, 2005On one of our machines, all of the SQL Server 2000components except for the main Server component (SQL Servercore) itself were installed (Management tools, etc) a while agoand everything was running fine. Now I go and add/install theServer component and then Service Pack 3a.It seems that Service Manager won't start up (I get an hourglass cursor)and now I find that Enterprise Manager won't run as well. No errormessages appeared and I don't think I saw anything unusual inthe log file.However, I can use Enterprise Manager on a differentmachine and connect to the database (so the databaseitself seems to be running).Any suggestions as to what the problem might be and how tofix it? I like to see if I can repair this without havingto do a reinstall.Thanks.PF
View 2 Replies View RelatedMS SQL Server Service Manager Does Not Find Instance
Jul 23, 2005I am running Win XP SP2 and MSDE 2000 SP3a. The user is logging on asa POWERUSER. When the user logs on the MSSQLSERVER service starts butthe SQL Server Service Manager, that runs in the system tray, showsthat the instance has not started. The field that displays theinstance name is blank and it is not listed in the drop down list.The MSSQLSERVER service is set to start with a Windows domainadministrator account. The SQL server can be accessed by a remotecomputer through Enterprise Manager. The local programs cannontinteract with the server though.Does anyone know if I could grant some user access rights to allow MSDEto work under a POWERUSER login?
View 2 Replies View RelatedSQL Server Enterprise Manager Could Not Start The Service 'MSDTC'
Jul 20, 2005SQL Server Enterprise Manager could not start the service 'MSDTC' on server'NTAS21'.1722 - (The RPC server is unavailable)I Setup A publication on a server called NTAS4D, then Pushed TheSubscription to another server called NTAS21. If I configure so that thechanges at the subscriber are not replicated to the publisher, all works ok,I make a change at the publisher, it is replicated to the subscriber.If I configure for updating at the subscriber, I am presented with a screenstating that the following services must be started for replication to work:SQL Server Agent on NTAS4D - RunningMSDTC on NTAS4D - RunningMSDTC on NTAS21 - UnknownWhen I complete the wizard, I receive the message listed above.The Servers are in two separate locations, each behind a NAT enabled routerusing the internet to transfer data between the publisher and subscriber.Any Suggestions will be greatly appreciated.ThanksSteve
View 1 Replies View RelatedIs SQL Server Service Manager Still Existing On SQL Express Edition?
Jun 5, 2006Hi there. I am new to the SQL Express. I just finished installing the SQL Express 2005 with Advanced Services on a Windows XP SP2 computer. The first thing I noticed was the service manager (used to be on the taskbar) was being removed on the Express Edition. How do I get this feature back if it's even possible? I know you can find out the server status from the Configuration Manager but it's handy if the status is showned on the taskbar after logging in.
Any help will be greatly appreciated. Thank you.
KC
SQL Server Is Terminating Due To 'stop' Request From Service Control Manager
Nov 6, 2000Hi
I have been getting this message in the event viwer and my SQL server goes down. I have to go and start the service once again. Can somebody throw some light as how to solve this problem?
Please respond.
Tks.
Zolla
No Default Entries In SQL Server 2000 Service Manager Options
Jul 20, 2005ver: SQL-DMO Version: 8.00.760I have the option to automatically start SQL Server on startup, butwhen it does start up, the SQL Server Service Manager does not havethe green arrow indicating that it is active. When I double-click itto display the SQL Server Service Manager, it shows the name of theserver, but no services in the drop-down box.When I start Enterprise Manager I see an instance of MSDE wheresomeone installed an MSDE application. That is active. But I have to"connect" to the localhost. The instance name is the name of the MSDEapplication. I would like it to connect to the localhost on startup.Any ideas on how to correct this problem?Thanks,RBollinger
View 2 Replies View RelatedConfigure Report Server From Reporting Service Configuration Manager
Jan 25, 2008When I opened "Reporting Service Configuration Manger" from SQL server configuration tool list, The "Report Server Installation Instance window came out. It showed my local machine name on the field of Machine Name. When I click "Find" button, a message box came out. It says: "No report server were found on the specified machine. Details: Invalid namespace
What is the problem and how to solve it.
Spid3 SQL Server Is Terminating Due To 'stop' Request From Service Control Manager
Aug 28, 2005Installing MSDE (SP3) on a clean updated Win-XP system with all the latest fixes installed unsuccesfully. A clean systems means a fresh installed Win-XP, updated all using webupdate. And Excel 2003 installed. Thats all (not even AntiVirus (yet))
View 19 Replies View RelatedSSIS Doesn`t Start After Applying SQL Server 2005 SP1 Error Message 7000 Service Control Manager
Apr 27, 2006SSIS doesn`t start after applying SQL Server 2005 SP1
I get an error Message in event log
event id 7000 source: Service Control Manager Type: Error
Message:
The SQL Server Integration Services service failed to start due to the following error:
The service did not respond to the start or control request in a timely fashion.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
regards
Lothar Belle
SQL Service Manager Problem
May 29, 2007I have an SQL DB that resides on a server in my office, but when I try to connect a workstation to the DB with SQL Service Manager, I can't. The server is listed, but the drop down menu for the services is blank. If I click on the Start button, I get an error that a service has to be selected. Any ideas?
View 1 Replies View RelatedTerminal Service Manager
Jul 18, 2006I opened up Terminal Service Manager on my SQL Server to close out someghost connections. Then I minimized the application. After working onsome other issues. I right clicked on the minimized icon of TerminalService Manager on my tool bar and closed it. Now when I go toStart/Admin Tools/Terminal Service Manager, it opens up minimized and Ican't get it to maximize to close out ghost connections. The only wayI can close it is to go to the task manager and kill it from there.I've rebooted my server and I still have this problem when I openTerminal Service Manager. Does anyone have a solution for this?
View 2 Replies View RelatedAnalysis Service Manager
May 24, 2007I give up, how do you start the Analysis Manager? SSAS is installed and running, but I just can't seem to find the button/shortcut/whatever to start the manager.
View 6 Replies View RelatedSQL Service Manager Startup Problem
Jun 22, 2004Hi,
The SQL Service Manager is not running automatically despite that fact the the STartup type for the following service IS set to Automatic:
C:Program FilesMicrosoft SQL ServerMSSQLBinnsqlservr.exe -sMSSQLSERVER
When I start my PC and look at the taskbar (or is it better called the status bar), the service Manager appears with a big WHITE circle and when I get the tooltip it says:
"Unknown - \ - MSSQLServer"
Can someone please help me out.
SQL Service Manager Startup Problem
Jun 22, 2004Hi,
The SQL Service Manager is not running automatically despite that fact the the STartup type for the following service IS set to Automatic:
C:Program FilesMicrosoft SQL ServerMSSQLBinnsqlservr.exe -sMSSQLSERVER
When I start my PC and look at the taskbar (or is it better called the status bar), the service Manager appears with a big WHITE circle and when I get the tooltip it says that
"Unknown - \ - MSSQLServer"
Can someone please help me out.
Service Manager Won't Start After Reboot
Jun 30, 2004Got an issue:
I am running SQL Server 7.0 on a Web server and recently the SQL Server has been acting up. Basically what happens is every time the server is restarted the Service Manager fails to restart. I even get an error telling me that the service failed to start. So, when I log back in I have to physically restart the Service Manager. I have the services set to start automatically. Can anyone direct me where to look...perhaps a SQL Server log that might give me a clue. My application and error logs only tell me that it stops. Any ideas?
Service Manager In 2005 Not Found
Jan 18, 2006I have uninstall MS SQL 2000 and installed MS SQL 2005, but i cant find nowhere the service manager to run the server
where is it ?
thank you
Starting The SQL Service Through Enterprise Manager
Jul 23, 2005Folks,We're implementing a software based mirroring solution. This solutionrequires that the SQL Server service on the target server be stoppedwhile data is being replicated from the source server.One problem we encountered while testing was that the SQL ServerService on the target server was inadvertantly started when usersselected that server in Enterprise Manager. Is there any way to keepthe service from starting through Enterprise Manager?Thanks
View 2 Replies View RelatedStill Error In Service Listing Manager....
Sep 20, 2006Hi Remus:
I am using latest ServiceListingManager v1.1.3 and still getting this error....
Msg 6522, Level 16, State 1, Procedure ssb_create_certificate_from_blob, Line 0
A .NET Framework error occurred during execution of user defined routine or aggregate 'ssb_create_certificate_from_blob':
System.Data.SqlClient.SqlException: A certificate with name 'CMA_sbuser' already exists or this certificate already has been added to the database.System.Data.SqlClient.SqlException: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnectionSmi.EventSink.ProcessMessagesAndThrow(Boolean ignoreNonFatalMessages)
at Microsoft.SqlServer.Server.SmiEventSink_Default.ProcessMessagesAndThrow(Boolean ignoreNonFatalMessages)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQuerySmi(Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.SqlServiceBroker.Samples.CertificatesBlob.CertificatesBlob.ssb_create_certificate_from_blob(SqlString databaseName, SqlString certificateName, SqlString authorizationUser, SqlBinary certificateBody)
Help is greatly appreciated....
Thanks,
Pramod
Service Listing Manager Question For Remus
Aug 21, 2006Hi Remus - Thank you for your Service Listing utility. I am very new to S.B. I had an intern working for us do some research work into S.B. and I gave him your utility to use for the work I gave him to do. Here is what I am trying to do. Very simply, I want to setup a remote (target) server that many other source (initiator) servers will send messages to via S.B. I had the intern learn how to have a single initiator server send messages to the remote server. He used your utility to create the SQL script that needs to be run on both servers to get things set up, and it works correctly.
The script below is what your utility created to be run on the remote server. The reference to 'SDDev2' below is a reference to the initiator (source) server my intern was working against. Not knowing much about S.B., my concern by looking at the T-SQL below is that when creating the required objects on the remote server, we are hard-coding a reference to a single initiator server ('SDDev2'). However, I need to be able to support messages coming from hundreds of initiator servers. What, if anything, do I need to do or change to support this?
Thanks very much - Amos
The TSQL script from your utility is below:
USE [master];
GO
CREATE LOGIN [SDDEV2] WITH PASSWORD = '6p}J4saGX=*b9Z';
ALTER LOGIN [SDDEV2] DISABLE;
CREATE USER [SDDEV2] FROM LOGIN [SDDEV2];
GO
declare @dbname sysname;
select @dbname = DB_NAME();
exec msdb.dbo.ssb_create_certificate_from_blob @dbname, 'SDDEV2','SDDEV2',0x308201BF30820128A003020102021089C68EF17EAA289B42BB56454CA195D7300D06092A864886F70D0101050500301E311C301A06035504031313506572736F6E4164647265737353656E646572301E170D3036303831343030303030305A170D3037303831353030303030305A301E311C301A06035504031313506572736F6E4164647265737353656E64657230819F300D06092A864886F70D010101050003818D0030818902818100BCFD0F7BEE09988F08B0AED98A750795755CB35207C2DA7A2F69618ECD8118CE885E7EBFE644263EE397B72ABB14DFA67E2C4518D6C37B021D1CDDBC1E9E7B8C33AA622FA2DE3474B3529A2F165ED791DFC31E930D6C7E65EB49B4F3162A2CD94B43D6BE4DBE792D11A4F7FFA7DE5DC82329CE683D18D90C6A8108F50D601BE10203010001300D06092A864886F70D01010505000381810041ED85516EF68F21CE0538F4A6D5F6BDF8AF76BFF509FE84FEC173D7EB19AA310E383285C501BDFF1F1A7AD69F404C6F8F7A9653B191062249ADAE85AD5F2ED073F197E4FB06DEA5B19BD80577F85518924640A40F0FE1481292C6E4F4F9ED5A52AB960A41A47D5501EC512BEF71135A1AA05BD29151466D29B41B921575B865;
GO
GRANT CONNECT ON ENDPOINT::[BROKER] TO [SDDEV2];
GO
USE [AdventureWorks_Tim];
GO
IF NOT EXISTS (SELECT * FROM sys.certificates WHERE thumbprint = 0xF6FD43253A7DD7AB1562FAA3F8BD03C0532E45EE)
BEGIN
CREATE USER [Proxy::PersonAddressSender] WITHOUT LOGIN;
declare @dbname sysname;
select @dbname = DB_NAME();
exec msdb.dbo.ssb_create_certificate_from_blob @dbname, 'CN=PersonAddressSender::7DD56F1CFAB41F9C4A46DA13368EB879','Proxy::PersonAddressSender',0x308201BF30820128A00302010202107DD56F1CFAB41F9C4A46DA13368EB879300D06092A864886F70D0101050500301E311C301A06035504031313506572736F6E4164647265737353656E646572301E170D3036303831363030303030305A170D3037303831373030303030305A301E311C301A06035504031313506572736F6E4164647265737353656E64657230819F300D06092A864886F70D010101050003818D0030818902818100B31EC8E14AF32003FBCEE27C201A8BAC9F34797DB1D6AB1405DEBE73807BEBB9A5536009B5A1A4A28D4461D51B488FBD7AF4D2F8C8A956F4186F05CA50C541B90B243C6CF4826A5DCE3A22E9FAC263D7407611E537031E67EC8318A90FE3789783C5F87179294E17CDE2C3DBED3F95353B089BA4FBC098FF36F2177F3627AE530203010001300D06092A864886F70D01010505000381810092C058712A17533D8A8C44D53863121D4108B982AE456093A1C95CDD37BE446122B117662785B5F151C21F70C948F686CB3CC5895000AE5D107EF0371373F9ED8EC43A227ECAFF79C57F740981D726E6511C3377BFE7B4CEE94CEF30EEDC4ACA43BCAD56A626A563F1B733666CB74A4122B7084C853E9F8D5EA0DBB224DC2DD3;
END
GO
DECLARE @certificateOwner sysname;
DECLARE @sql nvarchar(4000);
SELECT @certificateOwner = p.name
FROM sys.database_principals p
JOIN sys.certificates c ON c.principal_id = p.principal_id
WHERE c.thumbprint = 0xF6FD43253A7DD7AB1562FAA3F8BD03C0532E45EE;
SELECT @sql = N'GRANT SEND ON SERVICE::[PersonAddressReceiver] TO ' + QUOTENAME(@certificateOwner);
EXEC sp_executesql @sql;
GO
CREATE ROUTE [Route::PersonAddressSender,C73507DF-0914-4DF5-8074-14A8A00060D3] WITH
SERVICE_NAME = 'PersonAddressSender',
BROKER_INSTANCE = 'C73507DF-0914-4DF5-8074-14A8A00060D3',
ADDRESS = 'tcp://SDDEV2:4022';
GO
SSIS Error On Connection Manager - IUI Service Could Not Be Created.
Oct 26, 2007I have installed the SQL Standard Client install on my laptop which has windows xpp using the following batch file.
Start /wait setup.exe /qn ADDLOCAL=SQL_DTS,Client_Components,Connectivity,SQL_Tools90,SDK,SQL_WarehouseDevWorkbench,SQLXML,Tools_Legacy,SQL_Documentation,SQL_BooksOnline
I am yet to connect to any datasource on my SSIS package. But when I right click on the connection Managers box in my SSIS project and select €œNew OLE DB Connection€? (or any other connection type), I get an Error as below. Please Help to resolve this error.
The new connection manager could not be created.
Additional information:
The service System.Windows.Forms.Design.IUIService could not be located.
(Microsoft.DataTransforamtionServices.Design).
Problems In Changing Windows Service Identity In Configuration Manager
Aug 1, 2007
Hi all,
I have installed SQL Server 2005 Express Edition with Advanced Services and also Toolkit in my system. Following which I cofigured the Reporting Services Configuration.
When I try http://localhost/Reports it throws the following error.
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) (rsRPCError) Get Online Help
The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled)
Bad Data. (Exception from HRESULT: 0x80090005)
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
I have tried to search exhaustively for the solution and nothing seems to be crystal clear in solving the above error.
Under Reporting Services Configuraiton Manager (RSCM) all are ticked excepting:
Initialization, SharePoint Integration,Encryption Keys, EMail Settings,Execution Account.
Before this unknowingly I have changed "Windows Service Identity" during configuration which is not the same as Web Service Identity. Under "Web Service Identity" ASP.Net Service Account is listed as <machinename>ASPNET.
Now under "Windows Service Identity" it is selected to "Windows Account" : homequinn. After reading the installation steps it is suggested to have it with "Buil-in Account" ->"Network Services" is recommended. When I try to change it asks me for password and key file. Once I provide it, it is throwing me the following error.
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
ReportServicesConfigUI.WMIProvider.WMIProviderException: The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.BackupEncryptionKey(Byte[]& encryptedBytes, String password)
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
Can someone tell how should I proceed to get the reporting services working.
Unable To Reinstall Enterprise Manager From Original Disk: Service Pack Rejected
Jun 21, 2006I would like to reinstall the enterprise manager of sql server 2000,and i have currently sql server 2000 SP4 installed on it.I googled on it, and read that installation of enterprise manager ispossible from the setup disk, however, this is not possible: it rejectsbecause of the service pack.How can I reinstall enterprise manager, without haveing to uninstallsql completely?ThanksPrem
View 4 Replies View RelatedUnable To Open Windows Service Identity Panel In Reporting Services Configuration Manager
Jul 4, 2007Hi,
I've a slight problem with configuring my Report Server. I have set up everything apart from the initialisation and and the Windows Service Identity, however when I select the panel for the latter I am presented with a message box displaying the following:
" Reporting Services Configuration Manager:
There was an error while switching panels. The most likely cause is an error retreiving WMI properties. The exception details are:
InvalidArgument=Value of '1' is not valid for 'SelectedIndex'.
Parameter name: SelectedIndex "
I have tried re-installing the entire SQL server setup and this made no difference, I followed this by removing then reinstalling just the Report Service. Still nothing.
Any ideas as to what it is doing and how I should go about fixing it?
Sim
The SQL Server (SQLEXPRESS) Service Terminated With Service-specific Error 10013.
Jul 12, 2007I have an almost virgin install of SQLExpres running on a WIN2K Pro system.
Have been able to create and connect db to Access 2000 without problem.
Now I wish to extend to remote connections. Using Surface Area Configuration tool, I changed Remote Connections to Local and Remote.
Whenever this setting contains TCP/IP and I try to restart the service I receive the following errors:
System Log:
The SQL Server (SQLEXPRESS) service terminated with service-specific error 10013.
Application Log:
Server TCP provider failed to listen on [ 'any' <ipv4> 0]. Tcp port is already in use.
TDSSNIClient initialization failed with error 0x271d, status code 0xa.
TDSSNIClient initialization failed with error 0x271d, status code 0x1.
Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.
If I change back to Local Connections Only or Local and Remote using named pipes only, the service starts up again without a problem.
After five days of investigating, researching, reinstalling and waiting I have to ask for help.
Any suggestions or leads?
Thank You in advance.
What Permissions Are Required For SQL Server Service Account To Call Web Service Using CLR Integration?
May 18, 2007Hello! I have the following problem. I developed CLR Stored Procedure "StartNotification" and deploy it on db. This sp calls external web service. Furthermore, this sp is called according with SQL Server Agent Job's schedule. On my PC SQL Server works under Local System account and this web service is called correctly (Executed as user: NT AUTHORITYSYSTEM). But on ther other server the following exception is raised during job running:
Date 17.04.2007 16:42:10
Log Job History (FailureNotificationJob)
Step ID 1
Server MSK-CDBPO-01
Job Name FailureNotificationJob
Step Name MainStep
Duration 00:00:00
Sql Severity 16
Sql Message ID 6522
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
Executed as user: CORPmssqlserver.
A .NET Framework error occurred during execution
of user defined routine or aggregate 'StartNotification':
System.Security.SecurityException: Request for the permission of type
'System.Net.WebPermission, System, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089' failed. System.Security.SecurityException:
at System.Security.CodeAccessSecurityEngine.Check(Object demand,
StackCrawlMark& stackMark, Boolean isPermSet)
at System.Security.CodeAccessPermission.Demand()
at System.Net. The step failed.
What is the reason of this behaviour? Unfortunately I do not have direct access to this server.
I have the following guesses:
1) CORPmssqlserver may have not enough permissions to call web service
2) Something wrong with SQL Server account's permissions
2) Something wrong with SQL Server Agent account's permissions
I will take the will for the deed. Thanks.
User Account Per SQL Server Service && SQL Agent Service, Why?
Jul 30, 2007Hi all,
I do understand that it is highly recomended to have aserprate user (perfered a domain user account) for each of the SQL Server service and SQL Agent service.
What is the reason behind that? (Someone told me to not run the service with an account that has a powerul privilegs! - I don't undrstanmd this point can you explain it please?)
What is the diffrent between: 1- Local System account 2 -Network Service account
Thanks in advanced!
CS4Ever
A User Group Account Acting Like A Content Manager And Admin On The Report Manager????
Nov 2, 2007
A user was created with a limited privilege under the USERS group. Once this user loged in the Report Manager he is acting like an Admin and Content Manager, though he is not given even a browser role.
What do u think that this guy is acting like a Super User evenif he is restricted to a browser role on the Report Manager ????????????
I did all my best, but no luck so far
SQL Server 2000 Databases To SQL Server 2005? Enterprise Manager And Management Stuio At The Same Server?
Feb 13, 2008When I proposed start to use SQL Server 2005 for new VS 2005 web sites, one of my co-workers responded that
we will update the old SQL Server 2000 databases to SQL Server 2005 when we are ready to use 2005 SQL Server.
Questions:
1. Any expected problems to upgrade old 2000 databases to new 2005 SQL Server?
2. I have installed both 2005/Management Studio Express and 2000/Enterprise Manager in my PC. Any expected
problems when running both 2000 and 2005 SQL Server at the same database server?
3. What is the best configuration for running SQL Server 2005 when we have old 2000 databases? Upgade or not upgrade?
TIA,
Jeffrey
The Report Server Windows Service 'ReportServer' Is Not Running. The Service Must Be Running To Use Report Server
May 16, 2007Hello Reporting Services 2005 users or Reporting Services Team,
I have done everything to get pass this error but no luck.
My setup is :- WIndows 2003 Standared Edition SP1
Sql Server :-
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
Reporting Services starting SKU: Standard.
From the Reporting Services Configuration Manager:
I can see all other things configured except Encryption Keys(blue sign)
Initialization(Grey sign) and Execution Acct(Yellow sign)
My windows Service Identity is using :
NT AuthorityNetworkService
Builtin Acct :NetworkService
Web Service Identity :-
ASP.NET Service Acct :- NT AuthorityNetworkService
DataBase Setup :- Credentials Type :- Service Credentials
I have also done everything from here thanks to Göran
http://stevenharman.net/blog/archive/2007/03/21/Avoiding-the-401-Unauthorized-Error-when-Using-the-ReportViewer-in.aspx
and
http://support.microsoft.com/default.aspx?scid=kb;en-us;896861
and
http://forum.k2workflow.com/viewtopic.php?t=619&
If you guys any solution for this please let me know.
I was wondering could this be a scale-out deployment issue ?
I also get the error when setting up the DataBase Setup :
Although saving the database connection info succeeded the The report server cannot access internal info about this deployment to determine whetherthe current con fig is valid for this editionThis could be a scale-out deployment and that the feature is not supported by this editionTo continue use a diff report server database or remove the encription keys
My Error log file is below:-
w3wp!webserver!5!16/05/2007-14:52:46:: i INFO: Reporting Web Server started
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!5!16/05/2007-14:52:46:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!resourceutilities!5!16/05/2007-14:52:46:: i INFO: Reporting Services starting SKU: Standard
w3wp!resourceutilities!5!16/05/2007-14:52:46:: i INFO: Evaluation copy: 0 days left
w3wp!resourceutilities!5!16/05/2007-14:52:46:: i INFO: Running on 1 physical processors, 2 logical processors
w3wp!runningjobs!5!16/05/2007-14:52:46:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
w3wp!runningjobs!5!16/05/2007-14:52:46:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!5!16/05/2007-14:52:46:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!5!16/05/2007-14:52:46:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!library!5!05/16/2007-14:52:48:: i INFO: Call to GetPermissions:/
w3wp!library!5!05/16/2007-14:52:48:: i INFO: Catalog SQL Server Edition = Standard
w3wp!library!5!05/16/2007-14:52:48:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server.
w3wp!library!5!05/16/2007-14:52:48:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server.
w3wp!library!5!05/16/2007-14:52:49:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server.
w3wp!library!5!05/16/2007-14:52:49:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server.