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Â
Â
Â