CodeVerge.Net Beta


   Explore    Item Entry    Members      Register  Login  
NEWSGROUP
.NET
Algorithms-Data Structures
Asp.Net
C Plus Plus
CSharp
Database
HTML
Javascript
Linq
Other
Regular Expressions
VB.Net
XML

Free Download:
Zone: > NEWSGROUP > Asp.Net Forum > starter_kits_and_source_projects.commerce_starter_kit Tags:
Item Type: NewsGroup Date Entered: 4/1/2004 8:37:06 AM Date Modified: Subscribers: 0 Subscribe Alert
Rate It:
(NR, 0)
XPoints: N/A Replies: 5 Views: 23 Favorited: 0 Favorite
Can Reply:  No Members Can Edit: No Online: Yes
6 Items, 1 Pages 1 |< << Go >> >|
Incred
Asp.Net User
Could not add ASPNET user to SQL Server4/1/2004 8:37:06 AM

0/0

Setup:
MSDE
Framework 1.1
WindowsServer2003 Enterprise

I am trying to install the store with the process failing at the same point continually. The log file is as follows:

7:13:00 Thursday, 1 April 2004: [Checking system requirements]
7:13:00 Thursday, 1 April 2004: [Pass] Detected a local instance of SQL Server.
7:13:00 Thursday, 1 April 2004: [Pass] Determined SQL Server version (8.00.194).
7:13:00 Thursday, 1 April 2004: [Pass] Detected .NET Framework.
7:13:00 Thursday, 1 April 2004: [Pass] Detected Internet Information Server (IIS).
7:13:09 Thursday, 1 April 2004: [Begin Sample Configuration]
7:13:12 Thursday, 1 April 2004: [Pass] Created IIS virtual directory.: StoreVB
7:13:13 Thursday, 1 April 2004: [Pass] Determined SQL Server version (8.00.194).
7:13:34 Thursday, 1 April 2004: [Fail] Could not add ASPNET user to SQL Server.
SQL Server does not exist or access denied.
7:13:34 Thursday, 1 April 2004: [Done]


I understand this is a common problem and I have read the associated posts by other users. My connection string as specified in the web.comfig file is:
<add key="ConnectionString" value="server=172.16.0.2;Trusted_Connection=true;database=store" />

MSDE is configured in mixed mode security as I can access it via the following command:
OSQL -E

As the server does exist I see no reason why access would be denied as I can access this db in trusted mode as above.

I have also tried the following variation of the connection string without success:
<add key="ConnectionString" value="server=172.16.0.2;uid=sa;pwd=abcdef;database=store" />

Thank you in advance for any assistance provided.

Murphy


stinky5
Asp.Net User
Re: Could not add ASPNET user to SQL Server4/1/2004 9:57:45 PM

0/0

try changing your guest account name to ASPNET and then give it the permissions it needs to administer the database. Should work fine after that. I had the same issue.
stinky5
Asp.Net User
Re: Could not add ASPNET user to SQL Server4/1/2004 10:16:26 PM

0/0

And you may have to change your web.config file as well for the path to the DB.
chainy
Asp.Net User
Re: Could not add ASPNET user to SQL Server4/15/2004 8:23:38 AM

0/0

I had the very same problem trying to install!
here is what sorted it for me locate the server network utility in folder
Microsoft SQL Server/80/Tools/Bin/SVRNETCN.exe Click it and in the general tab make sure TCP/IP is enabled if not add it. I had no problem after that,
Chainy
giantsteps
Asp.Net User
Re: Could not add ASPNET user to SQL Server4/17/2004 6:49:21 PM

0/0

I have had the same problem myself.

These resources helped me

how to use osql
http://support.microsoft.com/default.aspx?scid=kb;en-us;325003#5

and the SQL server Web Data Administrator was a very handy tool for administering MSDE

http://www.microsoft.com/downloads/details.aspx?FamilyId=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylang=en

The thing that fixed my problem was to login as sa for SQL and then to add a user account named ASPNET. I did this within the Web Data Admin tool. I then gave this account access to the database and all the permissions to use it.

Hope this helps.
netdraw
Asp.Net User
Re: Could not add ASPNET user to SQL Server5/1/2004 6:51:21 PM

0/0

Hello,

For this problem, you may change two things.

(1). Re-assign the ODBC configuration for SQL server with SQL Authentication ID, and User name=sa.

(2). Modify Add Key statement to :< add key = ?ConnectionString? value=?server=your Server ; Integred Security=SSPI, initial catalog=store?>

After these, the SQL connection should work with no error.

Good Luck.
Gary
6 Items, 1 Pages 1 |< << Go >> >|


Free Download:

Books:
Pro SQL Server 2005 Integration Services: Intergration Services Authors: James Wightman, Pages: 548, Published: 2007
Hacking Exposed Web 2.0: Web 2.0 Security Secrets and Solutions Authors: Himanshu Dwivedi, Rich Cannings, Zane Lackey, Pages: 258, Published: 2007
Professional DotNetNuke 4: Open Source Web Application Framework for ASP.NET 2.0 Authors: Shaun Walker, Joe Brinkman, Bruce Hopkins, Scott McCulloch, Patrick J. Santry, Chris Paterra, Scott Willhite, Dan Caron, Pages: 517, Published: 2006
The Ultimate VB.NET and ASP.NET Code Book Authors: Karl Moore, Pages: 380, Published: 2003
Real World SharePoint 2007: Indispensable Experiences from 16 MOSS and WSS MVPs Authors: Robert Bogue, Adam Buenz, Scot Hillier, Andrew Connell, Stacy Draper, Luis Du Solier Grinda, Todd Klindt, Jason Medero, Dustin Miller, Shane Perran, Joris Poelmans, Heather Solomon, Nick Swan, Jan Tielens, Mike Walsh, Shane Young, Pages: 504, Published: 2007
Beginning SQL Server 2005 for Developers: From Novice to Professional Authors: Robin Dewson, Pages: 536, Published: 2006
Visual Web Developer 2005 Express Edition For Dummies Authors: Alan Simpson, Pages: 358, Published: 2005
Hitchhiker's Guide to SQL Server 2000 Reporting Services Authors: Peter Blackburn, William R. Vaughn, Pages: 784, Published: 2004
Pro Ajax and the .NET 2.0 Platform Authors: Daniel Woolston, Pages: 463, Published: 2006
Expert ASP.NET 2.0 Advanced Application Design: Advanced Application Design Authors: Dominic Selly, Andrew Troelsen, Tom Barnaby, Pages: 459, Published: 2005

Web:
Error installing IBuySpy - [Fail] Could not add ASPNET user to SQL ... When You hit the error "Could not add ASPNET user to SQL Server" while installing the sample application(IBuySpy Store), click on the finish ...
Could not add ASPNET user to SQL Server. - ASP.NET Forums Re: Could not add ASPNET user to SQL Server. 12-01-2003, 10:35 PM ... Re: Could not add ASPNET user to SQL Server. 12-01-2003, 10:52 PM ...
aspnet user and interated security (SQL Server) - .NET C# to use integrated security by adding the aspnet user to SQL Server ... Also, could security on this server be better addressed by setting up ...
how to create ASPNET user in SQL Server 2000 - SQL Server - How Can I add a linked server with IP address only(Not server name) Hi, .... some link where I could find complete steps for craeting the ASPNET user or if ...
SQL Server 2005 - how do i create the ASPNET user? btw i should add... i can create a db user called "ASPNET", .... which are not related to SQL Server instance's login & users. ...
ASPNET user not found - MSDN Forums Normally to add the ASPNET user to sql server. You go to the general logins section of your sql server not to the logins section of your database yet. ...
Using Sql Server 2005 w/ ASP 2.0, attaching a .mdf c) In my main login page there is NOT an aspnet user f) I can not add ... Could not open a connection to SQL Server) c) Check the Sql log and see nothing. ...
microsoft.public.dotnet.framework.aspnet.security: Re: Hybrid sql ... Server accesses. So, I will not give any application user SQL Server >> > direct ... I want both of this, but I could not find a way to accomplish both. One ...
Login failed for user\ASPNET user\ASPNET". > > I've tried to supply/not supply a username and password at the SQL > server login but both methods could not work. ...
Mutex Could not be Created. Server Error in Application. Mutex could not be created. .... Right clicked and added aspnet as user providing it full-control permissions. Hope this help! ...




Search This Site:










cannot upload files to isp

making a menu choice appear selected after choosing?

visual studio-project types

help!! how to use role-based authentuation

error on edit pages

problem with controls registered in web.config

bugs / feature ?

error creating edit control <asp:hyperlink navigateurl='

problem with viewstate when having a label in the master page and the rest of the form in the content page

confirm password change dialog???

is microsoft kidding with this thing?

how to get personal starter kit to work with sql 2005 beta?

disable the use of back button on browser - the solution

wikinews - how to get the feed into dnn 3.0.13

how to compile

aspnetmenu tabstrip - silver?

authorization verbs

where to save acounts?

intermittent error

explain wizard steps in member_register.aspx

simple image/link module

trying to add a verb menu to webpartverbcollection

need a way to expire cache of credentials and event required to trigger this when browser exits

msdn subscription changes for vs2005 on msdn web site

suggestion for recent solpartmenu problems

sqldataadapter & sqlcommand

reconfigure a component to work inside ibs c#

how to set 'group name' for radio buttons in child gridview

smr initials - who is that?

left align text in terms and privacy?
 
All Times Are GMT