Named Pipes Disabled in SQL 2005

I see Named Pipes disabled by default in SQL 2005. Is this for any specific reasons?Depends on the SKU of your SQL Server package, NP may or may not disabled. In general, we disable NP to reduce attack surface area. You can turn it on by your own judgement based on your cofiguration and requirement.

My Site option

What permission is required to be able to go into the "My Site" settings in
the Report Manager? Is it looking for a specific permission in the
ReportServer database, config file, or some machine permission?Correction, I meant the "Site Setting" option. What permission is required
to be able to go into the "Site Setting" option?
"David" wrote:
> What permission is required to be able to go into the "My Site" settings in
> the Report Manager? Is it looking for a specific permission in the
> ReportServer database, config file, or some machine permission?|||Hello David,
You need to create a new server side role and grant proper server side
permission.
At least, you need to grant the following:
Execute Report Definitions
Manage report server properties
View report server properties
View shared schedules
Or any other Server Management permission like Manage report server
security,Manage roles, Manage shared schedules.
Once you grant one of these Server management permission to the Role and
assign a user to this Server Side Role, the user could see the 'Site
Setting' in the Report Manager.
Hope this helps.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.