我想连接两个sql server并在它们之间进行事务处理 [英] I want to connect two sql server and make transaction between them
问题描述
亲爱的先生,
我正在开发一个asp.net项目。我正在研究学生管理项目。有两个系统,它们通过LAN连接。在我的第一个系统上有一个sql server数据库,库应用程序基于该数据库正常工作。但是第二个系统是Windows Server 2008.我开发了另一个学生管理项目,它安装在这个服务器上并正常工作。但我希望服务器应该使用我的sql数据库以及第一个系统的Library数据库。
如何使用连接字符串来使用第二个系统。它们都已正确连接并成功ping通。但是sql server可以从服务器连接到客户端和副varsa。
当我想通过他们的IP地址连接它时它显示错误No40。
plz帮助我使用来自不同系统的两个服务器和两个数据库。
Dear sir,
I am developing an asp.net project.Here I am working on a Student Management project. There are two systems and they are connected through LAN. On my first system there is a sql server database on which the library application based and worked properly. But the second system is a Windows Server 2008. And I have developed another Student Management project , which had installed in this server and work correctly.But I want the server should use my sql database as well as the Library database of the first system.
How could I use the connection string for use the second system.They all are connected properly and pinging successfully. But the sql server can,t connect from server to client and vice-varsa.
when I want to connect them through their IP Address it shows me Error No40.
plz help me for use two server and two databases from the different system.
推荐答案
您可以使用链接服务器连接另一个服务器实例。 br />
转到此链接查看步骤..
[ ^ ]
you can connect another server instance using link server.
go for this link to see the steps..
[^]
这篇关于我想连接两个sql server并在它们之间进行事务处理的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!