January 30, 2008 at 12:29 am
Application connects to the database successfully on login.
We are able to perform certain other Add/Edit features that call related SPs in MSSQL 2000.
But when we move on to the Import Activity, it gives the following error:
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection
P.S.Authentication Property -> Mixed mode
What is the problem here, people? I have no clue!!
January 30, 2008 at 2:48 am
What import activity you are referring here, is it within your application or import within SQL server? Generally this error can occur under the following circumstances:
• You are trying to establish a trusted connection, and the Microsoft Windows NT or Windows 2000 user account that Internet Information Server (IIS) uses to process the request for the ASP page does not have a corresponding NT Authentication login in SQL Server.
• You are trying to use standard SQL Server authentication to establish a connection, and the UID parameter is not specified in the ADO connection string.
If this is not the case, please elaborate your problem.
January 30, 2008 at 6:03 am
CHECK & reply the below
1. Login your sql2000 using the same userid/password which you given in application code.
2. if it's login, check your ODBC Connection.
3. If ODBC is OK, then send your application written code, there is the problem in application code. You left some options.
thanks & regards
RSK
January 30, 2008 at 6:10 am
Check the following link
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=854321&SiteID=1
January 31, 2008 at 10:23 pm
There was an existing application by the same name in the system.. therefore a folder by that application name in registry.
The Import module connection string was picking up 'null' as username which was not the case for the login exe and others..
We simply had to delete the existing folder from 'regedit'. 🙂
Thanks, guys!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply