x

sql server installation

Please help

I am new to SQL and willing to get a handle on it i have recently installed an evaluation copy which seems to have installed ok, but when i try to start the sql server agent, i get this message: unable to start service sqlserveragent on server . mscorlib

please see error log below

2011-07-05 06:33:54.94 Server      Dedicated admin connection support was established for listening locally on port 1434.
2011-07-05 06:33:55.15 Server      The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b, state: 3. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.
2011-07-05 06:33:55.15 Server      SQL Server is now ready for client connections. This is an informational message; no user action is required.
2011-07-05 06:34:12.37 spid10s     Starting up database 'tempdb'.
2011-07-05 06:34:15.60 spid15s     The Service Broker protocol transport is disabled or not configured.
2011-07-05 06:34:15.66 spid15s     The Database Mirroring protocol transport is disabled or not configured.
2011-07-05 06:34:16.55 spid15s     Service Broker manager has started.
2011-07-05 06:34:25.52 spid20s     Starting up database 'msdb'.
2011-07-05 06:34:25.52 spid21s     Starting up database 'ReportServer'.
2011-07-05 06:34:25.55 spid22s     Starting up database 'ReportServerTempDB'.
2011-07-05 06:34:28.85 spid6s      Recovery completed for database ReportServerTempDB (database ID 6) in 1 second(s) (analysis 509 ms, redo 0 ms, undo 494 ms.) This is an informational message only. No user action is required.
2011-07-05 06:34:30.19 spid6s      Recovery is complete. This is an informational message only. No user action is required.
2011-07-05 06:36:11.50 spid13s     A new instance of the full-text filter daemon host process has been successfully started.
2011-07-05 09:03:48.90 spid55      Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.
2011-07-05 09:03:48.90 spid56      Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.
2011-07-05 09:03:49.29 spid56      Using 'xpstar.dll' version '2009.100.1600' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
2011-07-05 09:52:44.87 spid57      Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.
2011-07-05 09:52:44.89 spid57      FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
2011-07-05 09:52:44.93 spid57      Configuration option 'Agent XPs' changed from 1 to 0. Run the RECONFIGURE statement to install.

i have tried to research on the net about resolutions to this query but it still not working

my sqlagent.out file contains info

2011-06-29 19:00:26 - ? [131] SQLSERVERAGENT service stopping due to a stop request from a user, process, or the OS...
2011-06-29 19:00:28 - ? [100] Microsoft SQLServerAgent version 10.50.1600.1 (x86 unicode retail build) : Process ID 9912
2011-06-29 19:00:28 - ? [101] SQL Server HANNAH-ACER version 10.50.1600 (0 connection limit)
2011-06-29 19:00:28 - ? [102] SQL Server ODBC driver version 10.50.1600
2011-06-29 19:00:28 - ? [103] NetLib being used by driver is DBNETLIB.DLL; Local host server is 
2011-06-29 19:00:28 - ? [310] 2 processor(s) and 3000 MB RAM detected
2011-06-29 19:00:28 - ? [339] Local computer is HANNAH-ACER running Windows NT 6.0 (6002) Service Pack 2
2011-06-29 19:00:28 - ? [432] There are 0 subsystems in the subsystems cache
2011-06-29 19:00:28 - ! [000] Failed to load any subsystems. Check errorlog for details.
2011-06-29 19:00:29 - ? [098] SQLServerAgent terminated (normally)

please if anyone can help check this out and advise me on what to do, i'll appreciate it much

thank you
more ▼

asked Jul 05, 2011 at 11:19 AM in Default

gragra gravatar image

gragra
11 1 1 1

Is your machine on a domain or a workgroup? Did you set SQL Server and SQL Agent to use a domain account, a local service account, or a local Windows account? Another issue might be the dash in the name - this isn't a good idea for machine names. The kerberos messages may just be red herrings... do you have Agent XPs enabled? In SSMS / Object Explorer what does the icon for SQL Server Agent look like?
Jul 05, 2011 at 11:24 AM AaronBertrand
You might want to also check the Windows Event log to see what messages show there.
Jul 05, 2011 at 11:28 AM Shawn_Melton
(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

no my machine is a standalone one, not on any domain or workgroup when i installed sql server i followed the instructions in a cbt and created s seperate local user account for the database engine which is what was advised in the cbt asper the computer name with a dash, i think it was when i first bought the computer ages ago that i named it so and didnt think it would be a problem then the agent XPs is also an issue, i executed the follow script

sp_configure 'show advanced options','1' RECONFIGURE go

sp_configure 'Agent XPs','1' RECONFIGURE go

when executed, it comes up with this message

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

then the agent xp disappeared after refreshing and after a while it came back again, the sql server agent in ssms has a red arrow pointing downward which is why i know something is wrong

in the event viewer, i get something like this FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'. Configuration option 'Agent XPs' changed from 1 to 1. Run the RECONFIGURE statement to install.

please any advice/help will be appreaciated

more ▼

answered Jul 05, 2011 at 11:54 AM

gragra gravatar image

gragra
11 1 1 1

Open up your Windows System and Application logs and see if there is anything in there (errors/warnings) that are related.
Jul 05, 2011 at 12:25 PM SirSQL
(comments are locked)
10|1200 characters needed characters left
please i await replies to my post what has gone wrong with the installation
more ▼

answered Jul 05, 2011 at 03:10 PM

gragra gravatar image

gragra
11 1 1 1

And we're awaiting replies on whether there are corresponding entries in the Windows event logs.
Jul 05, 2011 at 03:22 PM SirSQL
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x729
x588

asked: Jul 05, 2011 at 11:19 AM

Seen: 2080 times

Last Updated: Jul 05, 2011 at 11:46 AM