User cannot see SSIS package on Server
Hello, I deployed an SSIS package from Visual Studio 2008 to the SQL Server on the same windows 7 machine.(In the SQL Server Manag. Studio I connected to the Integration Services as the windows admininstrator). The problem is a colleague with her own login
connects to to the integration services in the Management Studio but cannot see the directories under the directory MSDB. She gets the error (translated from german) "no server instance available.." telling me something about a standard instance (???) and
also stating "error logging in (MsDtsSrvr).." This is rather confusing to me? Anyone who could explain this? Thank you!!! SergioGreetings from No Planet!
May 24th, 2011 7:38am
looks like she does not have enough permissions on MSDB database. can you please tell use does she able to connection SQL Server instance?http://uk.linkedin.com/in/ramjaddu
Free Windows Admin Tool Kit Click here and download it now
May 24th, 2011 7:43am
You may need to add the user to a SSIS Role
http://msdn.microsoft.com/en-us/library/ms141053.aspxJeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA Blog: MrWharty.wordpress.com
May 24th, 2011 8:03am