Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Analysis Server and Reporting Services (2005)  When I run the create script, SSAS services stop.

Author  Topic  gbraden Starting Member 1 Post Posted - 2008-11-20 : 16:28:36 I am a SSAS newbie. I have recently installed SSAS 2005 on it's own server with the idea of doing the normal 12+ hour cube build there, and syncing the data back to it's old server so that the users can actually access te data throughout the day. There is no database (yet) on the new server and my problems exist from trying to create one. I have ran a create script in management studio of the current cube database and have tried running that script to the new server. The process errors out after a very short run because the services on the new server stop. Sometimes I have to remote into the new server to start the services up because I get an error in Studio Manager. I have tried a restore from a backup created on the old server, which will run about an hour and then die with a communication error because, services are stopped on the new server. This happens when I remote into the server and start the backup in Management Studio or if I start the restore from local using Management Studio. I get the same communication error when I try doing a sync (via Management Studio) from old to new. Old and new server are at same SS version and patch level, BUT OS for new server is at SP2 while OS for old is SP1. I have increased Server timeout from 3600 to 0 (no timeout). Any suggestions??? Thanks in advance!