Named Instance naming rules

Hi, I'm trying to wrap the MSDE command line installer with an
InstallShield setup. One of the requirements is that the user can choose to
install a named instance and can choose the name of the named instance.
Here's what I found on SQL BOL:
"A new instance name must begin with a letter, an ampersand (&), or an
underscore (_), and can contain numbers, letters, or other characters. SQL
Server sysnames and reserved names should not be used as instance names. For
example, the term "default" should not be used as an instance name because
it is a reserved name used by Setup."
That's a little vague for trying to write an installer. Does anyone know the
specific rules for a naming a named instance? For example - how long can the
name be? can there be spaces in the name? what exactly are "other
characters" - anything?Refer "Instance Name" under "instance names" in BOL
--
Thanks
Ravi
"Andy Gaskell" wrote:
> Hi, I'm trying to wrap the MSDE command line installer with an
> InstallShield setup. One of the requirements is that the user can choose to
> install a named instance and can choose the name of the named instance.
> Here's what I found on SQL BOL:
> "A new instance name must begin with a letter, an ampersand (&), or an
> underscore (_), and can contain numbers, letters, or other characters. SQL
> Server sysnames and reserved names should not be used as instance names. For
> example, the term "default" should not be used as an instance name because
> it is a reserved name used by Setup."
> That's a little vague for trying to write an installer. Does anyone know the
> specific rules for a naming a named instance? For example - how long can the
> name be? can there be spaces in the name? what exactly are "other
> characters" - anything?
>
>|||Thanks Ravi.
"Ravi" <Ravi@.discussions.microsoft.com> wrote in message
news:AAC8D56C-739C-4C63-8EC2-AABF3937382F@.microsoft.com...
> Refer "Instance Name" under "instance names" in BOL
> --
> Thanks
> Ravi
>
> "Andy Gaskell" wrote:
>> Hi, I'm trying to wrap the MSDE command line installer with an
>> InstallShield setup. One of the requirements is that the user can choose
>> to
>> install a named instance and can choose the name of the named instance.
>> Here's what I found on SQL BOL:
>> "A new instance name must begin with a letter, an ampersand (&), or an
>> underscore (_), and can contain numbers, letters, or other characters.
>> SQL
>> Server sysnames and reserved names should not be used as instance names.
>> For
>> example, the term "default" should not be used as an instance name
>> because
>> it is a reserved name used by Setup."
>> That's a little vague for trying to write an installer. Does anyone know
>> the
>> specific rules for a naming a named instance? For example - how long can
>> the
>> name be? can there be spaces in the name? what exactly are "other
>> characters" - anything?
>>

Named Instance naming rules

Hi, I'm trying to wrap the MSDE command line installer with an
InstallShield setup. One of the requirements is that the user can choose to
install a named instance and can choose the name of the named instance.
Here's what I found on SQL BOL:
"A new instance name must begin with a letter, an ampersand (&), or an
underscore (_), and can contain numbers, letters, or other characters. SQL
Server sysnames and reserved names should not be used as instance names. For
example, the term "default" should not be used as an instance name because
it is a reserved name used by Setup."
That's a little vague for trying to write an installer. Does anyone know the
specific rules for a naming a named instance? For example - how long can the
name be? can there be spaces in the name? what exactly are "other
characters" - anything?Refer "Instance Name" under "instance names" in BOL
--
Thanks
Ravi
"Andy Gaskell" wrote:

> Hi, I'm trying to wrap the MSDE command line installer with an
> InstallShield setup. One of the requirements is that the user can choose t
o
> install a named instance and can choose the name of the named instance.
> Here's what I found on SQL BOL:
> "A new instance name must begin with a letter, an ampersand (&), or an
> underscore (_), and can contain numbers, letters, or other characters. SQL
> Server sysnames and reserved names should not be used as instance names. F
or
> example, the term "default" should not be used as an instance name because
> it is a reserved name used by Setup."
> That's a little vague for trying to write an installer. Does anyone know t
he
> specific rules for a naming a named instance? For example - how long can t
he
> name be? can there be spaces in the name? what exactly are "other
> characters" - anything?
>
>|||Thanks Ravi.
"Ravi" <Ravi@.discussions.microsoft.com> wrote in message
news:AAC8D56C-739C-4C63-8EC2-AABF3937382F@.microsoft.com...[vbcol=seagreen]
> Refer "Instance Name" under "instance names" in BOL
> --
> Thanks
> Ravi
>
> "Andy Gaskell" wrote:
>sql

Named Instance naming rules

Hi, I'm trying to wrap the MSDE command line installer with an
InstallShield setup. One of the requirements is that the user can choose to
install a named instance and can choose the name of the named instance.
Here's what I found on SQL BOL:
"A new instance name must begin with a letter, an ampersand (&), or an
underscore (_), and can contain numbers, letters, or other characters. SQL
Server sysnames and reserved names should not be used as instance names. For
example, the term "default" should not be used as an instance name because
it is a reserved name used by Setup."
That's a little vague for trying to write an installer. Does anyone know the
specific rules for a naming a named instance? For example - how long can the
name be? can there be spaces in the name? what exactly are "other
characters" - anything?
Refer "Instance Name" under "instance names" in BOL
Thanks
Ravi
"Andy Gaskell" wrote:

> Hi, I'm trying to wrap the MSDE command line installer with an
> InstallShield setup. One of the requirements is that the user can choose to
> install a named instance and can choose the name of the named instance.
> Here's what I found on SQL BOL:
> "A new instance name must begin with a letter, an ampersand (&), or an
> underscore (_), and can contain numbers, letters, or other characters. SQL
> Server sysnames and reserved names should not be used as instance names. For
> example, the term "default" should not be used as an instance name because
> it is a reserved name used by Setup."
> That's a little vague for trying to write an installer. Does anyone know the
> specific rules for a naming a named instance? For example - how long can the
> name be? can there be spaces in the name? what exactly are "other
> characters" - anything?
>
>
|||Thanks Ravi.
"Ravi" <Ravi@.discussions.microsoft.com> wrote in message
news:AAC8D56C-739C-4C63-8EC2-AABF3937382F@.microsoft.com...[vbcol=seagreen]
> Refer "Instance Name" under "instance names" in BOL
> --
> Thanks
> Ravi
>
> "Andy Gaskell" wrote:

Name: dbo Login name: none ??

Sometimes I find that when I restore a database the user
(sa is the only user in the database in this case) comes
up with the "Name" of dbo but there is nothing displayed
in the "Login Name" column in the "users" object. How do I
get the "Login Name" of sa to appear there?
Thanks
JThe login mapping for the 'dbo' user is determined by database ownership.
This can get out-of-sync following a restore or attach. You can correct
this with sp_changedbowner:
USE MyDatabase
EXEC sp_changedbowner 'sa'
GO
"J" <anonymous@.discussions.microsoft.com> wrote in message
news:04e701c3b9e8$ced2ab50$a101280a@.phx.gbl...
> Sometimes I find that when I restore a database the user
> (sa is the only user in the database in this case) comes
> up with the "Name" of dbo but there is nothing displayed
> in the "Login Name" column in the "users" object. How do I
> get the "Login Name" of sa to appear there?
> Thanks
> J

Name of User Requesting Report

I have several reports that need a parameter for logon name. How can I get
the name of the user requesting the report so I can use that in a parameter
for the report query?
Thanks for any helpThere is a global value of UserID that you can assign to the report
parameter in an expression. Its value is the domain\userid for the
connected user.
example:
=Globals!UserID
You can assign it to a stored procedure paramter in the parameter tab
of the data set editor. Be sure to use the CommandType of
"StoredProcedure" and not "Text" when configuring the data set.
Regards,
Clayton
Scott Duckworth wrote:
> I have several reports that need a parameter for logon name. How can I get
> the name of the user requesting the report so I can use that in a parameter
> for the report query?
> Thanks for any help|||Thanks for the help.
"SQLMonger" <claytongroom@.gmail.com> wrote in message
news:1120842855.113091.85050@.z14g2000cwz.googlegroups.com...
> There is a global value of UserID that you can assign to the report
> parameter in an expression. Its value is the domain\userid for the
> connected user.
> example:
> =Globals!UserID
> You can assign it to a stored procedure paramter in the parameter tab
> of the data set editor. Be sure to use the CommandType of
> "StoredProcedure" and not "Text" when configuring the data set.
> Regards,
> Clayton
> Scott Duckworth wrote:
> > I have several reports that need a parameter for logon name. How can I
get
> > the name of the user requesting the report so I can use that in a
parameter
> > for the report query?
> >
> > Thanks for any help
>sql

MYSQL error

While installing mysql server on a windows 2000 machine without a
firewall, I get an error numbered 1045. Access is denied for user
'root'@.'localhost' (using password: NO). If anyone has any ideas of
how to solve it, it would be much appreciated.
RBThis is a newsgroup for Microsoft SQL Server support. I am not trying to
chase you off or flame you, but you may not find te assistance you are
looking for here. You may want to look at http://forums.mysql.com/ for help
with your problem.
Of course, you could try SQL Express.
http://www.microsoft.com/downloads/details.aspx?FamilyId=1A722B0F-6CCA-4E8B-B6EA-12D9C450ED92&displaylang=en
Don't forget the SQL Express manager:
http://www.microsoft.com/downloads/details.aspx?FamilyId=C7A5CC62-EC54-4299-85FC-BA05C181ED55&displaylang=en
Geoff N. Hiten
Microsoft SQL Server MVP
<slush@.albertaimit.ca> wrote in message
news:v0fua1lc7b2ftt4c5i81bvikeuk4t2k1l0@.4ax.com...
> While installing mysql server on a windows 2000 machine without a
> firewall, I get an error numbered 1045. Access is denied for user
> 'root'@.'localhost' (using password: NO). If anyone has any ideas of
> how to solve it, it would be much appreciated.
> RB|||www.mysql.com
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
<slush@.albertaimit.ca> wrote in message
news:v0fua1lc7b2ftt4c5i81bvikeuk4t2k1l0@.4ax.com...
> While installing mysql server on a windows 2000 machine without a
> firewall, I get an error numbered 1045. Access is denied for user
> 'root'@.'localhost' (using password: NO). If anyone has any ideas of
> how to solve it, it would be much appreciated.
> RB

My SQL7.0 Problems

I have a SQL 7.0 DB that is working fine, except for some records that a
user deleted. She wants me to restore them. My normal process for
restoring SQL data is to restore last night's backup to a test DB and let
the user access this DB for their information. My problem is that the test
DB is corrupt. When I try to access the DB through Enterprise Manager, I
get this: An error occurred while trying to access the database information.
When I try to get properties on the database, I get this: Error 945:
Database 'database' cannot be opened because some of the files could not be
activated.
I was able to try to restore (and import) data to the DB, but got various
error messages.
My questions:
1. Can this DB be repaired?
2. If this DB can't be repaired, can restore or import to it?
I made a new blank DB and tried to restore (and import) to it, but got
errors when I tried that too.
Any ideas?
Thanks,
JohnHi
Delete the DB and re-create it, then re-restore the Data. "DROP DATABASE" is
the command.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"AnytimeAnywhere" <gm79ta@.yahoo.com> wrote in message
news:11411o8s8vrbibf@.corp.supernews.com...
> I have a SQL 7.0 DB that is working fine, except for some records that a
> user deleted. She wants me to restore them. My normal process for
> restoring SQL data is to restore last night's backup to a test DB and let
> the user access this DB for their information. My problem is that the
test
> DB is corrupt. When I try to access the DB through Enterprise Manager, I
> get this: An error occurred while trying to access the database
information.
> When I try to get properties on the database, I get this: Error 945:
> Database 'database' cannot be opened because some of the files could not
be
> activated.
> I was able to try to restore (and import) data to the DB, but got various
> error messages.
> My questions:
> 1. Can this DB be repaired?
> 2. If this DB can't be repaired, can restore or import to it?
> I made a new blank DB and tried to restore (and import) to it, but got
> errors when I tried that too.
> Any ideas?
> Thanks,
> John
>|||Thanks for the response!
How do I use the 'DROP DATABASE' command? After I delete and restore the
database, do I go into 'Query Analyzer' and issue the command there? What
does it do?
Thanks again,
John
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:u7J0bPzLFHA.568@.TK2MSFTNGP09.phx.gbl...
> Hi
> Delete the DB and re-create it, then re-restore the Data. "DROP DATABASE"
is
> the command.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "AnytimeAnywhere" <gm79ta@.yahoo.com> wrote in message
> news:11411o8s8vrbibf@.corp.supernews.com...
> > I have a SQL 7.0 DB that is working fine, except for some records that a
> > user deleted. She wants me to restore them. My normal process for
> > restoring SQL data is to restore last night's backup to a test DB and
let
> > the user access this DB for their information. My problem is that the
> test
> > DB is corrupt. When I try to access the DB through Enterprise Manager,
I
> > get this: An error occurred while trying to access the database
> information.
> > When I try to get properties on the database, I get this: Error 945:
> > Database 'database' cannot be opened because some of the files could not
> be
> > activated.
> >
> > I was able to try to restore (and import) data to the DB, but got
various
> > error messages.
> >
> > My questions:
> >
> > 1. Can this DB be repaired?
> >
> > 2. If this DB can't be repaired, can restore or import to it?
> >
> > I made a new blank DB and tried to restore (and import) to it, but got
> > errors when I tried that too.
> >
> > Any ideas?
> >
> > Thanks,
> >
> > John
> >
> >
>

'My Reports' folder not being created for some users

Hi,
I was just nosing around the DB, and I noticed that all the users are in the
'users' table, but the user accounts don't appear in the 'PolicyUserRole'
table, and hence there are not any policies for them.
I don't know if this helps any or just confuses...
And there aren't any application events in the log on the server, either.
"Lance" <lance@.[nospam]keayweb.com> wrote in message
news:11869vtmjhs8i08@.corp.supernews.com...
> Hi,
> Thanks for the reply, but I am a bit confused about it! Maybe if I
explain
> a bit more about the setup: The ReportServer is set up with no common
> reports. Each user can *only* view the reports in their own 'My Reports'
> folder. As such each user *must* have a 'My Reports' folder! (obviously)
>
> Here is how the server is set up:
> * There are the standard 'Item-level' roles and an additional one,
> 'Viewer' - which is a limited acct, that just allows the user to 'view
> folders' and 'view reports'. None of the non-admin users can create
> reports.
> * The 'System Roles' are the standard 'System Administrator' and 'System
> User' - the 'System User' has the 'View report server properties' and
'View
> shared schedules' tasks.
> * The 'Enable My Reports to support user-owned folders for publishing and
> running personalized reports.' checkbox is checked in the 'Reporst Server'
> 'Site Settings'. The 'Choose the role to apply to each user's My Reports
> folder' dropdown is 'Viewer'
>
> To set up for a new user:
> * Each new user is added to the 'Users' group on the server (windows 2000
> server).
> * The user logs in, and a 'My Reports' folder should be created.
>
> But mostly, a 'My Reports' folder is *not* created. Or perhaps just not
> shown. I don't know how to check whether there is a 'My Reports' folder
for
> the user - I am thinking that there is a value in the DB somewhere that
> tells me...
>
> I was experimenting with a dozen new users, and the docs say that as soon
as
> a windows user logs in, a 'My Reports' folder should be created. I tried
> both creating a 'System Role' for the user and *not* creating a system
role,
> but the creation of the 'My Reports' folder seems to occur randomly. I
say
> *seem*, as I am sure that I am missing a step or something, as I confess
> that I find the role assignment somewhat confusing. But I'm new, and I am
> sure I'll get used to it...
>
>
> In response to your kindly answer:
> So, from my limited understanding, the 'My Reports' role is an
'item-level'
> role; I can only seem to assign to this at the report level (ie an 'item')
> *not* to a user. But if the 'My Reports' folder is not being created, I
> can't assign this 'tiem-level' role to it!
>
>
> In short: I am still stuck with some users having a 'My Reports' folder
and
> most users *not* having one!
> Thanks,
> Lance
>
>
>
>
>
> > Lance,
> >
> > Have you checked to ensure all users are are included in the "My
Reports"
> > role - or in some custom role that includes the required permissions.
> >
> > Regards,
> >
> >
> > --
> > Rob Labbé, MCP, MCAD, MCSD, MCT
> > Lead Architect/Trainer
> > Fidelis
> >
> > Blog: http://spaces.msn.com/members/roblabbe
> >
> > "Lance" <lance@.[nospam]keayweb.com> wrote in message
> > news:11849vnplj1n02@.corp.supernews.com...
> > > Hi,
> > > I am having some trouble getting the 'My Reports' folder to appear for
> all
> > > users. The docs just say that as long as the user exists as a windows
> > > user
> > > and the 'My Reports' option is ticked in 'Site Settings', ReportServer
> > > should just create a 'My Reports' folder the first time a user logs
onto
> > > the
> > > ReportServer. But this is not working for all users. About half of
the
> > > users have the 'My Reports' folder created. So I need to know how to
> > > create
> > > them manually, or at least some workaround to get each user a 'My
> Reports'
> > > folder!
> > >
> > > I don't see any difference between the user accts (other than the
> names).
> > >
> > > Thanks,
> > > Lance
> > >
> > >
> >
> >
>
>The my reports folder will not be created until the user browses to that
folder. (Yes, I know, a little confusing) The first time they browse to it
RS will create the folder and assign the My Reports permission to it.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lance" <lance@.[nospam]keayweb.com> wrote in message
news:1188kvr7cuimc7a@.corp.supernews.com...
> Hi,
> I was just nosing around the DB, and I noticed that all the users are in
> the
> 'users' table, but the user accounts don't appear in the 'PolicyUserRole'
> table, and hence there are not any policies for them.
> I don't know if this helps any or just confuses...
> And there aren't any application events in the log on the server, either.
>
> "Lance" <lance@.[nospam]keayweb.com> wrote in message
> news:11869vtmjhs8i08@.corp.supernews.com...
>> Hi,
>> Thanks for the reply, but I am a bit confused about it! Maybe if I
> explain
>> a bit more about the setup: The ReportServer is set up with no common
>> reports. Each user can *only* view the reports in their own 'My Reports'
>> folder. As such each user *must* have a 'My Reports' folder!
>> (obviously)
>> Here is how the server is set up:
>> * There are the standard 'Item-level' roles and an additional one,
>> 'Viewer' - which is a limited acct, that just allows the user to 'view
>> folders' and 'view reports'. None of the non-admin users can create
>> reports.
>> * The 'System Roles' are the standard 'System Administrator' and 'System
>> User' - the 'System User' has the 'View report server properties' and
> 'View
>> shared schedules' tasks.
>> * The 'Enable My Reports to support user-owned folders for publishing and
>> running personalized reports.' checkbox is checked in the 'Reporst
>> Server'
>> 'Site Settings'. The 'Choose the role to apply to each user's My Reports
>> folder' dropdown is 'Viewer'
>> To set up for a new user:
>> * Each new user is added to the 'Users' group on the server (windows 2000
>> server).
>> * The user logs in, and a 'My Reports' folder should be created.
>> But mostly, a 'My Reports' folder is *not* created. Or perhaps just not
>> shown. I don't know how to check whether there is a 'My Reports' folder
> for
>> the user - I am thinking that there is a value in the DB somewhere that
>> tells me...
>> I was experimenting with a dozen new users, and the docs say that as soon
> as
>> a windows user logs in, a 'My Reports' folder should be created. I tried
>> both creating a 'System Role' for the user and *not* creating a system
> role,
>> but the creation of the 'My Reports' folder seems to occur randomly. I
> say
>> *seem*, as I am sure that I am missing a step or something, as I confess
>> that I find the role assignment somewhat confusing. But I'm new, and I
>> am
>> sure I'll get used to it...
>>
>> In response to your kindly answer:
>> So, from my limited understanding, the 'My Reports' role is an
> 'item-level'
>> role; I can only seem to assign to this at the report level (ie an
>> 'item')
>> *not* to a user. But if the 'My Reports' folder is not being created, I
>> can't assign this 'tiem-level' role to it!
>>
>> In short: I am still stuck with some users having a 'My Reports' folder
> and
>> most users *not* having one!
>> Thanks,
>> Lance
>>
>>
>> > Lance,
>> >
>> > Have you checked to ensure all users are are included in the "My
> Reports"
>> > role - or in some custom role that includes the required permissions.
>> >
>> > Regards,
>> >
>> >
>> > --
>> > Rob Labbé, MCP, MCAD, MCSD, MCT
>> > Lead Architect/Trainer
>> > Fidelis
>> >
>> > Blog: http://spaces.msn.com/members/roblabbe
>> >
>> > "Lance" <lance@.[nospam]keayweb.com> wrote in message
>> > news:11849vnplj1n02@.corp.supernews.com...
>> > > Hi,
>> > > I am having some trouble getting the 'My Reports' folder to appear
>> > > for
>> all
>> > > users. The docs just say that as long as the user exists as a
>> > > windows
>> > > user
>> > > and the 'My Reports' option is ticked in 'Site Settings',
>> > > ReportServer
>> > > should just create a 'My Reports' folder the first time a user logs
> onto
>> > > the
>> > > ReportServer. But this is not working for all users. About half of
> the
>> > > users have the 'My Reports' folder created. So I need to know how to
>> > > create
>> > > them manually, or at least some workaround to get each user a 'My
>> Reports'
>> > > folder!
>> > >
>> > > I don't see any difference between the user accts (other than the
>> names).
>> > >
>> > > Thanks,
>> > > Lance
>> > >
>> > >
>> >
>> >
>>
>
>|||Hi,
Thanks for the reply but if the user can't see the folder, how can they
browse to it? As is explained further on in the text, some users seem to
get them created automatically, while others don't. So I need either a way
to create the folder manually (some SQL?) or an explanation of the user
differences as to why a folder would be created for one user but not for
another...
Thanks,
Lance
"Daniel Reib (MSFT)" <danreib@.online.microsoft.com> wrote in message
news:#cE3Af8VFHA.1200@.TK2MSFTNGP14.phx.gbl...
> The my reports folder will not be created until the user browses to that
> folder. (Yes, I know, a little confusing) The first time they browse to
it
> RS will create the folder and assign the My Reports permission to it.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Lance" <lance@.[nospam]keayweb.com> wrote in message
> news:1188kvr7cuimc7a@.corp.supernews.com...
> > Hi,
> > I was just nosing around the DB, and I noticed that all the users are in
> > the
> > 'users' table, but the user accounts don't appear in the
'PolicyUserRole'
> > table, and hence there are not any policies for them.
> >
> > I don't know if this helps any or just confuses...
> >
> > And there aren't any application events in the log on the server,
either.
> >
> >
> > "Lance" <lance@.[nospam]keayweb.com> wrote in message
> > news:11869vtmjhs8i08@.corp.supernews.com...
> >> Hi,
> >> Thanks for the reply, but I am a bit confused about it! Maybe if I
> > explain
> >> a bit more about the setup: The ReportServer is set up with no common
> >> reports. Each user can *only* view the reports in their own 'My
Reports'
> >> folder. As such each user *must* have a 'My Reports' folder!
> >> (obviously)
> >>
> >> Here is how the server is set up:
> >> * There are the standard 'Item-level' roles and an additional one,
> >> 'Viewer' - which is a limited acct, that just allows the user to 'view
> >> folders' and 'view reports'. None of the non-admin users can create
> >> reports.
> >> * The 'System Roles' are the standard 'System Administrator' and
'System
> >> User' - the 'System User' has the 'View report server properties' and
> > 'View
> >> shared schedules' tasks.
> >> * The 'Enable My Reports to support user-owned folders for publishing
and
> >> running personalized reports.' checkbox is checked in the 'Reporst
> >> Server'
> >> 'Site Settings'. The 'Choose the role to apply to each user's My
Reports
> >> folder' dropdown is 'Viewer'
> >>
> >> To set up for a new user:
> >> * Each new user is added to the 'Users' group on the server (windows
2000
> >> server).
> >> * The user logs in, and a 'My Reports' folder should be created.
> >>
> >> But mostly, a 'My Reports' folder is *not* created. Or perhaps just
not
> >> shown. I don't know how to check whether there is a 'My Reports'
folder
> > for
> >> the user - I am thinking that there is a value in the DB somewhere that
> >> tells me...
> >>
> >> I was experimenting with a dozen new users, and the docs say that as
soon
> > as
> >> a windows user logs in, a 'My Reports' folder should be created. I
tried
> >> both creating a 'System Role' for the user and *not* creating a system
> > role,
> >> but the creation of the 'My Reports' folder seems to occur randomly. I
> > say
> >> *seem*, as I am sure that I am missing a step or something, as I
confess
> >> that I find the role assignment somewhat confusing. But I'm new, and I
> >> am
> >> sure I'll get used to it...
> >>
> >>
> >> In response to your kindly answer:
> >> So, from my limited understanding, the 'My Reports' role is an
> > 'item-level'
> >> role; I can only seem to assign to this at the report level (ie an
> >> 'item')
> >> *not* to a user. But if the 'My Reports' folder is not being created,
I
> >> can't assign this 'tiem-level' role to it!
> >>
> >>
> >> In short: I am still stuck with some users having a 'My Reports' folder
> > and
> >> most users *not* having one!
> >> Thanks,
> >> Lance
> >>
> >>
> >>
> >>
> >>
> >> > Lance,
> >> >
> >> > Have you checked to ensure all users are are included in the "My
> > Reports"
> >> > role - or in some custom role that includes the required permissions.
> >> >
> >> > Regards,
> >> >
> >> >
> >> > --
> >> > Rob Labbé, MCP, MCAD, MCSD, MCT
> >> > Lead Architect/Trainer
> >> > Fidelis
> >> >
> >> > Blog: http://spaces.msn.com/members/roblabbe
> >> >
> >> > "Lance" <lance@.[nospam]keayweb.com> wrote in message
> >> > news:11849vnplj1n02@.corp.supernews.com...
> >> > > Hi,
> >> > > I am having some trouble getting the 'My Reports' folder to appear
> >> > > for
> >> all
> >> > > users. The docs just say that as long as the user exists as a
> >> > > windows
> >> > > user
> >> > > and the 'My Reports' option is ticked in 'Site Settings',
> >> > > ReportServer
> >> > > should just create a 'My Reports' folder the first time a user logs
> > onto
> >> > > the
> >> > > ReportServer. But this is not working for all users. About half
of
> > the
> >> > > users have the 'My Reports' folder created. So I need to know how
to
> >> > > create
> >> > > them manually, or at least some workaround to get each user a 'My
> >> Reports'
> >> > > folder!
> >> > >
> >> > > I don't see any difference between the user accts (other than the
> >> names).
> >> > >
> >> > > Thanks,
> >> > > Lance
> >> > >
> >> > >
> >> >
> >> >
> >>
> >>
> >
> >
> >
>|||When My Reports is enabled, ListChildren will always return a folder named
'My Reports', even if it has not been created for that user. That is why it
will show up in Report Manager. The first time a user calls any soap method
that uses the My Reports folder, RS will create the corresponding folder in
the user directory that the My Reports folder points to. If you have each
user just call ListChildren on '/My Reports' then each user will have the
'My Reports' folder created.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lance" <lance@.[nospam]keayweb.com> wrote in message
news:1189iffai01fh76@.corp.supernews.com...
> Hi,
> Thanks for the reply but if the user can't see the folder, how can they
> browse to it? As is explained further on in the text, some users seem to
> get them created automatically, while others don't. So I need either a
> way
> to create the folder manually (some SQL?) or an explanation of the user
> differences as to why a folder would be created for one user but not for
> another...
> Thanks,
> Lance
>
> "Daniel Reib (MSFT)" <danreib@.online.microsoft.com> wrote in message
> news:#cE3Af8VFHA.1200@.TK2MSFTNGP14.phx.gbl...
>> The my reports folder will not be created until the user browses to that
>> folder. (Yes, I know, a little confusing) The first time they browse to
> it
>> RS will create the folder and assign the My Reports permission to it.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>>
>> "Lance" <lance@.[nospam]keayweb.com> wrote in message
>> news:1188kvr7cuimc7a@.corp.supernews.com...
>> > Hi,
>> > I was just nosing around the DB, and I noticed that all the users are
>> > in
>> > the
>> > 'users' table, but the user accounts don't appear in the
> 'PolicyUserRole'
>> > table, and hence there are not any policies for them.
>> >
>> > I don't know if this helps any or just confuses...
>> >
>> > And there aren't any application events in the log on the server,
> either.
>> >
>> >
>> > "Lance" <lance@.[nospam]keayweb.com> wrote in message
>> > news:11869vtmjhs8i08@.corp.supernews.com...
>> >> Hi,
>> >> Thanks for the reply, but I am a bit confused about it! Maybe if I
>> > explain
>> >> a bit more about the setup: The ReportServer is set up with no common
>> >> reports. Each user can *only* view the reports in their own 'My
> Reports'
>> >> folder. As such each user *must* have a 'My Reports' folder!
>> >> (obviously)
>> >>
>> >> Here is how the server is set up:
>> >> * There are the standard 'Item-level' roles and an additional one,
>> >> 'Viewer' - which is a limited acct, that just allows the user to 'view
>> >> folders' and 'view reports'. None of the non-admin users can create
>> >> reports.
>> >> * The 'System Roles' are the standard 'System Administrator' and
> 'System
>> >> User' - the 'System User' has the 'View report server properties' and
>> > 'View
>> >> shared schedules' tasks.
>> >> * The 'Enable My Reports to support user-owned folders for publishing
> and
>> >> running personalized reports.' checkbox is checked in the 'Reporst
>> >> Server'
>> >> 'Site Settings'. The 'Choose the role to apply to each user's My
> Reports
>> >> folder' dropdown is 'Viewer'
>> >>
>> >> To set up for a new user:
>> >> * Each new user is added to the 'Users' group on the server (windows
> 2000
>> >> server).
>> >> * The user logs in, and a 'My Reports' folder should be created.
>> >>
>> >> But mostly, a 'My Reports' folder is *not* created. Or perhaps just
> not
>> >> shown. I don't know how to check whether there is a 'My Reports'
> folder
>> > for
>> >> the user - I am thinking that there is a value in the DB somewhere
>> >> that
>> >> tells me...
>> >>
>> >> I was experimenting with a dozen new users, and the docs say that as
> soon
>> > as
>> >> a windows user logs in, a 'My Reports' folder should be created. I
> tried
>> >> both creating a 'System Role' for the user and *not* creating a system
>> > role,
>> >> but the creation of the 'My Reports' folder seems to occur randomly.
>> >> I
>> > say
>> >> *seem*, as I am sure that I am missing a step or something, as I
> confess
>> >> that I find the role assignment somewhat confusing. But I'm new, and
>> >> I
>> >> am
>> >> sure I'll get used to it...
>> >>
>> >>
>> >> In response to your kindly answer:
>> >> So, from my limited understanding, the 'My Reports' role is an
>> > 'item-level'
>> >> role; I can only seem to assign to this at the report level (ie an
>> >> 'item')
>> >> *not* to a user. But if the 'My Reports' folder is not being created,
> I
>> >> can't assign this 'tiem-level' role to it!
>> >>
>> >>
>> >> In short: I am still stuck with some users having a 'My Reports'
>> >> folder
>> > and
>> >> most users *not* having one!
>> >> Thanks,
>> >> Lance
>> >>
>> >>
>> >>
>> >>
>> >>
>> >> > Lance,
>> >> >
>> >> > Have you checked to ensure all users are are included in the "My
>> > Reports"
>> >> > role - or in some custom role that includes the required
>> >> > permissions.
>> >> >
>> >> > Regards,
>> >> >
>> >> >
>> >> > --
>> >> > Rob Labbé, MCP, MCAD, MCSD, MCT
>> >> > Lead Architect/Trainer
>> >> > Fidelis
>> >> >
>> >> > Blog: http://spaces.msn.com/members/roblabbe
>> >> >
>> >> > "Lance" <lance@.[nospam]keayweb.com> wrote in message
>> >> > news:11849vnplj1n02@.corp.supernews.com...
>> >> > > Hi,
>> >> > > I am having some trouble getting the 'My Reports' folder to appear
>> >> > > for
>> >> all
>> >> > > users. The docs just say that as long as the user exists as a
>> >> > > windows
>> >> > > user
>> >> > > and the 'My Reports' option is ticked in 'Site Settings',
>> >> > > ReportServer
>> >> > > should just create a 'My Reports' folder the first time a user
>> >> > > logs
>> > onto
>> >> > > the
>> >> > > ReportServer. But this is not working for all users. About half
> of
>> > the
>> >> > > users have the 'My Reports' folder created. So I need to know how
> to
>> >> > > create
>> >> > > them manually, or at least some workaround to get each user a 'My
>> >> Reports'
>> >> > > folder!
>> >> > >
>> >> > > I don't see any difference between the user accts (other than the
>> >> names).
>> >> > >
>> >> > > Thanks,
>> >> > > Lance
>> >> > >
>> >> > >
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >
>> >
>>
>|||Hi,
Thanks for the reply, but I don't understand how to get each user to call
this method...
** a few minutes pass ...**
Ok, here is what I did to get it to work:
I logged in as a user that had a working 'My Reports' folder
I copied the URL
(http://webstats.co.uk/Reports/Pages/Folder.aspx?ItemPath=%2fMy+Reports&IsDe
tailsView=False)
I then logged in as a user that was having a problem
I then pasted the preceeding URL and loaded it.
Then using the admin user, put some reports into the 'My Reports' folder of
the problem user.
And, voila! Now they have their own 'My Reports' folder! Woo hoo!
Thanks for the help,
Lance
"Daniel Reib (MSFT)" <danreib@.online.microsoft.com> wrote in message
news:#t70OrDWFHA.3424@.TK2MSFTNGP09.phx.gbl...
> When My Reports is enabled, ListChildren will always return a folder named
> 'My Reports', even if it has not been created for that user. That is why
it
> will show up in Report Manager. The first time a user calls any soap
method
> that uses the My Reports folder, RS will create the corresponding folder
in
> the user directory that the My Reports folder points to. If you have each
> user just call ListChildren on '/My Reports' then each user will have the
> 'My Reports' folder created.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Lance" <lance@.[nospam]keayweb.com> wrote in message
> news:1189iffai01fh76@.corp.supernews.com...
> > Hi,
> > Thanks for the reply but if the user can't see the folder, how can they
> > browse to it? As is explained further on in the text, some users seem
to
> > get them created automatically, while others don't. So I need either a
> > way
> > to create the folder manually (some SQL?) or an explanation of the user
> > differences as to why a folder would be created for one user but not for
> > another...
> >
> > Thanks,
> > Lance
> >
> >
> > "Daniel Reib (MSFT)" <danreib@.online.microsoft.com> wrote in message
> > news:#cE3Af8VFHA.1200@.TK2MSFTNGP14.phx.gbl...
> >> The my reports folder will not be created until the user browses to
that
> >> folder. (Yes, I know, a little confusing) The first time they browse
to
> > it
> >> RS will create the folder and assign the My Reports permission to it.
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >>
> >>
> >> "Lance" <lance@.[nospam]keayweb.com> wrote in message
> >> news:1188kvr7cuimc7a@.corp.supernews.com...
> >> > Hi,
> >> > I was just nosing around the DB, and I noticed that all the users are
> >> > in
> >> > the
> >> > 'users' table, but the user accounts don't appear in the
> > 'PolicyUserRole'
> >> > table, and hence there are not any policies for them.
> >> >
> >> > I don't know if this helps any or just confuses...
> >> >
> >> > And there aren't any application events in the log on the server,
> > either.
> >> >
> >> >
> >> > "Lance" <lance@.[nospam]keayweb.com> wrote in message
> >> > news:11869vtmjhs8i08@.corp.supernews.com...
> >> >> Hi,
> >> >> Thanks for the reply, but I am a bit confused about it! Maybe if I
> >> > explain
> >> >> a bit more about the setup: The ReportServer is set up with no
common
> >> >> reports. Each user can *only* view the reports in their own 'My
> > Reports'
> >> >> folder. As such each user *must* have a 'My Reports' folder!
> >> >> (obviously)
> >> >>
> >> >> Here is how the server is set up:
> >> >> * There are the standard 'Item-level' roles and an additional one,
> >> >> 'Viewer' - which is a limited acct, that just allows the user to
'view
> >> >> folders' and 'view reports'. None of the non-admin users can create
> >> >> reports.
> >> >> * The 'System Roles' are the standard 'System Administrator' and
> > 'System
> >> >> User' - the 'System User' has the 'View report server properties'
and
> >> > 'View
> >> >> shared schedules' tasks.
> >> >> * The 'Enable My Reports to support user-owned folders for
publishing
> > and
> >> >> running personalized reports.' checkbox is checked in the 'Reporst
> >> >> Server'
> >> >> 'Site Settings'. The 'Choose the role to apply to each user's My
> > Reports
> >> >> folder' dropdown is 'Viewer'
> >> >>
> >> >> To set up for a new user:
> >> >> * Each new user is added to the 'Users' group on the server (windows
> > 2000
> >> >> server).
> >> >> * The user logs in, and a 'My Reports' folder should be created.
> >> >>
> >> >> But mostly, a 'My Reports' folder is *not* created. Or perhaps just
> > not
> >> >> shown. I don't know how to check whether there is a 'My Reports'
> > folder
> >> > for
> >> >> the user - I am thinking that there is a value in the DB somewhere
> >> >> that
> >> >> tells me...
> >> >>
> >> >> I was experimenting with a dozen new users, and the docs say that as
> > soon
> >> > as
> >> >> a windows user logs in, a 'My Reports' folder should be created. I
> > tried
> >> >> both creating a 'System Role' for the user and *not* creating a
system
> >> > role,
> >> >> but the creation of the 'My Reports' folder seems to occur randomly.
> >> >> I
> >> > say
> >> >> *seem*, as I am sure that I am missing a step or something, as I
> > confess
> >> >> that I find the role assignment somewhat confusing. But I'm new,
and
> >> >> I
> >> >> am
> >> >> sure I'll get used to it...
> >> >>
> >> >>
> >> >> In response to your kindly answer:
> >> >> So, from my limited understanding, the 'My Reports' role is an
> >> > 'item-level'
> >> >> role; I can only seem to assign to this at the report level (ie an
> >> >> 'item')
> >> >> *not* to a user. But if the 'My Reports' folder is not being
created,
> > I
> >> >> can't assign this 'tiem-level' role to it!
> >> >>
> >> >>
> >> >> In short: I am still stuck with some users having a 'My Reports'
> >> >> folder
> >> > and
> >> >> most users *not* having one!
> >> >> Thanks,
> >> >> Lance
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >> > Lance,
> >> >> >
> >> >> > Have you checked to ensure all users are are included in the "My
> >> > Reports"
> >> >> > role - or in some custom role that includes the required
> >> >> > permissions.
> >> >> >
> >> >> > Regards,
> >> >> >
> >> >> >
> >> >> > --
> >> >> > Rob Labbé, MCP, MCAD, MCSD, MCT
> >> >> > Lead Architect/Trainer
> >> >> > Fidelis
> >> >> >
> >> >> > Blog: http://spaces.msn.com/members/roblabbe
> >> >> >
> >> >> > "Lance" <lance@.[nospam]keayweb.com> wrote in message
> >> >> > news:11849vnplj1n02@.corp.supernews.com...
> >> >> > > Hi,
> >> >> > > I am having some trouble getting the 'My Reports' folder to
appear
> >> >> > > for
> >> >> all
> >> >> > > users. The docs just say that as long as the user exists as a
> >> >> > > windows
> >> >> > > user
> >> >> > > and the 'My Reports' option is ticked in 'Site Settings',
> >> >> > > ReportServer
> >> >> > > should just create a 'My Reports' folder the first time a user
> >> >> > > logs
> >> > onto
> >> >> > > the
> >> >> > > ReportServer. But this is not working for all users. About
half
> > of
> >> > the
> >> >> > > users have the 'My Reports' folder created. So I need to know
how
> > to
> >> >> > > create
> >> >> > > them manually, or at least some workaround to get each user a
'My
> >> >> Reports'
> >> >> > > folder!
> >> >> > >
> >> >> > > I don't see any difference between the user accts (other than
the
> >> >> names).
> >> >> > >
> >> >> > > Thanks,
> >> >> > > Lance
> >> >> > >
> >> >> > >
> >> >> >
> >> >> >
> >> >>
> >> >>
> >> >
> >> >
> >> >
> >>
> >>
> >
> >
>|||Yes, this is one way. You could also make any SOAP call to the My Reports
folder and this will cause their My Reports folder to be created.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lance" <lance@.[nospam]keayweb.com> wrote in message
news:118juil68hh0sc7@.corp.supernews.com...
> Hi,
> Thanks for the reply, but I don't understand how to get each user to call
> this method...
> ** a few minutes pass ...**
> Ok, here is what I did to get it to work:
> I logged in as a user that had a working 'My Reports' folder
> I copied the URL
> (http://webstats.co.uk/Reports/Pages/Folder.aspx?ItemPath=%2fMy+Reports&IsDe
> tailsView=False)
> I then logged in as a user that was having a problem
> I then pasted the preceeding URL and loaded it.
> Then using the admin user, put some reports into the 'My Reports' folder
> of
> the problem user.
> And, voila! Now they have their own 'My Reports' folder! Woo hoo!
> Thanks for the help,
> Lance
>
> "Daniel Reib (MSFT)" <danreib@.online.microsoft.com> wrote in message
> news:#t70OrDWFHA.3424@.TK2MSFTNGP09.phx.gbl...
>> When My Reports is enabled, ListChildren will always return a folder
>> named
>> 'My Reports', even if it has not been created for that user. That is why
> it
>> will show up in Report Manager. The first time a user calls any soap
> method
>> that uses the My Reports folder, RS will create the corresponding folder
> in
>> the user directory that the My Reports folder points to. If you have
>> each
>> user just call ListChildren on '/My Reports' then each user will have the
>> 'My Reports' folder created.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>>
>> "Lance" <lance@.[nospam]keayweb.com> wrote in message
>> news:1189iffai01fh76@.corp.supernews.com...
>> > Hi,
>> > Thanks for the reply but if the user can't see the folder, how can they
>> > browse to it? As is explained further on in the text, some users seem
> to
>> > get them created automatically, while others don't. So I need either a
>> > way
>> > to create the folder manually (some SQL?) or an explanation of the user
>> > differences as to why a folder would be created for one user but not
>> > for
>> > another...
>> >
>> > Thanks,
>> > Lance
>> >
>> >
>> > "Daniel Reib (MSFT)" <danreib@.online.microsoft.com> wrote in message
>> > news:#cE3Af8VFHA.1200@.TK2MSFTNGP14.phx.gbl...
>> >> The my reports folder will not be created until the user browses to
> that
>> >> folder. (Yes, I know, a little confusing) The first time they browse
> to
>> > it
>> >> RS will create the folder and assign the My Reports permission to it.
>> >>
>> >> --
>> >> -Daniel
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> > rights.
>> >>
>> >>
>> >> "Lance" <lance@.[nospam]keayweb.com> wrote in message
>> >> news:1188kvr7cuimc7a@.corp.supernews.com...
>> >> > Hi,
>> >> > I was just nosing around the DB, and I noticed that all the users
>> >> > are
>> >> > in
>> >> > the
>> >> > 'users' table, but the user accounts don't appear in the
>> > 'PolicyUserRole'
>> >> > table, and hence there are not any policies for them.
>> >> >
>> >> > I don't know if this helps any or just confuses...
>> >> >
>> >> > And there aren't any application events in the log on the server,
>> > either.
>> >> >
>> >> >
>> >> > "Lance" <lance@.[nospam]keayweb.com> wrote in message
>> >> > news:11869vtmjhs8i08@.corp.supernews.com...
>> >> >> Hi,
>> >> >> Thanks for the reply, but I am a bit confused about it! Maybe if I
>> >> > explain
>> >> >> a bit more about the setup: The ReportServer is set up with no
> common
>> >> >> reports. Each user can *only* view the reports in their own 'My
>> > Reports'
>> >> >> folder. As such each user *must* have a 'My Reports' folder!
>> >> >> (obviously)
>> >> >>
>> >> >> Here is how the server is set up:
>> >> >> * There are the standard 'Item-level' roles and an additional one,
>> >> >> 'Viewer' - which is a limited acct, that just allows the user to
> 'view
>> >> >> folders' and 'view reports'. None of the non-admin users can
>> >> >> create
>> >> >> reports.
>> >> >> * The 'System Roles' are the standard 'System Administrator' and
>> > 'System
>> >> >> User' - the 'System User' has the 'View report server properties'
> and
>> >> > 'View
>> >> >> shared schedules' tasks.
>> >> >> * The 'Enable My Reports to support user-owned folders for
> publishing
>> > and
>> >> >> running personalized reports.' checkbox is checked in the 'Reporst
>> >> >> Server'
>> >> >> 'Site Settings'. The 'Choose the role to apply to each user's My
>> > Reports
>> >> >> folder' dropdown is 'Viewer'
>> >> >>
>> >> >> To set up for a new user:
>> >> >> * Each new user is added to the 'Users' group on the server
>> >> >> (windows
>> > 2000
>> >> >> server).
>> >> >> * The user logs in, and a 'My Reports' folder should be created.
>> >> >>
>> >> >> But mostly, a 'My Reports' folder is *not* created. Or perhaps
>> >> >> just
>> > not
>> >> >> shown. I don't know how to check whether there is a 'My Reports'
>> > folder
>> >> > for
>> >> >> the user - I am thinking that there is a value in the DB somewhere
>> >> >> that
>> >> >> tells me...
>> >> >>
>> >> >> I was experimenting with a dozen new users, and the docs say that
>> >> >> as
>> > soon
>> >> > as
>> >> >> a windows user logs in, a 'My Reports' folder should be created. I
>> > tried
>> >> >> both creating a 'System Role' for the user and *not* creating a
> system
>> >> > role,
>> >> >> but the creation of the 'My Reports' folder seems to occur
>> >> >> randomly.
>> >> >> I
>> >> > say
>> >> >> *seem*, as I am sure that I am missing a step or something, as I
>> > confess
>> >> >> that I find the role assignment somewhat confusing. But I'm new,
> and
>> >> >> I
>> >> >> am
>> >> >> sure I'll get used to it...
>> >> >>
>> >> >>
>> >> >> In response to your kindly answer:
>> >> >> So, from my limited understanding, the 'My Reports' role is an
>> >> > 'item-level'
>> >> >> role; I can only seem to assign to this at the report level (ie an
>> >> >> 'item')
>> >> >> *not* to a user. But if the 'My Reports' folder is not being
> created,
>> > I
>> >> >> can't assign this 'tiem-level' role to it!
>> >> >>
>> >> >>
>> >> >> In short: I am still stuck with some users having a 'My Reports'
>> >> >> folder
>> >> > and
>> >> >> most users *not* having one!
>> >> >> Thanks,
>> >> >> Lance
>> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >> >> > Lance,
>> >> >> >
>> >> >> > Have you checked to ensure all users are are included in the "My
>> >> > Reports"
>> >> >> > role - or in some custom role that includes the required
>> >> >> > permissions.
>> >> >> >
>> >> >> > Regards,
>> >> >> >
>> >> >> >
>> >> >> > --
>> >> >> > Rob Labbé, MCP, MCAD, MCSD, MCT
>> >> >> > Lead Architect/Trainer
>> >> >> > Fidelis
>> >> >> >
>> >> >> > Blog: http://spaces.msn.com/members/roblabbe
>> >> >> >
>> >> >> > "Lance" <lance@.[nospam]keayweb.com> wrote in message
>> >> >> > news:11849vnplj1n02@.corp.supernews.com...
>> >> >> > > Hi,
>> >> >> > > I am having some trouble getting the 'My Reports' folder to
> appear
>> >> >> > > for
>> >> >> all
>> >> >> > > users. The docs just say that as long as the user exists as a
>> >> >> > > windows
>> >> >> > > user
>> >> >> > > and the 'My Reports' option is ticked in 'Site Settings',
>> >> >> > > ReportServer
>> >> >> > > should just create a 'My Reports' folder the first time a user
>> >> >> > > logs
>> >> > onto
>> >> >> > > the
>> >> >> > > ReportServer. But this is not working for all users. About
> half
>> > of
>> >> > the
>> >> >> > > users have the 'My Reports' folder created. So I need to know
> how
>> > to
>> >> >> > > create
>> >> >> > > them manually, or at least some workaround to get each user a
> 'My
>> >> >> Reports'
>> >> >> > > folder!
>> >> >> > >
>> >> >> > > I don't see any difference between the user accts (other than
> the
>> >> >> names).
>> >> >> > >
>> >> >> > > Thanks,
>> >> >> > > Lance
>> >> >> > >
>> >> >> > >
>> >> >> >
>> >> >> >
>> >> >>
>> >> >>
>> >> >
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >
>>
>

My reports folder

How to rename the "My reports" folder. My browser language is in french and
user are speaking french. The report manager only show "My reports" but I
want to see "Mes rapports"
I know that is the "listChildren" method that add My report. Is there a way
to change this?We simply made an .aspx (or it could even be an html) page as the
starting-page for the users with an url-link to their "my reports" content
"Francis Côté" wrote:
> How to rename the "My reports" folder. My browser language is in french and
> user are speaking french. The report manager only show "My reports" but I
> want to see "Mes rapports"
> I know that is the "listChildren" method that add My report. Is there a way
> to change this?
>
>|||Interestingly, this page seems to indicate either that you cannot localize
this, or that the localization should be automatic if the OS hosting the
report server is localized to French:
http://msdn2.microsoft.com/en-us/library/aa972255(SQL.80).aspx -- while this
page may be outdated, there is a similar set of paragraphs in BOL for 2005.
I quote:
A few items are always articulated in the language that corresponds to the
operating system language setting, regardless of client application locale.
The following table describes these items.
Predefined roles
Reporting Services installs with several predefined roles (Browser,
Publisher, Content Manager, My Reports, System Administrator, and System
User) that are articulated in the language resource of the operating system
that runs the report server.
Users folder, and My Reports folder
These folder names are reserved when the My Reports feature is enabled. This
feature requires a fixed folder structure. Because the report server manages
reserved names, reserved folder names are articulated in the language
resource of the operating system that runs the report server.
<<
So... what is the regional setting of the OS, in your case?
>L<
"Francis Côté" <francis.cote@.uqat.ca> wrote in message
news:u2seBrchHHA.4300@.TK2MSFTNGP05.phx.gbl...
> How to rename the "My reports" folder. My browser language is in french
> and user are speaking french. The report manager only show "My reports"
> but I want to see "Mes rapports"
> I know that is the "listChildren" method that add My report. Is there a
> way to change this?
>

