Trying to install umbraco for the first time and have a bit of bother with databases.
In our set up we have a separate database and webserver. Problem is I can't get the connection to work using the IP of the database server in the installer.
Is this setup possible with Umbraco and do I need to do anything apart from putting in the database server IP and the logon details?
If you are having problems with the connection string in the installer, you can try and place it manually in the web.config file here
<appSettings>
<add key="umbracoDbDSN" value="" />
The connection string is the same as it would be for any .NET web project, so it doesn't matter if it's on the same or remote server, just as long as the connection string is working.
What @Rich said, plus, check that you can connect to the DB server from the other server using the IP address in say SQL Management Studio (if you have it on the web box) that way you'll get a detailed error message if there's something wrong (like the username/password is wrong for example).
Also, double check that the connection details are correct. Is the installer giving you an error message at all?
I started the setup again and corrected the file permissions (which I didn't do properly the first time round) and the IP worked fine. Silly mistake it looks like.
External Database
Hi folks,
Trying to install umbraco for the first time and have a bit of bother with databases.
In our set up we have a separate database and webserver. Problem is I can't get the connection to work using the IP of the database server in the installer.
Is this setup possible with Umbraco and do I need to do anything apart from putting in the database server IP and the logon details?
Cheers
Raymond
Hey Raymond,
Welcome to the forum!
If you are having problems with the connection string in the installer, you can try and place it manually in the web.config file here
<appSettings>
<add key="umbracoDbDSN" value="" />
The connection string is the same as it would be for any .NET web project, so it doesn't matter if it's on the same or remote server, just as long as the connection string is working.
Rich
What @Rich said, plus, check that you can connect to the DB server from the other server using the IP address in say SQL Management Studio (if you have it on the web box) that way you'll get a detailed error message if there's something wrong (like the username/password is wrong for example).
Also, double check that the connection details are correct. Is the installer giving you an error message at all?
the SQL Server may have not been configured to allow remote connections.
Hay folks,
Thanks for the replies.
I started the setup again and corrected the file permissions (which I didn't do properly the first time round) and the IP worked fine. Silly mistake it looks like.
Thanks
Raymond
is working on a reply...