Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am using SQL Server Management Studio with the following version information below:

Microsoft SQL Server Management Studio              10.50.4000.0
Microsoft Data Access Components (MDAC)             3.85.1132
Microsoft MSXML                                     2.6 3.0 4.0 5.0 6.0 
Microsoft Internet Explorer                         6.0.2900.5512
Microsoft .NET Framework                            2.0.50727.3053
Operating System                                    5.1.2600

When i try to use Task->Import Data.. i get error like shown below

enter image description here

The SQL server engine is 2008 R2 and the user is sysadmin. Also this error is occuring on all instances of SQL (both local and network) instances. I tried giving full permissions for the user on the SQL server installation folder. But that didn't help. So what might be the reason for this error? If you want any more information please write me.


I checked the process monitor for process DTSWizard.exe(used for import in sql) has about 160,000 events. Then i searched for "denied" in those. I got a registry entry showing "ACCESS DENIED" .Same is shown below.

enter image description here

Now i searched for that particular registry. But that registry entry was not there in the PC having problem.

Then i searched same registry entry in some other PC where there is no error for SQL import data. but in other PC also i didnt get same registry. But in these PC there where no ACCESS DENIED error in process monitor.

Now by using the process monitor events and access denied registry how can i trace the problem?

share|improve this question

closed as off-topic by Paul White, Colin 't Hart, Kin, RolandoMySQLDBA, dezso Aug 3 '15 at 9:29

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Tip of the iceberg - the question or comments reveal an underlying issue that would need extensive investigation by a consultant or database vendor support team: issues like this do not fit the SE Q&A model well. For more information see this meta post." – Paul White, Colin 't Hart, Kin, RolandoMySQLDBA, dezso
If this question can be reworded to fit the rules in the help center, please edit the question.

Could you try running process monitor to find out what access is being denied and report back? – Edward Dortland Jan 9 '14 at 9:01
I have seen most of this kind of errors are advised to solve by using process monitor. But in process monitor process DTSWizard.exe(used for import in sql) has about 160,000 events.How to track the error in that huge number of events? – IT researcher Jan 9 '14 at 9:10
At least we've now narrowed it down only 160k events. ;-) On a more serious note, try filtering on the result column. Exclude things like Success, buffer overflow. etc that would narrow it down to "only" 1k or 2k. – Edward Dortland Jan 9 '14 at 9:27
Just to confirm with you since the answers being given assume differently. You are receiving this error before you are even dialing in a SQL server name correct? I'm assuming this since your data source windows is still empty. – Edward Dortland Jan 9 '14 at 12:56
@EdwardDortland I have updated my question with process monitor results.Please check. Also what u mean by "your data source windows is still empty" in your previous comment? I am getting error while i click on import data in ssms.(before entering the data source-same can be seen in image also) – IT researcher Jan 10 '14 at 8:05