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
ja***@removethis.dystopia.fi
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

"TheMaxx" <th***********@net.hrwrote in message
news:ej**********@magcargo.vodatel.hr...

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)

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

"chanmm" <ch*****@hotmail.comwrote in message
news:uL*************@TK2MSFTNGP06.phx.gbl...

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

chanmm

"TheMaxx" <th***********@net.hrwrote in message
news:ej**********@magcargo.vodatel.hr...

>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)