You are viewing limited content. For full access, please sign in.

Discussion

Discussion

Azure DBs for repositories

Version 11 Self-Hosted Administration How To
Updated February 11
posted on May 3, 2024

Hello all, 

I'm starting to try and test Azure DB's for our system. All my LF servers are running in Azure VMs right now but I want to get rid of the MSSQL server and replace them with the Azure DBs. I have already migrated them to Azure and I'm trying to change the DBMS connection in Admin console. I used the host path for the server and name-provided credentials and it won't find the DB. 
Am I missing anything? I can't change the DB type in admin console. Is there a different process for this? 

Thanks. 

0 0
replied on May 6, 2024

Can you elaborate on "won't find the DB"?

Across all Laserfiche applications, the database type is the same MS SQL. Really all that setting means is "Use the Microsoft SQL Driver", which is shared by SQL Server, Azure SQL Managed Instance, and Azure SQL Database.

If you're referring to the dropdown list of discoverable SQL instances, that's looking for instances running the SQL Server Brower service on port 1434. Azure SQL does not, to my knowledge, run this service.

With Azure SQL Database or Managed Instance, you put in the logical "server name", the database name, and valid username/password credentials, then hit next. 

If you're having connectivity issues, temporarily install SQL Management Studio on the same machine and validate that you can connect to the database from there using the same hostname/database name/credentials.

2 0
replied on May 7, 2024

Thanks for the response, Samuel. I was referring to the dropdown. I did get it working after I found another issue with my account not having DB owner role. It makes sense that the server drop-down won't work with the information you provided. I would love to see formal support for Azure DB in Laserfiche. It was making me nervous at first in the change DBMS wizard for the repositories. The DBMS is locked to Microsoft SQL Server. I would love to have the option to select Azure DB. It would be a little more user-friendly. 

Thanks again.

0 0
replied on May 7, 2024 • Show version history

I would love to see formal support for Azure DB in Laserfiche.

It is. See the Supported Configurations page:

Database Engines:

The "SQL Server" UI option in the installers/repo wizard is essentially a relic from when Laserfiche used to support both Microsoft SQL Server and Oracle Database. There was a radio button to select which database engine/driver to use. Now that Oracle support is no more, only the "SQL Server" option remains. Removing the Oracle radio button option was easier than reworking the installer (which is notoriously difficult to modify). 

If you look at Microsoft's ODBC Driver for SQL Server download page, you'll note it says right at the top:

Applies to:  SQL Server  Azure SQL Database  Azure SQL Managed Instance

There's no separate "Microsoft ODBC Driver for Azure SQL". 

Re:

I would love to have the option to select Azure DB. It would be a little more user-friendly. 

Because SQL Server, Azure SQL Database, and Azure SQL Managed Instance all use the same "Microsoft ODBC Driver for SQL Server" or "Microsoft ADO.NET for SQL Server" driver with the same parameters, having an "Azure SQL" option wouldn't do anything. The exact same server/database/credential values get dropped into the same connection string regardless of which flavor of Microsoft SQL is on the backend.

1 0
replied on May 8, 2024

That all makes sense. Thanks Samuel. 

1 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...