473,837 Members | 1,689 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 3328
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***@removethi s.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.vod atel.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*****@hotmai l.comwrote in message
news:uL******** *****@TK2MSFTNG P06.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.vod atel.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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
3630
by: Peter Morris | last post by:
Hi, I'm having trouble connecting to SQLServer in my ASP program. here's the code <% dim objConnection, ObjRecorSet, strConnection, strOut, objCmd, objParameters Set objConnection = Server.CreateObject ("ADODB.Connection") strConnection = "DSN=SQL_Tracker;Database=Tracker;UID=sa;PWD=;" objConnection.Open strConnection ....
0
3630
by: Nilesh | last post by:
The problem i am facing is described as below: I have one client application which execute some stored procedure using SqlExecDirect and just after executing the statement if connection with SqlServer gets broken sometimes the client gets hang. Basically the response does not come from odbc statement. If i put connection time out it will return me the error that connection with sql server has been broken after the time out period.
2
2975
by: Martijn Rutte | last post by:
Hi, On one side, I have a Sybase 12.5 32 bits Server running on AIX 5.1 (maintenance level 3). On the other, I've got W2000 5.00.2195 (SP2) with SQL Server Standard Edition, Product Version 8.00.534 (SP2), having installed MDAC 2.6. I connect to the Sybase 12.5 database using Merant ASE ODBC driver for Sybase 12.5, and using the Microsoft OLE DB Provider for SQL Server that comes with this SQLServer version.
1
1564
by: Rakesh | last post by:
hello, I have a application that connects to sqlserver to get the job done. I am looking for something that will act as an inbetween layer. Basically instead of connecting direct to the sql server, my application wil connect to this layer( may be a service), this service will do something and then fwd the
2
8190
by: netx | last post by:
How to enable remote connections on TCP/IP? I have just installed for first time SqlServer 2000, and cannot connect from other host via ODBC. I give hostname or address but it does not connect. I checked on my firewall that there is no listenning socket on port 1433 nor 1440 on sqlserver host. I can only connect using "(local)" server in ODBC on sqlserver host.
2
1318
by: Ray | last post by:
Hi folks, I have a database that goes to a client for evaluation/purchase as an Access2k2FE / Access2k2 BE. When they decide to upsize to MySQL or SQL Server, I would like an easy way to allow them to switch table sources. When I try to use Linked Table Manager, and the Find a File dialog pops up, it only gives me the option to look for .mdb or *.*. I would have thought it could allow me to choose an ODBC data source, but it
1
1951
by: Michael Peters | last post by:
what does a user (running XP) need who has Access but no SQLServer, and who would like to connect to a remote SQLServer database via ODBC? This user can set up a new System DSN but he needs a SQLServer driver for this, right? which files does he need to install that? -Michael
0
1583
by: UDBDBA | last post by:
Hi: We have a setup which connects a V8.2 32bit db2 instance on AIX to SQLServer 2000 using the unixODBC driver. We have 5 SQLServer "Server mappings" and 4 of them work just fine and can use the nicknames associated with it. The one last mapping is going against a sqlserver and can't seem to get the nicknames setup on db2. The error is:
0
1278
by: TheMaxx | last post by:
I need to access ODBC from remote computer, if there's a better way other than WebService please let me know. So, i am doing web service which connects on ODBC, which connects to SqlServer 2000 (Windows auth.) First error was: Login failed for user 'MyComputerNmae\ASPNET'. Then i unchecked "Anonymous acces" from IIS for this webservice
0
10863
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10560
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10609
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10263
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9390
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7798
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5663
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5838
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4468
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

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.