sqlServer - ODBC - WebServices

[TheMaxx]

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)

 

[Jani Järvinen [MVP]]

TheMaxx,

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

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.

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.

--
Regards,

Mr. Jani Järvinen
C# MVP
Helsinki, Finland
(e-mail address removed)
http://www.saunalahti.fi/janij/

 

[chanmm]

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

chanmm

 

[DG]

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?

chanmm

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)