vendredi 17 avril 2015

SQL Server 2008 R2 installation nightmare

I'm not a SQL Server specialist, i'm only a software developer. But i've been using SQL Server since version 7.


I have apps that use SQL Server, so i often need to install this DB on my customers machines.


Until SQL Server 2005 i had no issues ; i just installed , attach my DB and everything worked fine.


Some customers want upgrade to 2008 version and that's when the nightmare started.


It seems SQL Server 2008 has a lot of new 'security' restrictions and the fact is everytime i try to install it, it NEVER finishes the installation without problems.


Some errors i get include :



  • 'Access denied' at the end of installation

  • 'Error 1814' when trying to start the service

  • Windows authentication not connecting


If i run the SQL Sever 2005 installation, it works fine as always.


Due to all these problems, can anyone point me to some advices to how really get a fluid and efficient install of SQL Server 2008 R2, just like 2005 worked ?


Thanks in advance !


Aucun commentaire:

Enregistrer un commentaire