ArcSDE Underlying DBMS Error in ArcCatalog

[SukheshKrishna]

Hello,

I have two spatial databases in my SQL Server R2. First database is the one created while creating the service, and second one is later on. While I try to connect to the second database through ArcCatalog an error comes up, saying "Not able to connect to the datase, underlying DBMS error".

Can any one help me please... ?

Thanks,
Sukhesh Krsihna.

[anthonysanchez]

Sukhesh,
you may get more responses if you provide the specifics of your architecture:

Operating System
sde version + service packs
application connection or direct connection
multiple vs single gdb model
etc

and the specific steps to reproduce (specifics of your connection)

good luck,

Anthony

[KimPeter]

Sukhesh,

Are you trying to connect to the second geodatabase using the same ArcSDE service you created when creating the first geodatabase?  If so, that could be your problem. If you use an ArcSDE service to connect, you have to have one for each geodatabase with its own unique name and port.

Try making a direct connection to the second geodatabase (syntax = sde:sqlserver:<name of sql server instance>.  If that works, then you probably need to create a second ArcSDE service (if that's how you want to connect to the second geodatabase).

Hope this helps,
-Kim