Login failed for user '(null)'

Hi,

I am using a Third Party software which depends on my SQL Server 2000 for storing data. When I use Windows Security in my Third Party software, I get the following message in the event viewer of my SQL Server 2000.

Description:

18452:
Login failed for user '(null)'. Reason: Not associated with trusted SQL Server connection.

When I user SA, I do not get the above error.

Any clarifications on the possibilites for getting the error is appreciated.
Also let me know if we can overcome the error without using SA.

I tried the article in http://support.microsoft.com/kb/840219. But it didn't make a difference.

I would check with the third party app. It seems like they are using an account that isn't authorized in SQL Server. It all depends on how they have implemented their connection.|||

Are the application and the SQL Server running on the same machine? If not, are the machines in the same domain?

If you search this forum for the text of the error, you will find additional related threads that may contain hints helpful to you.

Thanks
Laurentiu

|||

check the authentication of your SQL Server. which authentication r u using..

Madhu

|||

Hi Santhosh,

Santhosh Pallikara wrote:

Hi,

I am using a Third Party software which depends on my SQL Server 2000 for storing data. When I use Windows Security in my Third Party software, I get the following message in the event viewer of my SQL Server 2000.

Description:

18452:
Login failed for user '(null)'. Reason: Not associated with trusted SQL Server connection.

When I user SA, I do not get the above error.

Any clarifications on the possibilites for getting the error is appreciated.
Also let me know if we can overcome the error without using SA.

I tried the article in http://support.microsoft.com/kb/840219. But it didn't make a difference.

You have said that when you are using user "SA" you are not getting error, which means application connects using "SQL/Mixed Authentication Mode" , as Madhu said have you check the authentication mode for server , ensure your application connection string uses Windows Authentication based connection string while you are trying with windows users to login in your application refer http://www.connectionstrings.com for connection string and refer http://hemantgirisgoswami.blogspot.com/2006_11_01_hemantgirisgoswami_archive.html to know/change the Authentication Mode of Server.

Hemantgiri S. Goswami