Unable to Connect to SQL server from SQL server VBO

[VinothkumarC_N]

I am receiving below error when I am trying to login to SQL server using SQL server VBO A connection was successfully established with the server, but then an error occurred during the login process. (provider: Named Pipes Provider, error: 0 - No process is on the other end of the pipe.) I am able to telnet the SQL server from machine where I am connecting. No firewall/Connectivity issues Do we need to enable "Named pipes" on the configuration manager Has anyone faced and resolved this issue.

[Denis__Dennehy]

Can you connect to the database using Excel data options or Visual studio code.  It sounds as though your connection string is wrong somehow.

[AloknathSingh]

Could you please provide me the steps to use Data-Sql server VBO with steps?

[John__Carter]

Start with Set Connection to tell BP how to connect to the DB. For this you'll either need a SQL user/password or the current Windows account will need permission to access the DB. Then run your SQL via pages such as Execute or Get Collection.