Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
 Posted - 2007-07-23 : 15:21:51
|
| Let me try to put this down in words...If I log into the SQL server with my credentials and connect to SSIS through SQL Management Studio, I'm able to execute my test SSIS package successfully.If I go to my machine and try to connect to SSIS "Integration Services..." I get "Access Denied" message.If I execute the same package via DTEXECUI, the package errors out also.My account is member of the group "Security_IT_Data", this group has sysadmin privileges on the SQL Server level.The account used to run the SSIS Service is part of the Local Admin group on the box and also a sysadmin on the SQL Server.What am I missing? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-23 : 16:34:58
|
| You logged on both machines with same windows account? Does your machine have same sql2k5 sp as on server? |
 |
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2007-07-23 : 17:25:10
|
| Correct, I logged on both machines with my personal domain account. Yes.I added the Security_IT_Data group the the local admin on the box, now I'm able to connect to Integration Services Server from SQLMS, but still not able to execute the test package, it errors out.Error Messages:Error: The product level is insufficient for component "Flat File Destination" (183). Error: The product level is insufficient for component "Row Count" (165). Not sure if I said this previously, but this and other packages work fine if executed via VS. |
|
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2007-07-24 : 09:33:37
|
| Here's the report I get when I go to control panel > add or remove programs > microsoft sql server 2005 > change > report for ssisTAKKARAThe following components are installed on this serverMSSQLSERVERDatabase Engine[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3042 Language: English (United States)]Common componentsIntegration Services[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3042 Language: English (United States)]Notification Services[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3042 Language: English (United States)]Workstation Components[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3042 Language: English (United States)] |
|
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2007-07-24 : 09:56:44
|
| I guess I found the issue... The SSIS component isn't installed on the clients. I'm going to try installing that on my box, if it works, we'll install across all clients computers. |
|
|
|
|
|
|
Connecting to SSIS puzzle