Showing posts with label browser. Show all posts
Showing posts with label browser. Show all posts

Monday, March 19, 2012

"Sql Broswer" vs. "Hide Sql Instance"

I was never clear what the sql 2005 Browser service is about. But now that I've found the "Hide Instance" property of a server (SQL Server Configuration manager, select Protocols for MSSQLSERVER, right-click, go to Properties) I'm more confused than ever. What is the difference between these two items?

TIA,

Barkingdog


Hiding instance will prevent the broadcast request for instance to list that server instance. YOu will have to directly and explicitly connect to it (and therefore know the name).

HTH, Jens Suessmeyer.


http://www.sqlserver2005.de

|||

That makes sense but if I stop the Sql Browser won't that have the same impact?

TIA,

Barkingdog

|||Yes, shutting down your computer will also hide the instance in some way :-)

SQL Browser is not only for enumeration of instances, it will redirect requests to SQL Server instances, although the user did not specify the port to connect to, e.g. Connecting to instance SomeServer\SomeInstance on port 1677 (random port chosen by me) needs to be written in the connection string like this (without SQL Server Browser) SomeServer\SomeInstance,1677. SQL Server browser activated will also redirect the request for SomeServer\SomeInstance to the specific port without naming the port epplicitly.

So, hiding the SQL Server instance means something different. It won′t answer broadcasting request for instance names and only react on connection requests.

HTH, Jens Suessmeyer:

http://www.sqlserver2005.de

"Sql Broswer" vs. "Hide Sql Instance"

I was never clear what the sql 2005 Browser service is about. But now that I've found the "Hide Instance" property of a server (SQL Server Configuration manager, select Protocols for MSSQLSERVER, right-click, go to Properties) I'm more confused than ever. What is the difference between these two items?

TIA,

Barkingdog


Hiding instance will prevent the broadcast request for instance to list that server instance. YOu will have to directly and explicitly connect to it (and therefore know the name).

HTH, Jens Suessmeyer.


http://www.sqlserver2005.de

|||

That makes sense but if I stop the Sql Browser won't that have the same impact?

TIA,

Barkingdog

|||Yes, shutting down your computer will also hide the instance in some way :-)

SQL Browser is not only for enumeration of instances, it will redirect requests to SQL Server instances, although the user did not specify the port to connect to, e.g. Connecting to instance SomeServer\SomeInstance on port 1677 (random port chosen by me) needs to be written in the connection string like this (without SQL Server Browser) SomeServer\SomeInstance,1677. SQL Server browser activated will also redirect the request for SomeServer\SomeInstance to the specific port without naming the port epplicitly.

So, hiding the SQL Server instance means something different. It won′t answer broadcasting request for instance names and only react on connection requests.

HTH, Jens Suessmeyer:

http://www.sqlserver2005.de

Sunday, February 19, 2012

"#Value!" error for calculated cells

I have designed an AS 2000 cube with quite complex calculated cells, which work fine in cube browser or with MDX. The moment I use Excel 2007 Pivot table (both in default or compatibility mode), it shows #Value! instead of the calculations. I thought GetPivotData simply returned values from the cube and did not do any calculations of its own... I spent a lot of time to design the cube, but now it cannot be used from Excel, which it needs to be. Any help would be greatly appreciated.

Best regards.

Have you tried creating a copy of your cube, removing all the calculated cells and then connecting to it?

This might help isolate if it is just an Excel connectivity issue or an problem to do with the calculations. Unfortunately you cannot use profiler to trace AS 2000 like you can with AS 2005 otherwise we could trace the MDX that Excel is sending to the server.

|||

Thank you Darren,

It is definitely not an Excel connectivity issue, since everything else shows on the cube. It seems to fall over when it comes across calculated cells which are defined on the cube. And it does seem to be specific to Excel only. I remember the was an issue with pivot tables when the was a limitation on the cell definition MDX length, but it is unlikely to be that (I used the very minimun number of dimensions). Maybe there is known issue with the display of certain calculated cells in Excel ...

