I am trying to install SQL Server Reporting Services on SQL Server 2000. A message comes up as follows: "Setup is verifying that the Server instance <servername> is accessible and the credentials provided have sufficient permissions to create the database. If the specified SQL Server instance is on the local computer and is stopped, setup will start the instance."
I ensure that the SQL Server is running and the login has administrator's permission to the server and the sql server but I still get an error as follows:
"Cannot connect to the SQL Server instance on the <Server>"
Can anyone help me? Desparate.