InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 14:20:29 GMT20http://www.sqlservercentral.com/Forums/Topic408741-146-1.aspxsad, but true. 'All in the box' for one price is 'all on one server, one proc'But depending on how you plan on using RS, you may be able to use a lesser version than your main server.Greg EThu, 11 Oct 2007 07:34:58 GMTGreg Edwards-268690http://www.sqlservercentral.com/Forums/Topic408741-146-1.aspxI was under the impression, at least with SSRS 2000, that if you used a different webserver you had to have SQL License for both servers. Is this true with SSRS 2005?Thu, 11 Oct 2007 07:28:30 GMT Jack Corbetthttp://www.sqlservercentral.com/Forums/Topic408741-146-1.aspxChecking out the RS configuration is one of my tasks this morning, and the web server is a different server than the database server.Thanks for the input.DeanaThu, 11 Oct 2007 07:12:07 GMTDeana Sandershttp://www.sqlservercentral.com/Forums/Topic408741-146-1.aspxIt sounds like they installed RS but did not Configure it. This is an option during install of SQL Server, and necessary if installing the web site on one server and the database on antoher server.If you aren't doing anything with RS, you should probably remove it.Greg EThu, 11 Oct 2007 06:56:14 GMTGreg Edwards-268690http://www.sqlservercentral.com/Forums/Topic408741-146-1.aspxI usually install under my own account as a local admin on the box, not using the service account. To date not ever had any errors. Suggest you don't define the service account.Wed, 10 Oct 2007 06:20:52 GMTcolin.Leversuch-Robertshttp://www.sqlservercentral.com/Forums/Topic408741-146-1.aspxHi, I have a server running SQL Server 2005 -- two instances each with Reporting Services. During the installation window asking about which authentication method to use, I put down Windows with the username of the service account. Then I hit the 'Test' button. One of the Reporting Services came back with an error:HResult 0xFFFFFFFF, Level 16, State 1SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].Error: sqlcmd Microsoft SQL Native Client : An error has occurred That nice protocols explanation thingy gave two suggestion about named pipes (already enabled) and SQL Server Browser (already turned on).A question to the logical DBA/developer said that they had previously loaded the Reporting Services for some future plan, but that they had not done anything with it. Literally. I could not access anything in Management Studio except to log in.So, now what? Do I upgrade the instance with no problems and forget about the one with problems for the time being? Remove Reporting Services and re-install it another time?Regards,DeanaTue, 09 Oct 2007 16:01:52 GMTDeana Sanders