web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / SL2011 - Create additi...
Microsoft Dynamics SL (Archived)

SL2011 - Create additional empty application database

(0) ShareShare
ReportReport
Posted on by SL_GP_BC_123 1,088

I've inherited a new SL Client that is still on version 2011.  They would like to create a new company, however I am running into a number of errors when attempting to create an "Additional Application Database".  The process runs with errors and the DBBuild.Log is referenced at the end of this post.  Upon completion, the database displays on the Database Maintenance Screen and the corresponding company can be added on under company maintenance.  Yet when I try to log into the new company, I receive the following message:

In troubleshooting, we also tried rebuilding procs and indexes, doing the security update, and resetting windows authentication for the logon method.  Neither seemed to have an affect and the logon error remained.

I am not finding references to the message on line.  Any thoughts as to what may be causing the DB Creation process to fail?  Please advise..

Here is the contents of the DBBuild.log file:

 

Start Time: 9:32:40 PM

Database Name: MYCOMPANY
Error Code: -1
Error Text: E:\Program Files (x86)\Microsoft Dynamics\SL\Applications\DB\Empty\App\Budget_Dist_Type.bcp: Expected more than 0 rows to be imported.  Please check the .log file and .err files for table 'Budget_Dist_Type'
Statement: Budget_Dist_Type, Budget_Dist_Type.bcp, /n


Database Name: MYCOMPANY
Error Code: -1
Error Text: E:\Program Files (x86)\Microsoft Dynamics\SL\Applications\DB\Empty\App\EntryTyp.bcp: Expected more than 0 rows to be imported.  Please check the .log file and .err files for table 'EntryTyp'
Statement: EntryTyp, EntryTyp.bcp, /n


Database Name: MYCOMPANY
Error Code: -1
Error Text: E:\Program Files (x86)\Microsoft Dynamics\SL\Applications\DB\Empty\App\FlexDef.bcp: Expected more than 0 rows to be imported.  Please check the .log file and .err files for table 'FlexDef'
Statement: FlexDef, FlexDef.bcp, /n


Database Name: MYCOMPANY
Error Code: -1
Error Text: E:\Program Files (x86)\Microsoft Dynamics\SL\Applications\DB\Empty\App\PJCode.bcp: Expected more than 0 rows to be imported.  Please check the .log file and .err files for table 'PJCode'
Statement: PJCode, PJCode.bcp, /n


Database Name: MYCOMPANY
Error Code: -1
Error Text: E:\Program Files (x86)\Microsoft Dynamics\SL\Applications\DB\Empty\App\PJContrl.bcp: Expected more than 0 rows to be imported.  Please check the .log file and .err files for table 'PJContrl'
Statement: PJContrl, PJContrl.bcp, /n


Database Name: MYCOMPANY
Error Code: -1
Error Text: E:\Program Files (x86)\Microsoft Dynamics\SL\Applications\DB\Empty\App\PJDocnum.bcp: Expected more than 0 rows to be imported.  Please check the .log file and .err files for table 'PJDocnum'
Statement: PJDocnum, PJDocnum.bcp, /n


Database Name: MYCOMPANY
Error Code: -1
Error Text: E:\Program Files (x86)\Microsoft Dynamics\SL\Applications\DB\Empty\App\PCSetup.bcp: Expected more than 0 rows to be imported.  Please check the .log file and .err files for table 'PCSetup'
Statement: PCSetup, PCSetup.bcp, /n


Database Name: MYCOMPANY
Error Code: -1
Error Text: E:\Program Files (x86)\Microsoft Dynamics\SL\Applications\DB\Common\App\Country.bcp: Expected more than 0 rows to be imported.  Please check the .log file and .err files for table 'Country'
Statement: Country, Country.bcp, /n


Database Name: MYCOMPANY
Error Code: -1
Error Text: E:\Program Files (x86)\Microsoft Dynamics\SL\Applications\DB\Common\App\EDCommQual.bcp: Expected more than 0 rows to be imported.  Please check the .log file and .err files for table 'EDCommQual'
Statement: EDCommQual, EDCommQual.bcp, /n


Database Name: MYCOMPANY
Error Code: -1
Error Text: E:\Program Files (x86)\Microsoft Dynamics\SL\Applications\DB\Common\App\EDConvMeth.bcp: Expected more than 0 rows to be imported.  Please check the .log file and .err files for table 'EDConvMeth'
Statement: EDConvMeth, EDConvMeth.bcp, /n


Database Name: MYCOMPANY
Error Code: -1
Error Text: E:\Program Files (x86)\Microsoft Dynamics\SL\Applications\DB\Common\App\EDDataElement.bcp: Expected more than 0 rows to be imported.  Please check the .log file and .err files for table 'EDDataElement'
Statement: EDDataElement, EDDataElement.bcp, /n


Database Name: MYCOMPANY
Error Code: -1
Error Text: E:\Program Files (x86)\Microsoft Dynamics\SL\Applications\DB\Common\App\EDRelease.bcp: Expected more than 0 rows to be imported.  Please check the .log file and .err files for table 'EDRelease'
Statement: EDRelease, EDRelease.bcp, /n


Database Name: MYCOMPANY
Error Code: -1
Error Text: E:\Program Files (x86)\Microsoft Dynamics\SL\Applications\DB\Common\App\EDTransaction.bcp: Expected more than 0 rows to be imported.  Please check the .log file and .err files for table 'EDTransaction'
Statement: EDTransaction, EDTransaction.bcp, /n


