安装IIS网站后无法访问sqlserver数据库 [英] Not able to access sqlserver database after installing IIS website

问题描述

我已在IIS中部署了该网站。现在我可以通过IIS在另一台计算机上通过局域网访问网站文件，但我有一个registration.aspx表单



因为给定的用户名和密码存储在一个附带项目的sqlserver数据库，但是在我错的地方它不起作用:(请帮帮我






登录正在运行它验证用户名和密码但注册不起作用:(这意味着对数据库有读访问权限但不能写访问权限:(



我已部署在c：/ inetpub / wwwroot / website offline /



其中网站离线是我的网站

I have Deployed the website in IIS. Now i can access the website files over LAN in another computer through IIS but i have a registration.aspx form

In that the given username and password is getting stored in a sqlserver database that is attached with the project but it is not working where i am going wrong :( please help me



Login is working it verifies the username and password but registration is not working :( that means there is read access to database but not write access :(

I have deployed in c:/inetpub/wwwroot/website offline/

where website offline is my website

推荐答案

您没有提到从您的应用程序到Windows服务器（如Windows或sqlserver）的身份验证类型。我猜这是NTLM（Windows身份验证）。如果是这样，那么您需要给您的Windows用户（您记录的用户）在您的操作系统上）对您的数据库的适当权限。正确的missio n可能是完全访问/读/写/删除等访问等。

You did not mention what is your authentication type from your application to sql server like windows or sqlserver. I guess it is NTLM(windows authentication). If so then you need to give your windows user(the user which you logged on your OS) proper permission to your database. Proper mission might be full access/read/write/delete etc access etc.

这篇关于安装IIS网站后无法访问sqlserver数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！