I'm having the same problem as NiQ - Once I enter a valid connection string, the error above appears. Interestingly, this is only if the connection string is correct. If I deliberately enter an incorrect username / password, then the error that is returned (as expected) is:
An error occured while testing connection string: Login failed for user 'dbusername'.
I've been using Umbraco 4 for a while now for a number of sites and not had this error message before. The installation is on a Plesk shared hosting environment, with MSSQL 2008 as the database.
Alex, I have ran your SQL Query with the following result:
Hi there, according to http://www.sqlteam.com/article/sql-server-versions you're actually running against SQL Server 2005 - if your hosting account does have 2008, please check you've picked the right instance name when you put in the connection details
My mistake, it is SQL Server 2005 that's on the host server (I'm running 2008 on my local machine and it works fine), so that looks like it is the problem. I'll upgrade to SQL Server 2008 and report back.
"Value was either to large or too small" Umbraco 5 installation, connectionstring
I get this error message when I click to use an empty Windows Server 2008 database:
An error occured while testing connection string: Value was either too large or too small for an Int32.
I have entered all neccesary information such as server, database, username and password.
Does this solve your problem?
http://our.umbraco.org/forum/core/umbraco-5-general-discussion/25686-Umbraco-v5-install-wizard
Hi NiQ, please can you run the following query on your SQL Server 2008 db and report back what results you get?
Hi,
I'm having the same problem as NiQ - Once I enter a valid connection string, the error above appears. Interestingly, this is only if the connection string is correct. If I deliberately enter an incorrect username / password, then the error that is returned (as expected) is:
An error occured while testing connection string: Login failed for user 'dbusername'.
I've been using Umbraco 4 for a while now for a number of sites and not had this error message before. The installation is on a Plesk shared hosting environment, with MSSQL 2008 as the database.
Alex, I have ran your SQL Query with the following result:
9.00.5000.00 SP4 Workgroup Edition
Hi there, according to http://www.sqlteam.com/article/sql-server-versions you're actually running against SQL Server 2005 - if your hosting account does have 2008, please check you've picked the right instance name when you put in the connection details
Hi Alex,
My mistake, it is SQL Server 2005 that's on the host server (I'm running 2008 on my local machine and it works fine), so that looks like it is the problem. I'll upgrade to SQL Server 2008 and report back.
Thanks for your help.
is working on a reply...