• I had no trouble getting the scripts themselves to work. To do so, I opened Management Studio, then opened the scripts (DDL and Populate) in turn, then executed them. Then I switched to Business Intelligence Studio, began the Restore and then realized that I would have to switch a flag indicating whether to permit browsing to a new directory. Rather than do that, I simply moved the backup file to the directory indicated. Then I proceeded and the database restored fine.

    It was after that that my problems began. I have proceeded further and am now convinced that my setup of BI is toast. I tried creating a new project and got as far as defining a new data source, when I got an error message.

    Unfortunately, my master copy is off-site, so all this will have to wait until tomorrow (for me at least).

    As for you, try my steps above. Make sure that you create the database in Management Studio not Intelligence Studio. Just do File | Open then browse to where you stored the DDL and Populate scripts, then run the DDL first and then the Populate. Then switch to Business Intelligence and restore the backup file.

    Arthur

    Arthur Fuller
    cell: 647-710-1314

    Only two businesses refer to their clients as users: drug-dealing and software development.
    -- Arthur Fuller