I bought the personal edition last night and spent all night trying to get it to install. For a while I was able to get the web installer to run but I kept getting errors. This morning I wiped everything off my host and ftp'd up the files again so everything would be back the way it was when I downloaded it. I edited the connection string and added my information in there then I run the web installer. I am getting this message now. I tested Community Server over and over in a non-hosted lab environment and I loved it but now I am strting to think installing it may be more trouble that it's worth. Can anyone please help me get this installed? My website has been completely down since yesterday.
Please contact your CommunityServer administrator. A technical explanation of why this error is caused is below.
Community Server expects to find a valid XML file containing all of the links for a community. By default, this file is located at the root of the with the name SiteUrls.config.
A common error is to included unescaped XML characters, such as "&" when defining a querystring.
If available, the location of the error will be listed below:
Unable to open connection to data provider.
Login failed for user 'HOSTINGXP\NTXPWUS24$'.
For more information you can also visit http://CommunityServer.Org the home of the CommunityServer Forums development team.
Greetings. What is the current information contained in your connectionstrings.config file? It appears as though it isn't letting the user login to the database. Additionally are you setup for a Trusted Connection?
Are you running using a remote SQL server in a domain using AD?
Rick Reszler
I don't know what a trusted connection is. Here is my connection string info
<?xml version="1.0"?>
<connectionStrings> <add name="SiteSqlServer" connectionString="server=mssql09.1and1.com;uid=dbo206438764;pwd=mypasswordishere;Trusted_Connection=yes;database=db206438764" /> </connectionStrings>
It's not an AD domain, it's 1 and 1 hosting.
Set Trusted_Connection to "No" instead of the "Yes" that is has currently and try to hit the site again.
That got me a new error;
SQL Connection String is invalid.
That is when I try to hit the installer. There are no tables in the DB from where the installer partially ran last night so I assume I need to run the installer again.
I won't hang in there for days. If mine isn't working in the next hour or two I will say to heck with it. From the cs home page, you can have Community Server up-and-running in less than 5 minutes" and that's what I need, a website that is up and running in 5 minutes. I am no web developer and I don't have time to learn to be one either.
Yes if the db is not empty it would be best to start over, also you will want to touch the web.config after changing the connection string just to be sure you get a fresh load of the application.
You can touch the web.config by opening it up and adding then removing some white space and then save and re upload this will trick IIS into thinking the app settings have changed and it will reload it.
Could also repost your current connectionstring information so we could double check that?
One more thing I may need to mention, I think 1and1 doesn't support asp sites being installed in subdirectories so I copied the web directory to the root of my site. here is the sting like it is now. I will touch the webconfig file right now.
<connectionStrings> <add name="SiteSqlServer" connectionString="server=mssql09.1and1.com;uid=dbo206438764;pwd=mypassworsishere;Trusted_Connection=no;database=db206438764" /> </connectionStrings>
Okay, I did something else, I noticed when I posted the connection string it looked funny soI opened it in notepad again and turned off wordwrap and I also touched the web config and how the installer is opening.
Copyright© 2008 Telligent Systems Inc. All rights reserved CommunityServer.com • Telligent.com