IDT relational database connection issue

[Former Member]

Hi All,

I'm trying to create a universe based on relational database connection, I can connect to database using sql server management studio but in IDT its failing, could someone shine some light on this please.

database: sql server 2008

drivers: OLEDB providers

[former_member219634]

Hi Santosh

Issue is on user: please try using full qualifier of user

Best Regards

Ines

[Former Member]

Thank Ines for your reply,

sorry to ask this but what do you mean by "please try using full qualifier of user" how can I do that.

Thanks.

[mhmohammed]

Hey Santosh,

Instead of corp\sgandra_con, just use sgandra_con and see if that works. If that doesn't work either, try sgandra_con@corp.<domainname>.com which would be the fully qualified domain user name.

FYI:

Fully Qualified Domain Name (FQDN) - of a user, is a user name including the domain name.

E.g. In your case it would be sgandra_con@corp.<domainname>.com (That domainname can be your companyname.

Similarly FQDN is also used for Server names as SHE-CICSQLP1.corp.<domainname>.com

Thanks,

Mahboob Mohammed