see article

http://msdn2.microsoft.com/en-us/library/aa176564.aspx

which explains service account options. Also lists a few reasons why you might require the account to have admin rights

Elabuwa,

up to a point it does not matter as you can always change it later after the install (though a bounce of SQL will be required)

If SQL does not need...

try net start mssqlserver -m instead

may need to use /m rather than -m

sorry to butt in.........default...

Yelena, I wish, but no. The maintenance plan migrate option has taken 'all system dbs' to include tempdb and no way in in the gui to remove it.

creating a NEW...

should be able to salvage current set up.

disable the log shipping jobs

delete (or move to another directory) any tran log backups in source and destination folders (leave redo file)

backup primary...

there were lots of problems with maintenance plans following SP2.

see http://blogs.msdn.com/psssql/archive/2007/04/06/post-sql-server-2005-service-pack-2-sp2-fixes-explained.aspx

On training courses and in HA seminars I have always seen the figure of 100 miles quoted as a max for nodes in a MS cluster. The limitation would be...

What ALZDBA said - here! here!

Some software vendors are lazy and write app to use sa as then they don't have to worry about permissions, if you have a relationship...

I don't see why moving a user database would prevent an instance starting so thats probably a red herring, check out the errorlogs to see why instance not starting

should there not have not been another option in the answers - a sql server table in the subscription databases if local sql servr queue used?

Jim Russell (1/3/2008)

---

What is recommended in the case where multiple independent dbs owned by unrelated individuals/groups/organizations are sharing the same server, and providing local DBA functions themselves, and wish their...

Jeff, if people are actually going to listen to me 🙂 I better clarify my point....

an object created by a sysadmin will always be owned by dbo even when...

or use one of the SQL gui tools (Query analyser, enterprise manager. sql server management studio, maintenance plans). exact too, depends on version of SQL u r using.

Again see BOL

right click on server registration and choose 'edit sql server registration properties'. check connection properties are correct.

I note you have placed this post on 2005 forum but enterprise manager is...