Errors: SQL Reporting Services with CRM 3.0

Good Day All ...

I am currently trying to install CRM 3.0 onto one of our test servers.
I have managed with no problem to get everything ready for installation ... but having a problem with reporting services.

On the system requirements results page i have green for everything but reporting services.

ERROR;
Specified Reporting Services Reports Server http://XXXXXX/ReportsServer was not found.

I have reporting services installed, can someone please give me some direction on where to go from here to get this up and working.

Thanks

Do you habe any Sharepoint Server installed on the machine or any other program which tries to bind port 80 to itself ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||Yes i do have sharepoint installed.
Would you recommend removing that?|||

Hi,

no defintely not, but you should have a look on my site under the Screencast Section, this will whow you a way to solve your problem.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||Thanks for all of your help.
Works fine.

Thanks Again ... Great Advice!!|||If this helped please mark post as answer and (for me) rate the screencast and give additional feedback if you want to :-)

HTH, Jens K. SUessmeyer.

http://www.sqlserver2005.de

Errors with SP4 upgrade... Please Help

I am having problems accessing DTS after install SP4 and was wondering
if someone could offer some advice.

I installed SP4 and got the following error after it competed.

Unable to write to response file 'U:\WINDOWS\setup.iss' during
recording. Please ensure enough space is available on target drive.

I got the error 3 times (3 pop-ups).

After the install I could not access DTS. I was getting 2 error
pop-ups.
1. 'rebbrui.rll is missing'
2. Snap-In failed to initialize: Meta Data Services

I read the groups and tried several things.

I tried to reinstall MDAC and it did not help.

I tried to register several dlls and it did not help.

I found this post and it seemed to help.
Repair Script:
http://www.experts-exchange.com/Dat...Q_21445589.html

I was then able to access DTS using the profile (which is an
administrator) which
I used to install SP4 and run the above repair script. However, no
other profile can open or run DTS.

I tried running the repair script under the other profiles and it did
not help.

I was receiving 2 errors for the other profiles. I only documented one
and I am no longer getting the other. Now it just goes to a white
screen and hangs.

1st error:
DTS Designer Error
The specified module could not be found.

2nd error:
???

I tried reinstalling client tools and SP4 and it did not help. Now I
get one additional error.

Before I can expand the server node in enterprise manager I get the
following error.
Snap-in failed to initialize
Name: Meta Data Services
CLSID: {1DBA4DD4-EB97-4FD2-AB80-9D0D4BA74034}

Does anyone have a suggestion on how I might fix this?

I am running SQL Server 2000 Enterprise on Windows 2000 Server with 4
GB RAM.

I did notices that someone has set the /3GB switch. I know this is not
supported on this OS but it was not causing major problems before the
upgrade. Could it be the culprit?Finally got this fixed. It was a real pain!

The registry on this server looked all hacked up to me. It looks like
many of the keys referenced U:/ instead of C:/

Some of the necessary dlls were pointing to U: also.

I had to manually uninstall SQL Server. Then reinstall. Then uninstall
via add remove programs. Then I did another uninstall/reinstall
(because i got a few errors).

I reinstalled, upgraded to sp4, stopped the service, swapped my master,
msdb, tempdb with the originals and everything is working great.

Errors on install of SQL Svr 2005 Enterprise

Greetings,

I have attempted a full install of 2005 Ent on our W2k3 Enterprise

server. When attempting to install all services (SQL Svr database,

analysis, reporting, notification, integration, client

services/components) I get the message: "The features specified are

not valid for this edition of SQL Server". I got the same thing

when attempting to install with various subsets of services. Then I

tried just database services and client components and got the

message: " There was an unexpected failure during the setup

wizard. "

Perusing the core.log, I see:

Fatal Exception caught while installing package: "10"

Error Code: 0x80070002 (2)

Windows Error Text: The system cannot find the file specified.

Source File Name: sqlchaining\sqlprereqpackagemutator.cpp

Compiler Timestamp: Tue Aug 9 01:14:20 2005

Function Name: sqls::SqlPreReqPackageMutator::modifyRequest

Source Line Number: 196

Has anyone encountered this? One of our guys downloaded the install

files from Microsoft. We don't use CDs anymore. I think there are

files missing.

Thanks for any assistance with this.

Windows Server 2003 SP1 is the minimum OS required. Do you have SP1 installed?

Michelle

|||Windows Server 2003 R2 SP1 is installed.|||

Oop! I found the answer, I think:

http://support.microsoft.com/kb/916760

This problem occurs because the folders that contain the files that are required

during the installation of SQL Server 2005 do not have a correct

layout.

This problem is most likely to occur if you start the SQL Server

2005 installation from a folder on a network share or on a hard disk when the

folder was copied from the SQL Server 2005 installation CDs.

Thanks!

marge

|||

That was going to be my next guess we see that alot.

Michelle

error-1920.service mssqlserver failed

