problem logging onto Great Plains.

I have a user who is trying to log into Great Plains. It uses SQL Server
2000 which is on the same server. HE gets the following error message:
"Error occurred creating the pass-through SQL connection.:0"
When he clicks OK a second message comes up that says: "You're attempting to
log in from a data source using a trusted connection. Update the SQL server
settings for this data source to disable trusted connections and try logging
in again."
Could you please explain what this means and how do I do this.
Thank you
Davidi do not use Great Plains, but it sounds like you are trying to log in
using your NT/Domain account instead of the sql login.|||GreatPlains need a SQL connection. When you try to login you have a window
that indicate a server. This server is in fact an ODBC. The ODBC need to
use a SQL server authentification to be used to log in Great Plains.
"David Goldberg" wrote:

> I have a user who is trying to log into Great Plains. It uses SQL Server
> 2000 which is on the same server. HE gets the following error message:
> "Error occurred creating the pass-through SQL connection.:0"
> When he clicks OK a second message comes up that says: "You're attempting
to
> log in from a data source using a trusted connection. Update the SQL serv
er
> settings for this data source to disable trusted connections and try loggi
ng
> in again."
> Could you please explain what this means and how do I do this.
> Thank you
> David|||what string are you trying to log in with?|||No. He is using his SQL server account. I know this to be true because he
tried logging in from another machine and he could get in. It is only on hi
s
machine that this problem is occurring. I also hadanother user try to log i
n
on that machine and they could not. It appears to be machine related.|||so if he uses his same login on another machine it works, just not on
his machine? are they inside the same firewall?|||YES.|||You need to change the ODBC DSN using the ODBC control panel. Find the DSN
in the ODBC Data Source Administrator, select it and choose Configure. On
the second page you find the option "How should SQL Server verify the
authenticity of the login ID?" Make sure the SQL Server authentication
option is selected.
Mike
"David Goldberg" <DavidGoldberg@.discussions.microsoft.com> wrote in message
news:84305A48-4487-4DD2-BCAF-EA1065035D10@.microsoft.com...
>I have a user who is trying to log into Great Plains. It uses SQL Server
> 2000 which is on the same server. HE gets the following error message:
> "Error occurred creating the pass-through SQL connection.:0"
> When he clicks OK a second message comes up that says: "You're attempting
> to
> log in from a data source using a trusted connection. Update the SQL
> server
> settings for this data source to disable trusted connections and try
> logging
> in again."
> Could you please explain what this means and how do I do this.
> Thank you
> David

problem logging onto Great Plains.

I have a user who is trying to log into Great Plains. It uses SQL Server
2000 which is on the same server. HE gets the following error message:
"Error occurred creating the pass-through SQL connection.:0"
When he clicks OK a second message comes up that says: "You're attempting to
log in from a data source using a trusted connection. Update the SQL server
settings for this data source to disable trusted connections and try logging
in again."
Could you please explain what this means and how do I do this.
Thank you
David
i do not use Great Plains, but it sounds like you are trying to log in
using your NT/Domain account instead of the sql login.
|||GreatPlains need a SQL connection. When you try to login you have a window
that indicate a server. This server is in fact an ODBC. The ODBC need to
use a SQL server authentification to be used to log in Great Plains.
"David Goldberg" wrote:

> I have a user who is trying to log into Great Plains. It uses SQL Server
> 2000 which is on the same server. HE gets the following error message:
> "Error occurred creating the pass-through SQL connection.:0"
> When he clicks OK a second message comes up that says: "You're attempting to
> log in from a data source using a trusted connection. Update the SQL server
> settings for this data source to disable trusted connections and try logging
> in again."
> Could you please explain what this means and how do I do this.
> Thank you
> David
|||what string are you trying to log in with?
|||No. He is using his SQL server account. I know this to be true because he
tried logging in from another machine and he could get in. It is only on his
machine that this problem is occurring. I also hadanother user try to log in
on that machine and they could not. It appears to be machine related.
|||so if he uses his same login on another machine it works, just not on
his machine? are they inside the same firewall?
|||YES.
|||You need to change the ODBC DSN using the ODBC control panel. Find the DSN
in the ODBC Data Source Administrator, select it and choose Configure. On
the second page you find the option "How should SQL Server verify the
authenticity of the login ID?" Make sure the SQL Server authentication
option is selected.
Mike
"David Goldberg" <DavidGoldberg@.discussions.microsoft.com> wrote in message
news:84305A48-4487-4DD2-BCAF-EA1065035D10@.microsoft.com...
>I have a user who is trying to log into Great Plains. It uses SQL Server
> 2000 which is on the same server. HE gets the following error message:
> "Error occurred creating the pass-through SQL connection.:0"
> When he clicks OK a second message comes up that says: "You're attempting
> to
> log in from a data source using a trusted connection. Update the SQL
> server
> settings for this data source to disable trusted connections and try
> logging
> in again."
> Could you please explain what this means and how do I do this.
> Thank you
> David

problem logging onto Great Plains.

I have a user who is trying to log into Great Plains. It uses SQL Server
2000 which is on the same server. HE gets the following error message:
"Error occurred creating the pass-through SQL connection.:0"
When he clicks OK a second message comes up that says: "You're attempting to
log in from a data source using a trusted connection. Update the SQL server
settings for this data source to disable trusted connections and try logging
in again."
Could you please explain what this means and how do I do this.
Thank you
Davidi do not use Great Plains, but it sounds like you are trying to log in
using your NT/Domain account instead of the sql login.|||GreatPlains need a SQL connection. When you try to login you have a window
that indicate a server. This server is in fact an ODBC. The ODBC need to
use a SQL server authentification to be used to log in Great Plains.
"David Goldberg" wrote:
> I have a user who is trying to log into Great Plains. It uses SQL Server
> 2000 which is on the same server. HE gets the following error message:
> "Error occurred creating the pass-through SQL connection.:0"
> When he clicks OK a second message comes up that says: "You're attempting to
> log in from a data source using a trusted connection. Update the SQL server
> settings for this data source to disable trusted connections and try logging
> in again."
> Could you please explain what this means and how do I do this.
> Thank you
> David|||what string are you trying to log in with?|||No. He is using his SQL server account. I know this to be true because he
tried logging in from another machine and he could get in. It is only on his
machine that this problem is occurring. I also hadanother user try to log in
on that machine and they could not. It appears to be machine related.|||so if he uses his same login on another machine it works, just not on
his machine? are they inside the same firewall?|||YES.|||You need to change the ODBC DSN using the ODBC control panel. Find the DSN
in the ODBC Data Source Administrator, select it and choose Configure. On
the second page you find the option "How should SQL Server verify the
authenticity of the login ID?" Make sure the SQL Server authentication
option is selected.
Mike
"David Goldberg" <DavidGoldberg@.discussions.microsoft.com> wrote in message
news:84305A48-4487-4DD2-BCAF-EA1065035D10@.microsoft.com...
>I have a user who is trying to log into Great Plains. It uses SQL Server
> 2000 which is on the same server. HE gets the following error message:
> "Error occurred creating the pass-through SQL connection.:0"
> When he clicks OK a second message comes up that says: "You're attempting
> to
> log in from a data source using a trusted connection. Update the SQL
> server
> settings for this data source to disable trusted connections and try
> logging
> in again."
> Could you please explain what this means and how do I do this.
> Thank you
> David