Problems installing SRS

I'm trying to install Reporting Services on a new XP Pro SP2 IIS 6
development box. The local database is SQL Server 2000 sp3.
At the end of the installation I get an error message indicating that
the 'Setup could not initialize the report server' and that I'll have
to manually initialize the Report Server.
After running rsactive I got the message indicating that the "Report
Server Web Service has not generated a public key".
Looking in the log files is less-than-helpful (hundreds of lines
indicating that some -unknown- file is missing):
===============================================================================
aspnet_wp!library!a4!12/01/2004-10:15:58:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details. --> System.IO.FileNotFoundException: The system cannot
find the file specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.Storage.get_Connection()
at Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
storedProcedureName)
at Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String
key)
at Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String
name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String
name)
at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
source)
at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path, Boolean validate, Boolean convert, Boolean translate)
at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
-- End of inner exception stack trace --
a
===============================================================================
When I navigate to the http://localhost/ReportServer I get the
following error message:
An internal error occurred on the report server. (again not very
helpful).
IIS is listening on port 80 (and there are no other apps on the port).
SO... I'm running out of things to try and patience. Is there anyone
out there who can help me get over this problem? I really need to
get this installed ASAP and there doesn't seem to be any documentation
anywhere that explains what is going wrong!!!
Any help appreciated.
GlennAfter much trail-and-error and finally a call to Microsoft I was able to
install the SRS and get everything working. I'm posting this in hopes that my
solution will help someone in a similar situation.
Ultimately the problem was solved by:
1) accessing the machine.config file
2) find the user name in the process model section (by default it's set
to 'machine')
3) change this to 'system' (temporarily)
4) using EnterpriseManager open the Keys table of the ReportServer
database (three are probably 2 keys)
5) delete the NON-ZERO key (don't delete the ZERO key)
6) browse to http:/localhost/ReportServer (should no longer produce any
errors!!!)
7) browse to http:/localhost/Reposrts
Hope this helps...
Glenn
"Glenn" wrote:
> I'm trying to install Reporting Services on a new XP Pro SP2 IIS 6
> development box. The local database is SQL Server 2000 sp3.
> At the end of the installation I get an error message indicating that
> the 'Setup could not initialize the report server' and that I'll have
> to manually initialize the Report Server.
> After running rsactive I got the message indicating that the "Report
> Server Web Service has not generated a public key".
> Looking in the log files is less-than-helpful (hundreds of lines
> indicating that some -unknown- file is missing):
> ===============================================================================> aspnet_wp!library!a4!12/01/2004-10:15:58:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details., ;
> Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details. --> System.IO.FileNotFoundException: The system cannot
> find the file specified.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ExportPublicKey()
> at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
> at Microsoft.ReportingServices.Library.Storage.get_Connection()
> at Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
> storedProcedureName)
> at Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String
> key)
> at Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String
> name)
> at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
> name)
> at Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String
> name)
> at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
> at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
> source)
> at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path, Boolean validate, Boolean convert, Boolean translate)
> at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
> path)
> at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
> at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> -- End of inner exception stack trace --
> a
> ===============================================================================> When I navigate to the http://localhost/ReportServer I get the
> following error message:
> An internal error occurred on the report server. (again not very
> helpful).
> IIS is listening on port 80 (and there are no other apps on the port).
>
> SO... I'm running out of things to try and patience. Is there anyone
> out there who can help me get over this problem? I really need to
> get this installed ASAP and there doesn't seem to be any documentation
> anywhere that explains what is going wrong!!!
> Any help appreciated.
> Glenn
>

Problems in opening the Enterprise Manager

Hi,

I had one perfectly windows a 2003 with the SP2 and SQL Server twirling. Later that I came back the server toward the SP1 I I do not obtain more to enter in the Enterprise Manager. It of the o error

MMC Cannot open file “….\ SQL Server Enterprise Manager.MSC”

Somebody could help me?

Reinstall client tools... some dll might have got corrupted..

Madhu

Problems after installing SP2

After installing SP2, my Reporting Services does not work. I received the following message in the Summary:

Product : Reporting Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\RS9_Hotfix_KB921896_sqlrun_rs.msp.log
Error Number : 29528
Error Description : MSP Error: 29528 The setup has encountered an unexpected error while Setting reporting service and share point exclusion path. The error is: Fatal error during installation.

In the msp.log, I see the following:

