Shared SQL Server Instance for Bizview & ERP System
This topic describes the process for setting up a shared SQL server instance for Bizview and an ERP system.
This topic contains the following sections:
Determine the Internal DB User for Bizview
When SQL Server instance is setup with Mixed Mode Authentication, then the Bizview DB user most often is bvadmin. This can be configured during installation of Bizview, or after using the Bizview Database installation software (C:\Program Files\NCG Group\Bizview\DBWizard\Application\DbWizard.exe)
If only Windows Authentication is allowed for login, then the internal Bizview user is a Domain User. Most common is using the 'NT AUTHORITY\NETWORK SERVICE'. Check the application pool setting on the Bizview application server to see what identity context the Bizview application is running within.
Grant Read Access for the ERP Database(s) to the Internal Bizview DB User
The Bizview DB User must be mapped to the ERP system database(s), and granted the db_datareader role in the database(s) to be able to read data from the ERP Systems database.
Example script to grant read access:
use erp_database
go
createuser <username> from login <loginname>
go
exec sp_addrolemember db_datareader, <username>
go
Next step:Tasks for Bizview Integrator Consultant