SQL Server 2008 R2

Question

Hi,

I have below installation of SQL Server on my server.

Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)   Apr  2 2010 15:48:46   Copyright (c) Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 6.0 <X64> (Build 6002: Service Pack 2) (VM)

My first question is

-Are there any service packs for SQL SERVER 2008 R2 ? If yes, please provide me a microsoft link.

-I am unable to start my SQL Server Agent after the Installation.

From Configuration manager, it get below error

The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details

From Mgt Studio, i get below error

Unable to start service SQLSERVERAGENT on server SALSABDBA05. The SQLSERVERAGENT service on SERVERNAME started and then stopped.

Please advice.

Answer 1

1. No Service Pack for R2 yet.
2. Since SQLAgent is not starting, I would like you to check if there is any file called SQLAgent.out created in
C:\Program Files\Microsoft SQL Server\MSSQL10_50.<InstanceName>\MSSQL\Log folder

---

Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
--------------------------------------------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------------------------------------------------------------------
My Blog: http://blogs.msdn.com/blakhani
Team Blog: http://blogs.msdn.com/sqlserverfaq

Answer 2

thanks Balmukung.

Yes, there is a file SQLAGENT.OUT under E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log as we do all application installations in our E Drive.

whats next?

Answer 3

Please post the content of the file?

---

Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
--------------------------------------------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------------------------------------------------------------------
My Blog: http://blogs.msdn.com/blakhani
Team Blog: http://blogs.msdn.com/sqlserverfaq

Answer 4

There is no service pack for R2.

But if you want to keep your server update you should instal CU(Cumulative update). the latest CU is 4

http://blogs.msdn.com/b/sqlreleaseservices/archive/2010/10/18/cumulative-update-4-for-sql-server-2008-r2-rtm.aspx

 

---

Guy Twena, SQL server Consultant The answers are provided "AS IS"; Please "mark as answer" if a post solves your problem

Answer 5

Here it is

2010-11-29 08:55:36 - ? [100] Microsoft SQLServerAgent version 10.50.1600.1 ((Unknown) unicode retail build) : Process ID 2996
2010-11-29 08:55:36 - ? [101] SQL Server SALSABDBA05 version 10.50.1600 (0 connection limit)
2010-11-29 08:55:36 - ? [102] SQL Server ODBC driver version 10.50.1600
2010-11-29 08:55:36 - ? [103] NetLib being used by driver is DBNETLIB.DLL; Local host server is
2010-11-29 08:55:36 - ? [310] 1 processor(s) and 3839 MB RAM detected
2010-11-29 08:55:36 - ? [339] Local computer is SALSABDBA05 running Windows NT 6.0 (6002) Service Pack 2
2010-11-29 08:55:36 - ? [432] There are 12 subsystems in the subsystems cache
2010-11-29 08:55:37 - ! [364] The Messenger service has not been started - NetSend notifications will not be sent
2010-11-29 08:55:37 - ? [129] SQLSERVERAGENT starting under Windows NT service control
2010-11-29 08:55:38 - ! [260] Unable to start mail session (reason: Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException: Mail configuration information could not be read from the database. ---> System.Data.SqlClient.SqlException: profile name is not valid
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStre)
2010-11-29 08:55:38 - ! [355] The mail system failed to initialize; check configuration settings
2010-11-29 08:55:38 - + [396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect
2010-11-29 08:56:58 - ? [131] SQLSERVERAGENT service stopping due to a stop request from a user, process, or the OS...
2010-11-29 08:57:51 - ? [098] SQLServerAgent terminated (normally)

Answer 6

So you mean to say sql server is started and agent services are not started ? Are you able to connect to the server ?

Add service account permissons on registry

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10 ---

Check wethere permissosn are given on the  E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL ??

--------------------------------
Thanks,Suhas V

Answer 7

2010-11-29 08:55:38 - ! [260] Unable to start mail session (reason: Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException: Mail configuration information could not be read from the database. ---> System.Data.SqlClient.SqlException: profile name is not valid

Run below command

sp_configure 'Agent XPs', 1
RECONFIGURE 

Please open Management Studio, right click on SQL Server Agent > Properties > Alert System > Make sure that "Enable Mail Profile" is unchecked.

If above does not solve the problem Please Event log if there is any error at the same time?

---

Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
--------------------------------------------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------------------------------------------------------------------
My Blog: http://blogs.msdn.com/blakhani
Team Blog: http://blogs.msdn.com/sqlserverfaq

Answer 8

Didnt help. When i start the SQL Server agent from Mgt studio after running above commands, its giving me message SQL Server Agent started and then stopped.

I see below in event viewer

SQL Server blocked access to procedure 'dbo.sp_get_sqlagent_properties' of component 'Agent XPs' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Agent XPs' by using sp_configure. For more information about enabling 'Agent XPs', see "Surface Area Configuration" in SQL Server Books Online.

FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.

Configuration option 'Agent XPs' changed from 0 to 1. Run the RECONFIGURE statement to install.

Disabled performance counter data collection for this session from the "MSSQLServerOLAPService" service because the performance counter library for that service has generated one or more errors. The errors that forced this action have been written to the application event log.

Windows cannot open the 64-bit extensible counter DLL MSSQLServerOLAPService in a 32-bit environment. Contact the file vendor to obtain a 32-bit version. Alternatively if you are running a 64-bit native environment, you can open the 64-bit extensible counter DLL by using the 64-bit version of Performance Monitor. To use this tool, open the Windows folder, open the System32 folder, and then start Perfmon.exe.

The configuration information of the performance library "C:\Windows\system32\perf-MSSQLSERVER-sqlctr10.50.1600.1.dll" for the "MSSQLSERVER" service does not match the trusted performance library information stored in the registry. The functions in this library will not be treated as trusted.

sdd

Answer 9

Ensure the service account used for Agent is defined as a login to SQL Server . Re-apply the service account name and password fro both sql server and agent sercvices . I would suggest not to browse the name . Type the service account name .

----------------
Thanks,Suhas V