installation issues

Mar 12, 2015 at 7:15 PM
I followed the installation instructions but I seem to be missing some details?!
Copied the files in my new website
Created database kbvault, run the script, no errors,
browse to <website>/Dashboard and got the folllowing meesage after 1st login

[SqlException (0x80131904): Cannot open database "kbvault" requested by the login. The login failed.
Login failed for user 'IIS APPPOOL\<websitename>'.]

What credentials do I need to set at the kbvault database to get the acces I need?

Server win2012, sql2012

Regards
Roy
Developer
Mar 12, 2015 at 7:34 PM
Roy,


Try this and please report back your findings:
  1. Create a new local windows user (IE call it SVC-KBVault)
  2. Create a new AppPool for KBVault (IE call it KBVault)
  3. Assign the new user SVC-KBVault, to the newly created KBVault AppPool
  4. On your IIS Website change the AppPool from the deafault AppPool to the new KBVault AppPool you just created
  5. In SQL give the SVC-KBVault user permission to the KBVault SQL database (DBO if you aren't too concerned with security and just want it to work)
Mar 14, 2015 at 9:40 PM
Edited Mar 16, 2015 at 8:27 AM
Thank you for the explanation, but I'm not there yet.
Done all of the above steps and when I login on the Dashboard I get the following errorpage

[SqlException (0x80131904): Invalid column name 'Author'.]

I can log in in SSMS as the user created and do a query (select * from dbo.article) and get back alle collums.
Where Am I missing something?

Regards
Roy
Mar 16, 2015 at 8:31 AM
Edited Mar 19, 2015 at 4:44 PM
Desperately created new database onder administator account,
created new site, copied the kbvault,zip content in this directory,
added the administrator account to the AppPool just to see it work 1 time,

after login in in the dashboard with admin/admin this is the responcw


Source Error:


An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:



[SqlException (0x80131904): Invalid column name 'Author'.]
Apr 13, 2015 at 7:01 AM
Edited Apr 13, 2015 at 7:05 AM
Okay, the tipp from gn00347026 in Discussion https://kbvault.codeplex.com/discussions/586600 helped me to solve this.
Tnx.
Marked as answer by DetroitTechno on 4/28/2015 at 1:32 PM