M
mash
hi
i am getting this event logged on my client pc's when ever
i try to do a ODBC connection to my SQL server.
i suspect this is something to do with DNS or DHCP
Event Type: Warning
Event Source: MRxSmb
Event Category: None
Event ID: 3034
Date: 12/30/2003
Time: 12:40:23 PM
User: N/A
Computer: tony
Description:
The redirector was unable to initialize security context
or query context attributes.
the ODBC connection fails with the following error
Connection failed:
Sql state :'01000'
sql server error : 1396
[Microsoft][ODBC SQL server driver][named pipes]
connectionopen
(createfile())
connection failed:
SQL state:'08001'
SQL server error:1396
[Microsoft][ODBC SQL server driver]Client unable to
establish connection
i've tried some sugesstions from KB
1)synchronized the clients clock with the DC
2)disconnect the client from the domain and rejoin the
domain
3)delete the clients ip lease from DHCP and get a new lease
4) delete the clients host record from DNS and allow it to
automatically create one
5)delete the clients computer account from the domain and
recreate it.
on all of the above instances the problem gets fixed but
when the client is restarted same thing happens again
need help
thanks in advance
i am getting this event logged on my client pc's when ever
i try to do a ODBC connection to my SQL server.
i suspect this is something to do with DNS or DHCP
Event Type: Warning
Event Source: MRxSmb
Event Category: None
Event ID: 3034
Date: 12/30/2003
Time: 12:40:23 PM
User: N/A
Computer: tony
Description:
The redirector was unable to initialize security context
or query context attributes.
the ODBC connection fails with the following error
Connection failed:
Sql state :'01000'
sql server error : 1396
[Microsoft][ODBC SQL server driver][named pipes]
connectionopen
(createfile())
connection failed:
SQL state:'08001'
SQL server error:1396
[Microsoft][ODBC SQL server driver]Client unable to
establish connection
i've tried some sugesstions from KB
1)synchronized the clients clock with the DC
2)disconnect the client from the domain and rejoin the
domain
3)delete the clients ip lease from DHCP and get a new lease
4) delete the clients host record from DNS and allow it to
automatically create one
5)delete the clients computer account from the domain and
recreate it.
on all of the above instances the problem gets fixed but
when the client is restarted same thing happens again
need help
thanks in advance