yet another free help desk framework

2 Comments:

• Thank you! Great application, can't wait to try it out!

  By  Anonymous, at 7:26 PM  

• I posted this in the SourceForge.net forum as well.
  I’m really not sure where I went wrong.
  I was doing very well, until I got to the end point!
  Also, in your latest version, I was not sure, by the readme.txt if I needed to run the SQL files separately, or if they were run in one of the batch files.
  
  
  The installation of everything seemed to go well with one exception; the out files from membership_Application,Roles, Users, UsersInRole all show the following error when run:
  
  Login failed for user 'PRESSLER\gritz'.
  Cannot open database "Sinergia_aspnetdb" requested by the login. The
  login failed.
  
  This is my domain\username.
  
  When running the Membership_Grant.sql I get the following output:
  
  C:\Program Files\GLR\Sinergia>OSQL -S .\sqlexpress -E -Q "EXEC sp_grantlogin 'TESTSERVER\ASPNET'" -d Sinergia_aspnetdb
  Login failed for user 'PRESSLER\gritz'.
  Cannot open database "Sinergia_aspnetdb" requested by the login. The login failed.
  
  C:\Program Files\GLR\Sinergia>OSQL -S .\sqlexpress -E -Q "EXEC sp_grantdbaccess
  'TESTSERVER\ASPNET', 'ASPNET'" -d Sinergia_aspnetdb
  Login failed for user 'PRESSLER\gritz'.
  Cannot open database "Sinergia_aspnetdb" requested by the login. The login failed.
  
  C:\Program Files\GLR\Sinergia>OSQL -S .\sqlexpress -E -Q "EXEC sp_addrolemember 'db_owner', 'ASPNET'" -d Sinergia_aspnetdb
  Login failed for user 'PRESSLER\gritz'.
  Cannot open database "Sinergia_aspnetdb" requested by the login. The login failed.
  
  C:\Program Files\GLR\Sinergia>OSQL -S .\sqlexpress -E -Q "EXEC sp_grantlogin 'TESTSERVER\ASPNET'" -d Sinergia
  
  C:\Program Files\GLR\Sinergia>OSQL -S .\sqlexpress -E -Q "EXEC sp_grantdbaccess 'TESTSERVER\ASPNET', 'ASPNET'" -d Sinergia
  Msg 15023, Level 16, State 1, Server TESTSERVER\SQLEXPRESS, Line 1 User, group, or role 'ASPNET' already exists in the current database.
  
  C:\Program Files\GLR\Sinergia>OSQL -S .\sqlexpress -E -Q "EXEC sp_addrolemember 'db_owner', 'ASPNET'" -d Sinergia
  C:\Program Files\GLR\Sinergia>
  
  When opening the the default web page I see the following error:
  
  Error Message: Cannot open database "Sinergia_aspnetdb" requested by the login. The login failed. Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
  
  And if I try to click on the diagnostics link on the page:
  
  Error Message: Error executing child request for login.aspx.
  
  Any help is greatly appreciated. Should I uninstall and start from the beginning? I see that 'NT AUTHORITY\NETWORK SERVICE' will never be able to log in to the database because it is not a user and cannot be. I set the database up for Windows authentication. Should this have been something else?
  
  Thank you,
  Greg

  By  Gritz, at 3:04 PM  

Post a Comment

Links to this post:

  <$BlogBacklinkTitle$>  

<$BlogBacklinkSnippet$>
posted by <$BlogBacklinkAuthor$> @ <$BlogBacklinkDateTime$>

Create a Link

"The whole is more than the sum of its parts"

Aristotle