Connecting to the Sql server 2005

[#1]

Hi,

I am connecting SQL Server 2005 as the data source,when i login using SQL Server Authentication using username and password not able to connect to the datasource and selecting the tables.

Username:sa

When myself write the sql queries to extract the tables (ie...) select * from particular table..it's ask for username and password when i save the qlikview document,it's ask for sql server username and password then its working.

Pls.,help me out to connect to the datasource.

Thanks

[#2]

Hi,

I am connecting SQL Server 2005 as the data source,when i login using SQL Server Authentication using username and password not able to connect to the datasource and selecting the tables.

Username:sa

When myself write the sql queries to extract the tables (ie...) select * from particular table..it's ask for username and password when i save the qlikview document,it's ask for sql server username and password then its working.

Pls.,help me out to connect to the datasource.

Thanks

[#3]

try to use the connection OLEDB et using Microsoft OLE DE provider for SQL Serveur

[#4]

i tried that one eventhough its not connected...

any other solutions

[#5]

can u please share the screenshot of the connectivity