Forum Replies Created
Shahab QamarParticipantJuly 21, 2021 at 4:58 amPost count: 3
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 QamarParticipantMay 5, 2021 at 12:44 amPost count: 3
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.