Connection issues. Any suggestions? - General development

BugNET Forums

Forum Development General develop... Connection issues. Any suggestions?

6/14/2007 12:16 PM

	jetjaguar
14 posts

Connection issues. Any suggestions?

Hello,

When I run BugNET from VS2005 I'm encountering an error:

Cannot open database "BugNet" requested by the login. The login failed.

This is my connection string in Web.config:

connectionString="Server=.\SQLEXPRESS;Database=BugNet;Trusted_Connection=True;" providerName="" />

Sinc the DB isn't attached to my SQL server I tried this next:

connectionString="Server=.\SQLEXPRESS;AttachDbFileName=|DataDirectory|BugNet;Trusted_Connection=True;" providerName="" />

Got this error:
An attempt to attach an auto-named database for file D:\Projects\BugNET\src\BugNET_WAP\App_Data\BugNet failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

Any ideas?

Jet

6/20/2007 5:58 PM

	jetjaguar
14 posts

Re: Connection issues. Any suggestions?

Am I not understanding something here? Why can't I get bugnet to run from Visual Studio? Why can't it connect to the bugnet DB?

Jet

6/20/2007 6:08 PM

	admin
658 posts
bugnetproject.com

Re: Connection issues. Any suggestions?

Modified By admin on 6/20/2007 5:09:18 PM)

jetjaguar wrote
Am I not understanding something here? Why can't I get bugnet to run from Visual Studio? Why can't it connect to the bugnet DB?

Jet

The asp.net account / network service on window server 2003 also needs read and write permissions on a sql express database file in the app_data folder.

Something to try...

Davin Dubeau
BugNET - Core Developer

6/21/2007 10:19 AM

	jetjaguar
14 posts

Re: Connection issues. Any suggestions?

I am attempting to run BugNET through Visual Studio on my local system (a Windows Vista system). Can I do that?

Security tab says that NETWORK SERVICE has Full control Permission of the BugNet.mdf file. There isn't an ASPNET account on my Vista system. I wonder why?

Jet

6/21/2007 4:38 PM

	admin
658 posts
bugnetproject.com

Re: Connection issues. Any suggestions?

jetjaguar wrote
I am attempting to run BugNET through Visual Studio on my local system (a Windows Vista system). Can I do that?

Security tab says that NETWORK SERVICE has Full control Permission of the BugNet.mdf file. There isn't an ASPNET account on my Vista system. I wonder why?

Jet

You can do that. I do all my development in windows vista now. There is no aspnet account in vista just the network service now.

Are you running visual studio as administrator?

Davin Dubeau
BugNET - Core Developer

Page 1 of 3

Forum

Development

General develop...

Connection issues. Any suggestions?

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.