views

Search This Blog

Monday, November 26, 2018

Database connection failed While deploying vRA 7.3.x


While deploying vRA from LCM2.0 getting error in 6th step stating "Database connection failed". 


I  seen  below error message inside log file

   Result: Database connection failed. Verify that you are using the full instance name typed correctly, that the database user and password are correct, and that TCP/IP is enabled for the instance. Error details: A network-related or instance-specific error occurred 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)
 



The most common reasons for this error can be resolved using the one or more of the steps below. 

Solution 

There could be several reasons you get these error messages. Follow the below steps to see if you can resolve the issue.

Step 1

Make sure you are able to ping the physical server where SQL Server is installed from the client machine. If not, you can try to connect to the SQL Server using an IP Address (for default instance) or IP Address\Instance Name for a named instance. 

Step 2

Make sure the SQL services are running You can check the SQL Server services by using the SC command or SQL Server Configuration Manager. Many times you may find that the SQL Server instance is not running. 

Step 3

Make sure you are using the correct instance name. When you connect to a default instance, machinename is the best representative for the instance name and when you connect to a named instance such as sqlexpress, you should specify machinename\instancename 

Step 4

Check for TCP/IP and Named Pipes protocols and port. Open SQL Server Configuration Manager and check the SQL Server Network Configuration protocols. You should enable Named Pipes and TCP/IP protocol.

For the TCP/IP protocol, right click and select properties to check the TCP/IP communication port as well. The default port is 1433, which can be changed for security purposes if needed. 

 

Note -  I used SQLEXPRESS in my Lab . 

Next time you have issues connecting, check these steps to resolve the issue.

Thank you 

 


11 comments:

  1. Replies
    1. IEEE Final Year projects Project Center in Chennai are consistently sought after. Final Year Students Projects take a shot at them to improve their aptitudes. Final Year Project Domains for IT

      JavaScript Training in Chennai

      JavaScript Training in Chennai

      The Angular Training covers a wide range of topics including Components, project projects for cse. Angular Training

      Delete
  2. The AAA Cartier Replica watches sale at are best quality cheap fake watch from China,The replica cartier uk high end Cartier replica watches include Ballon Bleu De Cartier, Calibre De Cartier, replica ballon bleu de cartier watchesCartier La Dona,Cartier Love Watch,Cartier Pasha,Cartier Roadster,Cartier Santos,Cartier Tank replica watches,We can shipp to Uk,USA,canada,australia,and almost all country worldwide.

    ReplyDelete
  3. The Royal Oak Offshore collection replica watches uk has defied established conventions since 1993,replica royal oak watches giving an ever more sporty, masculine and powerful take on the iconic Royal Oak and its aesthetic codes.

    ReplyDelete
  4. Longines watches have been a landmark of the replica watches uk industry since their brand began in 1832 in Saint-Imier. Today, the replica Longines 1832 watches brand offers a wide variety of watches for men and women. Watches manufactured by Longines have been utilized throughout history for everything from exploration ventures to the expression of elegance. In addition to being famous for their ties to the racing and equestrian worlds, Longines watches are globally recognized for their timeless chic sophistication. we have a variety of Longines watches for sale, all new, beautiful, and guaranteed to be genuine. Even better, when shopping our Longines watches online, you know you are getting the best value. Browse our selection to find the Internet’s best Longines watch price.

    ReplyDelete
  5. I never comment on blogs but your article is so best that I never stop myself to say something about it. You’re amazing Man, I like it Database Errors... Keep it up

    ReplyDelete
  6. I check cloud ping on this blog Cloudping.online

    Thanks...

    ReplyDelete
  7. A motivating discussion is worth comment. I believe that you need to publish more about this subject matter, it may not be a taboo matter but generally folks don't speak about such subjects. To the next! Cheers!!
    Tech news

    ReplyDelete

Deploy Windows VMs for vRealize Automation Installation using vRealize Suite Lifecycle Manager 2.0

Deploy Windows VMs for vRealize Automation Installation using vRealize Suite Lifecycle Manager 2.0 In this post I am going to describe ...