Re: SQL Server 2005 Connection Problem

Il giorno ven, 06/06/2008 alle 11.50 -0400, Mat W ha scritto:
> I'm sure someone must have had something similar to this.  
>  
> I have a FC8 box trying to connect to a MSSQL 2005.  Took awhile to get all the bits together and I think I'm good, but now I get some errors.  Looks like I'm almost there.  But I think I'm needing to tweak some settings somewhere to get the connection to go through.  I read something about about a "tokensize" registry setting but it involves rebooting my server which I'd rather avoid until I'm a bit more sure may fix it.
>  
> Here's the SQL2005 error:
> Event Type: ErrorEvent Source: MSSQLSERVEREvent Category: (4)Event ID: 17832Date:  6/6/2008Time:  11:36:11 AMUser:  N/AComputer: <obscured>Description: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: <obscured>]
> For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.Data:0000: a8 45 00 00 14 00 00 00   <obscured>0008: 09 00 00 00 42 00 45 00   <obscured>0010: 4c 00 4c 00 41 00 47 00   <obscured>
> 0018: 49 00 4f 00 00 00 00 00   <obscured>0020: 00 00                     ..      
> And on my FreeDTS log... 
>  

You are using wrong TDS protocol version. Use 8.0 

freddy77