topic Getting &quot;Login failed for user&quot; when loading data in QlikView https://community.qlik.com/t5/QlikView/Getting-quot-Login-failed-for-user-quot-when-loading-data/m-p/378357#M141113 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>Have restored a database on a SQL 2012 server. Connecting the database via ODBC (with user 'sa') from script editor works fine. Also selecting the table(s) to load. When trying to load data however, the load fails with "Login failed for user".&nbsp; </P><P></P><P>Have I missed something when restoring the database or are there any issues with SQL Server 2012? I have used the 'sa' account both when restoring the database and when connecting the db from script editor. </P><P></P><P>Mikael</P></BODY></HTML> Thu, 16 Aug 2012 07:41:19 GMT 2012-08-16T07:41:19Z Getting "Login failed for user" when loading data https://community.qlik.com/t5/QlikView/Getting-quot-Login-failed-for-user-quot-when-loading-data/m-p/378357#M141113 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>Have restored a database on a SQL 2012 server. Connecting the database via ODBC (with user 'sa') from script editor works fine. Also selecting the table(s) to load. When trying to load data however, the load fails with "Login failed for user".&nbsp; </P><P></P><P>Have I missed something when restoring the database or are there any issues with SQL Server 2012? I have used the 'sa' account both when restoring the database and when connecting the db from script editor. </P><P></P><P>Mikael</P></BODY></HTML> Thu, 16 Aug 2012 07:41:19 GMT https://community.qlik.com/t5/QlikView/Getting-quot-Login-failed-for-user-quot-when-loading-data/m-p/378357#M141113 2012-08-16T07:41:19Z Re: Getting "Login failed for user" when loading data https://community.qlik.com/t5/QlikView/Getting-quot-Login-failed-for-user-quot-when-loading-data/m-p/378358#M141114 <HTML><HEAD></HEAD><BODY><P>Have you enabled 'Allow Saving of Password'</P></BODY></HTML> Thu, 16 Aug 2012 17:14:27 GMT https://community.qlik.com/t5/QlikView/Getting-quot-Login-failed-for-user-quot-when-loading-data/m-p/378358#M141114 jeremy_fourman 2012-08-16T17:14:27Z