SQL Server Compatability level issue wtih SQL Server Agent Account

[kxramse]

I'm trying to set up a SQL Server Agent account and I just hit a wall. I was following these instructions.

http://msdn.microsoft.com/en-us/library/ms187901.aspx

and

http://msdn.microsoft.com/en-us/library/ms190703.aspx

When I was creating the SQL Sever Agent Proxy it started to error out and honestly I didn't keep the error thinking that whatever it was, it would reverse what I was doing. Then I got some kooky error message that the SQL Server Agent proxy account was already set up, and so I basically "OK'd" out of that thinking I would simply look at the proxyies to see if it was there already. Now I can't look at any of the proxies. When I do I get this LONG error message.. (See below)



Our database is on SQL Server 2005, however it is set to compatibility mode 80, its a thorn in my side, but a reality I am stuck with. What I need to do though is run SSIS on the same server and setting up the security to do that has led me to this point. If I only need the compatability on the MSDB database I may be able to do that, but the application that I am suporting needs its databases to be in 2000 mode.



So how do I resolve this error? The darn databases are in 2000 and I can't exactly turn on 2005 everywhere. is there one of the system databases I can do this with to resolve this error? Can I get SSIS running with a SQL Server Agent without 2005 compatability?



Any help would be appreciated.



Keith









TITLE: Microsoft SQL Server Management Studio
------------------------------

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

For help, click:

http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Incorrect syntax near 'REVERT'. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the stored procedure sp_dbcmptlevel.
Incorrect syntax near 'REVERT'. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the stored procedure sp_dbcmptlevel.
Incorrect syntax near 'REVERT'. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the stored procedure sp_dbcmptlevel.
Incorrect syntax near 'REVERT'. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the stored procedure sp_dbcmptlevel.
Incorrect syntax near 'REVERT'. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the stored procedure sp_dbcmptlevel.
Incorrect syntax near 'REVERT'. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the stored procedure sp_dbcmptlevel.
Incorrect syntax near 'REVERT'. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the stored procedure sp_dbcmptlevel.
Incorrect syntax near 'REVERT'. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the stored procedure sp_dbcmptlevel.
Incorrect syntax near 'REVERT'. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the stored procedure sp_dbcmptlevel.
Incorrect syntax near 'REVERT'. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the stored procedure sp_dbcmptlevel.
Incorrect syntax near 'REVERT'. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the stored procedure sp_dbcmptlevel.
Incorrect syntax near 'REVERT'. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the stored procedure sp_dbcmptlevel.
Incorrect syntax near 'REVERT'. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the stored procedure sp_dbcmptlevel.
Incorrect syntax near 'REVERT'. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the stored procedure sp_dbcmptlevel.
Incorrect syntax near 'REVERT'. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the stored procedure sp_dbcmptlevel.
Incorrect syntax near 'REVERT'. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the stored procedure sp_dbcmptlevel.
Incorrect syntax near 'REVERT'. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the stored procedure sp_dbcmptlevel.
Incorrect syntax near 'REVERT'. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the stored procedure sp_dbcmptlevel.
Incorrect syntax near 'REVERT'. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the stored procedure sp_dbcmptlevel.
Incorrect syntax near 'REVERT'. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the stored procedure sp_dbcmptlevel. (Microsoft SQL Server, Error: 325)

For help, click:

http://go.microsoft.com/fwlink?Prod...047&EvtSrc=MSSQLServer&EvtID=325&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------