<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{mso-style-priority:99;
mso-style-link:"Plain Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.5pt;
font-family:Consolas;}
span.PlainTextChar
{mso-style-name:"Plain Text Char";
mso-style-priority:99;
mso-style-link:"Plain Text";
font-family:Consolas;}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-AU link=blue vlink=purple>
<div class=Section1>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>Good
morning all,<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>I’m
hoping for some fresh ideas.<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>A
few nights ago, the Ingres Windows server was rebooted and from that point, remote
Ingres Net/OpenROAD connections are rejected with errors:<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt;font-family:"Calibri","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>E_GC000B_RMT_LOGIN_FAIL Login
failure: invalid username/password.<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>E_GC000B_RMT_LOGIN_FAIL Login
failure: invalid username/password.<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>E_GC000E_RMT_LOGIN_FAIL_INFO A
remote login attempt failed. The remote machine was 'MACHINE', and the userid
was 'someuser'.<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt;font-family:"Calibri","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>sql myvnode::pw<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>INGRES TERMINAL MONITOR
Copyright 2008 Ingres Corporation<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>E_LC0001 GCA protocol
service (GCA_REQUEST) failure.<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'> Internal service status
E_GC000b -- Login failure: invalid<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'> username/password..<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>E_LQ0001 Failed to connect
to DBMS session.<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'><o:p> </o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>These
work:<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>RDP
to the Ingres server as user Ingres, and can connect directly to any of the
databases with command line sql.<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>A
local .net application is working fine synchronising between Ingres and MSSQL
which are running together on the server.<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>These
fail:<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>vnode
connections from remote machine.<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>vnode
Local loopback to 127.0.0.1.<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>vnode
changed user to ingres and other users.<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>Created
new vnode.<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>The
installation is owned by ingres. The site has been running since 2014.<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>II
10.1.1 (a64.win/100) + P14744<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>I've
checked ownership and permissions on all IngresII files.<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>I've
created a new Ingres user and corresponding operating system user. Also fails.<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>The
reject is immediate, it does not seem to be firewall timeout or DNS lookup.<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>I've
stopped and restarted Ingres service. Reset the password in the service.<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>Run
a install/repair and repatched.<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>I
checked there have been no recent changes to vnode files in
%II_SYSTEM%\ingres\files\name\<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>Checked
Ingres and system environment variables<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>Started
ingres in local test only mode. (iigcn+iigcc)<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>Confirmed
Ingres is a local admin, removed and added the account to "logon as a
service", "logon as a batch" and "act as part of the
operating system"<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>Confirmed
settings for “access this server from the network”.<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>The
Windows event log shows slightly different messages depending if I use ingres user
for connect:<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span style='font-size:9.0pt'>============<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span style='font-size:9.0pt'>EventID:4625<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span style='font-size:9.0pt'>Security
ID:MACHINE\ingres<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span style='font-size:9.0pt'>Account
Name:ingres<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span style='font-size:9.0pt'>Account
Domain:MACHINE<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span style='font-size:9.0pt'>Logon
ID:0x22F7B<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span style='font-size:9.0pt'>Logon
Type:3<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span style='font-size:9.0pt'>Account
for which Logon Failed:<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span style='font-size:9.0pt'>Security
ID:NULL SID<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span style='font-size:9.0pt'>Account
Name:ingres<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span style='font-size:9.0pt'>Account
Domain:<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span style='font-size:9.0pt'><o:p> </o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span style='font-size:9.0pt'>Failure
information:<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span style='font-size:9.0pt'>Failure
Reason:An Error occurred during Logon<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span style='font-size:9.0pt'>Status:0xC0000022<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span style='font-size:9.0pt'>Sub
Status:0x0<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span style='font-size:9.0pt'>Process
information<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span style='font-size:9.0pt'>Caller
ProcessID: 0xb58<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span style='font-size:9.0pt'>Caller
Process Name c:\IngresI\ingres\bin\iigcn.exe<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span style='font-size:9.0pt'>Network
Information<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span style='font-size:9.0pt'>Workstation
Name:MACHINE<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span style='font-size:9.0pt'><o:p> </o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span style='font-size:9.0pt'>============<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span style='font-size:9.0pt'>EventID:4625<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span style='font-size:9.0pt'>Security
ID:MACHINE\ingres<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span style='font-size:9.0pt'>Account
Name:ingres<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span style='font-size:9.0pt'>Account
Domain:MACHINE<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span style='font-size:9.0pt'>Logon
ID:0x22F7B<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span style='font-size:9.0pt'>Logon
Type:3<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span style='font-size:9.0pt'>Account
for which Logon Failed:<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span style='font-size:9.0pt'>Security
ID:NULL SID<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span style='font-size:9.0pt'>Account
Name:someuser<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span style='font-size:9.0pt'>Account
Domain:<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span style='font-size:9.0pt'><o:p> </o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span style='font-size:9.0pt'>Failure
information:<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span style='font-size:9.0pt'>Failure
Reason:Unknown user name or bad password<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span style='font-size:9.0pt'>Status:0xC000006D<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span style='font-size:9.0pt'>Sub
Status:0xC000006A0<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span style='font-size:9.0pt'>Process
information<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span style='font-size:9.0pt'>Caller
ProcessID: 0xb58<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span style='font-size:9.0pt'>Caller
Process Name c:\IngresI\ingres\bin\iigcn.exe<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span style='font-size:9.0pt'>Network
Information<o:p></o:p></span></p>
<p class=MsoPlainText style='margin-left:36.0pt'><span style='font-size:9.0pt'>Workstation
Name:MACHINE<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>The
default Ingres port 21064 is open for TCP4 and TCP6.<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>netstat -an | grep 21064<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'><o:p> </o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'> TCP
0.0.0.0:21064 0.0.0.0:0 LISTENING<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'> TCP
127.0.0.1:21064 127.0.0.1:62866 TIME_WAIT<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'> TCP
127.0.0.1:21064 127.0.0.1:62897 TIME_WAIT<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'> TCP
[::]:21064 [::]:0 LISTENING<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'><o:p> </o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>netstat -anb<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'> TCP 0.0.0.0:21064 0.0.0.0:0
LISTENING<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'> [iigcc.exe]<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'> TCP
127.0.0.1:21064 127.0.0.1:62866 TIME_WAIT<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'> TCP 127.0.0.1:21064
127.0.0.1:62897 TIME_WAIT<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'> TCP
[::]:21064 [::]:0 LISTENING<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'> [iigcc.exe]<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'><o:p> </o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>GCA
trace has been captured. Here is my script.<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'><o:p> </o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>@echo off<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>if [%1] == [-s] (<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>echo setting<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>ingsetenv II_GCA_TRACE 5<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>ingsetenv II_GCN_TRACE 5<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>ingsetenv II_GCS_TRACE 5<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>ingsetenv II_GCC_TRACE 5<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>ingsetenv II_GC_TRACE 5<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>ingsetenv II_GCA_LOG
C:\IngresII\ingres\files\iigca_%%d_%%p.log<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>goto end<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>) <o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'><o:p> </o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>echo clearing<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>ingunset II_GCA_TRACE<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>ingunset II_GCN_TRACE<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>ingunset II_GCS_TRACE<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>ingunset II_GCC_TRACE<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>ingunset II_GC_TRACE<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>ingunset II_GCA_LOG <o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'><o:p> </o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>:end<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>Here
is an excerpt of the trace<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>The
second call to GCS_USR_AUTH fails with status </span><span style='font-size:
9.0pt'>000C000B</span><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>,
it matches the status in the reject given to the user “</span><span
style='font-size:9.0pt'>E_GC000b”</span><span style='font-size:10.0pt;
font-family:"Calibri","sans-serif"'><o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'><o:p> </o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>!GCS call: GCS_OP_VALIDATE,
mechanism <internal><o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>!GCS call: validating
GCS_USR_AUTH with mechanism ingres<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>!GCS ingres:
GCS_OP_VALIDATE<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>!GCS ingres: validating
GCS_USR_AUTH (43 bytes)<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>!GCS ingres: user 'ingres',
alias 'ingres'<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>!GCS ingres:
GCS_OP_VALIDATE status 0x00000000<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>!GCS call: GCS_OP_VALIDATE,
status 0x00000000<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>! 1 GCA LS_CHKBED
status 00000000 (148)<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>! 1 GCA LS_CHKAPI
status 00000000 (149)<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>! 1 GCA RG_IF_NSDISC
status 00000000 (203)<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>! 1 GCA LS_DONE
status 00000000 (209)<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>! 1 GCA SA_COMPLETE
status 00000000 (210)<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>! 1 GCA_COMPLETE 4
status=00000000<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>! 1 GCA_COMPLETE 4
completing<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>...<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>!GCS call: GCS_OP_VALIDATE,
mechanism <internal><o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>!GCS call: validating
GCS_PWD_AUTH with mechanism ingres<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>!GCS ingres:
GCS_OP_VALIDATE<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>!GCS ingres: validating
GCS_PWD_AUTH (82 bytes)<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>!GCS ingres: alias
'someuser'<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>!GCusrpwd: Entry point.<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>!GCS ingres: invalid
password: 'mypasswd#'<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>!GCS ingres:
GCS_OP_VALIDATE status 0x000C000B<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>!GCS call: GCS_OP_VALIDATE,
status 0x000C000B<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>! 2 GCA LS_SET_PSTAT
status 000C000B (152)<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>! 2 GCA LS_FMT_PEER
status 000C000B (153)<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>! 2 GCA SA_SEND_PEER
status 000C000B (154)<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>! 2 GCA SA_GOSUB
status 000C000B (155)<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'>! 2 GCA GC_SEND
status 000C000B (509)<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:9.0pt'><o:p> </o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>Other
clues I have:<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>Windows
patches were applied as part of the reboot.<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>New
software was installed elsewhere on the machine.<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>MSSQL
is running ok with remote connections.<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>Server
is part of a domain but is not the DNS.<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>No
other start up errors in Ingres errlog.log.<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>Site
claims there has been no policy changes.<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>UAC
is enabled on the server Win2012<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>I
suspect the site administrator has changed something to do with guest account,
as I can see several attempts to log in as Administrator and Guest just prior
to restart.<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>Next
steps:<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>Remove
recent windows patches<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>Disable
UAC<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>Disable
Antivirus/firewall<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>&<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>Shift
Seven Solutions<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>84
Annie Drive Peregian Beach QLD 4573<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>Mob
0414 681799<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>Ph
07 5448 2137<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>www.shift7solutions.com.au<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'><o:p> </o:p></span></p>
</div>
</body>
</html>