Hi all!

 

I am trying to connect to SQL database hosted in MS SQL server, located in Azure. 

 

My setup: 

Server

- Win 2012 Server, FMS 13 Advanced,

- ODBC Driver: ODBC Driver 11 for SQL Server 11.0.2270.0 (64-bit)

Clients: 

- FMSA 13, tried MAC & WIN

 

 

Setting up System DNS without problems, test completed succesfully

 

Added this DNS as external DataSource in my DB.

 

When trying to add TO to Relationships graph , get the message: 

 

SQL Database & All its Tables and Views shows in "Specify Table" Dialog

 

"This action cannot be performed because the required table is missing"

 

 

I though that the credentials for SQL Database does not allow to see tables/ edit data. But the SQL database guy said that I have all rights there. At the moment, I can't check it

 

I am new to MS SQL connection, but done quite a lot work with MySQL databases. 

 

I would be happy to get some hints what to do. The database guy in SQL side is not very helpful. 

 

rgdrs, Martti 

 

 

What userid are you using in your dsn? is it windows authentication or specified?

If you have a separate userid, try connecting directly to SQL using it with SQL Studio.

That way you can rule out SQL Permissions.

 

I know I had to set connect permissions on SQL.