- This topic has 3 replies, 1 voice, and was last updated 3 years, 5 months ago by
.
-
Posts
-
-
I’ve got a sample orchestration using WCF-SQL adapter on my test machine, using integrated security Now suppose I deploy to a QA environment, where I need to use a remote SQL server, a port, a different database, and a SQL userid, password. There really isn’t a full connection string, is there?
1. Can I just change the Address (URI:) as follows?
mssql://newmachine:12345//Database2?
2. Where do I put the user/password? I see a credentials tab, do I just put them there? How do you know it’s really using integrated security or not? Just the lack of a user/pass?
I went back into VisualStudio, and the “Configure” button there allows me to specify a user/pass, but I assume only for the purpose of running the adapter wizard.
Thanks,
Neal Walters -
-
HI Neal,
1. The URI can be changed, in this pattern: mssql://SQLServerName//DBName? -You can configure connection to database by wizard – button “Configure..” above the URI should be
2. Username and password – need to be added, if you don’t use windows authentication – in “Credentials” tab, in configuration of an adapter.
3. Is MSDTC configured for working in distributed environment? See this links:
http://msdn.microsoft.com/en-us/library/aa544733(CS.70).aspx
-
Turnaround: A Memoir by Miloš Forman – 9780788198847
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.