1. Via SQL Management Studio, connect to the analysis service.

2. right click database and select backup

Derek

Why not use an existing msdb backup and then restore it in your express system? I just tried this and it works just fine.

Derek

Straight from BOL,  the source of all knowledge:

To rebuild system databases and specify a new system collation

Insert the SQL Server 2005 installation media into the disk drive.

Run the following command...

Hmm can't say I've tried on 2005 either.  One way would be via add / remove programs uninstall sql server db engine and re-install.  During install you need to ensure...

Sorry also noticed a comment in your last post which hinted that this server you are having issues with has a default instance and more than one named instance?  How...

Couple of things to try

1. create a named pipe alias (using client network utility) specifying the server\instancename.  This will probably solve issue, but means you are connecting over a named...

Kevin I have the solution and your just gunna love this one.

What you and I want to do is std stuff and should just...

Hi Kevin, did you get a resolution??  I have the same issue on pretty much any server with sp4 on it.  I have not changed service accounts, even a system...

So long as the account has perms on the dir or path and file it is writing to then no problem.

Note that depending on what the dts package does (SSIS...

Uh could be wrong but don't think there is one in sql2005.  you manage sql services using

SQL server configuration manager, which is available via start, all programs, ms sqlserver...

Jurgen

No problem and in fact recommended by Microsoft.  Under 2005 there are more services than just sql server engine and agent service. You could use a different login for each.

The main...

Thanks, but that would only create the jobs which refer to a maint plan, which wouldn't then exist on any new server.  I guess its time to dive into SSIS.  Seems...

Thanks very much for the ideas.  Didn't know of sp_stop_job.  I love the brute force approach and even though this is prod it will do just fine.  Agree this is...

ok so to clarify further,

1. From the same server as the failed BDE attempted connections you can connect via ODBC when logged on as either trusted or domain login?

2....

ultimately the osql command is going to connect to sql server .  You can connect as sql authenticated login or windows authentcated login using the -U or -E  switches respectively. ...