Home › Forums › Help needed › Errors with creating the first super user (Tabbles LAN over AWS MSSQL) › Reply To: Errors with creating the first super user (Tabbles LAN over AWS MSSQL)
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?