Conectare
 
Pagina de pornireBibliotecăInformațiiFişiere de descărcatSuportComunitateForumuri
Resurse pentru profesionişti IT >
> 
> 
Can't connect with BCS

Întrebare Can't connect with BCS

  • 3 mai 2012 14:13
     
     
    Sign in pentru a vota
    0

    Hello Everybody

    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

     

Toate mesajele

  • 3 mai 2012 19:48
     
     
    Sign in pentru a vota
    0

    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.


     
  • 4 mai 2012 05:26
     
     
    Sign in pentru a vota
    0

    ok sir

    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).

    Thank you

     
  • 4 mai 2012 07:32
    Moderator
     
      Are cod
    Sign in pentru a vota
    0

    Hi,

    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

    http://blogs.technet.com/b/harmeetw/archive/2011/08/28/getting-login-failed-for-user-nt-authority-anonymous-logon-when-browsing-external-list-on-a-claims-kerberos-web-application.aspx

    Let us know if it works

    Cheers, Hemendra-MCTS "Yesterday is just a memory,Tomorrow we may never see"

     
  • 7 mai 2012 18:13
     
     
    Sign in pentru a vota
    0
    it didn't work I will try using SSS and I will be back with the results