deploying with default parameter value

I have an application with a parameter that has a single value drop down list from a query. My dataset has a union with "0","All". I set the default to non-queried, value "0". I go to preview and BI displays the label correctly as "All". When I deploy the app and view it in the web browser the default value is not displayed correctly, and it shows "Select a value". Why, why, why does it preview correctly yet deploys incorrectly, and how can I fix it
From http://www.developmentnow.com/g/115_0_0_0_0_0/sql-server-reporting-services.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.comYou can try deleting the earlier deployed report from Report Manager
and deploy the modified report which is previewing fine with all
default values.
Thanks
Subhash

Deploy to named instance

Is it possible to deploy to a named instance from the default instance on the same machine? I keep gettin 'unable to connect' error.

Thanks.

SQL Server 2005 sp 2/Vista

> deploy to a named instance from the default instance on the same machine?

What does it mean "deploy from instance" ? Normally the project is deployed from BI Dev Studio. There in the Deployment Options, you specify the named instance as a server to deploy to, and it will work.

|||

I get the following error message: The project could not be deployed to the '...' server because of the following connectivity problems" '....' instance was not found on '..' server

I know the instance is there because I can open it in sql server mgmt studio. I can also use the named instance as a data source.

|||

Further information: Microsoft doesn't like instance names to include the '_' character, as in SQL_TWO.

Getting closer....just one Mdx script error

Deploy so that data sources are not viewable

Is there a way to configure a RS data source (in VS.NET) to be not visible
as default when deployed?
Thanks,
BryanI don't know of a way to do this. I go to Report Manager and have the data
source not show up in list view (go to the properties to set this). I know
of no way to do this from VS.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bryan Bullard" <reply@.to.group.com> wrote in message
news:e1xiZ%23qGFHA.2356@.TK2MSFTNGP12.phx.gbl...
> Is there a way to configure a RS data source (in VS.NET) to be not visible
> as default when deployed?
> Thanks,
> Bryan
>|||Maybe its possible to run this as a build step:
update ReportServer.dbo.Catalog
set Hidden = 1
where Type = 5
Is this safe?
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:O0%23nvNrGFHA.3912@.TK2MSFTNGP10.phx.gbl...
>I don't know of a way to do this. I go to Report Manager and have the data
> source not show up in list view (go to the properties to set this). I know
> of no way to do this from VS.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Bryan Bullard" <reply@.to.group.com> wrote in message
> news:e1xiZ%23qGFHA.2356@.TK2MSFTNGP12.phx.gbl...
>> Is there a way to configure a RS data source (in VS.NET) to be not
>> visible
>> as default when deployed?
>> Thanks,
>> Bryan
>>
>|||I don't know. See as how when you are installing no-one has rights to it
until you give them rights I have never felt the need to not just use the
Report Manager.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bryan Bullard" <reply@.to.group.com> wrote in message
news:ODL4h3rGFHA.2744@.tk2msftngp13.phx.gbl...
> Maybe its possible to run this as a build step:
> update ReportServer.dbo.Catalog
> set Hidden = 1
> where Type = 5
> Is this safe?
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:O0%23nvNrGFHA.3912@.TK2MSFTNGP10.phx.gbl...
> >I don't know of a way to do this. I go to Report Manager and have the
data
> > source not show up in list view (go to the properties to set this). I
know
> > of no way to do this from VS.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Bryan Bullard" <reply@.to.group.com> wrote in message
> > news:e1xiZ%23qGFHA.2356@.TK2MSFTNGP12.phx.gbl...
> >> Is there a way to configure a RS data source (in VS.NET) to be not
> >> visible
> >> as default when deployed?
> >>
> >> Thanks,
> >> Bryan
> >>
> >>
> >
> >
>|||Good point. Thanks for your reply.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:ul3HEDsGFHA.3628@.TK2MSFTNGP15.phx.gbl...
>I don't know. See as how when you are installing no-one has rights to it
> until you give them rights I have never felt the need to not just use the
> Report Manager.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Bryan Bullard" <reply@.to.group.com> wrote in message
> news:ODL4h3rGFHA.2744@.tk2msftngp13.phx.gbl...
>> Maybe its possible to run this as a build step:
>> update ReportServer.dbo.Catalog
>> set Hidden = 1
>> where Type = 5
>> Is this safe?
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:O0%23nvNrGFHA.3912@.TK2MSFTNGP10.phx.gbl...
>> >I don't know of a way to do this. I go to Report Manager and have the
> data
>> > source not show up in list view (go to the properties to set this). I
> know
>> > of no way to do this from VS.
>> >
>> > --
>> > Bruce Loehle-Conger
>> > MVP SQL Server Reporting Services
>> >
>> > "Bryan Bullard" <reply@.to.group.com> wrote in message
>> > news:e1xiZ%23qGFHA.2356@.TK2MSFTNGP12.phx.gbl...
>> >> Is there a way to configure a RS data source (in VS.NET) to be not
>> >> visible
>> >> as default when deployed?
>> >>
>> >> Thanks,
>> >> Bryan
>> >>
>> >>
>> >
>> >
>>
>

denying read rights to a dimension

Hi,

When you give read rights to a cube then the dimension gets read rights by default. Is there a way by which you can grant read rights to certain dimensions of that cube and deny the read rights to certain dimensions of that cube?

thanx.

In AS 2005, just create a new Role, and select what the users belonging to that role can see in the Dimension Data tab. If you select the "Deselect All Members" option, then the users of the role won't be able to see any data of that dimension.

In AS 2000, you have to add the dimension to the restricted dimension list when editing the proper role.

Hope this help,

Santi

|||

Thanx. But then in that case I can still see the dimension. However if I dont want to show any of the attributes of a dimension, is it possible to hide the dimension completely..

Deny create schema still does not work in 2k8

You can't assign a default schema for a user that maps to a Windows group. OK fine. But if you create a user for that group anyway with no default schema, any objects created by members of that group will automatically cause a schema to be created for them, EVEN WHEN THAT USER HAS BEEN EXPLICITLY DENIED THE CREATE SCHEMA PERMISSION IN THE DATABASE. This is the same as it was in 2K5, but has still not been fixed in 2k8.

To reproduce, do the following steps:
Create a windows group, either in the doman or local to the box.
Add at least one Windows user to that group.
Create a SQL login for that Windows group.
Map that login to a new user in some database.
Explicitly 'deny create schema to ' that group/user.
Grant 'create procedure' to that group/user.
Log onto SQL with a Windows login that is a member of that Windows group
Use the database that we set the permissions in above.
Create a dummy stored procedure without qualifying the name with a schema ie: 'create prodedure test1 as select 'hello world').
Look to see what you ended up with. You will have a new schema named the same as the user who created the sproc. This will now be their default schema implicitly, and the test1 stored procedure will be in that schema, EVEN WHEN THAT USER WA EXPLICITLY DENIED THE CREATE SCHEMA PERMISSION IN THE DATABASE.

Could you please fix this?

Actually what you are describing is implicit user creation. It is working by design and as described in BOL (please refer to the remarks section in USER_ID topic http://msdn2.microsoft.com/en-us/library/ms181466.aspx). This functionality is there mainly to preserve backwards compatibility when a Windows user doesn’t have an explicitly created user.

During the implicit user creation, it is the system creating a Windows principal and schema (following the SQL Server 2000 behavior) for a user that is taking an action on the database that requires an owner (in your scenario creating a SP) in order to mark the appropriate owner. Even more, this newly created schema is the default schema for the implicit user (again, for backwards compatibility).

For example, if you look at the newly created SP you mentioned, you will notice that the proper owner is a newly created user (Windows user) that maps to the Windows principal who created it:

CREATE DATABASE [db_Demo_ImplicitUser]

go

USE [db_Demo_ImplicitUser]

go

CREATE USER [DOMAIN\windows_group]

go

DENY CREATE SCHEMA TO [DOMAIN\windows_group]

go

GRANT CREATE PROCEDURE TO [DOMAIN\windows_group]

go

-- Using execute as login to mimic the behavior of

-- connecting as this principal

--

EXECUTE AS LOGIN = 'DOMAIN\windows_user'

go

-- It will return 0 == public

-- but user_name() knows this principal got access via a group

-- and handles the scenario using the Windows name directly

--

SELECT user_id(), user_name( user_id() ), user_name()

go

CREATE PROC sp_demo

as

print 'test'

go

-- In which schema was it created?

--

EXEC [DOMAIN\windows_user].[sp_demo]

go

-- Try the user_id test again and see that now this principal

-- is mapped to a DB principal

--

SELECT user_id(), user_name( user_id() ), user_name()

go

SELECT * FROM sys.database_principals

SELECT * FROM sys.objects

go

-- This call should fail

--

CREATE SCHEMA [myOwnSchema]

go

One point that is important to emphasize is that the user doesn’t have the ability to create arbitrary schemas (i.e. call CREATE SCHEMA).

Hopefully this brief explanation will help to explain the reasons behind this behavior; but please let us know is you have any additional feedback on this topic, we really appreciate it.

Thanks a lot,

-Raul Garcia

SDE/T

SQL Server Engine

|||

Yes, I am aware that it is now documented since it was done so in part due to my opening an incident with MS that this behavior happened at all in 2K5. There "solution" was simply to document it and close the indicent. But that doesn't fix it. It's illogical and breaks security. I have no way to deny schema creation. That's broken and needs to be fixed. Period.