| Author |
Message
|
| cadenza |
 Posted: Mon Dec 18, 2006 1:58 pm Post subject: Broker Creation Error - Windows Domain User |
 |
|
Apprentice
Joined: 01 Jun 2004
Posts: 48
|
Hi All,
I am facing problems in creating the broker for a domain user.
My Service user id is the domain user id that I have currently logged on with. I am using the syntax "domain\userid" for the service user id. My database is also configured for the same domain user. In other words when I test the DSN connection using "domain\user" and the password I am able to connect successfully.
However there lies a dilemma. The database user id is used for creating broker tables in the database. It is trying to create the tables with the schema "domain\userid", which DB2 is rejecting due to the presence of "\" character. 
Is there a work around for this problem? I am using MB 5.0 CSD 5
Thanx. |
|
| Back to top |
|
 |
| Gaya3 |
| Posted: Mon Dec 18, 2006 9:26 pm Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
Hi
As far as i know the database won't entertain any symbols like '\' or '/' etc
so i suggest you to use only characters that will help you out to resolve this issue
Thanks and Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| cadenza |
| Posted: Tue Dec 19, 2006 6:33 am Post subject: |
|
|
Apprentice
Joined: 01 Jun 2004
Posts: 48
|
Hi Gayathri,
Thanks for your response. However is there any other method to specify a domain user for this command? I didn't find one. I can't ignore the domain because without it the Database wont authenticate me to access it.
It seems that this command does not support a domain user account with the DB2 database. My DB2 version is 8.1 Fixpack 14.
I think one solution would be to create a "LOCAL" user and give it admin rights for DB2 and use this user id for the create broker command.
However I would go for domain user authentication if I have a work around for the problem.
Any ideas / comments?
Thanx. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue Dec 19, 2006 6:35 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
There used to be a "d" flag that would handle this.
It's not there now, though, and I'm sure it won't work.
You can try the alternate "user@domain" form.
Or you can set service user id to "domain\user" and database user id to "user".
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| cadenza |
| Posted: Tue Dec 19, 2006 6:49 am Post subject: |
|
|
Apprentice
Joined: 01 Jun 2004
Posts: 48
|
Hi Jeff,
I tried the "user@domain" format but it did not work. It is giving me authentication error.
I tried -i "domain\user" with -u "user" , that too did not work as it gave me authentication error. This is because DB2 is not able to recognize it as a domain user.
Thanx. |
|
| Back to top |
|
|
|
|
