SQL server connection

[Anonymous]

Dear all,

I tried to connect to a SQL server but it doesn't work. Please can you help me ? I have these following information : 

• Data Source = "sql-isotarget-qual\Isotarget_qual"
• Initial Catalog = "VENDORSMDW_QUAL"
• Name = "VENDORSMDW.Application"

[v-xicai]

Hi   @Anonymous ,

Does that make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best regards

Amy

[v-xicai]

Hi @Anonymous ,

You may connect to the SQL Server database using SQL Server database connector in Power BI Desktop, see more details: https://docs.microsoft.com/en-us/power-bi/service-gateway-sql-tutorial.

Please check if the Server name and Database name are correct.

Please check the Named Pipes connections or TCP/IP connections. See more in the blog:

https://www.mssqltips.com/sqlservertip/2340/resolving-could-not-open-a-connection-to-sql-server-erro...

(Please understand that this link is provided “AS IS” with no warranties or guarantees of content changes, and confers no rights.)

You may also resolve the issue via the troubleshooting ink: https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/troubleshoot-connecting-to-the-sql-server-database-engine?view=sql-server-ver15.

Best Regards,

Amy

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@Anonymous can you connect to this sql server from other application like ssms?

[Anonymous]

@parry2k : Yes, I can connect to the SQL server by the "ODBC data base" (in fact I can't install on my laptop SSMS)