Home | Site Map | Cisco How ToNet How To | Wireless |Search | Forums | Services | Donations | Careers | About Us | Contact Us|

Can't install CRM with Event ID 117

Network Sharing , TCP/IP, Internet, Wireless, Exchange, IIS, ISA and Print

Can't install CRM with Event ID 117

Postby fenton » Wed Apr 22, 2009 8:31 pm

I am trying to install Microsoft CRM 4 on a Windows 2003 SP2 server. The server is HP DL380 with 2.66GHz and 1.22GB RAM. The server also running Microsoft SQL 2005. However, I get many System requirement errors as shown this link:
http://www.chicagotech.net/msapps/crm1.htm.

I have fixed all problems except SQL ReportServer. The SQL ReportServer is installed and the service is running (it is started in the services). However, I can't run it from the http://localhost/reportserver. The IIS doesn't shows Report or ReportServer folder.

In viewing the Event log, I found the Event ID 117 - The report server database is an invalid version. How do you fix it?
fenton
 
Posts: 421
Joined: Mon Dec 04, 2006 3:25 pm

Postby fenton » Wed Apr 22, 2009 8:32 pm

From your description, I understand that the Reporting Service sites were
invalid with the following error in the Windows Application Log.
Event ID 117 - The report server database is an invalid version.
If I have misunderstood, please let me know.

Usually, the error message means that the database of the Reporting
Services is corrupt or SSRS component is upgraded to some SP but the report
server database is not.

So, please confirm the version/sp they installed, and make sure SQL engine
and SSRS is same version and they try to create a new database in SSRS
configuration tool to test. If the SQL and SSRS are same version, please
try to uninstall and reinstall the SSRS.
fenton
 
Posts: 421
Joined: Mon Dec 04, 2006 3:25 pm

Postby fenton » Wed Apr 22, 2009 8:32 pm

Sorry, how do you confirm the version/sp they installed, and make sure SQL
engine and SSRS is same version? I am not SQL administrator.
fenton
 
Posts: 421
Joined: Mon Dec 04, 2006 3:25 pm

Postby fenton » Wed Apr 22, 2009 8:33 pm

We can find the detailed version in the error log file.

By default, the error log of the SQL engine is located at the folder:
%ProgramFiles%\Microsoft SQL Server\MSSQL.n\MSSQL\LOG\

The SSRS error log files can be found here:
%ProgramFiles%\Microsoft SQL Server\MSSQL.x\Reporting Services\LogFiles

where %ProgramFiles% is the language specific name of the program files
folder and MSSQL.x takes into account the components installed. An example
of an install on an machine using English as the language might look like
this:

C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles


Please open the error log file using the "notepad" application and the
detailed version can be found.
fenton
 
Posts: 421
Joined: Mon Dec 04, 2006 3:25 pm

Postby fenton » Wed Apr 22, 2009 8:33 pm

This is copy from MSSQL errorlog:

Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

This is the copy of ReportServerService:

<Product>Microsoft SQL Server Reporting Services Version
9.00.1399.00</Product>
<Locale>en-US</Locale>
<TimeZone>Eastern Daylight Time</TimeZone>
<Path>D:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\LogFiles\ReportServerService__04_20_2009_00_12_28.log</Path>
<SystemName>VALIANT</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 2</OSName>
<OSVersion>5.2.3790.131072</OSVersion>

I don't understand it. I used the same SQL DVD to install them. If they are
different version, how can I fix it?
fenton
 
Posts: 421
Joined: Mon Dec 04, 2006 3:25 pm

Postby fenton » Wed Apr 22, 2009 8:34 pm

From the logs, we found that the versions were same, but there were some
error message similar below in the error log of the SSRS.
===========
e ERROR: Sql error:System.Data.SqlClient.SqlException: Could not find
stored procedure 'GetDBVersion'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObjec
t stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader
ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
DbAsyncResult result)
at
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult
result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
===============

The stored procedure "GetDBVersion" is used to detect the version of the
current SSRS database, it should be in the SSRS database. According to some
other partners' experience, the stored procedure will be invalid if the
SSRS install failed or update failed.

So I recommend that please uninstall/reinstall the SSRS.
fenton
 
Posts: 421
Joined: Mon Dec 04, 2006 3:25 pm

http://www.chicagotech.net/netforums/viewtopic.php?p=9884#98

Postby fenton » Wed Apr 22, 2009 8:37 pm

I haven't fixed the SQL issue following this post: SQL: Fatal error during installation - http://www.chicagotech.net/netforums/vi ... =9884#9884
fenton
 
Posts: 421
Joined: Mon Dec 04, 2006 3:25 pm


Return to Networking

Your Ad Here

Who is online

Users browsing this forum: No registered users and 6 guests