Two most frequent Problems faced by SA's

After many days of implementation of  Meghdoot SP1 and Sanchay post R2 also, many of our friends facing two problems. So I have decided to post the two solutions again.

1) While doing submit accounts ‘Server not configured for RPC’
Solution: Run the following query using query analyzer (replace ‘myserver’ with your server name):

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

Note: The above error is related to SQL Server configuration settings and not related to the application. (RPC is Remote Procedure Call).

2) Login failed for user Arrow in Project database (While upgradation of SP R2)
                     or
    If you recieve error code "Z" If you check the status in DB Analyzer

Please Download the Arrow.exe, double click the Arrow.exe and input the login details
and press ok.

Download Arrow.exe