We have group added in SQL Server, this group had a 5 AD accounts. We grante
d
access to the SQL Server to that group.
Two people able to successfully created ODBC connection from work station A.
Other three was not able to create ODBC connection fron any workstation. It
is working for all other people from any workstation, only these three peopl
e
had a problem from any workstation:
The error meaggage in SQL Server Error Log:
Message
The login packet used to open the connection is structurally invalid; the
connection has been closed. Please contact the vendor of the client library.
[CLIENT: 192.168.149.4]
Message
Error: 17832, Severity: 20, State: 8.
any help will be appreciated.THis is SQL Server 2005 SP1.
"Sri" wrote:
> We have group added in SQL Server, this group had a 5 AD accounts. We gran
ted
> access to the SQL Server to that group.
> Two people able to successfully created ODBC connection from work station
A.
> Other three was not able to create ODBC connection fron any workstation. I
t
> is working for all other people from any workstation, only these three peo
ple
> had a problem from any workstation:
> The error meaggage in SQL Server Error Log:
> Message
> The login packet used to open the connection is structurally invalid; the
> connection has been closed. Please contact the vendor of the client librar
y.
> [CLIENT: 192.168.149.4]
> Message
> Error: 17832, Severity: 20, State: 8.
> any help will be appreciated.|||It looks more likely related to PC and not the people in particular.
Did you check MDAC on the machines? You can use component checker to
verity the MDAC versions and installations:
You can download the tool from:
http://msdn2.microsoft.com/en-us/data/aa937730.aspx
Have you looked for other configuration, service pack differences for
the PCs?
-Sue
On Mon, 12 Mar 2007 10:51:33 -0700, Sri
<Sri@.discussions.microsoft.com> wrote:
>We have group added in SQL Server, this group had a 5 AD accounts. We grant
ed
>access to the SQL Server to that group.
>Two people able to successfully created ODBC connection from work station A
.
>Other three was not able to create ODBC connection fron any workstation. It
>is working for all other people from any workstation, only these three peop
le
>had a problem from any workstation:
>The error meaggage in SQL Server Error Log:
>Message
>The login packet used to open the connection is structurally invalid; the
>connection has been closed. Please contact the vendor of the client library
.
>[CLIENT: 192.168.149.4]
>Message
>Error: 17832, Severity: 20, State: 8.
>any help will be appreciated.
Wednesday, March 21, 2012
ODBC connection Failure
Labels:
connection,
database,
failure,
grantedaccess,
group,
microsoft,
mysql,
odbc,
oracle,
server,
sql,
successfully
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment