ActiveX to warm up Report Server ?

Because the IIS threads are recycled at night, the first user that calls up Report Manager in the morning has to wait 30 seconds before the page loads, as IIS is creating a thread.

I'd like to set up a job in SQL Agent that will navigate to http://localhost/reports/ every morning before users come in to work, so they won't have to wait.

I think a SAL Agent job of type ActiveX Script would be suitable for this, so I need to write the code to navigate to the reports page in VBScript.

Anyone knows how to navigate to a page in VBScript ?

tia.

I meant SQL Agent job, of course, not SAL.|||

Schedule a job with a simple plain empty record and schedule this before the needed time.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

I know how to schedule a job, but what is a "plain empty record" ? I have lots of RS subscriptions scheduled already and they don't affect the way the first user has to wait 30 secs for Report Manager to load up.

What I wanted to know was how to navigate to the report manager home page in VBScript. I couldn't find any example anywhere.

|||

This isnt a solution that you are looking for but maybe you dont need to reschedule the IIS worker process every night? My reportserver serves up about 800 reports per week and its hosted on a server which also hosts 9 other web applications.

I have set it in IIS that the worker process for report server does not recycle at all, and so far it hasnt recycled for 6 weeks. I occasionally manually recycle it and then go straight to the report server home page to start up the server quickly again.

Depends on your environment but maybe you dont need to recycle it every night.

sql

ActiveDirectory Group Security

Hi all

What i want to do - Execute a Stored Procedure when a user log on that is in aActiveDirectory Group.

I want to create a storedprocedure that will be executed when a windows user log on that is part of a specific ADGroup.

I was able to create the ADGroup and add it to logins. I was able to create the procedure with the ADGroup as owner.

The problem is when the user log on, he is not seen as part of the group that has rights on the DB.

Please help

From your description, I am assuming that you are having trouble to access a database (different than master) where your SP resides, correct?

If this is the case, probably what happened is that the AD group in that DB doesn’t have access to it. This is typically the case when users are created implicitly. You can try the following:

USE [<db_name>]

go

GRANT CONNECT TO [<ADGroup_name>]

go

BTW. If you only want the AD group to be able to execute the SP, you don’t need to make them owners, granting EXECUTE on the SP should be sufficient.

I hope this information helps, let us know if this solved your problem.

- Raul Garcia

SDE/T

SQL Server ENgine

Active X sql error

Sql Windows/32 ActiveX error
ActiveX object creation failed-please check that your
installation is valid.
How can i fix this error? The user can execute the
command on other machines except his own. Is there
something Im missing?
And you get this error when? What command is being executed
from what application/tool? The general message can happen
for many reasons. Without any more information, it's
difficult to help you troubleshoot this. Generally you see
it when you try to instantiate an object and it fails due to
a dll not being properly registered or present on the
machine.
-Sue
On Tue, 8 Jun 2004 10:35:42 -0700, "Matt"
<bonefish8@.hotmail.com> wrote:

>Sql Windows/32 ActiveX error
>ActiveX object creation failed-please check that your
>installation is valid.
>
>How can i fix this error? The user can execute the
>command on other machines except his own. Is there
>something Im missing?

active directory with sqll 2005

Hello,
I have an active directoy controller with microsoft SQL 2005 installed
in the same windows 2003 machine.
is there a way to grant a domain user to start/stop sql server without
domain admin privilege?
Many thanks for the help in advance.The local admin on the server would do the trick. Thats what I have on all
SQL servers I manage.
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"one2001boy@.yahoo.com" wrote:

> Hello,
> I have an active directoy controller with microsoft SQL 2005 installed
> in the same windows 2003 machine.
> is there a way to grant a domain user to start/stop sql server without
> domain admin privilege?
> Many thanks for the help in advance.
>|||Mohit K. Gupta wrote:
> The local admin on the server would do the trick. Thats what I have on al
l
> SQL servers I manage.
>
For the domain controller on Win 2003, there is no local admin. Your SQL
server must not be on domain controller.
thanks for your help anyway.|||Yeap. Sorry my bad, I wouldn't want SQL Server to be on PDC. The network
guys would make my life a living hell.
Not server guy, but if the service is set to start under set of credentials.
Can those credentials start/stop the service?
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"one2001boy@.yahoo.com" wrote:

