Skip to main content
Solved

login refused by sql server

A

This is error message on the FME server.

Microsoft SQL Server Spatial Reader: Connection failed. Connection string `Provider=SQLNCLI11;DataTypeCompatibility=80;Data Source=gis02;Initial Catalog=nlpglive;Integrated Security=SSPI'. Provider error `(-2147467259) Cannot open database "nlpglive" requested by the login. The login failed.

However, on the desktop I almost the same error when I try to list the tables in the above database

Server 2012 Native Client...

Microsoft SQL Server Non-Spatial Reader: Connection failed. Connection string `Provider=SQLNCLI11;DataTypeCompatibility=80;Data Source=gis02\\sqlexpress;User ID=;Password=********'. Provider error `(-2147217843) Invalid authorization specification'

However, when I test the connection it is OK and successful

If I use a reader or writer I can see all the tables !

Any ideas? I have tried SQL Authentication for various local and domain accounts still the same issue.

Best answer by andygale

Now resolved. There needs to be a domain account and a local account with the same password details.

View original
Did this help you find an answer to your question?

3 replies

oscard
Influencer
Forum|alt.badge.img+21
  • oscardInfluencer
  • Influencer
  • March 22, 2018
In Server you are using a Sptial Reader and in Desktop a Non-Spatial?

 

 

Have you tried the Microsoft SQL Server JDBC and non-JDBC Readers?

 

 

A
  • andygale
  • Author
  • March 22, 2018

They are the same readers as it is published to FME server.

Both non and spatial work on the desktop.

A
  • andygale
  • Author
  • Best Answer
  • March 22, 2018

Now resolved. There needs to be a domain account and a local account with the same password details.

Reply


Helpful Members This Week

Community Stats

31,014
Posts
117,531
Replies
38,792
Members

Latest FME

Terms & ConditionsCookie settings

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
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.