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_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.
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?
2 comments:
Thank you! Great application, can't wait to try it out!
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
Post a Comment