Error while creating subscription in transactional replication!

Hi ALL

I am configuring subscription for a reporting server and getting the following error message .

Any body having any idea would be of great help.

TITLE: New Subscription Wizard

Microsoft SQL Server Management Studio is unable to access replication components because replication is not installed on this instance of SQL Server. For information about installing replication, see the topic Installing Replication in SQL Server Books Online.

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=Microsoft.SqlServer.Management.UI.ReplUtilitiesErrorSR&EvtID=ReplicationNotInstalled&LinkId=20476

ADDITIONAL INFORMATION:

SQL Server replication requires the actual server name to make a connection to the server. Connections through a server alias, IP address, or any other alternate name are not supported. Specify the actual server name, 'CORSTRATASQL01'. (Replication.Utilities)

BUTTONS:

OK

Regards,

Salman Shehbaz.

Hi,
I had similar problems when I want to integrate a publisher into the replication monitor.
I had the problem , when the server is in anothe domain.
So first question is: Is CORSTRATASQL01 in anothe domain then the server you got the error message ?

At last we solve the problem with a reconfiguration of the DNS-suffixes of the TCP/IP properties.

Regards
Wolfgang

error while Configuring XML Support in IIS with IIS 6.0

Hi,

I've two servers on which there is the SQL 2000 Server and the IIS 6.0.

I installed the SQL Server Client Tools on web server.

And created the nwind as told in booksonline.

I declared the SQLXML extention and allowed it using IIS 6.

But there is a problem with the virtual directory I created using the tool "Configure XML Support in IIS". Web server doesn't realize it as a virtual directory. Even a jpg or a text file is not served by the IIS.

The web server shows the following error.

ERROR: 500 Internal Server Error
HResult: 0x800706f4
Source: Microsoft SQL isapi extension
Description: Invalid virtual root settings

Thanks for any suggestions.Ok,

Do not use Client Tools any more on web server.

Instead, yuo can use SQLXML 3.0.

This solved my problem.|||Cool. Glad it's solved. The good news is that Yukon integrates all these features, so there won't be this kind of confusion. That is, if you can wait a year or so for Yukon!

Don

Error while configuring

While configuring reporting services, in the database setup section, I am entering the instance name connecting to, and the user-id details. On applying the changes, i am getting an error that "Using other edition of database for reporting data sources and/or report server databases is not allowed in this version of Reporting services"

Can anyone help me resolve this issue?

Thanks,

Vijay

Are you trying to connect to SQL Server 2005 express edition from your reporting services whose edition is not from express edition?

Shyam

|||I tried using both express instance and default instance. Both are giving the same error.|||

When you say default, it may also mean Developer edition. Ensure that you have an enterprise or a standard edition on your database server and connect to that instance.

Shyam

|||

We are using standard edition. Won't reporting services not work with standard edition?

Thanks,

Vijay

|||Is the reporting services edition on your report server an express edition?