BugNET 0.7 beta1: SQL Error - Installation problems

BugNET Forums

Forum Support Installation pr... BugNET 0.7 beta1: SQL Error

3/3/2007 10:23 AM

	robin
3 posts

BugNET 0.7 beta1: SQL Error

Trying hard since couple of days. Can someone help me with this?

___________________________________________________________________________________

Installing BugNET
Version: 0.7.719.0

Installation Status Report

Installing Version: 0.7.719.0
Installing Membership Provider... - 00:00:00.4806912
Error!

Error in file:C:\Inetpub\wwwroot\BugNet\Install\dbscripts\InstallCommon.sql
Message:Login failed for user 'MACHINENAME\ASPNET'.

Error!

Error in file:C:\Inetpub\wwwroot\BugNet\Install\dbscripts\InstallMembership.sql
Message:Login failed for user 'MACHINENAME\ASPNET'.

Error!

Error in file:C:\Inetpub\wwwroot\BugNet\Install\dbscripts\InstallProfile.sql
Message:Login failed for user 'MACHINENAME\ASPNET'.

Error!

Error in file:C:\Inetpub\wwwroot\BugNet\Install\dbscripts\InstallRoles.sql
Message:Login failed for user 'MACHINENAME\ASPNET'.

Installing BugNET Database... - 00:00:00.9814112
Error!

Error in file:C:\Inetpub\wwwroot\BugNet\Install\dbscripts\BugNET.Schema.SqlDataProvider.sql
Message:Login failed for user 'MACHINENAME\ASPNET'.

Installing BugNET Default Data... - 00:00:01.0114544
Error!

Error in file:C:\Inetpub\wwwroot\BugNet\Install\dbscripts\BugNET.Data.SqlDataProvider.sql
Message:Login failed for user 'MACHINENAME\ASPNET'.

Creating Administrator Account... - 00:00:01.0214688
___________________________________________________________________________________

3/3/2007 10:38 AM

	admin
641 posts
bugnetproject.com

Re: BugNET 0.7 beta1: SQL Error

By default on windows xp or 2000 asp.net runs under the machinename\aspnet account and passes this to the database as the user. You need to add the machinename\aspnet account to your database and add it to the dbowner database role.

You should be good to go after that.

Davin Dubeau
BugNET - Core Developer

3/4/2007 3:31 AM

	robin
3 posts

Re: BugNET 0.7 beta1: SQL Error

For that do I have to attach the db to SQLExpress? Any other workaround? I'll get back if i fail to add aspnet account to database.

Davin -one thing, keep up the good work.
This project is awesome!

Regards,
Robin

3/4/2007 4:09 AM

	robin
3 posts

Re: BugNET 0.7 beta1: SQL Error

I was not able to attach the database, it asked for a valid log (.ldf) file. I created a new database from SQLExpress and added aspnet user to the same. It worked!

Thanks,
Robin

3/4/2007 6:32 AM

	admin
641 posts
bugnetproject.com

Re: BugNET 0.7 beta1: SQL Error

robin wrote
For that do I have to attach the db to SQLExpress? Any other workaround? I'll get back if i fail to add aspnet account to database.

Davin -one thing, keep up the good work.
This project is awesome!

Regards,
Robin

For sql express the asp.net account has to have read and write permissions to the actual database file.

Thanks, I will do my best

Glad to hear you got it working.

Davin Dubeau
BugNET - Core Developer

Page 1 of 1

Forum

Support

Installation pr...

BugNET 0.7 beta1: SQL Error

Forum Policy

These Discussion Forums are dedicated to the discussion of the BugNET issue tracker.

For the benefit of the community and to protect the integrity of the project, please observe the following posting guidelines:
1. No Advertising.
2. No Flaming or Trolling.
3. No Profanity, Racism, or Prejudice.
4. Site Moderators have the final word on approving/removing a thread or post or comment.
5. English language posting only, please.