mq

mill2002 for chatting | 首页 | Login Failed: Reason:.... help plz!>>> 2004-05-14 mq_1980 I solved the "Configuration failed!" problem! Posted: 23 Sep 2003 02:06 AM i am exactly a newbie of ASP.NET though i was very familiar with ASP 3. when i determined to start my ASP.NET way with the IBuySpy Store application last week, a fucking puzzled problem blocked my road. i got the following log message. 10:00:42 2003?9?23?: [Checking system requirements] 10:00:42 2003?9?23?: [Pass] Detected a local instance of SQL Server. 10:00:42 2003?9?23?: [Pass] Determined SQL Server version (8.00.194). 10:00:42 2003?9?23?: [Pass] Detected .NET Framework. 10:00:42 2003?9?23?: [Pass] Detected Internet Information Server (IIS). 10:00:44 2003?9?23?: [Begin Sample Configuration] 10:00:44 2003?9?23?: [Pass] Created IIS virtual directory.: StoreVBVS 10:00:44 2003?9?23?: [Pass] Determined SQL Server version (8.00.194). 10:01:00 2003?9?23?: [Fail] Could not add ASPNET user to SQL Server. SQL Server does not exist or access denied. 10:01:00 2003?9?23?: [Done] i searched almost anywhere on the internet with google, yahoo, but nothing useful for me. so i decided to Solve It Myself. it's obviously that the problem is with SQL Server. i had installed MSDE and SQL Server 2000 tools (Query Analyzer, Enterprise Manager and so on). Note: I INSTALLED THE "Store" DATABASE WITH THE "Query Analyzer"! the SQL Server works well through the tools or OSQL, because i checked it with a ASP 3 application and a VB 6 application and a Manul Coded ASP.NET application (just to pull the data out from SQL Server), they all work well. the first success is VB 6 application, i used a ADODC and a DataGrid, and then the ASP 3 application (just a Connection and a Recordset), and then the Manul Coded ASP.NET application, and the last success. by this time the solution comes out: it is just the ConnectionString's problem! <!--<add key="ConnectionString" value="server=localhost;Trusted_Connection=true;database=store" />--> <add key="ConnectionString" value="server=myComputerName;Persist Security Info=False;User ID=sa;Password=mySAPassword;Initial Catalog=Store" /> Note: myComputerName SHOULD NOT BE "localhost" OR "(local)"! then my application started working, of course the "Configuration failed!" continues, but it will not be the matter again. i am a chinese, forgive my poor english, okay? wish a little help for the friends with the same problem! Face it, Think it, and Solve it! Jack Ma @ Comma Workshop, Inc. --------8<------------------------------------------ 32133156 / 118298744 / mq_1980@msn.com (QQ / ICQ / MSN Messenger) mq_1980@163.com / http://www.jackma.net/ akiaz Joined: 12 Nov 2003 Total Posts: 2 Re: I solved the "Configuration failed!" problem! Posted: 02 Feb 2004 11:37 PM Wow, I have searched all over this forum for this solution. There was one where you had to change an .ini file but that apparently does not work at all for anybody. THIS IS THE ONLY GOOD SOLUTION THAT WORKS! I don't know why though. If someone could please explain it for us that would be so helpful. Also, there are numerous people with the same problem because the installation documentation is pretty much nonexistent (not suprising for a MS product though). It's frustrating that everybody has to go through this experience before getting the Store running. R-man Joined: 06 Feb 2004 Total Posts: 9 Re: I solved the "Configuration failed!" problem! Posted: 10 Feb 2004 05:08 AM Hi. Connecting to the database using "sa" account, is not very good idea, IMHO. Because it is very unsafe. There is another way to solve connection problem. 1. Create computer_name/ASPNET user. In my case it was SERVER/ASPNET. 2. In SQL Enterprise manager, open STORE database and open USERS folder there. You have to add computer_name/ASPNET as new user for the STORE database and grant "public" and "dbo" privileges for computer_name/ASPNET user. 3. Connect to the database using Trusted connections, like it is described in IBuySptStore tutorial. Regards, R-Man. R-man Joined: 06 Feb 2004 Total Posts: 9 Re: I solved the "Configuration failed!" problem! Posted: 10 Feb 2004 05:11 AM Hi. Connecting to the database using "sa" account, is not very good idea, IMHO. Because it is very unsafe. There is another way to solve connection problem. 1. Create computer_name/ASPNET user. In my case it was SERVER/ASPNET. 2. In SQL Enterprise manager, open STORE database and open USERS folder there. You have to add computer_name/ASPNET as new user for the STORE database and grant "public" and "dbo" privileges for computer_name/ASPNET user. 3. Connect to the database using Trusted connections, like it is described in IBuySptStore tutorial. Regards, R-Man. bryanf Joined: 06 Feb 2004 Total Posts: 1 The Better Solution... Re: I solved the "Configuration failed!" problem! Posted: 13 Feb 2004 10:56 AM Since SQL Server 2000 tools cannot be added with out having a CAL for them. The better solution is to run cliconfg.exe located in the Windows/systems32 directory. General Enable TCP/IP and other relevant protocols Alias add localhost (server alias) to point to {yourservername} (server name) choosing TCP/IP as the network library. It was my finding that local host did not exist. One could run osql.exe and login into server localhost, however localhost could not be found via adding an ODBC connection. Once the above was setup, the ODBC connection could be created with no problems. Therefore the installations worked with no problem, and localhost was available to ASP.Net This should do it. bcross75 Joined: 26 Nov 2003 Total Posts: 10 Re: I solved the "Configuration failed!" problem! Posted: 20 Feb 2004 07:30 AM Can you tell us how to do this using OSQL ? R-man Joined: 06 Feb 2004 Total Posts: 9 Re: I solved the "Configuration failed!" problem! Posted: 20 Feb 2004 11:45 AM Check http://www.asp.net/Forums/ShowPost.aspx?tabindex=1&PostID=479385 I put a reply there. Regards, R-man. Previous Thread :: Next Thread Page 1 of 1 ASP.NET Forums > Source Discussions > IBuySpy Store > I solved the "Configuration failed!" problem! Copyright 2003 Microsoft Corporation Privacy Statement | Visit our Hoster: OrcsWeb Questions/Problems with www.asp.net? mill2002 引用Trackback(0) | 编辑 评论 Hi. Connecting to the database using "sa" account, is not very good idea, IMHO. Because it is very unsafe. There is another way to solve connection problem. 1. Create computer_name/ASPNET user. In my case it was SERVER/ASPNET. 2. In SQL Enterprise manager, open STORE database and open USERS folder there. You have to add computer_name/ASPNET as new user for the STORE database and grant "public" and "dbo" privileges for computer_name/ASPNET user. 3. Connect to the database using Trusted connections, like it is described in IBuySptStore tutorial. Regards, R-Man. R-man ( 发表评论 最后更新 斑竹,为什么备份数据的格式是htm的,而不是xml的呢?偶的分类目录及友情联结都无法保存啊 scottwater.com/blog/ weihua ju xml programming for .Net 的书那一本好? 程序员驿站 Login Failed: Reason:.... help plz! mq_1980 Login Failed: Reason:.... help plz! 用VS.NET打开书中的WEB窗体例子时遇到的错误,大侠指教. 大侠指点:VS.NET无法打开应用程序,提示说很可能是本地WEB服务器上没有安装所需的组件.

原始快照:web.archive.org