hostgator上的aspx mssql网站。除了login / createuser之外，所有存储过程都有效 [英] aspx mssql website on hostgator. all stored procedures work except the login/createuser stuff

问题描述

我使用vs web开发人员构建我的第一个网站。我一直在跟踪演练，一切都在游泳......或者像在裤子座位上someone f的人一样游泳......现在我正在努力学习如何部署。



如标题中所述，我正在使用hostgator。该站点使用createuserwizard和登录控件。由于某种原因，这些控件不起作用。但是，我可以添加新的记录到数据库，gridview和数据库通过存储过程的方式都可以工作。



这是我尝试登录时遇到的错误/创建新用户：



建立与SQL Server的连接时发生与网络相关或特定于实例的错误。服务器未找到或无法访问。验证实例名称是否正确，以及SQL Server是否配置为允许远程连接。 （提供者：SQL网络接口，错误：26 - 错误定位服务器/实例指定）



任何帮助将不胜感激我不知道是什么要做，我很抱歉，但这是我第一次尝试建立这种性质的网站。

I used vs web developer to build my first website. i've been following the walkthroughs, everything has sort of been going swimmingly...or as swimmingly as someone fyling by the seat of their pants can go...and now i'm trying to learn how to deploy.

as mentioned in the title, i'm using hostgator. the site uses the createuserwizard and the login controls. for some reason, those controls do not work. however, i can add new records to the database, the gridview and datasearches by way of stored procedures all work.

this is the error i get when i try to login/create a new user:

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 Interfaces, error: 26 - Error Locating Server/Instance Specified)

any help would be greatly appreciated i don't know what to do and i'm sorry to say but this is my first time trying to build a site of this nature.

推荐答案

这些是我原来的连接字符串...

these were my original connection strings...

<add name="connStr" connectionstring="Server=[serverip]; Database=db; User Id=user; Password=pass; Initial Catalog=db" providername="System.Data.SqlClient" />

<add name="ASPNETDBConnectionString" connectionstring="Server=[serverip]; Database=db; User Id=user; Password=pass; Initial Catalog=db" providername="System.Data.SqlClient" />

<add name="ConnectionString" connectionstring="Server=[serverip]; Database=db; User Id=user; Password=pass; Initial Catalog=db" providername="System.Data.SqlClient" />

<remove name="LocalSqlServer" />
<add name="LocalSqlServer">connectionString="connStr" providerName="System.Data.SqlClient" />
</add>

我应该拥有的...... < br $>

what i should have had...

<add name="connStr" connectionstring="Server=[serverip]; Database=db; User Id=user; Password=pass; Initial Catalog=db" providername="System.Data.SqlClient" />

<add name="ASPNETDBConnectionString" connectionstring="Server=[serverip]; Database=db; User Id=user; Password=pass; Initial Catalog=db" providername="System.Data.SqlClient" />

<add name="ConnectionString" connectionstring="Server=[serverip]; Database=db; User Id=user; Password=pass; Initial Catalog=db" providername="System.Data.SqlClient" />

<remove name="LocalSqlServer" />
<add name="LocalSqlServer">connectionString="Server=[serverip]; Database=db; User Id=user; Password=pass; Initial Catalog=db" providerName="System.Data.SqlClient"/>
</add>

加粗部分LocalSqlServer字符串是修复程序。

the bolded section in the LocalSqlServer string is the fix.

这篇关于hostgator上的aspx mssql网站。除了login / createuser之外，所有存储过程都有效的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！