Sql server 2008 installation problem

All Replies

• Wednesday, May 30, 2012 1:37 PM

   

   
  

  0

  I'd suggest you re-post in one of these forums

  http://social.msdn.microsoft.com/Forums/en/category/sqlserver

  al

  ---

  If this answer solves your problem, please check Mark as Answered. If this answer helps, please click the Vote as Helpful button. Al Edlund Visio MVP

  • Reply
  • Quote

   
• Wednesday, May 30, 2012 5:35 PM

   

   
  

  0

  Hi

  I am facing some serious problems while installing sql server 2008 on windows 7 machine. 8 months before sql server 2008 was successfully installed in my PC and now its expired . So i need to re install sql server 2008 again in my PC. But there are some problems now i am facing.

   For successful installation of sql server 2008 i uninstalled visual studio 2010 and related things ,but when i tried to install i was unable to proceed as it is showing "Fusion Active Template Library" failed message . Some how i got solution to avoid this step through command line( got this from web). After that installation was going on, but still the sql server setup is failed with the error messages like  "Database service is failed" etc.

  So database engine is not installed properly i think. When i try to connect to the database engine this error message is coming "

  "a network related or instance specific error occured while establishing a connection to sql server. The server was not found or was not accessible. Verify that the instance name is correct and that sql server is configured to allow remote connections. (provider: Named pipes provider error:-40- Could not open a connection to sql server)(Microsoft Sql server, Error:2)"

   

  Could you please suggest a solution to install sql server 2008 properly

  
  

  • Edited by rejeesh nv Wednesday, May 30, 2012 5:41 PM added error message
  • Merged by Maggie LuoMicrosoft Contingent Staff, Moderator Friday, June 01, 2012 7:34 AM
  •  
  • Reply
  • Quote

   
• Wednesday, May 30, 2012 5:51 PM

   

   
  

  0

  The solution for the :Fusion Active Template Library" is detailed in this thread -  http://social.msdn.microsoft.com/Forums/is/sqlsetupandupgrade/thread/cde9cb93-1f3d-4c54-a7d0-1a860ac9285c . Since you have already implemented this fix and installed , could you take a look at the installation log and see if it shows any errors or warnings ?

  Is the SQL Server Service running ? You can check this under control panel > administrative tools > services

  Have you configured an admin (sa) user. try connecting to your sql server with the sa login.

  Are you connecting using mgmt studio from the same machine where you installed sql server ? If not, you will need to enable remote connections.

  ---

  Sanil Mhatre | Database Developer | MCTS | If you find my reply useful in any way, please vote it as helpful. If it has helped answer your question, please mark it as Answer. http://sqlwithsanil.com

  • Reply
  • Quote

   
• Wednesday, May 30, 2012 6:36 PM

   

   
  

  0

  Hi

  Fusion Active template library issue i have resolved. But database service installation is a failure in the end for 2008 installation . I tried to install sql server 2005 also. Then also database services set up is not success.  After this when i tried to connect database engine this error message is coming

  "a network related or instance specific error occured while establishing a connection to sql server. The server was not found or was not accessible. Verify that the instance name is correct and that sql server is configured to allow remote connections. (provider: Named pipes provider error:-40- Could not open a connection to sql server)(Microsoft Sql server, Error:2)"

  i tried several methods.But nothing helped me. Could you please explain in detail a good solution for this?

  • Reply
  • Quote

   
• Wednesday, May 30, 2012 10:48 PM

   

   
  

  0

  Thanks for confirming that the Fusion Active Template Library issue is resolved.

  Since you Say "Then also database services set up is not success" - could you share with us the error message during installation, that leads you to believe so. Have  you gone to "control panel > administrative tools > services" and checked if SQL Server Services show up and are running ?

  Please share the issue that you see in the installation log.

  Without this detail - ONLY based on the error message you have shared here, there is no useful troubleshooting to be done ! What are the "Several methods" that you tried but did not help ?

  Please share more information about the issue, because your current description does not give enough detail.

  
  

  ---

  Sanil Mhatre | Database Developer | MCTS | If you find my reply useful in any way, please vote it as helpful. If it has helped answer your question, please mark it as Answer. http://sqlwithsanil.com

  • Reply
  • Quote

   
• Friday, June 01, 2012 7:22 AM

  Moderator

   

   
  

  0

  Hi ejeesh,

  Please post the error messages when you installed SQL Server 2008 in detail. It is located at %programfiles%\Microsoft SQL Server\100\Setup Bootstrap\Log\. To find errors in the summary text file, search the file by using the "error" or "failed" keywords.

  How to view and read SQL Server Setup Log Files: http://msdn.microsoft.com/en-us/library/ms143702(v=sql.100).aspx.

  Also refer to: SQL Express is not installed properly. Steps to be taken before reinstall again: http://blogs.msdn.com/b/sreekarm/archive/2010/03/15/sql-express-is-not-installed-properly-steps-to-be-taken-before-reinstall-again.aspx.

   

  Thanks,
  Maggie

  ---

  Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.

  • Reply
  • Quote

   
• Friday, June 01, 2012 7:41 AM

  Moderator

   

   
  

  0

  "a network related or instance specific error occured while establishing a connection to sql server. The server was not found or was not accessible. Verify that the instance name is correct and that sql server is configured to allow remote connections. (provider: Named pipes provider error:-40- Could not open a connection to sql server)(Microsoft Sql server, Error:2)"

  Hi rejeesh,

  Winerr 2 means "The system cannot find the file specified". This error message means the client can reach the server but there is no Named Pipe listener with specific pipe name on the target machine. It also means the account can have a file sharing session without a problem.
  Possible reasons are:
   a) Typo in instance name or wrong instance name. The instance name is not the one you are targeting. Note that for default instance, you shouldn't use MSSQLSERVER as instance name.
   b) Target SQL Server is not running
   c) Named Pipe is not enabled on the server. In this case, the SQL server is not listenning on the specific pipe name.

  
  Thanks,
  Maggie

   

  
  

  ---

  Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.

  • Marked As Answer by rejeesh nv Wednesday, June 06, 2012 6:27 AM
  •  
  • Reply
  • Quote

   
• Wednesday, June 06, 2012 6:29 AM

   

   
  

  0

  Hi

  You are absolutely right..I resolved the issue as per ur suggestions.. Thanks

  • Reply
  • Quote