Property(S): RS200532Hotfix3042 = e:\637303726034099d313316b7\HotFixRS\Files\sqlrun_rs.msp
MSI (s) (D4:90) [18:04:57:654]: Product: Microsoft SQL Server 2005 Reporting Services - Update 'Service Pack 2 for SQL Server Reporting Services 2005 ENU (KB921896)' could not be installed. Error code 1603. Additional information is available in the log file C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\RS9_Hotfix_KB921896_sqlrun_rs.msp.log.

MSI (s) (D4:90) [18:04:57:654]: Note: 1: 1729
MSI (s) (D4:90) [18:04:57:654]: Transforming table Error.

MSI (s) (D4:90) [18:04:57:654]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (D4:90) [18:04:57:669]: Transforming table Error.

MSI (s) (D4:90) [18:04:57:669]: Transforming table Error.

MSI (s) (D4:90) [18:04:57:669]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (D4:90) [18:04:57:669]: Transforming table Error.

MSI (s) (D4:90) [18:04:57:669]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (D4:90) [18:04:57:669]: Transforming table Error.

MSI (s) (D4:90) [18:04:57:669]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (D4:90) [18:04:57:669]: Transforming table Error.

MSI (s) (D4:90) [18:04:57:669]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (D4:90) [18:04:57:685]: Transforming table Error.

MSI (s) (D4:90) [18:04:57:685]: Transforming table Error.

MSI (s) (D4:90) [18:04:57:685]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (D4:90) [18:04:57:685]: Transforming table Error.

MSI (s) (D4:90) [18:04:57:685]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (D4:90) [18:04:57:685]: Transforming table Error.

MSI (s) (D4:90) [18:04:57:685]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (D4:90) [18:04:57:685]: Product: Microsoft SQL Server 2005 Reporting Services -- Configuration failed.

MSI (s) (D4:90) [18:04:57:685]: Attempting to delete file C:\WINDOWS\Installer\1da926.msp
MSI (s) (D4:90) [18:04:57:685]: Unable to delete the file. LastError = 32
MSI (s) (D4:90) [18:04:57:700]: Cleaning up uninstalled install packages, if any exist
MSI (s) (D4:90) [18:04:57:700]: MainEngineThread is returning 1603
MSI (s) (D4:9C) [18:04:57:700]: Destroying RemoteAPI object.
MSI (s) (D4:CC) [18:04:57:700]: Custom Action Manager thread ending.
=== Logging stopped: 3/8/2007 18:04:57 ===
MSI (c) (9C:08) [18:04:57:700]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (9C:08) [18:04:57:700]: MainEngineThread is returning 1603
=== Verbose logging stopped: 3/8/2007 18:04:57 ===

Can anyone help?

which OS and RS edition are you using? Is it a fresh install or upgrade existing RS?

Problems after installing SP2

I'm having some major problems with SSAS after installing SP2 (I never had an SP2 CTP installed, just SP1).

When I bring up BI Studio and select Open/Analysis Service Database, put in my server name (which is on the same machine that I'm running BI Studio), the click the "Database" drop down to select a database, it shows the following error in the bottom of the dialog:

Errors in the OLAP storage engine: The linked measure group with the ID of 'Sales', Name of 'Sales' cannot be processed because it contains MG dimension with the ID of 'Time', Name of 'Time' with different granularity attribute than its source object.
Errors in the metadata manager. An error occurred when loading the Sales measure group, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSSQL.3\OLAP\Data\FoodMart.0.db\Trained Cube.0.cub\Sales.1.det.xml'.
Errors in the metadata manager. An error occurred when loading the Trained Cube cube, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSSQL.3\OLAP\Data\FoodMart.0.db\Trained Cube.1.cub.xml'.

At this point, there doesn't seem to be any way to open any database in BI Studio. I always get that error, even if I try typing in another database name.

SQL Management Studio seems slightly better - I can at least connect there. But it only shows a couple of the databases that were on the machine - a bunch are missing. Any attempt to process or browse any of the databases results in the same error as above.

Any ideas?

Quoting the SP2 Readme: http://download.microsoft.com/download/2/B/5/2B5E5D37-9B17-423D-BC8F-B11ECD4195B4/ReadmeSQL2005SP2.htm

5.3.2 Analysis Services Databases that Contain a Linked Measure Group Might Become Unusable After Upgrade

Introduced in SQL Server 2005 SP2.

Analysis Services now requires that all dimensions contained in a linked measure group have the same granularity as the dimension in the source measure group. For example, if a time dimension in the source measure group has the day attribute as the granularity attribute, the linked measure group must also use the day attribute as the granularity attribute. The most common scenario for an Analysis Services database that violates this rule is a SQL Server 2000 Analysis Services database that was migrated by using a pre-release version of SQL Server 2005.

If you have a database that violates this granularity rule, you must modify the database containing the linked measure group before applying SP2. If you don't, the database will become invalid after SP2 is applied. Such invalid databases must be deleted.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||Thanks Edward. RTFM, eh? Actually, I doubt it would have helped - this is a sample DB that I found somewhere, I wouldn't have realized it had this issue.

The problem is, I don't see a way to delete the database. The admin tools all barf with that error when I try to do anything, including deleting a DB. Is there some other way to nuke it?|||Unless you can go back to pre-SP2 build, you can stop the service, and manually delete all the files and folders in the Data directory. Then you will have to redeploy and reprocess the rest of your databases, unless you have backups in which case you would simply restore them.|||Thanks Mosha. I deleted the .0.db directory and the 0.db.xml file for the bad database (which I didn't need anyway, it was just for playing with), and have now regained access to my server. Any other files I should delete to clean things up?|||

This should be enough.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

I've recently installed SP2. All was fine initially but I'm now getting the error listed above having not changed anything significant (changed the membersname unique property of an attribute and then changed it back again). I'd been making changes all day to the attribute relationships and deploying without a problem.

I'm not using a linked measure group but the measure group it's reporting an error on has a different granularity key to the main measure group. Apart from changing the granularity key of the group that has a problem what can I do to fix this?

Mark

|||

I got the same error message which is posted in the first post here.

On a server which didn't had the foodmart database installed, I didn't get any problems after installing SP2. When I tossed the foodmart files away as described above, all problems vanished. It seems the problem here is the foodmart database. At the end of it Im glad I got my DB back, but "they" managed to scare the living daylight out of me with this, because I thought the whole AS had been turned into a wreck. Ironically the only database left in the management studio was the foodmart db. If you don't use it I would recommend to delete it before installing SP2.

Regards, Jeroen

Problems after installing SP2

I'm having some major problems with SSAS after installing SP2 (I never had an SP2 CTP installed, just SP1).

When I bring up BI Studio and select Open/Analysis Service Database, put in my server name (which is on the same machine that I'm running BI Studio), the click the "Database" drop down to select a database, it shows the following error in the bottom of the dialog:

Errors in the OLAP storage engine: The linked measure group with the ID of 'Sales', Name of 'Sales' cannot be processed because it contains MG dimension with the ID of 'Time', Name of 'Time' with different granularity attribute than its source object.
Errors in the metadata manager. An error occurred when loading the Sales measure group, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSSQL.3\OLAP\Data\FoodMart.0.db\Trained Cube.0.cub\Sales.1.det.xml'.
Errors in the metadata manager. An error occurred when loading the Trained Cube cube, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSSQL.3\OLAP\Data\FoodMart.0.db\Trained Cube.1.cub.xml'.

At this point, there doesn't seem to be any way to open any database in BI Studio. I always get that error, even if I try typing in another database name.

SQL Management Studio seems slightly better - I can at least connect there. But it only shows a couple of the databases that were on the machine - a bunch are missing. Any attempt to process or browse any of the databases results in the same error as above.

Any ideas?

Quoting the SP2 Readme: http://download.microsoft.com/download/2/B/5/2B5E5D37-9B17-423D-BC8F-B11ECD4195B4/ReadmeSQL2005SP2.htm

5.3.2 Analysis Services Databases that Contain a Linked Measure Group Might Become Unusable After Upgrade

Introduced in SQL Server 2005 SP2.

Analysis Services now requires that all dimensions contained in a linked measure group have the same granularity as the dimension in the source measure group. For example, if a time dimension in the source measure group has the day attribute as the granularity attribute, the linked measure group must also use the day attribute as the granularity attribute. The most common scenario for an Analysis Services database that violates this rule is a SQL Server 2000 Analysis Services database that was migrated by using a pre-release version of SQL Server 2005.

If you have a database that violates this granularity rule, you must modify the database containing the linked measure group before applying SP2. If you don't, the database will become invalid after SP2 is applied. Such invalid databases must be deleted.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||Thanks Edward. RTFM, eh? Actually, I doubt it would have helped - this is a sample DB that I found somewhere, I wouldn't have realized it had this issue.

The problem is, I don't see a way to delete the database. The admin tools all barf with that error when I try to do anything, including deleting a DB. Is there some other way to nuke it?|||Unless you can go back to pre-SP2 build, you can stop the service, and manually delete all the files and folders in the Data directory. Then you will have to redeploy and reprocess the rest of your databases, unless you have backups in which case you would simply restore them.|||Thanks Mosha. I deleted the .0.db directory and the 0.db.xml file for the bad database (which I didn't need anyway, it was just for playing with), and have now regained access to my server. Any other files I should delete to clean things up?|||

