Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Cannot connect to dabase instance in Business Data List webpart

  Asked By: Donnell    Date: Apr 28    Category: Sharepoint    Views: 1433

Im having trouble when using business data list webpart in Sharepoint.

'Unable to connect to AdventureWorksDW_Instance.'

In my Event Logs, this is the error:

Could not open connection using 'data source=MSSQL;initial catalog=AdventureWorksDW;integrated security=True;persist security info=false' in App Domain '/LM/W3SVC/243996052/ROOT-1-129034982946432768'. The full exception text is: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

How can I fix this problem?



1 Answer Found

Answer #1    Answered By: Miranda Scott     Answered On: Apr 28

Your issue is that you do not have anonymous access to the AdventureWorks database. Are you using a Application Definition File that you have created yourself to access the data? If so can you post it?

It looks like you havent set any user  credentials in the ADF so it is trying to log in anonymously.