• State Not Answered
  • Locked Locked
  • Replies 3 replies
  • Subscribers 59 subscribers
  • Views 6281 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

SQL Grant permission script error

sriram_sivakumar
over 6 years ago

Dear All, 

 

 We have recently upgraded the  Database cartridge to 5.7.5.35.  We are trying to configure a SQL 2012 DB, when we try to manually execute the Grant permission script  we are receiving the below error.

msg 207, Level 16, state 1 line 27

Invalid column name 'srvid'

msg 207, Level 16, state 1 line 28

Invalid column name 'xstatus'

Kindly assist.

 

Parents
  • 0 over 6 years ago
    Hello Sriram,

    The script is for SQL Server 2005 - 2014. I just checked myself and I found the same script in cartridge version 5.7.5.36.
    You are correct, according to the release notes we support SQL Server 2016.
    So there might be a bug in this script.

    Please raise a service request for this issue, so we can properly track it.

    Regards
    Nicola
Reply
  • 0 over 6 years ago
    Hello Sriram,

    The script is for SQL Server 2005 - 2014. I just checked myself and I found the same script in cartridge version 5.7.5.36.
    You are correct, according to the release notes we support SQL Server 2016.
    So there might be a bug in this script.

    Please raise a service request for this issue, so we can properly track it.

    Regards
    Nicola
Children
No Data