|||I think I managed to locat ethe actual problem area - those caclulated cells use a User Defined Function. When I remove the function, the "#Value!" message disappears . It is strange, because the function is not called by excel, it should be resolved on the cube where it works 100%...|||

The problem in fact looks similar to one described in

http://support.microsoft.com/kb/238306

But that was valid for much older versions of AS and was supposed to be fixed a while ago. (I am using up to date version of AS 2000).

|||


it should be resolved on the cube where it works 100%...

I am just wondering if this is not the case. AS2k used to do a fair bit of the query resolution on the client. If you run ProcessMonitor while Excel is trying to execute the query you might be able to see if it is trying to execute the UDF on the client (although it might be hard as ProcessMonitor catches a lot of information)|||Actually an easier way might be to try installing your UDF on a client machine and see if that fixes the problem.|||

I tried that and it di dnot work. One thing I noticed Excel looked in C:\Documents and Settings\f2978326\Application Data\Microsoft\Template for UserDefined.UDF file and UserDefined is the name of the library while UDF is the name of the class that calculations use ..... Does anyone actually have the information on how PivotTable service handles cells which reference UDFs from analysis server? So far I have not been able to get it anywhere...

Thursday, February 9, 2012

#### Security on Report Manager ####

Hi:
I have security settings for everyone as browser on my home directory of the
report manager. No matter what settings I have for the browser role, (view
reports lets him view report properties as well). But i dont want my users to
go in and chnage the data source properties or parameters. How can i not show
the properties tab for the reports, but still have the susbcription available.
ThanksIf the account your testing with sees other report properties than jsut the
General properties (which would not let them get at the
data source) then it is not coming in as "Everyone". May be the account
you are testing with is a member of a higher privelege group.
"Everyone" should have the ability to access subscriptions so long as report
is being executed using stored credentials.
--
-- "This posting is provided 'AS IS' with no warranties, and confers no
rights."
jhmiller@.online.microsoft.com
"NI" <NI@.discussions.microsoft.com> wrote in message
news:5D49B753-7185-49B1-92C5-249A0A6E0788@.microsoft.com...
> Hi:
> I have security settings for everyone as browser on my home directory of
> the
> report manager. No matter what settings I have for the browser role,
> (view
> reports lets him view report properties as well). But i dont want my users
> to
> go in and chnage the data source properties or parameters. How can i not
> show
> the properties tab for the reports, but still have the susbcription
> available.
> Thanks|||Thats exactly what I want, browser be able to see just general properties and
subscription, and not get to parameters and data sources. And you may be
right when you say, the acocunt I am testing with is not coming in as
Everyone. Before I had "everyone" set up on the home directory, I used to
have a bunch of accounts (individual user in the format domain\user) set up.
Now I removed all those individual settings and have just everyone. But when
I look at the ReportServer DB and Users table, it has everyone with userType
1 and Auth Type 1. And it has those individual user accounts I used to have
with userType 1and Auth Type 1, and it has some other indivual accounts
(whihc I never set up, but they r probably hitting the reports coz everyone
can see them), with userTpe 0 and authType 1. Also one wierd thing, it has
"domain\" with UserType 1 and AuthType 1.
Anything wrong happening here.
Thanks a bunch
"John H. Miller" wrote:
> If the account your testing with sees other report properties than jsut the
> General properties (which would not let them get at the
> data source) then it is not coming in as "Everyone". May be the account
> you are testing with is a member of a higher privelege group.
> "Everyone" should have the ability to access subscriptions so long as report
> is being executed using stored credentials.
> --
> -- "This posting is provided 'AS IS' with no warranties, and confers no
> rights."
> jhmiller@.online.microsoft.com
> "NI" <NI@.discussions.microsoft.com> wrote in message
> news:5D49B753-7185-49B1-92C5-249A0A6E0788@.microsoft.com...
> > Hi:
> >
> > I have security settings for everyone as browser on my home directory of
> > the
> > report manager. No matter what settings I have for the browser role,
> > (view
> > reports lets him view report properties as well). But i dont want my users
> > to
> > go in and chnage the data source properties or parameters. How can i not
> > show
> > the properties tab for the reports, but still have the susbcription
> > available.
> >
> > Thanks
>
>