Cannot Start SQL Server Agent on SQL Server 7 after Upgrade

Cannot Start SQL Server Agent on SQL Server 7 after Upgrade

Post by Bill Parnel » Sat, 27 Nov 1999 04:00:00



-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

[000] SQLServerAgent cannot start because the msdb database is not set
to a compatibility level of 70 or higher

The error above is what I ab getting when I try to start the SQL
Server Agent.
Does anyone have any ideas as to why this is happening, and how I can
fix it????

any / all help greatly appreciated.

best regards,

Bill.
- --
+------------------------------------------------------------------+
|  Bill Parnell BSc (HONS)     |   Senior IT Analyst               |
|------------------------------------------------------------------|
| Information Services Division         Phone: +44 (1382) 308846   |
| The University of Abertay Dundee,       Fax: +44 (1382) 308808   |
| 40 Bell Street,                       Pager: +44 (7659) 511631   |

+------------------------------------------------------------------+

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 6.0.2i

iQA/AwUBOD5Lx2cHusY4HO/+EQJW3wCeOzoC0fqTT3cQr4zvZmIGGGbKDxkAn2eQ
hNhGDxsukQHpcZYKUM6DYLx+
=UVGP
-----END PGP SIGNATURE-----

 
 
 

Cannot Start SQL Server Agent on SQL Server 7 after Upgrade

Post by BPMargoli » Sat, 27 Nov 1999 04:00:00


Bill,

Check out the section "sp_dbcmptlevel (T-SQL)" in the SQL Server 7.0 Books
Online.


> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1

> [000] SQLServerAgent cannot start because the msdb database is not set
> to a compatibility level of 70 or higher

> The error above is what I ab getting when I try to start the SQL
> Server Agent.
> Does anyone have any ideas as to why this is happening, and how I can
> fix it????

> any / all help greatly appreciated.

> best regards,

> Bill.
> - --
> +------------------------------------------------------------------+
> |  Bill Parnell BSc (HONS)     |   Senior IT Analyst               |
> |------------------------------------------------------------------|
> | Information Services Division         Phone: +44 (1382) 308846   |
> | The University of Abertay Dundee,       Fax: +44 (1382) 308808   |
> | 40 Bell Street,                       Pager: +44 (7659) 511631   |

> +------------------------------------------------------------------+

> -----BEGIN PGP SIGNATURE-----
> Version: PGPfreeware 6.0.2i

> iQA/AwUBOD5Lx2cHusY4HO/+EQJW3wCeOzoC0fqTT3cQr4zvZmIGGGbKDxkAn2eQ
> hNhGDxsukQHpcZYKUM6DYLx+
> =UVGP
> -----END PGP SIGNATURE-----


 
 
 

1. SQLServer Agent NOT starting after upgr frm SQL Server 7.0 to SQL Server 2K

hi,
SQL Server 7.0 was running fine and was accessible by all
my applications. After upgrade to SQL Server 2000, the
SQLServer Agent is refusing to start. Infact, it starts
and stops IMMEDIATELY as is reflected in the Win2K
Services (Start from Services and refresh)

SQLAgent.OUT contains the following entries :
1. [298]SQL Server Error: 1311, Cannot generate SSPI
Context [SQLSTATE HY000]
2. [000] Unable to connect to SQL Server '[local]'; Cannot
start SQLServer Agent

The current setup is
x86 2 CPU
1GB RAM
NT4.0 upgraded to Win2K (No SP set up yet .... could this
be the reason ???)
SQL Server 7.0 EE upgraded to SQL Server 2000 EE witt SP1.
Connection to DB thro' Windows authentication.
Query Analyzer works fine ..... not checked out other apps.

Any ideas ???

2. Can't see any databases

3. SQL server Agent can not autostart when SQL server 7 start

4. SQL Query

5. Cannot start SQL Server Agent

6. Oracle 9i on Linux

7. SQL Server Agent cannot start

8. Error: No database manager command was issued

9. Cannot Start SQL Server Agent

10. Can not start SQL server and server agent

11. MS SQL Server Agent Could Not Start In Cluster Server

12. can not start SQL server and server agent service

13. Cannot set SQL Agent Proxy acount in SQL Server 2000