SQL Server Management Studio 2008 通过 VPN 在不同域上运行用户
我当前正在尝试以不同域中的用户身份运行 SQL Server Management Studio 2008。我注意到在其他线程中，从批处理脚本运行以下命令将执行此操作，但它似乎对我不起作用。
runas /netonly /user:DOMAIN\USER "C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe"
系统要求我输入密码，出现登录屏幕，但是 Windows 身份验证用户名和密码仍然错误地是本地域上当前登录的模拟用户。无论如何，尝试连接到其他域上的数据库都会失败。
这似乎对大多数人都有效，对我来说最重要的是这个域存在于 VPN 连接上。我无法在网上邻居中查看 VPN 域网络计算机，因此无法在控制面板中添加用户。
不幸的是，我的操作系统是 Vista Business，我对此无能为力。
任何想法将不胜感激。
I am currently trying to run SQL Server Management Studio 2008 as a user who is on a different domain. I noticed in other threads that running the following command from a batch script will do this however it doesn't seem to work for me.
runas /netonly /user:DOMAIN\USER "C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe"
I am asked for my password, the Login screen appears however the Windows Authentication username and password are still incorrectly the currently logged in impersonated user on the local Domain. Attempting to connect to the database on the other domain is unsuccessful regardless.
This seems to work for most people, the kicker for me is that this domain exists over a VPN connection. I am not able to view the VPN domain network computers in My Network Places, and thus I cannot Add Users in Control Panel.
My OS is Vista Business unfortunately, I cannot help this.
Any ideas would be appreciated.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
试试这个：
系统将提示您输入密码。这将与数据库服务器建立 NetBIOS 会话。完成此操作后，您应该能够在数据库服务器上看到共享文件夹和共享打印机。
如果有效，您应该能够像您自己一样使用 SSMS 进行连接。如果“命名管道”不能与 TCP 一起工作（但我认为可以），您可能必须指定“命名管道”作为要使用的网络协议。
命名管道继承您现有的 NetBIOS 会话，因此只要您可以列出您可能擅长的共享去。
更新：在某些配置中，这似乎不适用于 TCP 连接（可能是由于某些安全更新）。在这些情况下，您应该启用命名管道，并在连接字符串中设置命名管道。
Try this:
You will be prompted for your password. This establishes a NetBIOS session with the database server. You should be able to see the shared folders and shared printers on the database server once you have done that.
If that works you should be able to connect using SSMS as yourself. You may have to specify "named pipes" as the network protocol to usem, if it doesn't work with TCP (but I think it will).
Named Pipes inherits your existing NetBIOS session, so provided you can list the shares you are probably good to go.
Update: It looks like in some configurations this does not work with TCP connections, (possibly due to some security update). In these cases you should enable Named Pipes, and set named pipes in your connection string.
您还可以尝试使用 Windows 凭据管理器：
单击右侧窗格（Windows 凭据），然后单击添加 Windows 凭据。在服务器下，使用数据库 IP 地址，后跟用户名和密码。它应该通过 SSMS 工作，但无法从 WCF 等应用程序调用它。
You can also try using Windows Credential Manager:
Click on the right pane (Windows Credentials) and on Add a Windows Credential. Under server, use the DB IP address follow by username and passoword. It should work through SSMS, but does not work calling it from an app such as WCF.