SQL server login failed

[Former Member]

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.

[Former Member]

You may check these links to get more info:

http://social.msdn.microsoft.com/forums/en-US/sqldataaccess/thread/daece53a-aa18-4c70-88c6-c4b2492b7...

http://social.msdn.microsoft.com/Forums/fr-FR/sqldataaccess/thread/6980a972-637e-4291-a628-14ad92825...

http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/e5871084-cfe1-43cd-a405-73d86a532...

[Former Member]

Thanks Gorden,

Links provided are very useful.

I will follow the steps and inform you the outcomes

[Former Member]

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

Thanks,

Gordon

[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

[Former Member]

Hi,

I misspelled SQL Native Client not SAP client.

Regards

Jambulingam.P

[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,

[Former Member]

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

[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