473,772 Members | 2,420 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 3323
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
3629
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
2972
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
1562
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
1316
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
1948
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
1581
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
1277
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
9619
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9454
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10261
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
10103
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
10038
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
9911
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
6713
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5482
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3609
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.