Enterprise Manager registration

Discussion in 'Database Support' started by fedwebmaster, Jan 24, 2004.

  1. fedwebmaster

    fedwebmaster Guppy

    I have two Jodo accounts, both of which have SQL Server databases. Using the server name, username and password details from the H-sphere control panel I have successfully created an alias for the first database and registered it in E/Mgr. When I try the same procedure for the second database it fails.

    According to the control panel, the database server is the same - only the username and password are different - so I create a new alias for the second database but get an error when I attempt to register it in E/Mgr "Cannot open user default database. Login failed".

    I can open a connection to the second database using ASP code, but only if I use the IP address of the server as the data source (I use the network name of the server, eg. the one shown in sp_helpserver, on the 1st account which works fine). Querying the sysusers table (via some ASP) on the 2nd database, it shows my username.

    I can use sqladmin.jodohost.com and connect to the first database. I cannot do this for the 2nd database.

    What have I missed? Getting quite frustrated now :-( Any help will be greatly appreciated.

    Regards,
    Rob.
  2. fedwebmaster

    fedwebmaster Guppy

    All sorted now. No need to reply.

    Regards,
    Rob.

Share This Page

JodoHost - 26,000 hosting end-users in 100 countries
Plesk Web Hosting
VPS Hosting
H-Sphere Web Hosting
Other Services