search

fuel9 / DisplayMonkey

Display Monkey digital signage solution
Other
126 stars 50 forks source link

Runtime Error #58

Closed daanzii closed 6 years ago

daanzii commented 6 years ago

I'm trying to set up this Digital Signage software for the company I work for but I ran into an error and I'm unsure on the next steps to get around it, The error is as following:

2018-08-02_13-19-41

I followed the steps given and made a DisplayMonkey user in Server Management Studio but it didn't work so I went about trying to make another two users but didn't work either, I gave them db_owner permissions.

mstsc_2018-08-02_13-26-09

I edited the web.config file for both DisplayMonkey_Management and they have the same details in them and I have them as the following:

mstsc_2018-08-02_13-31-06

At this point I was slowly losing hope and had no idea what to do, I added a new user in the server rather than the database with a password (as shown above) and user mapped it to the DisplayMonkey database, Seen below:

mstsc_2018-08-02_13-35-56

I'm completely out of ideas, I'm using Windows Server 2012, Not sure if it's something I haven't configured properly or if it's something I haven't installed in Server manager/Roles and features.

Thanks.

michaelmalmgren commented 6 years ago

Hi, can you confirm that you created applications using an application pool with the correct .Net version? See step 2 of the installation instruction for more details http://www.displaymonkey.org/dm/documentation/installation/

Cheers, /M

psined1 commented 6 years ago

Check out closed issue #59. See if it will give you any clues.

daanzii commented 6 years ago

Found out the issue, posting in case anyone else has the same problem.

First time using Microsoft SQL Server Management Studio, I connected using Windows Authentication instead of SQL Server Authentication mainly because it wouldn't work for me plus I didn't see anywhere in the Display Monkey guide that you had to connect in SQL Server Authentication, I found out through digging through hours of guides that you had to enable the "sa" login by right clicking it and going into properties that way you can login as SQL Server Authentication instead of Windows Authentication instead of being given an error (Nowhere was this mentioned in the Installation page, Quite bad for newbies like me trying to set-up DisplayMonkey)

The second problem I had was I tried making a user in the DisplayMonkey database and tried using that as a login in the web.config file and came into issues also because it wouldn't let me assign it a password but making the user didn't give me an option of adding a password.

To fix this issue I used that login for "sa" in my DisplayMonkey web.config, I didn't realise I had to make a user in the SQLEXPRESS "Security" folder rather than the DisplayMonkey "Security" folder.

All my problems are solved and I have created great Digital Signage! I just with the Installation guide was a bit more in-depth to avoid these two issues I encountered.

Feel free to close the thread 👍

psined1 commented 6 years ago

closed per OP