Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Service pack 2 installation


Service pack 2 installation

Author
Message
Deana Sanders
Deana Sanders
Grasshopper
Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)

Group: General Forum Members
Points: 18 Visits: 33
Hi,



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 1

SQL 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,

Deana
colin.Leversuch-Roberts
colin.Leversuch-Roberts
Hall of Fame
Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)

Group: General Forum Members
Points: 3153 Visits: 715
I 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.

The GrumpyOldDBA
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Greg Edwards-268690
Greg Edwards-268690
SSC Eights!
SSC Eights! (973 reputation)SSC Eights! (973 reputation)SSC Eights! (973 reputation)SSC Eights! (973 reputation)SSC Eights! (973 reputation)SSC Eights! (973 reputation)SSC Eights! (973 reputation)SSC Eights! (973 reputation)

Group: General Forum Members
Points: 973 Visits: 8327
It 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 E
Deana Sanders
Deana Sanders
Grasshopper
Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)

Group: General Forum Members
Points: 18 Visits: 33
Checking 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.



Deana
Jack Corbett
  Jack Corbett
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12778 Visits: 14863
I 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?



Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming
At best you can say that one job may be more secure than another, but total job security is an illusion. -- Rod at work

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Greg Edwards-268690
Greg Edwards-268690
SSC Eights!
SSC Eights! (973 reputation)SSC Eights! (973 reputation)SSC Eights! (973 reputation)SSC Eights! (973 reputation)SSC Eights! (973 reputation)SSC Eights! (973 reputation)SSC Eights! (973 reputation)SSC Eights! (973 reputation)

Group: General Forum Members
Points: 973 Visits: 8327
sad, 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 E
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search