SQL请求连接字符串错误 [英] SQL Request connection string error

问题描述

我在Visual Studio 2012中编写了一个带有数据库连接的WCF服务。当我在服务器上部署数据库时，我得到一个服务器在处理请求时遇到错误。异常消息是实例失败。请参阅服务器日志以获取更多详错误。



我按照 帮助我，但它只在一定程度上帮助了我。我的连接字符串似乎是问题。我的连接字符串是Data Source =。\\ MSSQLSERVER; Database = jarvis; Integrated Security = SSPI; User Id = sa; Password = 123.



服务器我正在使用的是运行SQL Server 2012 Developer Edition。什么课程这个问题以及如何解决这个问题？

I have written a WCF service with database connection in Visual Studio 2012. When I deploy the database on my server I get a The server encountered an error processing the request. The exception message is 'Instance failure.'. See server logs for more details. error.

I followed the steps from to help me but it only helped me to an extent. My connection string seems to be the problem. My connection string is Data Source=.\\MSSQLSERVER;Database=jarvis;Integrated Security=SSPI;User Id=sa;Password=123.

The server that I am using is running SQL Server 2012 Developer edition. What courses this problem and how can I fix this?

推荐答案

首先，检查连接字符串：http://www.connectionstrings.com/sql-server/ [ ^ ]



您需要正确设置SQL Server以启用tcp / ip或命名管道连接。

请参阅： http://msdn.microsoft.com/en-us/library/ms189321 .aspx [ ^ ]

http://msdn.microsoft.com/en-us/library/ ms181035.aspx [ ^ ]

http://technet.microsoft.com/en-us/library/aa178138%28v=sql.80%29.aspx [ ^ ]



在某些情况下，您需要设置Windows防火墙： http ：//msdn.microsoft.com/en-us/library/cc646023.aspx [ ^ ]

First of all, check connection string: http://www.connectionstrings.com/sql-server/[^]

You need to properly setup SQL Server to enable tcp/ip or named pipes connections.
See: http://msdn.microsoft.com/en-us/library/ms189321.aspx[^]
http://msdn.microsoft.com/en-us/library/ms181035.aspx[^]
http://technet.microsoft.com/en-us/library/aa178138%28v=sql.80%29.aspx[^]

In some cases, you need to setup Windows Firewall: http://msdn.microsoft.com/en-us/library/cc646023.aspx[^]

这篇关于SQL请求连接字符串错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！