WCF-SQL适配器 - 如何更改配置 [英] WCF-SQL Adapter - How to change configurations
问题描述
我在测试计算机上使用WCF-SQL适配器进行了示例编排,使用集成安全性 现在假设我部署到QA环境,我需要使用远程SQL服务器,端口,不同的数据库和SQL用户ID密码。
真的不是一个完整的连接字符串,有吗?
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. 我可以按如下方式更改地址(URI :)吗?
1. Can I just change the Address (URI:) as follows?
mssql:// newmachine:12345 // Database2?
mssql://newmachine:12345//Database2?
2. 我在哪里放置用户/密码? 我看到了凭据标签,我只是把它们放在那里吗? 你怎么知道它真的使用集成安全性? 只是缺少用户/通行证?
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?
我回到了VisualStudio,并且"配置"了按钮允许我指定用户/通行证,但我假设只是为了运行适配器向导。
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.
谢谢,b
Neal Walters
Thanks,
Neal Walters
推荐答案
1。是和否。如果对象名称或数据库架构(例如:dbo)发生更改,则必须重新生成架构。看起来你可以改变架构,但我发现你不能做到的困难。这是我在此发表的一篇文章:
http:// msinnovations .spaces.live.com / blog / cns!62E68922E47BC425!756.entry
2。对于SQL身份验证,您将其放在凭据选项卡中。如果您使用的是Windows身份验证,则需要在该帐户下运行自定义主机。您还可以使用SSO将主机帐户映射到其他帐户,并指定端口中的哪个SSO映射
。
2. For SQL authentication you put it in the credentials tab. If you are using Windows authentication you need to have a custom host running under that account. You can also use SSO to map the host account to some other account and specify which SSO mapping in the port.
谢谢,
这篇关于WCF-SQL适配器 - 如何更改配置的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!