Database Name: MYCOMPANY
Error Code: -1
Error Text: E:\Program Files (x86)\Microsoft Dynamics\SL\Applications\DB\Common\App\EDVersion.bcp: Expected more than 0 rows to be imported.  Please check the .log file and .err files for table 'EDVersion'
Statement: EDVersion, EDVersion.bcp, /n


Database Name: MYCOMPANY
Error Code: -1
Error Text: E:\Program Files (x86)\Microsoft Dynamics\SL\Applications\DB\Common\App\smProServSetup.bcp: Expected more than 0 rows to be imported.  Please check the .log file and .err files for table 'smProServSetup'
Statement: smProServSetup, smProServSetup.bcp, /n


Database Name: MYCOMPANY
Error Code: -1
Error Text: E:\Program Files (x86)\Microsoft Dynamics\SL\Applications\DB\Common\App\smSVCCalendar.bcp: Expected more than 0 rows to be imported.  Please check the .log file and .err files for table 'smSVCCalendar'
Statement: smSVCCalendar, smSVCCalendar.bcp, /n


Database Name: MYCOMPANY
Error Code: -1
Error Text: E:\Program Files (x86)\Microsoft Dynamics\SL\Applications\DB\Common\App\State.bcp: Expected more than 0 rows to be imported.  Please check the .log file and .err files for table 'State'
Statement: State, State.bcp, /n


Database Name: MYCOMPANY
Error Code: -1
Error Text: E:\Program Files (x86)\Microsoft Dynamics\SL\Applications\DB\Common\App\TypeTransl.bcp: Expected more than 0 rows to be imported.  Please check the .log file and .err files for table 'TypeTransl'
Statement: TypeTransl, TypeTransl.bcp, /n


Database Name: MYCOMPANY
Error Code: -1
Error Text: E:\Program Files (x86)\Microsoft Dynamics\SL\Applications\DB\Common\App\PJPFTSYS.bcp: Expected more than 0 rows to be imported.  Please check the .log file and .err files for table 'PJPFTSYS'
Statement: PJPFTSYS, PJPFTSYS.bcp, /n


Database Name: MYCOMPANY
Error Code: -1
Error Text: E:\Program Files (x86)\Microsoft Dynamics\SL\Applications\DB\Common\App\SLIndex.csv: Expected more than 0 rows to be imported.  Please check the .log file and .err files for table 'SLIndex'
Statement: SLIndex, SLIndex.csv


Database Name: MYCOMPANY
Error Code: -1
Error Text: E:\Program Files (x86)\Microsoft Dynamics\SL\Applications\DB\Common\App\SLIndexCol.csv: Expected more than 0 rows to be imported.  Please check the .log file and .err files for table 'SLIndexCol'
Statement: SLIndexCol, SLIndexCol.csv


Database Name: MYCOMPANY
Error Code: -2146232060
Error Text: Could not find stored procedure 'GrantRolePermissions'.
Statement: GrantRolePermissions 'U', 'MSDSL'
GO

 

Database Name: MYCOMPANY
Error Code: -2146232060
Error Text: Invalid object name 'glsetup'.
Statement: Database Maintenance


Database Name: MYCOMPANY
Error Code: -2146232060
Error Text: Could not find stored procedure 'GrantViewPermissions'.
Statement: GrantViewPermissions


Database Name: MYCOMPANY
Error Code: -2146232060
Error Text: Could not find stored procedure 'GrantTrustedWebService'.
Statement: MYCOMPANY: GrantTrustedWebService


Database Name: MYCOMPANY
Error Code: -2146232060
Error Text: Could not find stored procedure 'GrantReportUserPermissions'.
Statement: Add User E8F575915A2E4897A517779C0DD7CE

End Time: 9:45:05 PM

 

Please advise.  Look forward to a reply,

 

JG

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Stuart Nottingham Profile Picture
    Stuart Nottingham 1,226 on at

    JG,

    Looking at the errors, my guess would be that either the bcp files are missing from the ..\db\empty\app folder or they are restricted by rights. The rights issue (in my mind) is probably more relevant as the "Grant ..." procedures also are throwing errors. Make sure you have proper admin rights to the server.

    Stuart Nottingham

  • SL_GP_BC_123 Profile Picture
    SL_GP_BC_123 1,088 on at

    Hello Stuart,

    Appreciate the input.  The BCP files are there.  Moreover supposedly I am logged in as a system administrator.  

    That said, I may have stumbled upon something.   It seems the server in question is also a domain controller.  Given the DC configuration I am unable to view local group membership to verify if the logon is also a local admin.  Could there be potential issues with the machine being configured as a domain controller?

    JG

  • Stuart Nottingham Profile Picture
    Stuart Nottingham 1,226 on at

    JG, I know that, in the past, having the DC and SQL on the same box was frowned upon. My recollection is that it was because both want to consume resources. Don't believe that's what is causing your problem though. Still feels like a rights issue to me.

  • CFROTON Profile Picture
    CFROTON 4,710 on at

    Hello JG,

    Are you using a port? 1433 is the default for sql server , it should be open for incoming/outgoing traffic.

    If you used a different port (some people do...) then perhaps that port is not open. And if you are using a different port, you need to include it on the login screen for db maintenance

    Jana MacDonald

    Microsoft Dynamics SL support

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans