Home Forums Help needed Errors with creating the first super user (Tabbles LAN over AWS MSSQL)

Tagged: 

Viewing 2 reply threads
  • Author
    Posts
    • AvatarShahab Qamar
      Participant
      Post count: 2

      Hi,

      I am getting errors when following the “Create database” step within the Tabbles LAN tab.  The error log contains the following:

      6:16:04 PM:39 Sql Error: 6:16:04 PM: creating-db-part-2 – exception: System.Data.SqlClient.SqlException number 15247 , state 1 – User does not have permission to perform this action.
      ALTER DATABASE statement failed. 5.9.3 4/28/2021

      6:16:05 PM:83 Sql Error: 6:16:05 PM: creating-db-part-2 – exception: System.Data.SqlClient.SqlException number 15247 , state 1 – User does not have permission to perform this action.
      ALTER DATABASE statement failed. 5.9.3 4/28/2021

      6:16:07 PM:27 Sql Error: 6:16:07 PM: creating-db-part-2 – exception: System.Data.SqlClient.SqlException number 15247 , state 1 – User does not have permission to perform this action.
      ALTER DATABASE statement failed. 5.9.3 4/28/2021

      Looking directly at the DB server, I can see that the tabbles DB gets created OK but its the creation of the SQL server login with restricted permissions thats failing.

      I have also attempted to Create the superuser manually but its receiving the following error:

      Login failed for user tabbles4
      SQL Exception Number = 18456, state = 1

      My MSSQL server is hosted on AWS RDS: https://aws.amazon.com/rds/sqlserver/ and I am using the DB master user/pass to authenticate. Would appreciate help with identifying the cause of this problem.

      Cheers,
      Shahab

      Attachments:
    • AndreaAndrea
      Keymaster
      Post count: 937

      Hi Shahab,

      we don’t really have experience with this. We had issues a few years back to install Tabbles Database on an MSSQL server in Azure, because of some SQL statements were not supported.

      We think that we could try is, to create a database on a regular MSSQL (we can do it for you) do a backup and then restore it in Azure. Could this work for you?

    • AvatarShahab Qamar
      Participant
      Post count: 2

      Hi Andrea, thanks for getting back.

      I have a local instance of MSSQL DB running. I will try exporting/restoring in our AWS RDS and see how I go. Will report back my findings.

Viewing 2 reply threads
  • You must be logged in to reply to this topic.