Godaddy的ASP.NET成员资格数据库困境 [英] Godaddy ASP.NET membership database woes

问题描述

确定继承人交易
我购买了GoDaddy的Windows共享托管帐户与2 MSSQL数据库来了。我安装一个抱我的网站数据，另一个安装ASPNET会员架构来存储网站的会员。该网站完美的作品，即使从第1个数据库显示数据。然而，当我尝试登录或注册我得到这个讨厌的错误

Ok heres the deal I purchased a windows shared hosting account on godaddy that came with 2 MSSQL databases. I setup one to hold my site data and the other installed aspnet membership schema to store site members. The site works perfectly even displaying data from the 1st database. However when I try to login or register I get this nasty error

异常详细信息：
  System.Configuration.Provider.ProviderException：
  上证所提供者没有找到
  数据库文件中的指定的
  连接字符串。在配置
  信任级别（低于高信任级别），
  上证所提供者不能自动
  创建数据库文件。

Exception Details: System.Configuration.Provider.ProviderException: The SSE Provider did not find the database file specified in the connection string. At the configured trust level (below High trust level), the SSE provider can not automatically create the database file.

香港专业教育学院通过我的web.config中消失了，那里有什么错我的2个连接字符串。这似乎GoDaddy的具有使用2 MSSQL数据库的同时，当1是会员的问题。

Ive gone through my web.config and theres nothing wrong with my 2 connection strings. It seems godaddy has a problem with using 2 mssql databases simultaneously when 1 is for membership.

谷歌搜索只是发现了一大堆人同样的问题 - 但没有解决方案！
有谁知道一个解决方案或解决方法吗？...或者有没有人曾经成功地使用2个数据库（1会员资格）在godaddy的？

Googling just finds a whole lot of people with the same problem -- but no solutions! Does anyone know a solution or a workaround?...or has anyone ever successfully used 2 databases(1 for membership) on godaddy?

推荐答案

希望我的经验有利于每一个人。基本上，如果你想避免在godaddy的ASPNET成员的问题总是用LocalSqlServer这个作为ConnectionString的。即

I hope my experience benefits every one. Basically if you want to avoid aspnet membership problems on godaddy always use "LocalSqlServer" as the connectionstring. i.e

<providers>
    <remove name="AspNetSqlMembershipProvider" />
    <add name="AspNetSqlMembershipProvider" connectionStringName="LocalSqlServer"
        ..other attributes here... />
</providers>

然后创建了LocalSqlServer这个...的connectionString记得先删除

Then create the "LocalSqlServer" connectionString...remember to remove it first

<connectionStrings>
    <remove name="LocalSqlServer"/>
    <add name="LocalSqlServer"
        connectionString="Data Source=xxxx; Initial Catalog=xxx; User ID=xxx; Password=xxx;"
        providerName="System.Data.SqlClient" />
</connectionStrings>

这篇关于Godaddy的ASP.NET成员资格数据库困境的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！