Topic
1 reply Latest Post - ‏2013-02-06T17:34:39Z by SystemAdmin
SystemAdmin
SystemAdmin
1632 Posts
ACCEPTED ANSWER

Pinned topic Data Studio V3.2 - Error connecting to a MS-SQL 2008 Source

‏2013-02-01T17:52:43Z |
Hi:

In my current pursue of integrating both our DBMS tecnologies (DB2 LUW and MS-SQL 2008), I was trying to connect to a MS-SQL 2008 database.

When I try the connection, I get an error box with the following message:

'Version 8 of SQL Server is not compatible with this driver'

I downloaded this sqljdbc4.jar from Microsoft's download site....and I was wondering if it is the correct version....

Any hints would be greatly appreciated...

Regards
Enrique Valdez
Buenos Aires - ARGENTINA
Updated on 2013-02-06T17:34:39Z at 2013-02-06T17:34:39Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    1632 Posts
    ACCEPTED ANSWER

    Re: Data Studio V3.2 - Error connecting to a MS-SQL 2008 Source

    ‏2013-02-06T17:34:39Z  in response to SystemAdmin
    Hi all:

    Finally I found what I was doing wrong....

    I was told that I was connecting to a MSSQL Server 2008....and it was actually a MSSQL Server 2000....

    I got the correct drivers, and I was finally able to connect to it....or sort of...

    Now I'm getting error with my userid. I don't know what's the problem since I can connect and perform admin tasks thru the native SQL Server Management Studio tool using the windows domain userid....

    Well....if this rings any bell, your help would be greatly appreciated !!

    Regards.
    Enrique Valdez