Problem installing local DW with SQL

E-mail notifications

Espen Thorvaldsen

Posted on 07/06/2013 09:15:01

Hi everyone,

I just tried to setup a local instance of newest DW 8.2.1.11

I followed Mortens instructions through his video about local setup.

First I had no problems with Access database. Than I did some work on that instance (add some pages, paragraphs etc...)

THAN I decided to make a new Instance with SQL database while using the same DW 8.2.1.11 application folder - so:

1) I downloaded new DefaultEmptyData8SQL.zip as again instructed in the video

2) Extracted accordingly and made sure that read write permission is granted.

3) Made new application in IIS and simply attached Files folder.

4) Restored db, made user + user mapping, add db information to Global settings...

Eventually when I am trying to run the application I am getting an error like this (see the attachment)

//Regards

Replies

Jeppe Eriksson Agger

Posted on 07/06/2013 09:34:39

This post has been marked as an answer

Hi Espen,

This error indicates that the table "Module" is missing from your database. Could you verify that this table is present if you view the database in Sql Server Management Studio?

If it is indeed missing, try and restore the database again. If it's still missing, please let me know.

- Jeppe

Votes for this answer: 1

Morten Snedker

Posted on 07/06/2013 09:43:38

Also, if running SQL Server Express, notice that you should have the "SQLEXPRESS\" prefix for server name in GlobalSettings.

I bet I've won. :-)

/Snedker

Espen Thorvaldsen

Posted on 07/06/2013 11:46:59

Hi Morten and Jeppe,

Thanks for help. And I found out that for some reason Table was not there somehow. Not sure how but...

I made new database restore and used Overwrite (WITH REPLACE) that did the trick.

Thanks allot for help guys! :-)

You must be logged in to post in the forum

Developer forum

Problem installing local DW with SQL

Replies