BugNET 0.7 beta1: SQL Error - Installing BugNET

Forums

Search Home All Forums

Home

Support

Installing BugN...

BugNET 0.7 beta1: SQL Error

3/3/2007 9:23 AM

Robin Debnath

Joined: 3/3/2007

Posts: 3

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 9:38 AM

Davin Dubeau

bugnetproject.com
Joined: 3/2/2006

Posts: 1425

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

3/4/2007 2:31 AM

Robin Debnath

Joined: 3/3/2007

Posts: 3

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 3:09 AM

Robin Debnath

Joined: 3/3/2007

Posts: 3

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 5:32 AM

Davin Dubeau

bugnetproject.com
Joined: 3/2/2006

Posts: 1425

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

Page 1 of 1

Home

Support

Installing BugN...

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.