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

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.

And you may have to change your web.config file as well for the path to the DB.

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

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.

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