> Mohit K. Gupta wrote:
> For the domain controller on Win 2003, there is no local admin. Your SQL
> server must not be on domain controller.
> thanks for your help anyway.
>

Active Directory User's Member Groups from SQL Server 2000

I can create a Linked Server for ADSI sucessfully but cannot retrieve group
membership for an indivdual user.
I've seen some examples of syntax but can't get it to work.
Does anyone have an example of some code I could use
LindaOLE DB provider for Directory Services does not support multi-valued
attributes such as: members and memberOf. sorry...
"Linda Lou" wrote:

> I can create a Linked Server for ADSI sucessfully but cannot retrieve grou
p
> membership for an indivdual user.
> I've seen some examples of syntax but can't get it to work.
> Does anyone have an example of some code I could use
> Linda

Active Directory User Data

Hi. I'm new to SQL Reporting Services and totally self taught so far.
I am trying to find out if there is a way from within a report to find
out the Active Directory user name or possibly other data from AD about
the user running the report from the web. I want to be able to look at
the user and rstrict the data they are allowed to see based on AD
characteristics. This is for a school district and I want teachers to
be able to go to the web page, run a report, but return only data fro
their students. Thanks in advance for any help.You get the AD username by from the global constant User!UserID. It returns
the username in the form of domain\username.
If you store the AD username of each teacher and a reference to what
students belong to them, you can use this for a query to only return the
data from their students.
I've never tried to query data in the Active Directory through Reporting
Services, but if you look at SQL tutorials, you might find something on how
to query AD data from the usual SQL server tools.
You need to check for information on ADSI
Here are a few links. I haven't tried them myself, but it might give you a
start
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q299410
http://www.databasejournal.com/features/mssql/article.php/2176561
Kaisa M. Lindahl Lervik
<jwilloz@.paplv.esu3.org> wrote in message
news:1161810778.724236.40460@.k70g2000cwa.googlegroups.com...
> Hi. I'm new to SQL Reporting Services and totally self taught so far.
> I am trying to find out if there is a way from within a report to find
> out the Active Directory user name or possibly other data from AD about
> the user running the report from the web. I want to be able to look at
> the user and rstrict the data they are allowed to see based on AD
> characteristics. This is for a school district and I want teachers to
> be able to go to the web page, run a report, but return only data fro
> their students. Thanks in advance for any help.
>

Active Directory and SSRS

Is it possible to create a report in SSRS that queries Active Directory data such as user's phone extension, email address etc

What would be a good way to do this?

Thanks,

Nisha

I haven't done this but probably the easiest way will be to use the OLE DB Provider for Microsoft Directory Services. When setting up the data source, choose the OLE DB option and then click the Edit button which will bring you to all OLE DB providers installed.|||

Thank You so much for pointing me in the right direction. I was able to do what I needed.

NB

Active directory and RServices

