Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Unable to connect to instance message

  Asked By: Kayla    Date: Dec 08    Category: Sharepoint    Views: 1002

I am trying to set up a BDC connection, and am able to go through the samples AdventureWorksDW and others, and can create and import the application, see the entities, and select them, but I keep getting an "unable to connect to the instance" message. The account seems to have all the permissions and authority it needs both to the bdc and the database, and I am even using the SharePoint back end database server...Does anyone have an idea of what could be causing this?



1 Answer Found

Answer #1    Answered By: Marjorie Humphrey     Answered On: Dec 08

Is your SQL Server remote, and are you using NTLM? If so, this sounds like the double hop issue. You can either use Kerberos, RevertToSelf or SSO to get around the problem. If you search for these terms, you will find additional help.

Didn't find what you were looking for? Find more on Unable to connect to instance message Or get search suggestion and latest updates.