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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / The stored procedure g...
Microsoft Dynamics GP (Archived)

The stored procedure getDBName() of form duSQLInstall Pass Throught SQL returned the following results: DBMS: 58, Microsoft Dynamics GP:0.

(0) ShareShare
ReportReport
Posted on by Ronie 1,080

Hi,

I'm upgrading from GP8 SP5 to GP11 using two VM.

VM1 - OS Windows 2003, SQL Server 2000 SP4, GP8 SP5 and GP10 SP2

VM2 - OS Windows 2008 R2, SQL Server 20008 R2, GP10 hotfix (KB2552042) and GP11 hotfix (KB2552044)

  • First step upgrade from GP8 SP5 to GP10 SP2  using the SQL 2000 SP4 - upgrade sucessful
  • Second step backup database from SQL Server 2000 SP4 and restore into SQL Server 2008 R2 and set the compatibility to 2008
  • Third step apply the GP10 hotfix using the GP10 utilities in the VM2, the hotfix is sucessfully applied and I launch the GP10 with hotfix - Fine
  • Fourth Step upgrade from GP10 hotfix to GP11 hotfix, system database upgrade run with no error, however at the middle of the company database upgrade I encountered error "The stored procedure getDBName() of form duSQLInstall Pass Throught SQL returned the following results: DBMS: 58, Microsoft Dynamics GP:0." then I click the OK button and warning message appears "No privilege to open"

I can't find a soluton from the net. Any one knows the reason why I encountered this error? I appreciate if you can help me.

Thanks,
Ronie

*This post is locked for comments

I have the same question (0)
  • Jonathan Fear Profile Picture
    Jonathan Fear on at

    Do you have a Dexsql.log? DId you switch all the databases to 100 compatibility level?

  • Jonathan Fear Profile Picture
    Jonathan Fear on at

    Any update on this Ronie?

  • Ronie Profile Picture
    Ronie 1,080 on at

    Hi Jonathan,

    Sorry for late reply this is due to our long holiday in our country, yes I switch all the databases to 100 compatibility level, however I found out the cause of the error this is due to the connection interruption (logged off/disconnected) during upgrade, the SQL server automatic stop with no reason during upgrade.

    This time I already done my upgrade. Than you for you time.

    Thanks,

    Ronie

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans