Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • Shahab Qamar
    Participant
    July 21, 2021 at 4:58 am
    Post count: 3
    in reply to: Errors with creating the first super user (Tabbles LAN over AWS MSSQL) #15755

    Hi Andrea,

    Hope you are well. I have an update on the Tabbles LAN setup. Instead of AWS, I went for Azure SQL Server as it has better compatibility with Microsoft.

    I setup SQL Server Management Studio on a local Windows machine and then had Tabbles create a DB and super user on it. I confirmed that Tabbles was able to login and work with the application.

    I then used the Microsoft Data Migration Assistant (https://docs.microsoft.com/en-us/sql/dma/dma-overview?view=sql-server-ver15) to export the data/schemas to the SQL server/db in our Azure tenancy. Besides some warning arounds slow join statements, everything went smoothly and all tables/schemas appeared dine in Azure SQL db.

    Tabbles is now able to connect to the Azure DB however I am stuck with the same error:

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

    where tabbles593 is the restricted user Tabbles created during the DB setup.

    Going forward, what is your advice?

    Shahab Qamar
    Participant
    May 5, 2021 at 12:44 am
    Post count: 3
    in reply to: Errors with creating the first super user (Tabbles LAN over AWS MSSQL) #15669

    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.

  • Author
    Posts
Viewing 2 posts - 1 through 2 (of 2 total)