帮助通过互联网连接 [英] help need for connection through internet

问题描述

嗨：

我的服务器是sql 2008，它在我的总公司，我开发了一个C＃Windows应用程序

我想从Branch连接我的办公室服务器应用程序

i有端口转发安装了sql server的路由器，但是当我从分支机构的服务器连接时它会抛出以下错误



i已经尝试过使用管理工作室，但是我也遇到了同样的错误

与服务器成功建立连接但出现错误在登录过程中。 （提供者：TCP提供者，错误： 0   - 指定的网络 不再可用。）（Microsoft sql服务器，错误： 64 ）

解决方案

您好，访问此链接，



http://stackoverflow.com/questions/7762204/a-connection-was-successfully-established-with-the-server-but-then-an-error-occ [ ^ ]



（或）读取此



< pre lang =text>错误消息：

指定的网络名称不再可用。 
 
说明：
 
您指定的网络资源要么暂时脱机，要么不再可用。有可能：（1）服务器上的共享可能已被临时删除; （2）共享资源的服务器可能已关闭;或（3）权限可能已被更改。

视为

sarva

第1步：按照此链接中给出的步骤在服务器电脑上设置数据库

http://support.microsoft.com/kb/914277 [^]



第2步：在第1步完成后，更改连接字符串的参数，

datasource = server-name或IP-Address [现在正在共享步骤1] ; [对于ip地址cmd> ipconfig -it将显示IP地址]

初始目录=您的数据库名称;

UserId = sql server - 用户登录ID;

密码= sql server - 用户登录密码;



快乐编码！

：）

我知道你的问题并不完全，但是你有没有想过开发一个Web应用程序来托管与SQL实例位于同一环境中的Web服务，而不是直接从客户端连接到SQL实例？，直接连接可能是一个安全风险。



然后，您可以将您的Web应用程序直接连接到SQL，这样可以减少问题并提高安全性。

Hi:
My server is sql 2008 which is in my head office and i have developed a C# Windows application
I want to connect my office server from Branch using the application
i have port forwarded the router where sql server is installed, but when i connect from server from branch office it throws the following error

i have tried this using management studio also but i got the same error

a connection was successfully established with the server but then an error during login process. (Provider: TCP Provider, Error :0 - the specifed network is no longer available.) (Microsoft sql Server , error:64)

解决方案

hi visit this link,

http://stackoverflow.com/questions/7762204/a-connection-was-successfully-established-with-the-server-but-then-an-error-occ[^]

(or) read this

Error Message:

The specified network name is no longer available.

Explanation:

The network resource that you specified was either temporarily taken offline or is no longer available. It is possible that: (1) the share at the server might have been temporarily deleted; (2) the server that shared the resource might have been turned off; or (3) the permissions might have been changed.

regards
sarva

step 1: follow steps given in this link to setting up database on server pc
http://support.microsoft.com/kb/914277[^]

step 2: after step 1 complete then change connection string''s parameters,
datasource = server-name OR IP-Address [which is in sharing now after step 1] ; [For ip address cmd > ipconfig -it will show ip address]
Initial catalog = your database name ;
UserId = sql server - user login Id ;
Password = sql server - user login password;

Happy Coding!
:)

I know it''s not quite what you are asking but have you thought of developing a web application that hosts web services that sits in the same enviroment as your SQL instance instead of connecting directly to the SQL instance from th client?, Connecting directly could be a security risk.

You can then have your web application connecting directly into SQL which will give you less problems and will be more secure.

这篇关于帮助通过互联网连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！