3 mai 2012 14:13
I had set up BCS using SP designer 2010 to create connection to SQL
I went to Manage service on Server administration and made sure the "Administrator" have All permissons to this file
but I still get this error message
3 mai 2012 19:48
Have you checked your Event viewer for errors? It is a good place to start troubleshooting.
Post the relavent errors, from the event viewer so we may help you better.
- Editat de GoingForward 3 mai 2012 19:50
4 mai 2012 05:26
when I try to connect I get two application errors
1st: critical error
Could not open connection using 'data source=SQL;initial catalog=test;integrated security=SSPI;pooling=True;persist security info=false' in App Domain '/LM/W3SVC/611835028/ROOT-1-129805210609473401'. The full exception text is: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
2nd: an Error
Application Server Administration job failed for service instance Microsoft.Office.Server.Search.Administration.SearchServiceInstance (ee7c322e-2890-4a18-b341-f2f8d500676d).
4 mai 2012 07:32Moderator
There may be authentication problem so try to run this powershell command.
Get-SPServiceApplication #Copy the ID of BCS Service Appliction $bcs = Get-SPServiceApplication -ID "BCS ServiceApp ID" $bcs.RevertToSelfAllowed = $true $bcs.update()Check this article for more information
Let us know if it works
Cheers, Hemendra-MCTS "Yesterday is just a memory,Tomorrow we may never see"
7 mai 2012 18:13it didn't work I will try using SSS and I will be back with the results