When a user exports to a flat file she gets an access denied error. The wizard allows her to preview the data so she has access on the db side. From Windows she can create a new file in the target destination so she seems to have network permissions. She is logged into her computer with a network username and into SS2012 with a SS login. Everyone else can run the export wizard to this location successfully. I am stumped!
Sql-server – SS2012 Export Wizard Access is denied
importsql serversql-server-2012
Related Question
- SQL Server 2012 – How to Import Existing Database
- SQL Server – Simple Methods to Export and Import Data
- SQL Server – Deploy SSIS Package Without Password Entry Issues
- SQL Server Data Export – Handling Hundreds of Tables with Timestamps
- SQL Server – BULK INSERT Access Denied Error Resolution
- Sql-server – Copy SQL Server DB into another instance without SA access
Best Answer
T.H. Everyone has a their own logins. I love your idea to try someone elses SS login from her machine. Unfortunately the export was successful from her machine with my SS login and also a success from my machine with her SS login. I say unfortunately because it now works from her machine with her own SS login. The issue has resolved itself but I don't know why! :-(