Umbraco 4.0.3 Install Step 2/5 - Windows Authentication.
I am trying to install Umbraco 4.0.3 and have been provided with a Database on a server with windows authentication (Company Policy doesn't allow SQL Authentication). I tried to hardcode the connection string "Data Source = xxxxxx, Initial Catalog = yyyyyy, Integrated Security = SSPI" in the web.config file and also gave the connection string during step2/5 under Custom Connection.
I get this error message,
"Database connection initialisation failed. The installer cannot connect to the database."
I can access the database using SQL server Management Studio.
I searched around but there isn't a conclusive solution for this. Any suggestions would be most welcome.
I am running Umbraco 4.0.3 on IIS 5.1 using VistaDB.
Slace, I managed to Copy the VistaDB tables successfully and manually. Now, I have to change the connection string in the web.config, herein lies the problem. Please shed light on the connection string to be specified.
Umbraco 4.0.3 Install Step 2/5 - Windows Authentication.
I am trying to install Umbraco 4.0.3 and have been provided with a Database on a server with windows authentication (Company Policy doesn't allow SQL Authentication). I tried to hardcode the connection string "Data Source = xxxxxx, Initial Catalog = yyyyyy, Integrated Security = SSPI" in the web.config file and also gave the connection string during step2/5 under Custom Connection.
I get this error message,
"Database connection initialisation failed. The installer cannot connect to the database."
I can access the database using SQL server Management Studio.
I searched around but there isn't a conclusive solution for this. Any suggestions would be most welcome.
I am running Umbraco 4.0.3 on IIS 5.1 using VistaDB.
/Baggi
The installer does not support using windows authentication, you can only use sql user accounts with the installer.
If you *must* use a windows account to connect to your database you'll need to manually install the database.
Thanks for clearing that up mate. Final question. How do I manually install the database? Transferring from VistaDB to SQL?
/Baggi
Slace, I managed to Copy the VistaDB tables successfully and manually. Now, I have to change the connection string in the web.config, herein lies the problem. Please shed light on the connection string to be specified.
is working on a reply...