Error connecting to SQL server after upload [closed]
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 questionI 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
精彩评论