IDS Forum

connection to informix 11.7 windows local system

Posted By: PRAJAKTA CHIKHALE
Date: Saturday, 14 July 2012, at 5:34 a.m.

In Informix 11.7X5 installed on Windows as local system account instead of using informix account, while installation user informix is created and added to Informix-Admin group in addition to Computer Administrator login through which informix was installed.

It seems it is known issue as specified in ids_win_fixed_and_known_defects_11.70 file in release notes

IC78379 [WINDOWS] USER INFORMIX AND GROUP

INFORMIX-ADMIN EXIST AFTER CUSTOM INSTALL

SPECIFYING LOCAL SYSTEM ACCOUNT

What is the work around for this ? Typical install installs it to C:\ where I do not have enough space. Creating additional user informix in Windows wastes lots of space for My Documents and other unwanted stuff. Still if I allow it to create informix account will it allow me to access database when looged in as other user. Will the database service start ? Basically there is volumes of information on Unix setup and dearth of information on windows setup.

I am able to create tables and connect to databases and issue after logging as informix. Creating dbspaces, logical logs all is possible as informix. All system databases sysadmin, sysmaster, sysuser, sysutil gets created successfully when I log in as informix. But when I log in as local system account, sysmaster (many times) and always sysadmin database does not get built.

Also login informix has been created with blank password. How do I change password of informix account ? Is there any command for this or changing password in windows user accounts work? Will changing password deny access to database for informix also ? Does ixpasswd change password for related services reliably ?

Does the problem exist for all versions of 11.7 or will installing 11.7x4 work ?

I am not to able to connect to database through OAT. For many of the options like
Logs -> Admin Command History
Space Administration -> Storage
SQL ToolBox -> Schema Browser

Following error is seen :

Connection Failed.
SQLSTATE=HY000, SQLDriverConnect: -387 [Informix][Informix ODBC Driver][Informix]No connect permission. sqlerrm(sysusers)

DSN:informix:host=test;service=3001;database=sysadmin;protocol=onsoctcp;server=ol_test

Also I am not able to connect through ODBC in Control Panel -> Administrative Tools to this database.

JDBC connectivity also not possible. Error shown as "Attempt to connect database server(ol_test) failed". Using the same drivers I am able to connect to other databases on Linux systems.

Also their is one new file since 11.7 olservice.log in INFORMIXDIR and previously following errors were observed in it

ol_test: Failure in SuMain(): WaitForMultipleObjects(): 0: The operation completed successfully.

The problem with OAT, ODBC, JDBC connectivity exists even when logged as informix.

I have tried reinstalling twice so I do not think that it might help.

Messages In This Thread

• connection to informix 11.7 windows local system
  PRAJAKTA CHIKHALE -- Saturday, 14 July 2012, at 5:34 a.m.
  • Re: connection to informix 11.7 windows local syst
    FRANK J. COMPUTER -- Saturday, 14 July 2012, at 12:35 p.m.
  • Re: connection to informix 11.7 windows local syst
    FRANK J. COMPUTER -- Monday, 16 July 2012, at 10:19 p.m.
    • Re: connection to informix 11.7 windows local syst
      PRAJAKTA CHIKHALE -- Tuesday, 17 July 2012, at 8:22 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.