Hello everyone!
There is a SQL Server named on my local machine, for testing purposes.
I can not connect the fme to sql, no matter what I write in the login line,
He's giving me an error.
What am I doing wrong?
Thank you!
Question
Connect to sql server on my local machine
+47- Celebrity
Can you connect to it with other tools other than FME. Are you sure the 'Server:' is correct?
+5- Contributor
Can you connect to it with other tools other than FME. Are you sure the 'Server:' is correct?
Hey @virtualcitymatt ,
Thanks for answer me.
In fact no,
I tried through GIS, and failed.
I'm relatively new to SQL, maybe I'm not writing the address properly?
This is what it looks like in SQL settings:
+47- Celebrity
Try and use localhost as the hostname, this should just be your computer. I'm not familiar with SQL Server either, however, usually hostnames are just a computer/server. When something is running on your own computer you can use localhost.
+5- Contributor
Try and use localhost as the hostname, this should just be your computer. I'm not familiar with SQL Server either, however, usually hostnames are just a computer/server. When something is running on your own computer you can use localhost.
Thank you,
But it still does not work ..
Maybe need to put a specific IP address?
+47- Celebrity
Thank you,
But it still does not work ..
Maybe need to put a specific IP address?
Hmm, ok maybe try .\\SQLEXPRESS
From here: https://stackoverflow.com/questions/11425275/connecting-to-sql-server-express-what-is-my-server-name
or localhost\\SQLEXPRESS
Perhaps you'll find some other helpful info in the link above
+5- Contributor
Thank you,
But it still does not work ..
Maybe need to put a specific IP address?
Still nothing..
I think it has to do with the definition of the SQLSERVER itself ..
But I did everything according to the instructions.
+61
Probably related: https://community.safe.com/s/article/workarounds-to-known-issues-in-fme-2020x
FME Desktop: SQL Server driver missing in the installer
Problem: If attempting to connect to SQL Server on a new system with no previous install of FME Desktop 2020.0, you may encounter a missing driver error.
Workaround: If you are unable to connect to a SQL Server database, install the MSOLEDBSQL driver that is present in the FME Desktop installer. Searching in your FME install directory for 'MSOLEDBSQL' should bring up the installer. If you run that installer, and re-launch FME Workbench it should connect to SQL Server as expected.