Is it possible to access Active Directory and read user data who run the report.
Thx.Shouldn't need to. There is a global User!userid that you can use in your
report.
Use the expression builder and you will see it listed (plus other
potentially useful globals)
Bruce L-C
<AG>; "NLB d.d." <AGNLBdd@.discussions.microsoft.com> wrote in message
news:1DCB51E5-8D07-407C-A40A-B9A8347FE7FE@.microsoft.com...
> Is it possible to access Active Directory and read user data who run the
report.
> Thx.|||Yes i use userid, but i need to know user name and other useful information from AD. Maybe you use extrenal class to read needed data from AD.
Aleš
"Bruce Loehle-Conger" wrote:
> Shouldn't need to. There is a global User!userid that you can use in your
> report.
> Use the expression builder and you will see it listed (plus other
> potentially useful globals)
> Bruce L-C
> <AG>; "NLB d.d." <AGNLBdd@.discussions.microsoft.com> wrote in message
> news:1DCB51E5-8D07-407C-A40A-B9A8347FE7FE@.microsoft.com...
> > Is it possible to access Active Directory and read user data who run the
> report.
> >
> > Thx.
>
>|||You can create a dataset using OLE-DB provider for Microsoft Directory
Services (built into RS 2000) and query the AD as follows:
select name, mail from 'LDAP://DC=US,DC=corp,DC=xyz,DC=com' where
objectCategory='user' and department = 'Data Warehousing'
Refer to
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_qd_12_94fn.asp
and
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adsi/adsi/sql_dialect.asp
for details on LDAP SQL dialect.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
<AG>; "NLB d.d." <AGNLBdd@.discussions.microsoft.com> wrote in message
news:63F05F64-2295-4EB6-B73A-9ACA97C68221@.microsoft.com...
> Yes i use userid, but i need to know user name and other useful
information from AD. Maybe you use extrenal class to read needed data from
AD.
> Aleš
> "Bruce Loehle-Conger" wrote:
> > Shouldn't need to. There is a global User!userid that you can use in
your
> > report.
> >
> > Use the expression builder and you will see it listed (plus other
> > potentially useful globals)
> >
> > Bruce L-C
> >
> > <AG>; "NLB d.d." <AGNLBdd@.discussions.microsoft.com> wrote in message
> > news:1DCB51E5-8D07-407C-A40A-B9A8347FE7FE@.microsoft.com...
> > > Is it possible to access Active Directory and read user data who run
the
> > report.
> > >
> > > Thx.
> >
> >
> >

Active directory + list users

I neet save user login form active direcotry to databases. How I can make that?

If you're using Trusted Security to connect to the database (In other words, every single user is authenticated to the database with their windows logon), you could write code like the following at the database level:

INSERT Users
(Username)
(SUSER_SNAME())

SUSER_SNAME, gives you the current authenticated user to the database.

If you're connecting to the database using a Sql Server Login, but are using windows authentication in your .net application you could write the following code:

Dim _sql as string
_sql = "INSERT Users (USERNAME) VALUES ('" + My.User.Name "')"

And just execute this code against the database.

Hope this helps,

Active Directory <-> SQL Integration ?

