Error Trying to Setup Sys DSN

Question

Error Trying to Setup Sys DSN

ScottDog129

SSC Rookie

Points: 34
More actions
January 20, 2015 at 12:20 pm

#300538

I have a Win7 Pro client computer trying to connect to a GreatPlains SQL database using System DSN. I can enter an IP address followed by the instance, but I cannot enter a server name. The server name, however, resolves on the PC in other areas.
The server is logging the following error:
And the client is showing this error when trying to connect in GreatPlains:
Can someone possibly help?

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Sean Lange SSC Guru Points: 286609 More actions · Answer 1

scottthompson (1/20/2015)
I have a Win7 Pro client computer trying to connect to a GreatPlains SQL database using System DSN. I can enter an IP address followed by the instance, but I cannot enter a server name. The server name, however, resolves on the PC in other areas.
The server is logging the following error:
And the client is showing this error when trying to connect in GreatPlains:
Can someone possibly help?

Can you post the actual error messages instead of an image? The images will not resolve on this end for me. Not sure if it our netnanny or the images are just rubbish.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

ScottDog129 SSC Rookie Points: 34 More actions · Answer 2

My apologies. Here is the server error:

"Login failed for user 'user'. Reason: Password did not match that for the login provided. [CLIENT: 192.168.1.45]"

And the error on the workstation when trying to connect to GP:

"Connection failed:

SQLState: '08001'

SQL Server Error: 10061

[Microsoft][SQL Server Native CLient 10.0]TCP Provider: No connection

could be make because the target machine actively refused it."