Updating connection for BDC to a different SQL Server

SitWalkStand
  • Updating connection for BDC to a different SQL Server SitWalkStand

    Is there a way other than exporting the BDC definition, changing the xml, and re-importing the definition to change the connection for the BDC application to a different server. We are setting up a separate development SQL server and need to update the BDC.

  • Not really as the BDC is entirely based on the definition. However you can use a SQL alias and change the alias to point to a different server.

    For more information on how to setup an alias there's a good writeup here:

    http://www.mssqltips.com/tip.asp?tip=1620

  • You can use the BDC Administration API to update the definition programatically. Another option might be BDC Meta Man web edition if it supports that.

Tags
business-data-catalog
Related questions and answers
  • directory. SqlException: Login failed for user ''. The user is not associated with a trusted SQL Server connection. The machine on which the restore takes place already has an existing web...I am trying to find the best way to accomplish the following: Move an existing share point application's content and meta databases, back them up and restore them to a different machine. In order to do this I am using the stsadm tool as follows: To backup, I use this command: stsadm -o backup -url http://devpn-004:1234 -directory c:\sharePointBackup -filename testBackup.bak -backupmethod full

  • service accounts domain administrator and local administrator permissions enabled Named Pipes and TCP/IP networking within SQL Server followed Troubleshooting Server and Database Connection Problems...On a single Windows 2008 Server I'm running SharePoint 2007 Enterprise (SP2, December 2009 CU) and SQL Server 2005 (SP3, CU 7). Authentication is NTLM. I've been trying to get SharePoint Reporting... to the computer cannot be established'. There is no error logged to the ULS logs or the Reporting Services logs about this. I've tried: a complete uninstall and reinstall both SQL Server

  • attempting to start and run the UPS Sync) and eventually fails: Error ID: 22 - The Forefront Identity Manager Service cannot connect to the SQL Database Server. The SQL Server could not be contacted. The connection failure may be due to a network failure, firewall configuration error, or other connection issue. Additionally, the SQL Server connection information could be configured incorrectly. Verify that the SQL Server is reachable from the Forefront Identity Manager Service computer. Ensure that SQL Server is running, that the network connection is active

  • I am working on replacing our protocol handler with a Connection Framework component, so that SharePoint will crawl our data source. I think I understand the big picture, but I'm missing a lot of the details. I've read the documentation starting at http://msdn.microsoft.com/en-us/library/ee556429%28office.14%29.aspx. I currently have a working BDC assembly; I know it works because I can make... "Data Sources"? Can I use my BDC assembly for this, or do I have to create another assembly?

  • SharePoint_AdminContent_1c2efc32-a7c8-4e97-93d6-447c3ea5cd29 server XXXXXXXX\lob 05/05/2010 09:43:45 8 INF Using NTLM for sql connection string 05/05/2010 09:43:45 8 INF Openning configdb so.... The SSP was created OK but there was an issue with finding the SQL Report Viewer assemblies which are required to view the SSP admin pages. My environments team have kindly looked into this and decided to completely re-install MOSS on that box. I have tried to re-run the config wizard to hook this server up to the existing config database and to re-create the central admin site. However I now

  • impersonate="true" username=”domain\someuser” password=”***” /> If we add “NTAuthority\Anonymous Logon” as a user in custom DB server instance. If we use Sql Authentication “Data Source=xxxx...\Anonymous Logon". This issue occurs in the following scenario: WebApplication exists in seperate server DB Server Instance exists in seperate server and WebApplication AppPool uses "domain\someuser" and DB Server Instance has the same user "domain\someuser" and has permission to Custom DB. Web.config entries: <authentication mode="Windows" /> <identity impersonate="true" />

  • like to create a Search Service Application after installing Search Server Express 2010. Do I need to run the Farm Configuration Wizard and install the below if I can create a Search Service Application? Business Data Connectivity Service Enabling this service provides the SharePoint farm with the ability to upload BDC models that describe the interfaces of your enterprises' line of business systems and thereby access the data within these systems. State Service Provides temporary storage of user session data for SharePoint Server components. Usage

  • I have a new SharePoint 2010 server farm that I'm trying to configure. Installation went fine. But I'm having trouble getting the user profiles to import. I've created the User Profile service application, and the two user profile services are running. However, whenever I try to create a synchronization connection to our AD servers, I'm getting the following error: "The operation was aborted... of permissions --- {1}. Available parameters: System.ServiceModel.EndpointNotFoundException: Could not connect to http://poc-bi-sp:5725/ResourceManagementService/MEX. TCP error code 10061: No connection could

  • Cross-posted from http://serverfault.com We have a SharePoint 2007 server (Windows 2003) for development which fails to provide access via SMB administrative shares like \server\c$. I can use \mywin7\c$ backwards from a terminal session on that server. Looking at the packets I see that the \server\share requests are handled by IIS 6 which renders http status 501 Not Implemented in response to PROPFIND verb WebDAV requests. PROPFIND / HTTP/1.1 Connection: Keep-Alive User-Agent: Microsoft-WebDAV-MiniRedir/6.1.7600 Depth: 0 translate: f Content-Length: 0 Host: server HTTP/1.1 501

Data information