hi
i am trying to install a software package called arrayinformatics. this
comes along with msde as part of it.
when i run the setup for arrayinformatics, as admin, after sometime, the
status of the installshield wizard shows that...
generating script operations for action:......
and thats it..after that nothing happens and i get a dozen dll load
error...starting from...
REPLRES.RLL cannot load resource dll error..
run setup again to install this file...
after clicking ok for a dozen of such error...
the installshield wizard now says that...
error-1920. service mssqlserver failed to start. verify that you have
sufficient privileges to start system services...
and closes,without completing the installation.
i tried installing the msde separately..and it got installed.. and i was
even able to start and stop the services...
but the arrayinformatics doesnt install with a previously installed mssql
server...
so i am struck here...i tried to figure out this problem...searching the net
for the past 2 days and couldnt solve it...
kindly help me..to fix this problem
thanks
vijayaraj nagarajan
graduate student
the university of southern mississippi
MS - USA
hi,
vijayaraj nagarajan wrote:
> hi
> i am trying to install a software package called arrayinformatics.
> this comes along with msde as part of it.
> when i run the setup for arrayinformatics, as admin, after sometime,
> the status of the installshield wizard shows that...
> generating script operations for action:......
> and thats it..after that nothing happens and i get a dozen dll load
> error...starting from...
> REPLRES.RLL cannot load resource dll error..
> run setup again to install this file...
> after clicking ok for a dozen of such error...
> the installshield wizard now says that...
> error-1920. service mssqlserver failed to start. verify that you have
> sufficient privileges to start system services...
> and closes,without completing the installation.
> i tried installing the msde separately..and it got installed.. and i
> was even able to start and stop the services...
> but the arrayinformatics doesnt install with a previously installed
> mssql server...
> so i am struck here...i tried to figure out this problem...searching
> the net for the past 2 days and couldnt solve it...
if you separately succesfully installed MSDE with the official Microsoft
package, I think you have to check this issue with arrayinformatics
technicians... perhaps their installshield script is not correct...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Error:2147749904

When trying to install SQL Server 2005 I encountered this error:

The SQL Server Configuration Checker cannont be executed due to WMI configuration on the machine -- Error:2147749904 (0x80041010).

Could you please help.

Thanks

Here is a good thread outlining how to repair your WMI configuration:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1066137&SiteID=1

Thanks,
Sam Lester (MSFT)

Error:2147749904

When trying to install SQL Server 2005 I encountered this error:

The SQL Server Configuration Checker cannont be executed due to WMI configuration on the machine -- Error:2147749904 (0x80041010).

Could you please help.

Thanks

Here is a good thread outlining how to repair your WMI configuration:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1066137&SiteID=1

Thanks,
Sam Lester (MSFT)

Error: SQL Server does not exist or access denied. (Error code 17).

Hello everyone.

I am trying to install Project Server, and i'm having issues with sharepoint, and connecting to SQL:

dataserver is running sbs2003 sql2003 and analsys services.

server2 is running server2003 is to be the application server for project.

ProjectDb is the database that i have setup in sql.

username is the account that can control everything as administrer.

in Sharepoint is asks for the database server: <<dataserver>>

SQL Server database name: <<ProjectDb>>

I'm using windoes authentication and then i click ok, and get the error message.

I've also see the error message can not find the SQL Server, and access denied. Under ODBC i have installed the sql server information under System DSN.

Any help would be great.

Thanks

Everett Buel

Start by confirming that SQL Server is running and that you can access it directly. I take it this is SQL Server 2000, so you should have Query Analyzer installed and you can use it to try to connect to your database. Also (more basic) check to confirm that the SQL Server service is started.|||

SQL is running I have the Query Analyzer installed. All services are started. I can access the Sql Server from my desktop so i know that part is working.

But when I try to start up the data connection of the sharepoint services on the server running server 2003 i still get the error message.

Data services are all running on both servers.

Thanks for your reply

Everett Buel

|||

It would be nice if you two finished this thread. I can't tell you how many times I've gone searching the MS web site for resolution of error messages only to find this type of non-solution. If this is all you can do then why don't you delete the useless thread.

Bryce

Error: SQL Server does not exist or access denied. (Error code 17).

Hello everyone.

I am trying to install Project Server, and i'm having issues with sharepoint, and connecting to SQL:

dataserver is running sbs2003 sql2003 and analsys services.

server2 is running server2003 is to be the application server for project.

ProjectDb is the database that i have setup in sql.

username is the account that can control everything as administrer.

in Sharepoint is asks for the database server: <<dataserver>>

SQL Server database name: <<ProjectDb>>

I'm using windoes authentication and then i click ok, and get the error message.

I've also see the error message can not find the SQL Server, and access denied. Under ODBC i have installed the sql server information under System DSN.

Any help would be great.

Thanks

Everett Buel

Start by confirming that SQL Server is running and that you can access it directly. I take it this is SQL Server 2000, so you should have Query Analyzer installed and you can use it to try to connect to your database. Also (more basic) check to confirm that the SQL Server service is started.|||

SQL is running I have the Query Analyzer installed. All services are started. I can access the Sql Server from my desktop so i know that part is working.

But when I try to start up the data connection of the sharepoint services on the server running server 2003 i still get the error message.

Data services are all running on both servers.

Thanks for your reply

Everett Buel

|||

It would be nice if you two finished this thread. I can't tell you how many times I've gone searching the MS web site for resolution of error messages only to find this type of non-solution. If this is all you can do then why don't you delete the useless thread.

Bryce