Error on Creating publication

Hi all, when I create publication with New Publication Wizard. I get the following errors. Did someone meet this before? Can you help me? Thanks!

===================================

SQL Server could not create publication 'JK'. (New Publication Wizard)

===================================

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Program Location:

at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand)
at Microsoft.SqlServer.Replication.ReplicationObject.ExecCommand(String commandIn)
at Microsoft.SqlServer.Replication.ReplicationObject.CommonCreate()
at Microsoft.SqlServer.Replication.Publication.Create()
at Microsoft.SqlServer.Management.UI.CreatePublicationWizard.CreatePublicationThreadMethod()

===================================

Cannot promote the transaction to a distributed transaction because there is an active save point in this transaction.
Changed database context to 'Test'. (.Net SqlClient Data Provider)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.2047&EvtSrc=MSSQLServer&EvtID=3933&LinkId=20476

Server Name: nxstudio-david\sql2k5_dc
Error Number: 3933
Severity: 16
State: 1
Procedure: sp_addmergepublication
Line Number: 1034

Program Location:

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(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)

Try setting remote proc trans to 0. i.e.

exec sp_configure 'remote proc trans', 0

go

However you may have custom apps that depend on this being enabled, if so, be careful when flipping this switch.

|||

Greg, Thanks!

I try to follow your instruction, but I get the following message.

"Configuration option 'remote proc trans' changed from 0 to 0. Run the RECONFIGURE statement to install."

It seems the original value is 0 too.

error message saying I do not meet minimum hardware requirements

Hi

trying to install sql server 2005, but I get an error message that I do not meet minimum hardware requirements. But this is not right. I've a 32-bit system...............Windows XP professional and SP2. I have enough disk space and just don't know what the problem is. Please help anyone

Which edition are you trying to install? Enterprise edition is not suppoted and will not install on Windows XP. Also, is the install blocking you or just warning you?|||trying to install the standard ed. Its actually just a warning, but if I do carry on, it says something about not finding asp.net|||You'll get the warning if the processor speed is under 1 GHz or memory is under 1 GB. This is spelled out on the readme on the CD/DVD. I would bet you're under one of these numbers.