Your office is not registered with RPC

Run the following query using query analyzer.

exec sp_serveroption @server='myserver', @optname='rpc', @optvalue='true'
go
exec sp_serveroption @server='myserver', @optname='rpc out', @optvalue='true'
go

in the myserver replace the myserver with your servername.. It will solve the RPC problem

in SQL 2005 you will find query analyzer directly, and in sql 2008 you will find ADD NEW QUERY in SQL management studio. 

Share on Google Plus

About Unknown

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.