sqlServer - ODBC - WebServices

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TheMaxx - 17 Nov 2006 12:44 GMT

I've created ODBC DSN for sql server.
When i connect from win application works OK.
When i make WebService (on same machine) that connects to that ODBC
connection fails:

Error:
Server was unable to process request. --> ERROR [28000] [Microsoft][ODBC SQL
Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not
associated with a trusted SQL Server connection.
ERROR [28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed
for user '(null)'. Reason: Not associated with a trusted SQL Server
connection.

ODBC is configured to use SQL Server authentication (login id and passwd)

Reply to this Message

Jani Järvinen [MVP] - 17 Nov 2006 14:44 GMT

TheMaxx,

> I've created ODBC DSN for sql server.
> When i make WebService (on same machine) that connects to that ODBC
[quoted text clipped - 4 lines]
> Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not
> associated with a trusted SQL Server connection.

This error can be caused by several conditions, most common ones being
listed here (along with workarounds):

http://support.microsoft.com/kb/889615

If this document doesn't solve your issue, then we would need more
information, such as:

- your SQL Server version
- operating system(s) you run your application on
- your SQL Server's security setting configrations
- etc.

Signature

Regards,

Mr. Jani Järvinen
C# MVP
Helsinki, Finland
janij@removethis.dystopia.fi
http://www.saunalahti.fi/janij/

Reply to this Message

chanmm - 18 Nov 2006 03:58 GMT

Have you tried to type the username and password directly to the SQL
Management Studio and see whether it is able to login?

chanmm

> I've created ODBC DSN for sql server.
> When i connect from win application works OK.
[quoted text clipped - 11 lines]
>
> ODBC is configured to use SQL Server authentication (login id and passwd)

Reply to this Message

DG - 18 Nov 2006 21:40 GMT

Yes, and it works OK.
Also when i test ODBC connection from ODBC management it's ok.
Also from Win application everything is ok.

> Have you tried to type the username and password directly to the SQL
> Management Studio and see whether it is able to login?
[quoted text clipped - 16 lines]
>>
>> ODBC is configured to use SQL Server authentication (login id and passwd)

Reply to this Message

sqlServer - ODBC - WebServices

Free Magazines