Parker Software Ltd Homepage
Forum Home Forum Home > WhosOn Live Chat > FAQ's
  New Posts New Posts RSS Feed - Web Charts SQL Server Database Access
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Web Charts SQL Server Database Access - Event Date: 21 Sep 2006 - 21 Sep 2006

 Post Reply Post Reply
Author
Message
Stephen View Drop Down
Admin Group
Admin Group
Avatar

Joined: 21 Oct 2005
Location: Stoke on Trent
Points: 1454
Post Options Post Options   Thanks (0) Thanks(0)   Quote Stephen Quote  Post ReplyReply Direct Link To This Post Calendar Event: Web Charts SQL Server Database Access
    Posted: 21 Sep 2006 at 3:40pm
If you are using SQl Server or SQL server express to store the WhosOn database, the web charts may show a "Cannot open database error". This article explains what to do to fix this.

The error is caused because the user that the web charts runs under (the IUSE_COMPUTER user) wont have access to the SQL server db by default. WhosOn creates a login for this user in the database itself during installation. However this can sometimes fail if you have renamed any users or have a none-standard security setup. In which case you must add the user to SQL server manually.

To do this open the SQL Server Management studio.

Right-click Logins and select 'New Login'
Click the Search button
The Select User or Group dialog opens.
Click Advanced
Then click Object types and make sure 'Groups' is selected
Click the Find Now button to list your users & groups.
Select the IIS_WPG group on Windows 2003 or ASPNET on Windows 2000
Click OK to save the login.

Now select the WhosOnV4 database.
Open the database tree and select Security - Users
Right-click and select New User
Call the User IIS
Click the ... next to Login name
Click Browse and select the IIS_WPG login just created - click OK
In the Owned Schemas list check 'db_datareader'
in the Role Members list check 'db_datareader'
Click OK to save the user.

The web charts will now have access to the database.

if you have removed or renamed the IIS_WPG or ASPNET users, try repeating for the IUSR_COMPUTER user (this is the Windows user for anonymous access for web sites).

Steve
Back to Top
Daniel Horton View Drop Down
Admin Group
Admin Group
Avatar
Technical Support

Joined: 01 Jun 2009
Location: Stoke-on-Trent
Points: 351
Post Options Post Options   Thanks (0) Thanks(0)   Quote Daniel Horton Quote  Post ReplyReply Direct Link To This Post Posted: 08 Mar 2010 at 12:03pm
Within Windows 2008 and IIS 7 and above these users have different names. They are now: 

NT AUTHORITY\NETWORK SERVICE
NT AUTHORITY\SYSTEM


To do this open the SQL Server Management studio.

Right-click Logins and select 'New Login'
Click the Search button
The Select User or Group dialog opens.
NT AUTHORITY\NETWORK SERVICE
Click the Find Now button to list your users & groups.
Select the NT AUTHORITY\NETWORK SERVICE user on Windows 2008
Click OK to save the login.

Then again Right-click Logins and select 'New Login'
Click the Search button
The Select User or Group dialog opens.
NT AUTHORITY\SYSTEM
Click the Find Now button to list your users & groups.
Select the NT AUTHORITY\NETWORK SERVICE user on Windows 2008
Click OK to save the login.

Now select the WhosOnV5 database.
Open the database tree and select Security - Users
Right-click and select New User
Call the User NETWORK SERVICE
Click the ... next to Login name
Click Browse and select the NT AUTHORITY\NETWORK SERVICE login just created - click OK
In the Owned Schemas list check 'db_datareader'
in the Role Members list check 'db_datareader'
Click OK to save the user.

And finally select the WhosOnV5 database.
Open the database tree and select Security - Users
Right-click and select New User
Call the User SYSTEM
Click the ... next to Login name
Click Browse and select the NT AUTHORITY\SYSTEM login just created - click OK
In the Owned Schemas list check 'db_datareader'
in the Role Members list check 'db_datareader'
Click OK to save the user.


Edited by JamesH - 07 Apr 2010 at 10:14am
Best Regards,



Daniel James Horton

Technical Manager

Parker Software
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 11.05
Copyright ©2001-2016 Web Wiz Ltd.

This page was generated in 0.094 seconds.