Connect to sql server on my local machine

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:

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?

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

Still nothing..

I think it has to do with the definition of the SQLSERVER itself ..

But I did everything according to the instructions.

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.