ODBC Driver .... User cannot login ...

Although I am not working on the systems right now, while setting up replication, all of a sudden both systems began giving this error when I attempted to access the Web Portal login screen.
Any suggestions.yep...some sql servers when set up may have been set up using collations that are case sensitive, which means that usernames & passwords will be case sensitive also.

Also, make sure the ODBC is set up to use TCP sockets ( if 7,2000 ) or named pipes if 6.5 ...just seems to be better that way.

Also make sure that you have at least one database the login has access to & the login has access granted to it.

Post back if probs.

J.

ODBC Connection to SQL Server

I am setting up SQL Server ODBC connections on 5 machines
and everything has gone fine until I came to the last
machine.
When I go to choose the server I want to connect to from
the server drop down list, it isn't there. There other
machines listed, but not the one that I want.
The only difference is that this one has 2000 pro, while
all of the others have XP pro. I am assuming that I need
to update something on the 2000 machine, but don't know
what. Can anyone help me with this?
Thanks in advance.You should check the MDAC version, installation on the
machine that's having problems. If the versions are
different between the xp machines and the 2000 machine,
you'd want to upgrade the 2000 machine to the same MDAC
version.
You can download the MDAC component checker
from:
http://msdn.microsoft.com/data/down...ls/default.aspx
-Sue
On Fri, 16 Apr 2004 07:52:32 -0700, "Mark Kovach"
<anonymous@.discussions.microsoft.com> wrote:

>I am setting up SQL Server ODBC connections on 5 machines
>and everything has gone fine until I came to the last
>machine.
>When I go to choose the server I want to connect to from
>the server drop down list, it isn't there. There other
>machines listed, but not the one that I want.
>The only difference is that this one has 2000 pro, while
>all of the others have XP pro. I am assuming that I need
>to update something on the 2000 machine, but don't know
>what. Can anyone help me with this?
>Thanks in advance.|||Thanks. I downloaded MDAC 2.8 and installed it. It
works great now.
Thank you for the help.

>--Original Message--
>You should check the MDAC version, installation on the
>machine that's having problems. If the versions are
>different between the xp machines and the 2000 machine,
>you'd want to upgrade the 2000 machine to the same MDAC
>version.
>You can download the MDAC component checker
>from:
>http://msdn.microsoft.com/data/down...ools/default.as
px
>-Sue
>On Fri, 16 Apr 2004 07:52:32 -0700, "Mark Kovach"
><anonymous@.discussions.microsoft.com> wrote:
>
machines[vbcol=seagreen]
from[vbcol=seagreen]
while[vbcol=seagreen]
need[vbcol=seagreen]
>.
>

ODBC Connection to SQL Server

I am setting up SQL Server ODBC connections on 5 machines
and everything has gone fine until I came to the last
machine.
When I go to choose the server I want to connect to from
the server drop down list, it isn't there. There other
machines listed, but not the one that I want.
The only difference is that this one has 2000 pro, while
all of the others have XP pro. I am assuming that I need
to update something on the 2000 machine, but don't know
what. Can anyone help me with this?
Thanks in advance.
You should check the MDAC version, installation on the
machine that's having problems. If the versions are
different between the xp machines and the 2000 machine,
you'd want to upgrade the 2000 machine to the same MDAC
version.
You can download the MDAC component checker
from:
http://msdn.microsoft.com/data/downl...s/default.aspx
-Sue
On Fri, 16 Apr 2004 07:52:32 -0700, "Mark Kovach"
<anonymous@.discussions.microsoft.com> wrote:

>I am setting up SQL Server ODBC connections on 5 machines
>and everything has gone fine until I came to the last
>machine.
>When I go to choose the server I want to connect to from
>the server drop down list, it isn't there. There other
>machines listed, but not the one that I want.
>The only difference is that this one has 2000 pro, while
>all of the others have XP pro. I am assuming that I need
>to update something on the 2000 machine, but don't know
>what. Can anyone help me with this?
>Thanks in advance.
|||Thanks. I downloaded MDAC 2.8 and installed it. It
works great now.
Thank you for the help.

>--Original Message--
>You should check the MDAC version, installation on the
>machine that's having problems. If the versions are
>different between the xp machines and the 2000 machine,
>you'd want to upgrade the 2000 machine to the same MDAC
>version.
>You can download the MDAC component checker
>from:
>http://msdn.microsoft.com/data/downl...ols/default.as
px[vbcol=seagreen]
>-Sue
>On Fri, 16 Apr 2004 07:52:32 -0700, "Mark Kovach"
><anonymous@.discussions.microsoft.com> wrote:
machines[vbcol=seagreen]
from[vbcol=seagreen]
while[vbcol=seagreen]
need
>.
>
sql