开发者

Error connecting to SQL server after upload [closed]

开发者 https://www.devze.com 2023-03-20 19:50 出处:网络
Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.
Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.

This question does not appear to be about a specific programming problem, a software algorithm, or software tools primarily used by programmers. If you believe the question would be on-topic on another Stack Exchange site, you can leave a comment to explain where the question may be able to be answered.

Closed 9 years ago.

Improve this question

I know this sounds similar to many questions already asked, but those were answered mainly by reconfiguring the connection string. In my case, the scenario is a bit different.

I'm connecting to a remote server, and everything works fine on my 开发者_StackOverflowlocal PC. I can access it via SQL Server Management Studio Express, and the application itself connects without problem. After I upload everything, without changing the connection string, I get the famous A network-related or instance-specific error occurred while establishing a connection to SQL Server error.

The connection string is like:

<add name="barConnStr" 
     connectionString = "Persist Security Info=False;
                         Data Source=XX.XXX.X.XXX\SQLDBG;
                         Initial Catalog=FGE;
                         User Id=uid;
                         Password=pass" 
     providerName     = "System.Data.SqlClient" />

Anyone got an idea why this might be happening?


try to disable the firewall in both servers and see if it works if so you need to add rules to the firewall

0

精彩评论

暂无评论...
验证码 换一张
取 消