Skip to main content
Question

Problem with SQL server connection in translation

  • December 23, 2013
  • 1 reply
  • 13 views
J
I have a translation that is taking a shp file and inputting it to SQL Server.  I can create the writer, but during the translation I get an error saying that

 

MS SQL Server (Spatial) Writer: Connection Failed.  Connection string 'Provider=SQLOLEDB;Data Source=srv-onscene-tes

 

Provider error '(-2147467259) [DBNETLIB] [ConnectionOpen (Connect(().] SQL server does not exist or access denied.

 

 

Any suggestions would be helpful.

 

 

Thank you,

 

Joan

 

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

fmelizard
Safer
Forum|alt.badge.img+21
  • fmelizardSafer
  • Safer
  • December 26, 2013
Hi Joan

 

When you add the writer it does not really check that the credentials are valid so here are few things to check:

 

1. In the navigator on the left check the user name, password and server name are all correct

 

2. Assuming you have a destination feature type already (which represents a destination table)  double click on it to get the properties and then go to General tab and check that the user is set to a user with access to the table you want to write to. Here is a screen shot that might help.

 

 

 

 

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.