我想访问网络上的SQL Server [英] I want to access the sql server on network

问题描述

我正在连接网络中的两个系统.我正在使用集中化的sql server.所以我需要从另一个系统访问一个系统中的数据库

我正在使用以下连接字符串，但不起作用

I am connecting two systems in network. I am using sql server as centralised. so i need access database in one system from another system

I am using following connections string but it is not working

 Public con As New SqlConnection("Data Source=NILE-WINDOWS\SQLEXPRESS;Initial Catalog=phoneix;Integrated Security=True")
Public con As New SqlConnection("Server=NILESOFT\SQLEXPRESS,10000;Initial Catalog=phoneix;User Id=sa;Password=welcome123")
 Public con As New SqlConnection("Integrated Security=SSPI;Initial Catalog=phoneix;Data Source=NILESOFT\SQLPRESS;User Id=sa;Password=welcome")
 Public con As New SqlConnection("Data Source=192.170.1.53,1433;Network=TCP/IP;Initial Catalog=phoneix;Integrated Security=SSPI;user Id=sa;Password=welcome123")

但这不起作用

在我的sql服务器中，我使用浏览更多"获取了网络中的sqlserver

但是它不会在网络中显示sqlserver

请任何人帮助如何从网络访问sqlserver

谢谢

But it is not working

In my sql server i fetched the sqlserver in network using Browse for more

But it is not display the sqlserver in network

Please anybody help how to access the sqlserver from networking

Thank you

推荐答案

请在下面进行检查
1)是否可以从本地sql服务器客户端连接sql server(网络上)?
2)如果不是，则会引发什么类型的错误?
3)如果与命名管道"有关的错误，则可以使用sql server配置向导配置网络sql server来启用它.

Please check below
1) are you able to connect sql server (on network) from your local sql server client ?
2) If not what type of error it throw ?
3) If error related to "Named pipe" then enable it by configuring network sql server using sql server configuration wizard.

这篇关于我想访问网络上的SQL Server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！