This should be enough.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

I've recently installed SP2. All was fine initially but I'm now getting the error listed above having not changed anything significant (changed the membersname unique property of an attribute and then changed it back again). I'd been making changes all day to the attribute relationships and deploying without a problem.

I'm not using a linked measure group but the measure group it's reporting an error on has a different granularity key to the main measure group. Apart from changing the granularity key of the group that has a problem what can I do to fix this?

Mark

|||

I got the same error message which is posted in the first post here.

On a server which didn't had the foodmart database installed, I didn't get any problems after installing SP2. When I tossed the foodmart files away as described above, all problems vanished. It seems the problem here is the foodmart database. At the end of it Im glad I got my DB back, but "they" managed to scare the living daylight out of me with this, because I thought the whole AS had been turned into a wreck. Ironically the only database left in the management studio was the foodmart db. If you don't use it I would recommend to delete it before installing SP2.

Regards, Jeroen

Problems after installing SP2

I'm having some major problems with SSAS after installing SP2 (I never had an SP2 CTP installed, just SP1).

When I bring up BI Studio and select Open/Analysis Service Database, put in my server name (which is on the same machine that I'm running BI Studio), the click the "Database" drop down to select a database, it shows the following error in the bottom of the dialog:

Errors in the OLAP storage engine: The linked measure group with the ID of 'Sales', Name of 'Sales' cannot be processed because it contains MG dimension with the ID of 'Time', Name of 'Time' with different granularity attribute than its source object.
Errors in the metadata manager. An error occurred when loading the Sales measure group, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSSQL.3\OLAP\Data\FoodMart.0.db\Trained Cube.0.cub\Sales.1.det.xml'.
Errors in the metadata manager. An error occurred when loading the Trained Cube cube, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSSQL.3\OLAP\Data\FoodMart.0.db\Trained Cube.1.cub.xml'.

At this point, there doesn't seem to be any way to open any database in BI Studio. I always get that error, even if I try typing in another database name.

SQL Management Studio seems slightly better - I can at least connect there. But it only shows a couple of the databases that were on the machine - a bunch are missing. Any attempt to process or browse any of the databases results in the same error as above.

Any ideas?

Quoting the SP2 Readme: http://download.microsoft.com/download/2/B/5/2B5E5D37-9B17-423D-BC8F-B11ECD4195B4/ReadmeSQL2005SP2.htm

5.3.2 Analysis Services Databases that Contain a Linked Measure Group Might Become Unusable After Upgrade

Introduced in SQL Server 2005 SP2.

Analysis Services now requires that all dimensions contained in a linked measure group have the same granularity as the dimension in the source measure group. For example, if a time dimension in the source measure group has the day attribute as the granularity attribute, the linked measure group must also use the day attribute as the granularity attribute. The most common scenario for an Analysis Services database that violates this rule is a SQL Server 2000 Analysis Services database that was migrated by using a pre-release version of SQL Server 2005.

If you have a database that violates this granularity rule, you must modify the database containing the linked measure group before applying SP2. If you don't, the database will become invalid after SP2 is applied. Such invalid databases must be deleted.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||Thanks Edward. RTFM, eh? Actually, I doubt it would have helped - this is a sample DB that I found somewhere, I wouldn't have realized it had this issue.

The problem is, I don't see a way to delete the database. The admin tools all barf with that error when I try to do anything, including deleting a DB. Is there some other way to nuke it?
|||Unless you can go back to pre-SP2 build, you can stop the service, and manually delete all the files and folders in the Data directory. Then you will have to redeploy and reprocess the rest of your databases, unless you have backups in which case you would simply restore them.|||Thanks Mosha. I deleted the .0.db directory and the 0.db.xml file for the bad database (which I didn't need anyway, it was just for playing with), and have now regained access to my server. Any other files I should delete to clean things up?
|||

This should be enough.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

I've recently installed SP2. All was fine initially but I'm now getting the error listed above having not changed anything significant (changed the membersname unique property of an attribute and then changed it back again). I'd been making changes all day to the attribute relationships and deploying without a problem.

I'm not using a linked measure group but the measure group it's reporting an error on has a different granularity key to the main measure group. Apart from changing the granularity key of the group that has a problem what can I do to fix this?

Mark

|||

I got the same error message which is posted in the first post here.

On a server which didn't had the foodmart database installed, I didn't get any problems after installing SP2. When I tossed the foodmart files away as described above, all problems vanished. It seems the problem here is the foodmart database. At the end of it Im glad I got my DB back, but "they" managed to scare the living daylight out of me with this, because I thought the whole AS had been turned into a wreck. Ironically the only database left in the management studio was the foodmart db. If you don't use it I would recommend to delete it before installing SP2.

Regards, Jeroen

Problem:fail to invoke remote RPC method

I have two xp sp2 machines(one desktop with sql server running, the other is
a virtual pc, on the same domain), I'm trying to connect between the two
using the dtcping.exe tool from ms
the virtual pc has vs2005 etc installed and I can't get it to run a
distributed transaction on the sql server machine, both machines have the sp2
firewall disabled.
the rpc services are running, msdtc service are running,
on the virtual pc I get the following
Firewall Port Settings:
Port:5000-5015
RPC server is ready
++++++++++++Validating Remote Computer Name++++++++++++
08-03, 12:09:03.756-->Start DTC connection test
Name Resolution:
Gilbert-->10.0.4.22-->Gilbert
08-03, 12:09:03.776-->Start RPC test (PERTH-->Gilbert)
Problem:fail to invoke remote RPC method
Error(0x6BA) at dtcping.cpp @.289
-->RPC pinging exception
-->1722(The RPC server is unavailable.)
RPC test failed
on the desktop sql server machine I get this
Firewall Port Settings:
Port:5000-5015
RPC server is ready
++++++++++++Validating Remote Computer Name++++++++++++
08-03, 12:08:50.353-->Start DTC connection test
Name Resolution:
Perth-->10.0.4.23-->Perth
08-03, 12:08:50.368-->Start RPC test (GILBERT-->Perth)
Problem:fail to invoke remote RPC method
Error(0x5) at dtcping.cpp @.289
-->RPC pinging exception
-->5(Access is denied.)
RPC test failed
the msdtc service has been set to use my domain account and all the options
have been enabled, network access, inbound, outbound etc.
I have set up the msdtc to use ports 5000-5015
any ideas out there?
to get this poc working
Try turning off Norton internet worm protection...
Stuart
"SP" wrote:

> I have two xp sp2 machines(one desktop with sql server running, the other is
> a virtual pc, on the same domain), I'm trying to connect between the two
> using the dtcping.exe tool from ms
> the virtual pc has vs2005 etc installed and I can't get it to run a
> distributed transaction on the sql server machine, both machines have the sp2
> firewall disabled.
> the rpc services are running, msdtc service are running,
> on the virtual pc I get the following
> Firewall Port Settings:
> Port:5000-5015
> RPC server is ready
> ++++++++++++Validating Remote Computer Name++++++++++++
> 08-03, 12:09:03.756-->Start DTC connection test
> Name Resolution:
> Gilbert-->10.0.4.22-->Gilbert
> 08-03, 12:09:03.776-->Start RPC test (PERTH-->Gilbert)
> Problem:fail to invoke remote RPC method
> Error(0x6BA) at dtcping.cpp @.289
> -->RPC pinging exception
> -->1722(The RPC server is unavailable.)
> RPC test failed
> on the desktop sql server machine I get this
> Firewall Port Settings:
> Port:5000-5015
> RPC server is ready
> ++++++++++++Validating Remote Computer Name++++++++++++
> 08-03, 12:08:50.353-->Start DTC connection test
> Name Resolution:
> Perth-->10.0.4.23-->Perth
> 08-03, 12:08:50.368-->Start RPC test (GILBERT-->Perth)
> Problem:fail to invoke remote RPC method
> Error(0x5) at dtcping.cpp @.289
> -->RPC pinging exception
> -->5(Access is denied.)
> RPC test failed
> the msdtc service has been set to use my domain account and all the options
> have been enabled, network access, inbound, outbound etc.
> I have set up the msdtc to use ports 5000-5015
> any ideas out there?
> to get this poc working
>
|||Thanks Stuart, you are the man!
"Stuart" wrote:
[vbcol=seagreen]
> Try turning off Norton internet worm protection...
> Stuart
> "SP" wrote:

Problem:fail to invoke remote RPC method

I have two xp sp2 machines(one desktop with sql server running, the other is
a virtual pc, on the same domain), I'm trying to connect between the two
using the dtcping.exe tool from ms
the virtual pc has vs2005 etc installed and I can't get it to run a
distributed transaction on the sql server machine, both machines have the sp
2
firewall disabled.
the rpc services are running, msdtc service are running,
on the virtual pc I get the following
Firewall Port Settings:
Port:5000-5015
RPC server is ready
++++++++++++Validating Remote Computer Name++++++++++++
08-03, 12:09:03.756-->Start DTC connection test
Name Resolution:
Gilbert-->10.0.4.22-->Gilbert
08-03, 12:09:03.776-->Start RPC test (PERTH-->Gilbert)
Problem:fail to invoke remote RPC method
Error(0x6BA) at dtcping.cpp @.289
-->RPC pinging exception
-->1722(The RPC server is unavailable.)
RPC test failed
on the desktop sql server machine I get this
Firewall Port Settings:
Port:5000-5015
RPC server is ready
++++++++++++Validating Remote Computer Name++++++++++++
08-03, 12:08:50.353-->Start DTC connection test
Name Resolution:
Perth-->10.0.4.23-->Perth
08-03, 12:08:50.368-->Start RPC test (GILBERT-->Perth)
Problem:fail to invoke remote RPC method
Error(0x5) at dtcping.cpp @.289
-->RPC pinging exception
-->5(Access is denied.)
RPC test failed
the msdtc service has been set to use my domain account and all the options
have been enabled, network access, inbound, outbound etc.
I have set up the msdtc to use ports 5000-5015
any ideas out there?
to get this poc working Try turning off Norton internet worm protection...
Stuart
"SP" wrote:

> I have two xp sp2 machines(one desktop with sql server running, the other
is
> a virtual pc, on the same domain), I'm trying to connect between the two
> using the dtcping.exe tool from ms
> the virtual pc has vs2005 etc installed and I can't get it to run a
> distributed transaction on the sql server machine, both machines have the
sp2
> firewall disabled.
> the rpc services are running, msdtc service are running,
> on the virtual pc I get the following
> Firewall Port Settings:
> Port:5000-5015
> RPC server is ready
> ++++++++++++Validating Remote Computer Name++++++++++++
> 08-03, 12:09:03.756-->Start DTC connection test
> Name Resolution:
> Gilbert-->10.0.4.22-->Gilbert
> 08-03, 12:09:03.776-->Start RPC test (PERTH-->Gilbert)
> Problem:fail to invoke remote RPC method
> Error(0x6BA) at dtcping.cpp @.289
> -->RPC pinging exception
> -->1722(The RPC server is unavailable.)
> RPC test failed
> on the desktop sql server machine I get this
> Firewall Port Settings:
> Port:5000-5015
> RPC server is ready
> ++++++++++++Validating Remote Computer Name++++++++++++
> 08-03, 12:08:50.353-->Start DTC connection test
> Name Resolution:
> Perth-->10.0.4.23-->Perth
> 08-03, 12:08:50.368-->Start RPC test (GILBERT-->Perth)
> Problem:fail to invoke remote RPC method
> Error(0x5) at dtcping.cpp @.289
> -->RPC pinging exception
> -->5(Access is denied.)
> RPC test failed
> the msdtc service has been set to use my domain account and all the option
s
> have been enabled, network access, inbound, outbound etc.
> I have set up the msdtc to use ports 5000-5015
> any ideas out there?
> to get this poc working
>|||Thanks Stuart, you are the man!
"Stuart" wrote:
[vbcol=seagreen]
> Try turning off Norton internet worm protection...
> Stuart
> "SP" wrote:
>