My Reports folder

Hi everyone,
I reinsralled my reporting services (on sql 2000) and i have a problem:
i added users and if one user create folder everyone else can see his
folder. also the my reports folder is not created auto like it was.
cant i create a folder that only i can see?
thanksThe folder that all of the My Reports are in is Users... If everyone can
see this, then either everyone is an administrator, or you need to reduce the
permissions on the Users folder.
To have the My Reports folders created automatically you must
Check the Enable My Reports box from the SIte Settings menu item on the top
left of Report Manager. There you can also setup the permissions that
individuals have on their My Reports folder.
Hope this helps
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Ruby Nadler" wrote:
> Hi everyone,
> I reinsralled my reporting services (on sql 2000) and i have a problem:
> i added users and if one user create folder everyone else can see his
> folder. also the my reports folder is not created auto like it was.
> cant i create a folder that only i can see?
> thanks
>

my query and user defined fuction problem

I have a table which has six fields ID, dateDue, dateReceived, dueday. month, ContactFYE
my query looks like

select ID, DateDue, dateReceived, dueday, month, ContactFYE
from Report
where (dbo.Report.DateDue BETWEEN dbo.udfDisplayTime(dueday, month, ContactFYE) AND DateDue )

user defined function

CREATE FUNCTION dbo.udfDisplayTime ( @.dueday int, @.month int, @.ContactFYE smalldatetime)
RETURNS smalldatetime AS
BEGIN
DECLARE @.ReturnString AS smalldatetime
Declare @.dueday1 as int
if (@.month =1)
begin
set @.dueday1 = @.dueday -7
end
else if (@.month =2)
begin
set @.dueday1 = @.dueday -14
end
else if (@.month =3)
begin
set @.dueday1 = @.dueday -60
end

select @.ReturnString = DATEADD ( dd, @.dueday1, @.ContactFYE)
Return @.ReturnString

END

I got a incorrect result when using this query and user defined function.
the result that I got was out of between displaytime and datdue.

any idea for this , Thanks.I think we are going to need to see some data and desired results in order to be able to help you. The purpose of the function and your different data columns is not obvious (to me at least).|||

The query you have is the same as:

select ID, DateDue, dateReceived, dueday, month, ContactFYE
from Report

the where condition you have specified will always be true, because DateDue is ALWAYS between (anything) and DateDue. It makes no difference what the udf returns.