Skip to main content
Question

FME Sql reader help

  • May 5, 2016
  • 1 reply
  • 14 views
amgaad
Contributor
Forum|alt.badge.img+3

Hi, I am new to FME, just learning bits and bobs as I go.

I am trying to connect an sql reader to a non spatial sql server.

No matter what I fill in for the connection it fails. The sql server is on a another pc which is part of a domain. For the server field of reader should I be writing an ip address or domain name or pc name too?

Any guidance would be appreciated.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

C
Forum|alt.badge.img
  • candimk
  • May 5, 2016

@amgaad - You should just be able to type in the server name. If you use management studio, it is the same server name you connect using that (see below). Shouldn't need anything else. The database name is whatever your database is called (not the table, but the database). Also make sure you have the correct authentication set. If you use windows auth, make sure you have the correct permissions to connect to the database, if not you won't be able to connect.

What error are you specifically getting? Is it that the user/password failed, or that it can't find the server?

Community Stats

32,207
Posts
122,305
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.