I have configured DSN in ODBC data source to connect o SqL server 2005 db, however in 'Edit Script' while I connect to db, i cannot see default sql db, it comes only after giving Sysadmin login id and Password. I need to create a user in SQL Server DB to load all tables needed for QlikView reports and use my login, instead of Sysadmin login. Please help on above issue.
Please share a doc on step by step to connect ot SQL server 2005, in mnual i cannot find much info.Also please tell if any additional drivers/sw is needed to connect to SQL server.
