Cannot open database "communityserver" requested by the login.

This post has 4 Replies | 3 Followers

Not Ranked
Posts 16
Points 310
renxunsaky Posted: Mon, Jul 31 2006 5:28 AM

when I first put such files under the wwwroot folder and I give users full permission. the error occured.

It says: Cannot open database "communityserver" requested by the login.

Any solutions?

Thanks!

  • | Post Points: 20
Top 10 Contributor
Male
Posts 2,373
Points 15,770
MVPs
Dave replied on Mon, Jul 31 2006 6:01 AM

Check that the username and password are correct in you web.config file.

Did you use the Windows Install or the Web Install?

  • | Post Points: 20
Not Ranked
Posts 16
Points 310
renxunsaky replied on Mon, Jul 31 2006 10:33 PM
Thanks for answering. Yes, I am using web install. It seems that there is a sqlscripts folder. And I need to configure the database and run some .sql files in such folder. Yes?  I am not a expert in program. I searched in the web.config file, but I can't find any useful information ralated to username or passwoird. I mean that, I put all these files under the wwwroot folder, and I haven't configured the database. Whe I open the default.aspx file. It says that I can't open the database. What can I do then? Thank you very much.
Top 500 Contributor
Posts 88
Points 1,695

It's the SiteSqlServer key in web.config that contains the username and password required to login to the database, as well as the obvious stuff like the name of the database.

 
You need to set the database up first though!  After creating a blank database, those SQL Scripts have to be run from Query Analyzer in the order specified in the HOW TO SETUP DB.txt file.

Regards, CommunityServer guy Available for hire for small jobs!!!!!
  • | Post Points: 5
Top 25 Contributor
Posts 1,160
Points 70,210
CS Developers

Edit the file \Installer\Default.aspx  there is a line near the top

bool INSTALLER_ENABLED = false;

change this to true, and save the file....

 Then point your browser to the IIS site you made for CS, and add the \installer path

(eg http:\\localhost\cs\installer where cs was the vdir you setup cs in)

the installer will guide you through creating a database, and setting the connection strings, as well as give you the option to install some sample data.

Dan

 (dont forget to go back and disable the installer once you have run it)

  • | Post Points: 5
Page 1 of 1 (5 items) | RSS
Powered by Community Server (Commercial Edition), by Telligent Systems

Copyright© 2008 Telligent Systems Inc. All rights reserved
CommunityServer.com  •  Telligent.com