Import of flat file into SQL Server Management Studio fails

With this error: Error inserting data into table. (Microsoft.SqlServer.Import.Wizard)Error inserting data into table. (Microsoft.SqlServer.Prose.Import)Object reference not set to an instance of an object. (Microsoft.SqlServer.Prose.Import) In my case this was due to extra carriage returns at the end of the CSV file – SSMS doesn’t like them! Remove them in a text editor and try again.... » read more

Login failed for user ‘NT AUTHORITY\NETWORK SERVICE’

After our server people did some MS SQL database restores from some old backups to find some data, some .NET websites we had on the server started showing an error. (note I couldn’t see the error and had to disable custom errors from remote only, see here http://tech.ralpharama.co.uk/1/viewing-errors-remote-machine-after-sql-restores-broke-sites Server Error in '/' Application. Cannot open database... » read more