AyaNova service management & work order software
AyaNova Support Forum
Home       Members    Calendar    Who's On
Welcome Guest ( Login | Register )
        



If want to use integrated security = true... Expand / Collapse
Author
Message
Posted 2/28/2008 1:38:22 PM
AyaNova Sales & Support

AyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & SupportAyaNova Sales & Support

Group: Administrators
Last Login: Yesterday @ 10:45:49 AM
Posts: 1,689, Visits: 3,988
If using SQL AyaNova database, and you want to have your config.txt use integrated security = true instead of the sa username and password, you will need to create a SQL user ASPNET (or NETWORK SERVICE) user and assign permissions to the AyaNova database.

Otherwise when you enter in the URL for WBI that has integrated security = true in its config.txt you will get either of the following errors:

WBI was unable to start, most likely this is due to a configuration error.
Double check your settings in the config.txt file as outlined in the documentation.
The error message is:
Cannot open database "AyaNova" requested by the login. The login failed.
Login failed for user 'COMPUTERNAME\ASPNET'

or

WBI was unable to start, most likely this is due to a configuration error.
Double check your settings in the config.txt file as outlined in the documentation.
The error message is:
Login failed for user 'NT_AUTHORITY\NETWORK SERVICE'

Below are the steps to create the user in SQL Express on a Windows XP station - it would be fairly the same if using SQL Server or other operating system:

  1. Open SQL Express Management Studio
  2. Expand Security
  3. Right-click on Logins -> select New Login....
  4. Click on the Search button for Login Name
  5. Click on Advanced and than Find Now so it lists all possible existing names
  6. Select ASPNET  (you may also or have to select NETWORK SERVICE)
  7. Select OK
  8. Select OK
  9. Click on User Mappings for this new SQL user
  10. Checkmark the Map box for the AyaNova database in the "users mapped to this login"
  11. Checkmark db_owner, db_securityadmin as well as the existing public
  12. Click on OK to create this new user in SQL
  13. Now restart SQL (open Services and restart SQL Express) - or reboot the entire computer
  14. On login, open a web browser and enter your local url to WBI to bring up the WBI login

- Joyce

AyaNova Sales & Technical Support
http://www.ayanova.com
Post #3853
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: AyaNova Sales & Support

Permissions Expand / Collapse

All times are GMT -8:00, Time now is 2:47am

Powered by InstantForum.NET v4.1.4 © 2008
Execution: 0.031. 9 queries. Compression Disabled.