网站发上服务器无法访问数据库。。
错误信息====================================
Server Error in '/' Application.
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Inte易做图ces, error: 26 - Error Locating Server/Instance Specified)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Inte易做图ces, error: 26 - Error Locating Server/Instance Specified)
=======================================
在本机web.config连接部分是这样设置的，要怎样改呢
<connectionStrings>
<add name="ConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=SSPI;User Instance=True "/>
</connectionStrings>
谢谢大家了！！ --------------------编程问答-------------------- 你的服务器易做图问数据应该是要账号密码的吧？
改成用户登录模式访问
--------------------编程问答-------------------- 现在显示成：用户 'NT AUTHORITY\NETWORK SERVICE' 登录失败。 --------------------编程问答-------------------- --------------------编程问答--------------------
<add name="test_connStr" connectionString="Data Source=USER-5QHBB1Q97K;Initial Catalog=myData;Persist Security Info=True;User ID=sa;Password=" providerName="System.Data.SqlClient"/>
因为你在ConnectionString中用了Integrated Security=SSPI
这是用当前用户登录数据库
asp.net 程序在IIS6下的当前用户是'NT AUTHORITY\NETWORK SERVICE'。
1， 你可以在sql server中给'NT AUTHORITY\NETWORK SERVICE'更大权限
2， 在sql server中建立SQL login, 使用SQL Login登录数据库，像这样：Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;
补充：.NET技术 , ASP.NET
