Hi Paula,

In Enterprise Manager browse to Management and SQL Server Agent.  Right click the Agent and select Properties.  The account name will be on the General tab.

Cath

Hi Farhad,

I had a similar problem and resolved it with J Foushee's final post on this TechNet forum:

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=701058&SiteID=17

Best of luck

Cath

SPID1 is the SQL Server Service, so:

SELECT (datediff(mi, login_time, getdate()))/'1440'

                  FROM master..sysprocesses WHERE spid = 1

Cath

Hi,

There's a good explanatory article with some troubleshhooting tips on this site:

http://www.sqlservercentral.com/columnists/cmiller/cannotgeneratesspicontext.asp

Good luck

Cath

Hi degrem,

This link helped me, hope it does you too:  http://msdn2.microsoft.com/en-us/library/ms189065.aspx

Cath

Hi Sam,

In Enterprise Manager browse to Management and select Backup.  Right click and select Export List.  This will give you the option to save all backup devices with their locations...

Run the command EXEC sp_who against your db in Query Analyser.  That will give you the SPID connections to your db.  Check this link for processes you shouldn't kill: http://msdn2.microsoft.com/en-US/library/ms173730.aspx  After...

Hi Mark,

It sounds as though you  may have an orphaned user as a result of the move.  Check BOL for sp_change_users_login.  Run this against your DB as sp_change_users_login 'Report' first and...

Hi Momak,

Are you sure you have the correct SP4 file for MSDE?  It's different from the SQL Server 2000, ie MSDE uses SQL2000.MSDE-KB884525-SP4-x86.EXE, SS2000 uses SQL2000-KB884525-SP4-x86.EXE.

Cath

As SS said, check the SQL Agent service account is mail enabled.  This kb should tell you everything you need: http://support.microsoft.com/kb/263556/

Cath

I know, you would think that, but I'm still having to edit hosts files even on trusted domains in my organisation.  Just thought it might be worth a try.

If you can register the server using the IP address but not the name, it sounds as though you might have a DNS issue.  Check with your network guys.

Cath

It sounds like your imported DB came from a server with a different collation, which affects case sensitivity and sort order amongst other things.  Check out BOL on 'collation' and...

Hi Nelson

Reporting Services isn't on the database installation disk.  Your SQL Server license includes RS, but you need to get the disk separately.  Here's a link:  http://www.microsoft.com/uk/windowsserversystem/reporting/howtobuy/default.aspx

Have fun

Cath

Hi Tom

I hope you resolve your problem, but in the meantime you really really should have a password on those sa accounts.  The spida and sasser worms - amongst others...