Need assitance to Launch MSDE and create a new database.

Installed MSDE. Icon on system tray shows "not connected". Start, Stop &
Pause are greyed out. I am trying to connect to a database. Please help.
Regards,
Shah.
hi, Shah,
Shah wrote:
> Installed MSDE. Icon on system tray shows "not connected". Start,
> Stop & Pause are greyed out. I am trying to connect to a database.
> Please help.
the "problem" with the SQL Server Service Manager can be related with
http://support.microsoft.com/default...;EN-US;814132, but you
should be able to connect to your MSDE instance anyway...
please verify in the service management applet your instance is (correctly)
installed and running...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
sql

Need advise on SSIS?

I am very new in SSIS. I have the Report Server set up with two dozen of the OLAP reports in it. The reports are connected to the OLAP database on a seperate computer running on Sql 2005 server and the data source for the OLAP DB is pointed to the warehouse database on another computer running on Sql 2000 server. The warehouse server updates daily from a number of "Production" Sql servers running on Sql 6.5 and Sql 7.0 with the legacy front-end data entry application. I know the update from the "Production" Sql 6.5/7.0 servers to the warehouse server complete around 9am in the morning everyday. How do I set up a package in SSIS to schedule the update of the OLAP database say 9:30am so that end-user can have the latest data to their report. The OLAP database has one fact table, half a dozen of cubes and ten dimensions. I know it is not an easy task to set up the package in SSIS. Please provide sample and step on how to do this. Thanks. One last question how to prevent/warn users from opening the report when SSIS updating the OLAP database?

Wow! that is 'whole project' question.

I recommend you to read about the REAL project, which offers a end-to-end BI implementation using SQL Server 2005 (including SSIS)

http://www.microsoft.com/technet/prodtechnol/sql/2005/projreal.mspx#EZGAC

http://www.microsoft.com/sql/solutions/bi/projectreal.mspx

There are a few webcast to watch as well; just search on this forum to get the links to it.