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".
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.
