Skip to main content
Question

Problem with SQL server connection in translation

  • December 23, 2013
  • 1 reply
  • 8 views

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

 

1 reply

fmelizard
Safer
Forum|alt.badge.img+19
  • 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.

 

 

 

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings