CodeVerge.Net Beta


   Item Entry   Register  Login  
Microsoft News
Asp.Net Forums
IBM Software
Borland Forums
Adobe Forums
Novell Forums




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

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" <>
NewsGroup User
Re: Could not add ASPNET user to SQL Server4/1/2004 9:57:45 PM

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" <>
NewsGroup User
Re: Could not add ASPNET user to SQL Server4/1/2004 10:16:26 PM

0

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

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" <>
NewsGroup User
Re: Could not add ASPNET user to SQL Server4/17/2004 6:49:21 PM

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" <>
NewsGroup User
Re: Could not add ASPNET user to SQL Server5/1/2004 6:51:21 PM

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:













expanding pools-super block header error

clustering error - unknown error with error code : 401

dhcp resource comatose

migrate or offline cluster resource kills ndsd

san migration

nss device/partition id's

oes2 stretch cluster with hp eva

clustering dns, clusterpath not found

ncs resource does not migrrate

cluster nodes randomly fail to load

cannot re-create sbd partition

cluster fatal 9054 can't find default route

odd cluster behavior

win client does not reconnect to cluster volume

oes2 cluster

cluster-<info>-<211>: wsasetservice() failed, error = -1

one cluster volume, 2 clusters?

rename cluster container?

poison pill given to cluster node

migrating a netware cluster services to a new oes2 cluster

multiple sbd partition on single hard drive?

cifs question

migration ncs 1.6 to 1.8

clustering vm

oes2 sp1, 3 node cluster migrating to new san

firewall ports to open for clustering in sles

cluster resource in unassigned state

ncp server access to reiser volumes

slow cluster resource load on oes/linuxbookmark

really?

cluster-<warning>-<12020> / warning 12038

esx vmware oes linux servers

cannot find error in kb

performance - ncs with nss / ext3 / reiserfs

cluster crashes

ncs on 2.6.16.46-0.14

clustered volume going to another cluster

ncs error and storaeg error in imanager 2.7.2

paths visible to non-mounted resources (suse10.2 oes2sp1)

re-create sbd on mpio device...

nfs, ncs with linux host behind firewall

sharable services on mixed ncs cluster (linux netware)

cluster ncp volume object in e-directory

expanding netware 6.5sp8 cluster with sles10

iscsi initiator error

dns failure on ncs

samba share on a oes2 linux cluster

oes2 nss volumes have different mount points on the nodes

license for groupwise cluster

dhcp load script isn't working

   
  Privacy | Contact Us
All Times Are GMT