Last replied: 24-Nov-10 12:16 AM

I have a sharepoint application and I want to show some data in a webpart. The source of the data is another SQL database other than SharePoint database. But I am getting error.

Login failed for user '<sqlusername>'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Login failed for user '<sqlusername>'.

Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Please help me to solve this problem.

Thanks in Advance..


This is happening because User doesn't have access rights to this database. Connect to the SQL server, open the user properties and check the rights of the user. Give the owner rights to the user. This may resolve your problem


Copyrights 2019,