Post reply

cannot create DTS through wizard

  • April 24, 2006 at 1:30 pm

    #172176

    I am trying to create a dts, using the dts wizard via Enterprise Manager then I get an error message after I have selected the odbc data

    source and entered the System DSN - DTS Import/Export

    Error "A serious error occurred when connecting to the

    provider"

    I have created another DTS with the same system dsn, and no problems, can you tell me what is wrong?

  • April 25, 2006 at 6:31 am

    #633982

    Just out of curiosity what is the source database platform ie. MySql, PostgreSQL, db2, Oracle? 

    Thanks.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • April 25, 2006 at 8:10 am

    #634029

    Does the DSN use Windows NT Authentication or SQL Server Authentication?  Who are you logged in as for the Enterprise Mananger session?  It could be a permissions problem.

    Steve

  • April 25, 2006 at 8:22 am

    #634035

    I am using a sql server 2000 sp4, when I go through start-programs-export/import wizard its fine but when i go through enterprise manager I get this error, do you know what it could be? I am logging in as an administrator.

  • April 25, 2006 at 9:24 am

    #634071

    You have to see what is your server registration in the Enterprise Manager. When  you are working with DTS Wizard from the start menu it is you - administrator who is working. When you are working from EM you are whatever your registration in SQL Server shows plus what is the startup account for SQL Server plus a user who starts Enterprise Manager (depends on the scenario)

    If you watch Task Manager processes and open DTS Wizard from the start menu the process dtswiz.exe appears with the user as your windows login. If you start DTS wizard from Enterprise Manager than dtswiz.exe process does not start, instead the wizard runs in the parent process Enterprise Manager under the name mmc.exe because EM runs in its parent process Microsoft Management Console mmc.exe The user of MMC most probably will be your windows login too but your permissions on the remote server are limited to SQL Server startup account and more limited by your SQL Server account role membership. Also you Windows authentication may not work on the third computer (if a workstation-server chain contains more than 2 computers) because of the delegation issues.

    Regards,Yelena Varsha

  • April 25, 2006 at 9:32 am

    #634082

    thank you sooo much!

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply