471,595 Members | 2,020 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,595 software developers and data experts.

sqlServer - ODBC - WebServices

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)
Nov 17 '06 #1
3 3180
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/
Nov 17 '06 #2
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)

Nov 18 '06 #3
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)


Nov 18 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Peter Morris | last post: by
1 post views Thread by Michael Peters | last post: by
reply views Thread by TheMaxx | last post: by
reply views Thread by leo001 | last post: by
reply views Thread by Anwar ali | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.