We have our user store in Active Directory. I am designing the data model
for some new applications, and a number of tables require fields such as
ApprovedBy, CreatedBy, etc. I want to be able to link these values back to
the Active Directory user store. I know I can just shove the AD user name i
n
there, but I want more. I want to have referential integrity between the tw
o
systems. Is this currently possible?
I'm going to assume it isn't possible, and if not is there a SQL Server wish
list/feedback email I can use to suggest this for a future product release?
I think this would be an extremely useful feature. (or if you could use SQL
Server as your Active Directory data store, that should solve the problem
also I believe, but I don't know if that is possible...).Hi
Check out the ADSI OLEDB provider.
http://msdn.microsoft.com/library/d...r />
_94fn.asp
If you can use check constraint that calls a function to implement RI, but
this sort of thing will probably prove prohibitably slow.
John
"Optikal" wrote:

> We have our user store in Active Directory. I am designing the data model
> for some new applications, and a number of tables require fields such as
> ApprovedBy, CreatedBy, etc. I want to be able to link these values back t
o
> the Active Directory user store. I know I can just shove the AD user name
in
> there, but I want more. I want to have referential integrity between the
two
> systems. Is this currently possible?
> I'm going to assume it isn't possible, and if not is there a SQL Server wi
sh
> list/feedback email I can use to suggest this for a future product release
?
> I think this would be an extremely useful feature. (or if you could use S
QL
> Server as your Active Directory data store, that should solve the problem
> also I believe, but I don't know if that is possible...).

Actiuve/Active

Hi,
I have to setup a Active/Active cluster and I need to know if there has to
be made any change in the applications that the user has? For example, direct
the app to the other virtual server, etc...
Thanks
What do you mean by "Active-Active"? It sounds like you may be
misunderstanding what the terms mean. "Active-Active" describes an onder
clustering technology that went away after SQL 7.0. The current correct
term is "multi-instance" and acts just like having multiple instances of SQL
Server on a single, non-clustered host.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Fred" <Fred@.discussions.microsoft.com> wrote in message
news:A2B00583-DDC2-41A1-94D9-394F2E985C6B@.microsoft.com...
> Hi,
> I have to setup a Active/Active cluster and I need to know if there has to
> be made any change in the applications that the user has? For example,
> direct
> the app to the other virtual server, etc...
>
> Thanks
|||Sorry,
what I meant was, we're going in a process of installing a cluster using
something similar to what then was called "Active/Active" in a sense that one
server serves a set of databases a acts as a failover through a instance what
will be activated in case of a failure in the other server. Something like:
Server1: Actives databases: A, B, C
Inactives databases: D, E, F
Server2: Actives databases: D, E, F
Inactives databases: A, B, C
In case of a failure in Server1, the Server2, serves not only databases D,
E, F, but also A, B, C. I think that's called in the old terminology
"Active/Active". My major point is, do I have to make some sort of change in
my applications to "redirect" them to the "new server" or the cluster can
that care of that automatically?
Is there any source that really clarifies clustering technology in terms of
applications made by our programmers?
Thanks for your observations, point taken.
"Geoff N. Hiten" wrote:

> What do you mean by "Active-Active"? It sounds like you may be
> misunderstanding what the terms mean. "Active-Active" describes an onder
> clustering technology that went away after SQL 7.0. The current correct
> term is "multi-instance" and acts just like having multiple instances of SQL
> Server on a single, non-clustered host.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "Fred" <Fred@.discussions.microsoft.com> wrote in message
> news:A2B00583-DDC2-41A1-94D9-394F2E985C6B@.microsoft.com...
>
>
|||Ok, you do have an almost correct picture of SQL Clustering.
It works more like this:
Instance 1: Databases A, B, C
Instance 2: Databases D, E, F
Host machines: Node 1, Node 2
Normal operation has Instance 1 on Node 1 and Instance 2 on Node 2. If node
2 fails, Node 1 grabs the resources for Instance 2 and starts up Instance 2
on Node 1. The outside world still sees Instance 2 with the exact same
names, security, and IP address(es) as before. The two( or more depending
on your cluster configuration) instances look like completely different and
independent servers to the outside world. Reconnection is necessary since
the SQL service stopped and restarted, but no client redirection is required
since the clients connect to a virtual IP address.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Fred" <Fred@.discussions.microsoft.com> wrote in message
news:C20D7184-9C4B-4D63-B3F8-AA37951F3CC0@.microsoft.com...[vbcol=seagreen]
> Sorry,
> what I meant was, we're going in a process of installing a cluster using
> something similar to what then was called "Active/Active" in a sense that
> one
> server serves a set of databases a acts as a failover through a instance
> what
> will be activated in case of a failure in the other server. Something
> like:
> Server1: Actives databases: A, B, C
> Inactives databases: D, E, F
> Server2: Actives databases: D, E, F
> Inactives databases: A, B, C
> In case of a failure in Server1, the Server2, serves not only databases D,
> E, F, but also A, B, C. I think that's called in the old terminology
> "Active/Active". My major point is, do I have to make some sort of change
> in
> my applications to "redirect" them to the "new server" or the cluster can
> that care of that automatically?
> Is there any source that really clarifies clustering technology in terms
> of
> applications made by our programmers?
> Thanks for your observations, point taken.
>
> "Geoff N. Hiten" wrote:
|||Thanks, this post helped a lot to clarify these points to me.
"Geoff N. Hiten" wrote:

> Ok, you do have an almost correct picture of SQL Clustering.
> It works more like this:
> Instance 1: Databases A, B, C
> Instance 2: Databases D, E, F
> Host machines: Node 1, Node 2
> Normal operation has Instance 1 on Node 1 and Instance 2 on Node 2. If node
> 2 fails, Node 1 grabs the resources for Instance 2 and starts up Instance 2
> on Node 1. The outside world still sees Instance 2 with the exact same
> names, security, and IP address(es) as before. The two( or more depending
> on your cluster configuration) instances look like completely different and
> independent servers to the outside world. Reconnection is necessary since
> the SQL service stopped and restarted, but no client redirection is required
> since the clients connect to a virtual IP address.
>
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "Fred" <Fred@.discussions.microsoft.com> wrote in message
> news:C20D7184-9C4B-4D63-B3F8-AA37951F3CC0@.microsoft.com...
>
>

Actiohailkve User Connections

Hi:
How can I quickly find out active user connections to the database and the
Server?
ThanksExactly what is it that you want to find out about them?
Andrew J. Kelly SQL MVP
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:3C36C435-2228-4C82-9B37-5D60E2464718@.microsoft.com...
> Hi:
> How can I quickly find out active user connections to the database and the
> Server?
> Thanks

Actiohailkve User Connections

Hi:
How can I quickly find out active user connections to the database and the
Server?
ThanksExactly what is it that you want to find out about them?
--
Andrew J. Kelly SQL MVP
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:3C36C435-2228-4C82-9B37-5D60E2464718@.microsoft.com...
> Hi:
> How can I quickly find out active user connections to the database and the
> Server?
> Thanks

Actiohailkve User Connections

Hi:
How can I quickly find out active user connections to the database and the
Server?
Thanks
Exactly what is it that you want to find out about them?
Andrew J. Kelly SQL MVP
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:3C36C435-2228-4C82-9B37-5D60E2464718@.microsoft.com...
> Hi:
> How can I quickly find out active user connections to the database and the
> Server?
> Thanks

Acquire NTLM User ID within Trigger or Sproc?

I need to acquire the userid that the person signed on at their Windows
workstation. I need to do it from within a Trigger.
How?If you are using Windows Authentication then see function suser_sname in BOL
.
AMB
"Carl Perkins" wrote:

> I need to acquire the userid that the person signed on at their Windows
> workstation. I need to do it from within a Trigger.
> How?|||That does not return the login user that logged into NT - it returns the use
r
that is setup to connect to sql server from the connection string.
When I execute it in Query Analyzer it certainly does work but I need it
from within a trigger and that is a bit different.
Thanks,
Carl
"Alejandro Mesa" wrote:
> If you are using Windows Authentication then see function suser_sname in B
OL.
>
> AMB
> "Carl Perkins" wrote:
>|||If the setup runs under the loggedon account thatll work for you like
Alejandro described. if you are using SQL Server Auth. you have to go for
tha:
There is a bad hack for that if you have control over the connection string:
912257c40e693afe" target="_blank">http://groups.google.de/group/micro...12257c40e693afe
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Carl Perkins" <CarlPerkins@.discussions.microsoft.com> schrieb im
Newsbeitrag news:A899FA96-996A-44D0-ADB5-1AD165506093@.microsoft.com...
> That does not return the login user that logged into NT - it returns the
> user
> that is setup to connect to sql server from the connection string.
> When I execute it in Query Analyzer it certainly does work but I need it
> from within a trigger and that is a bit different.
> Thanks,
> Carl
> "Alejandro Mesa" wrote:
>|||suser_sname(), but that only works of course if the user logs in to SQL
Server using Windows Authentication, not if you use SQL Server
Authentication.
Jacco Schalkwijk
SQL Server MVP
"Carl Perkins" <CarlPerkins@.discussions.microsoft.com> wrote in message
news:ED6D28FE-6F36-401A-8DF6-12480EB62F51@.microsoft.com...
>I need to acquire the userid that the person signed on at their Windows
> workstation. I need to do it from within a Trigger.
> How?

Acess on Production Server

Hi,

Presently our Organisation is in process of Implementing SOX.

Under Compliance all the User have to be removed from the Production Server.

1.My Question is Do a DBA Should have Admin Privilages on the Production Server.

If yes then what are the Actitvies that a DBA has to perform only if DBA have admin privilages.

Regards

Sufian

I don't know the SOX 'rules' about this but I would not want to be responsible for a production machine without having admin privileges on the server.

But that is a personal opinion, the Books Online contain information about which privileges are required for which actions. I will let you be the judge of whether you need sysadmin rights or not ;-)

WesleyB

Visit my SQL Server weblog @. http://dis4ea.blogspot.com

|||

These sources will better prepare you to make the appropriate decisions about security accounts and the local server/SQL Server/ and/or domain accounts.

Configuration -Service Accounts, SQL Server 2005 - Setting Up Windows Service Accounts
http://msdn2.microsoft.com/en-us/library/ms143691.aspx
http://msdn2.microsoft.com/en-us/library/ms143504.aspx

Configuration -Service Accounts, SQL Server or SQL Server Agent service account
http://support.microsoft.com/kb/283811/en-us
http://msdn2.microsoft.com/en-us/library/ms143691.aspx

Configuration -Service Accounts,Selecting an Account for the SQL Server Agent Service
http://msdn2.microsoft.com/en-us/library/ms191543.aspx
http://support.microsoft.com/kb/907557

AceCollection

I have made some decent progress on switching RS to use form based
authentication. Currently the application validates the user against
are Oracle database, then accepts the cookie created by the page and
then converts the cookie into a principal object which is used for the
authorization portion of the process. I have this working as long as
the user is an Admin, but I have a problem if they are not. When the
subroutine goes into the authorization portion of code for a non-admin
user, it calls an ACL. By looking at the code as it runs it would seem
that the ACL is empty, how can I modify this to add policies for users
or groups? Is the ACL an actual object that I can open an edit, sorry
I am new to most of all of this.
ThanksYou need to modify the CheckAccess functions in Authrorization to loop
through the username and all the groupnames the user is part of. That way,
it will apply role-based security. Something like this:
ArrayList userGroups = GetUserGroups(userName);
AceCollection acl = DeserializeAcl(secDesc);
foreach(AceStruct ace in acl)
{
foreach(string principalName in userGroups)
{
// First check to see if the user or group has an access control
// entry for the item
if (0 == String.Compare(principalName, ace.PrincipalName, true,
CultureInfo.CurrentCulture))
{
etc.
etc.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Will" <wlansing@.rlcarriers.com> wrote in message
news:1110232152.683072.256120@.g14g2000cwa.googlegroups.com...
>I have made some decent progress on switching RS to use form based
> authentication. Currently the application validates the user against
> are Oracle database, then accepts the cookie created by the page and
> then converts the cookie into a principal object which is used for the
> authorization portion of the process. I have this working as long as
> the user is an Admin, but I have a problem if they are not. When the
> subroutine goes into the authorization portion of code for a non-admin
> user, it calls an ACL. By looking at the code as it runs it would seem
> that the ACL is empty, how can I modify this to add policies for users
> or groups? Is the ACL an actual object that I can open an edit, sorry
> I am new to most of all of this.
> Thanks
>|||Jeff, thanks for the response. I think that I still maybe a step
behind you though, can you tell me where the information for this call
comes from. AceCollection acl = DeserializeAcl(secDesc);
When I debug though this code, the acl is always empty and therefore
never gets into the foreach loop. Am I doing something wrong? Thanks
again for your response.

Accumulated values in analysis services

Hello,

I'm making a report where I have a matrix showing the weeks of a month in the columns and certain data. The user selects a month and I use it as a parameter to show all the calculations from a cube. I already have all the data needed for the matrix, the problem is that I need an accumulated value in the last row that sums the first week's accumulated value and the second week's value and so on (the month can have 4 or 5 weeks). The first week's accumulated value is the data itself since there is no previous value.

week1

week2

week3

....

data

x1

x2

x3

...

accumulated value

x1

x1+x2

x1+x2+x3

...

I don't know if I can do this from the cube using a mesure or something(i think it would be easier to have all the calculations in the cube),or if it has to be done from the matrix in the report.

I would appreciate all help you can give me. Thanks in advance.

Assuming that you have a hierarchy with something like Year - Month - Week, you should be able to create a calculated "MonthToDate" figure using the PeriodsToDate function.

eg.

CREATE MEMBER Measures.MonthToDate AS SUM(PeriodsToDate([Time].[Year-Month-Week].[Month],[Time].[Year-Month-Week].CurrentMember),Measures.[data])

|||

Hello Darren!,

Thanks for your reply!, that is what I wanted to do :)

Accounts - Weird Behavior

When I double click on a SQL Server user (SQL Server
Authentication user) to give permission to another
database, it is asking me to 'confirm new password' after
clicking on OK. I am not changing the password, I am just
giving more permissions on a database or on another
database. Does any one knows anything about this ?
It is Windows 2000 SQL Server 2000 SP3 box.
Thanks.
Check the following article:
FIX: You are prompted for password confirmation after you
change a standard SQL Server login
http://support.microsoft.com/?kbid=826161
-Sue
On Tue, 12 Apr 2005 09:29:18 -0700, "Todd"
<anonymous@.discussions.microsoft.com> wrote:

>When I double click on a SQL Server user (SQL Server
>Authentication user) to give permission to another
>database, it is asking me to 'confirm new password' after
>clicking on OK. I am not changing the password, I am just
>giving more permissions on a database or on another
>database. Does any one knows anything about this ?
>It is Windows 2000 SQL Server 2000 SP3 box.
>Thanks.
|||Todd
The following KB article may help you out:
http://support.microsoft.com/default...b;en-us;826161
- Peter Ward
WARDY IT Solutions
"Todd" wrote:

> When I double click on a SQL Server user (SQL Server
> Authentication user) to give permission to another
> database, it is asking me to 'confirm new password' after
> clicking on OK. I am not changing the password, I am just
> giving more permissions on a database or on another
> database. Does any one knows anything about this ?
> It is Windows 2000 SQL Server 2000 SP3 box.
> Thanks.
>

Accounts - Weird Behavior

When I double click on a SQL Server user (SQL Server
Authentication user) to give permission to another
database, it is asking me to 'confirm new password' after
clicking on OK. I am not changing the password, I am just
giving more permissions on a database or on another
database. Does any one knows anything about this ?
It is Windows 2000 SQL Server 2000 SP3 box.
Thanks.Check the following article:
FIX: You are prompted for password confirmation after you
change a standard SQL Server login
http://support.microsoft.com/?kbid=826161
-Sue
On Tue, 12 Apr 2005 09:29:18 -0700, "Todd"
<anonymous@.discussions.microsoft.com> wrote:

>When I double click on a SQL Server user (SQL Server
>Authentication user) to give permission to another
>database, it is asking me to 'confirm new password' after
>clicking on OK. I am not changing the password, I am just
>giving more permissions on a database or on another
>database. Does any one knows anything about this ?
>It is Windows 2000 SQL Server 2000 SP3 box.
>Thanks.|||Todd
The following KB article may help you out:
http://support.microsoft.com/defaul...kb;en-us;826161
- Peter Ward
WARDY IT Solutions
"Todd" wrote:

> When I double click on a SQL Server user (SQL Server
> Authentication user) to give permission to another
> database, it is asking me to 'confirm new password' after
> clicking on OK. I am not changing the password, I am just
> giving more permissions on a database or on another
> database. Does any one knows anything about this ?
> It is Windows 2000 SQL Server 2000 SP3 box.
> Thanks.
>