集成安全连接问题 [英] Integrated Security Connection Problem

问题描述

我有一个已经部署到生产的asp.net应用程序。我正在使用集成安全性作为我的连接的一部分，并且它在生产中超时。超时是由于无法连接到数据库。我登录失败了。我正在使用Windows身份验证，我们正在使用IIS6。但是，从我的开发机器上它运行得很好。



这是我的connstring：add name =blahconnectionstring =Data Source = serverName; Initial Catalog = Blah;综合安全=真; providername =System.Data.SqlClient>



非常感谢任何反馈。 Thx。

I got an asp.net application that has been deployed to production. I''m using integrated security as part of my connection and it times out in production. The timeout is due to not being able to connect to the database. I get Login failed. I''m using Windows Authentication and we''re using IIS6. However, from my development machine it runs great.

this is my connstring: add name="blah" connectionstring="Data Source=serverName; Initial Catalog=Blah;Integrated Security=True;" providername="System.Data.SqlClient">

Any feedback is greatly appreciated. Thx.

推荐答案

在生产机器上，检查您的连接字符串。打开记事本保存为myName.udl

关闭它。然后再打开它。输入服务器名称，提供商等首选项，并检查您的连接。在web.config中使用相同的连接字符串并尝试再次运行它。

如果这对您不起作用，我想提供用户名和密码并在web.config中使用这些凭据

On Production Machine, Check your connection string. Open Notepad save it as myName.udl
close it. then open it again. Enter your preferences like server name, provider and check your connection there. Use the same connection string in web.config and try to run it again.
If that does not work for you, I guess provide Username and password and use those credentials in web.config

这篇关于集成安全连接问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！