topic Re: Unable to connect to Microsoft SQL Server in QlikView

Unable to connect to Microsoft SQL Server

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello everyone, I am adding screenshot of what I have tried to pass while connection to Microsoft SQL server,but unable to connect as the "create" connection button is disabled. Please let me know how I can solve this problem.

Re: Unable to connect to Microsoft SQL Server

Anil_Babu_Samineni — Sun, 25 Feb 2018 00:15:22 GMT

May be don't have permission. You can ask your admin to connect by there end instead developer?

Re: Unable to connect to Microsoft SQL Server

shilpan — Sun, 25 Feb 2018 03:11:58 GMT

I agree with Anil. Please make sure that you have permission to create connections

Re: Unable to connect to Microsoft SQL Server

ramasaisaksoft — Mon, 26 Feb 2018 11:47:49 GMT

Hi Kumar Sahu,

If you have the MS SQL Server access the check with your credentials weather you have the access for that Server and the Database

Then you can try to work on QV/QS.

Use the ADO (OLE DB) connection string rather than ODBC.

Select OLE DB, then click Connect and choose "Microsoft OLE DB Provider for Microsoft SQL Server" from the list.

ADO is faster and does not rely on a connection string being setup in control panel.

Re: Unable to connect to Microsoft SQL Server

Anonymous — Wed, 28 Feb 2018 12:59:37 GMT

Hello Rama, Shilpan, Anil thank you for your kid reply, I am using it on my localhost in my PC and the user I am logged in with is the admin of Microsoft SQL Server.

@Ram, Can you please let me know where I can get the window you have specified in Windows 10?

Re: Unable to connect to Microsoft SQL Server

ramasaisaksoft — Thu, 01 Mar 2018 05:33:24 GMT

windows-->Administrative Tools-->ODBC Data Sources(64-bit)-->User DSN Tab-->ADD

Re: Unable to connect to Microsoft SQL Server

Anonymous — Thu, 01 Mar 2018 18:46:57 GMT

I am having this on my system there, can you please let me know, what I should do here?