Skip to Content
avatar image
Former Member

SQL server login failed

Hi,

My client using MSSQL 2008 with sap 2007B patch 10 level.

But workstations is not get conneted with the server.

When user selecting server IP or name in window by changing "Change server" button and giving sa login name.

The following error window appears.

"connection failed :sql state ;01000

SQL server error :1326

Microsoft ODBC SQL Server Driver][DBNETLIB]connectionOpen

Connection failed

SQL state :08001

SQL server error :17

{Microsoft ][Odbc sql server driver][DBNETLIB]Sql server does not exists.

Please reply me urgently.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Jul 24, 2009 at 09:45 AM

    Hi Hemkanya,

    1.Check Are u installed SAP Native client in your client machine

    2.Use trusted connection

    *Close the thread if issue solved.

    Regards

    Jambulingam.P

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      I have installed SAP client on all the workstations.

      All workstations connected to Domain.

      Please help me to get the solution.

      Regards

  • avatar image
    Former Member
    Jul 24, 2009 at 10:23 AM

    Hi,

    I misspelled SQL Native Client not SAP client.

    Regards

    Jambulingam.P

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      Is it necessary to installed SQL native client on all workstations?

      Please explain me because on all workstation DIAPI,Client is installed.and from where i can get ODBC files.

      Please provide me detail info on this.

      regards,

  • avatar image
    Former Member
    Jul 24, 2009 at 05:48 PM

    MSSQL 2008 need special client that is different from SQL 2005 Native Client. Check it out what SQL client is in use.

    Thanks,

    Gordon

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi ,

      Please let me know what special client is required for SQL 2008.

      I have installed SAP client,DIAPI.but getting error.

      Please provide the solution

      Regards,

      Hemkanya

  • avatar image
    Former Member
    Jul 27, 2009 at 02:49 PM
    Add comment
    10|10000 characters needed characters exceeded