|
| RMS Log Analyzer & SQL2005 |
 |
Wed, 20 Feb 2008 09:07:01 -080 |
Hi all
I have a RMS DB named RMSDB in SQL2005 server ABCSRV, and now try to install
RMSLogAnalyzer.exe to analyser the RMS logs. when running RMSLogAnalyzer.exe
locally on the SQL2005 server, it looks that it always connects to
DRMS_Log_Admin on 127.0.0.1, and the error is "SQL Server does not exist or
access denied". but I have no issue to connect DRMS_Log_Admin via ODBC
connection. any idea ?
here is the DBConfig.xlm file:
<RMSAdminConfig>
<Server HostName="ABCSRV\RMSDB",
DatabaseName="DRMS_Logging_RMS_80"></Server>
</RMSAdminConfig>
thanks for ur advise.
|
| Post Reply
|
| RE: RMS Log Analyzer & SQL2005 |
 |
Wed, 20 Feb 2008 09:33:01 -080 |
I've documented setting up log analyzer and quicklook in detail here:
http://blogs.technet.com/rmssupp/archive/2006/12/15/making-rms-troubleshooting-m
o-betta-w-quicklook-pt-1.aspx
-Jason
"Jonson Yang" wrote:
> Hi all
> I have a RMS DB named RMSDB in SQL2005 server ABCSRV, and now try to
install
> RMSLogAnalyzer.exe to analyser the RMS logs. when running
RMSLogAnalyzer.exe
> locally on the SQL2005 server, it looks that it always connects to
> DRMS_Log_Admin on 127.0.0.1, and the error is "SQL Server does not
exist or
> access denied". but I have no issue to connect DRMS_Log_Admin via ODBC
> connection. any idea ?
> here is the DBConfig.xlm file:
> <RMSAdminConfig>
> <Server HostName="ABCSRV\RMSDB",
DatabaseName="DRMS_Logging_RMS_80"></Server>
> </RMSAdminConfig>
>
> thanks for ur advise.
|
| Post Reply
|
| RE: RMS Log Analyzer & SQL2005 |
 |
Wed, 20 Feb 2008 09:50:08 -080 |
Hi Jason
thanks for ur prompt respones. yes, I have already gone through your blog b4
the post.
my question here is that my SQL server has multi Instance, and RMSDB is one
of them. also, does not matter how I change the ServerName (with or without
the RMSDB Instance name) in the DBConfig.xml , it looks always connect to
127.0.0.1, and encounter the same error
cheers
"Jason Tyler" wrote:
> I've documented setting up log analyzer and quicklook in detail here:
>
>
http://blogs.technet.com/rmssupp/archive/2006/12/15/making-rms-troubleshooting-m
o-betta-w-quicklook-pt-1.aspx
>
> -Jason
>
> "Jonson Yang" wrote:
>
> > Hi all
> > I have a RMS DB named RMSDB in SQL2005 server ABCSRV, and now try to
install
> > RMSLogAnalyzer.exe to analyser the RMS logs. when running
RMSLogAnalyzer.exe
> > locally on the SQL2005 server, it looks that it always connects to
> > DRMS_Log_Admin on 127.0.0.1, and the error is "SQL Server does
not exist or
> > access denied". but I have no issue to connect DRMS_Log_Admin via
ODBC
> > connection. any idea ?
> > here is the DBConfig.xlm file:
> > <RMSAdminConfig>
> > <Server HostName="ABCSRV\RMSDB",
DatabaseName="DRMS_Logging_RMS_80"></Server>
> > </RMSAdminConfig>
> >
> > thanks for ur advise.
|
| Post Reply
|
| RE: RMS Log Analyzer & SQL2005 |
 |
Wed, 27 Feb 2008 09:55:01 -080 |
based on a few round of testing, my finding is that RMSLogAnalyzer.exe is
ONLY workable with the default DB instance (i.e MSSQLSERVER) and also the
default port - 1433.
btw, Microsoft has clarified that it does NOT support RMS Admin Toolkit for
SP2
cheers
"Jason Tyler" wrote:
> I've documented setting up log analyzer and quicklook in detail here:
>
>
http://blogs.technet.com/rmssupp/archive/2006/12/15/making-rms-troubleshooting-m
o-betta-w-quicklook-pt-1.aspx
>
> -Jason
>
> "Jonson Yang" wrote:
>
> > Hi all
> > I have a RMS DB named RMSDB in SQL2005 server ABCSRV, and now try to
install
> > RMSLogAnalyzer.exe to analyser the RMS logs. when running
RMSLogAnalyzer.exe
> > locally on the SQL2005 server, it looks that it always connects to
> > DRMS_Log_Admin on 127.0.0.1, and the error is "SQL Server does
not exist or
> > access denied". but I have no issue to connect DRMS_Log_Admin via
ODBC
> > connection. any idea ?
> > here is the DBConfig.xlm file:
> > <RMSAdminConfig>
> > <Server HostName="ABCSRV\RMSDB",
DatabaseName="DRMS_Logging_RMS_80"></Server>
> > </RMSAdminConfig>
> >
> > thanks for ur advise.
|
| Post Reply
|
| RE: RMS Log Analyzer & SQL2005 |
 |
Tue, 15 Apr 2008 13:31:04 -070 |
I would think if you have a multi-instance, you'd have a SQL cluster... in
that case you'd put your cluster name into the DBConfig.xml file as the
"Server HostName". In any event, just use one of the server names if
you
don't have a cluster, not both with a slash, if that was actually what you
put in the file.
You can run Log Analyzer on any server, local or remote, if you have SP2 of
RMS installed, and are using the SP2 Admin toolkit. When you have that, just
run
RMSLogAnalyzer.exe /ALTDB <SQL_SERVER_NAME> (no brackets)
on the C:\Program Files (x86)\RMS SP2 Administration Toolkit\RMSLogAnalyzer
directory (assuming you use the default location).
Good luck.
Tom
"Jonson Yang" wrote:
> based on a few round of testing, my finding is that RMSLogAnalyzer.exe is
> ONLY workable with the default DB instance (i.e MSSQLSERVER) and also the
> default port - 1433.
> btw, Microsoft has clarified that it does NOT support RMS Admin Toolkit for
> SP2
>
> cheers
>
> "Jason Tyler" wrote:
>
> > I've documented setting up log analyzer and quicklook in detail here:
> >
> >
http://blogs.technet.com/rmssupp/archive/2006/12/15/making-rms-troubleshooting-m
o-betta-w-quicklook-pt-1.aspx
> >
> > -Jason
> >
> > "Jonson Yang" wrote:
> >
> > > Hi all
> > > I have a RMS DB named RMSDB in SQL2005 server ABCSRV, and now try
to install
> > > RMSLogAnalyzer.exe to analyser the RMS logs. when running
RMSLogAnalyzer.exe
> > > locally on the SQL2005 server, it looks that it always connects
to
> > > DRMS_Log_Admin on 127.0.0.1, and the error is "SQL Server
does not exist or
> > > access denied". but I have no issue to connect
DRMS_Log_Admin via ODBC
> > > connection. any idea ?
> > > here is the DBConfig.xlm file:
> > > <RMSAdminConfig>
> > > <Server HostName="ABCSRV\RMSDB",
DatabaseName="DRMS_Logging_RMS_80"></Server>
> > > </RMSAdminConfig>
> > >
> > > thanks for ur advise.
|
| Post Reply
|
|
|
|
|
|
|
|
|
|