适用于Informatica PowerCenter的SQL Server存储库 [英] SQL Server repository for informatica powercenter

问题描述

我在Windows Server 2008 R2上安装了Powercenter 9.1. 该存储库位于SQL Server 2012上的同一框上.我已经配置了一个新用户(使用sql Server身份验证)，并且该用户拥有repo db. (它具有所有者角色)

I have a powercenter 9.1 installation on windows server 2008 R2. The repository is on the same box, hosted on sql server 2012. I have configured a new user (with sql server authentication) and have the repo db owned by that user. (it has the owner role)

核心问题:我无法在此设置上运行简单的测试工作流程.

The core problem : I am not able to run a simple test workflow on this setup.

这就是我一直在尝试的

Windows防火墙已被关闭约一个小时左右.

The windows firewall has been taken down now for about an hour or so.

存储库服务和集成服务分别以跟踪/调试模式运行.

The repository service and integration service are running in trace/debug mode respectively.

Integration Service日志抱怨它无法在某些文件夹(所有ID都包含ID)中为特定工作流找到特定会话.

The integration service log complains that it cant find a certain session for a certain workflow in certain folder (with ids for all of them).

当我登录到sql server mgmt控制台，并尝试查询存储库表中的确切项目(因为我有日志中的ID)时，所有数据都存在...

When I log into sql server mgmt console, and try to query the repository tables for those exact items (since i have the ids from logs), all the data is present...

我不明白我在搞什么...

I fail to understand what is that I am messing up...

免责声明-我对sql server的了解真的很低..可能是10的比例是1或2，因为我整个职业生涯都生活在篱笆的另一端(与oracle在一起)...

Disclaimer - my knowledge of sql server is really low.. may be 1 or 2 on scale of 10, since I have been living on the other side of fence (with oracle) for all of my career...

推荐答案

您是否尝试将sql server登录名/用户名和关联的默认架构名保持相同?

Did you try keeping the sql server login/user name and the associated default schema name as same?

这篇关于适用于Informatica PowerCenter的SQL Server存储库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！