Derived table and adding another column problem

Hi
I have this query below, which I'm trying to add and group data on the w
number (ISO w, taken from Books online) fn_getISOW returns an integer
and works independently of this query. This query also works as I want when
there is no wno invloved (the 3 places)
The error I get is "Invalid column name 'wno'", I think what I'm doing is
a "copy" of what has been done in the count(case.....) as xx
Can anyone see what I'm doing wrong and how to fix it?
regards
Henry
declare @.ext char(4)
declare @.site int
declare @.calltype char(1)
SET DATEFORMAT mdy
set @.site = 1
set @.calltype = 'E'
set @.ext = '6810'
SELECT wno***, network, centre, center, team, total, besvaret, optaget,
opgivet, ubesvaret
FROM (
SELECT network, centre, center, team,
COUNT(*) AS total,
COUNT(CASE WHEN durationofconversation > 0 THEN 1
END) AS besvaret,
COUNT(CASE WHEN durationofconversation = 0 AND
releasecause = 'OC' THEN 1 END) AS optaget,
COUNT(CASE WHEN durationofconversation = 0 AND
releasecause = 'RL' AND durationofcall < 40 THEN 1 END) AS opgivet,
COUNT(CASE WHEN durationofconversation = 0 AND
durationofcall >= 40 THEN 1 END) AS ubesvaret,
tcv2.dbo.fn_getISOw(DATECALLINITIATED) as wno
***
FROM V2tickets
INNER JOIN
(SELECT s.serie, a.nodename as network, cs.nodename as
centre, c.nodename as center, t.nodename as team
FROM areas a, centers cs, center c, teams t, series s
WHERE (t.nodeid = 1 or t.nodeid=8 or t.nodeid=2 or
t.nodeid=72 or t.nodeid=73) and a.nodeid=cs.parentid and
cs.nodeid=c.parentid and c.nodeid=t.parentid and t.nodeid=s.parentid) AS H
ON V2tickets.digits = H.serie
WHERE siteid = @.site
AND calltype = @.calltype
AND LEN(digits) = 4
GROUP BY wno***, network, centre, center, team) AS D
ORDER BY 1Try this
SELECT wno***, network, centre, center, team, total, besvaret,
optaget,
opgivet, ubesvaret
FROM (
SELECT network, centre, center, team,
COUNT(*) AS total,
COUNT(CASE WHEN durationofconversation > 0
THEN 1
END) AS besvaret,
COUNT(CASE WHEN durationofconversation = 0 AND
releasecause = 'OC' THEN 1 END) AS optaget,
COUNT(CASE WHEN durationofconversation = 0 AND
releasecause = 'RL' AND durationofcall < 40 THEN 1 END) AS opgivet,
COUNT(CASE WHEN durationofconversation = 0 AND
durationofcall >= 40 THEN 1 END) AS ubesvaret,
tcv2.dbo.fn_getISOw(DATECALLINITIATED) as
wno
***
FROM V2tickets
INNER JOIN
(SELECT s.serie, a.nodename as network, cs.nodename as
centre, c.nodename as center, t.nodename as team
FROM areas a, centers cs, center c, teams t, series s
WHERE (t.nodeid = 1 or t.nodeid=8 or t.nodeid=2 or
t.nodeid=72 or t.nodeid=73) and a.nodeid=cs.parentid and
cs.nodeid=c.parentid and c.nodeid=t.parentid and t.nodeid=s.parentid)
AS H
ON V2tickets.digits = H.serie
WHERE siteid = @.site
AND calltype = @.calltype
AND LEN(digits) = 4
) AS D
GROUP BY wno***, network, centre, center, team ORDER BY 1
Madhivanan|||> Try this
> Madhivanan
>
Hi
No I'm sorry that doesn't do the trick either :(
regards
Henry|||> > Try this
> Hi
> No I'm sorry that doesn't do the trick either :(
> regards
> Henry
Solved... I had to use the same syntax in the group by part since wno is
not know at that time.
regards
Henrik

Deploying updated report but still seeing old version

Hi,
I have looked up information about my problem in this group but couldn't
find any fitting solution.
I have deployed a report to the report server. I've added a textbox to the
report and delpoyed it again. When openening the report in the reportserver i
still get to see the old report (the one without the textbox). I have tried
the clearsession argument but did not work. I have cleared my IE cache,
restarted IIS, Deleted the whole map in the reports manager and deplyed the
report again, I don't cache any reports, but still i get to see the old
report. What could be the problem? I don't know where to look any more.
Thnx in advance.
StanleyAre you deploying from Visual Studio? I question whether it has been
deployed. The most I have ever had to do if this happens to me is to clost
IE and re-open IE. I have never had to do anything with IIS.
1. Do the following. Open up a new IE. Go to where the reports are and click
on the show details and look at the Modified Date.
2. Deploy
3. Redo #1 (new IE). Is the Modified Date column being updated?
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Stanley" <Stanley@.discussions.microsoft.com> wrote in message
news:955191A6-7FA6-4538-8422-29A746690707@.microsoft.com...
> Hi,
> I have looked up information about my problem in this group but couldn't
> find any fitting solution.
> I have deployed a report to the report server. I've added a textbox to the
> report and delpoyed it again. When openening the report in the
reportserver i
> still get to see the old report (the one without the textbox). I have
tried
> the clearsession argument but did not work. I have cleared my IE cache,
> restarted IIS, Deleted the whole map in the reports manager and deplyed
the
> report again, I don't cache any reports, but still i get to see the old
> report. What could be the problem? I don't know where to look any more.
> Thnx in advance.
> Stanley|||I just deployed an update of 2 reports and a new report and all I did when
viewing the details list was to hit the refresh button in IE and it showed
the modified date and it showed the new report both.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23duxcCx$EHA.3836@.tk2msftngp13.phx.gbl...
> Are you deploying from Visual Studio? I question whether it has been
> deployed. The most I have ever had to do if this happens to me is to clost
> IE and re-open IE. I have never had to do anything with IIS.
>
> 1. Do the following. Open up a new IE. Go to where the reports are and
click
> on the show details and look at the Modified Date.
> 2. Deploy
> 3. Redo #1 (new IE). Is the Modified Date column being updated?
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Stanley" <Stanley@.discussions.microsoft.com> wrote in message
> news:955191A6-7FA6-4538-8422-29A746690707@.microsoft.com...
> > Hi,
> >
> > I have looked up information about my problem in this group but couldn't
> > find any fitting solution.
> >
> > I have deployed a report to the report server. I've added a textbox to
the
> > report and delpoyed it again. When openening the report in the
> reportserver i
> > still get to see the old report (the one without the textbox). I have
> tried
> > the clearsession argument but did not work. I have cleared my IE cache,
> > restarted IIS, Deleted the whole map in the reports manager and deplyed
> the
> > report again, I don't cache any reports, but still i get to see the old
> > report. What could be the problem? I don't know where to look any
more.
> >
> > Thnx in advance.
> >
> > Stanley
>|||Hi Bruce,
I have deployed the reports and saw that the modified date indeed changed.
And i just noticed that the textbox was not showing on the same place as
where i had put it in desgin mode. The textbox was showing a the bottom of
the chart instead of on the chart where i had put it. That's why i assumed
that it was showing the old report. But than i have another problem which
also made me assume that is was showing the old report. I have some custom VB
code which select a default value for the month parameter. It selects the
current month and pre-sets that month as the default value when openening the
report. In preview mode it works fine, but when i deploy it, it doesn't wor.
I still have to select the value manually.
This is the VB code:
public function GetMonth() as string
GetMonth = Format(Now(),"MMMM")
end function
The parameter in the MDX query accepts the whole month name like:
[Period].[All Period].[2005].[January]
The report contains also a Year parameter which works just fine with VB Code
(to get this year value). Only the month parameter doens't work.
You know why?
Thanks for your help.
Stanley
"Bruce L-C [MVP]" wrote:
> I just deployed an update of 2 reports and a new report and all I did when
> viewing the details list was to hit the refresh button in IE and it showed
> the modified date and it showed the new report both.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:%23duxcCx$EHA.3836@.tk2msftngp13.phx.gbl...
> > Are you deploying from Visual Studio? I question whether it has been
> > deployed. The most I have ever had to do if this happens to me is to clost
> > IE and re-open IE. I have never had to do anything with IIS.
> >
> >
> > 1. Do the following. Open up a new IE. Go to where the reports are and
> click
> > on the show details and look at the Modified Date.
> > 2. Deploy
> > 3. Redo #1 (new IE). Is the Modified Date column being updated?
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Stanley" <Stanley@.discussions.microsoft.com> wrote in message
> > news:955191A6-7FA6-4538-8422-29A746690707@.microsoft.com...
> > > Hi,
> > >
> > > I have looked up information about my problem in this group but couldn't
> > > find any fitting solution.
> > >
> > > I have deployed a report to the report server. I've added a textbox to
> the
> > > report and delpoyed it again. When openening the report in the
> > reportserver i
> > > still get to see the old report (the one without the textbox). I have
> > tried
> > > the clearsession argument but did not work. I have cleared my IE cache,
> > > restarted IIS, Deleted the whole map in the reports manager and deplyed
> > the
> > > report again, I don't cache any reports, but still i get to see the old
> > > report. What could be the problem? I don't know where to look any
> more.
> > >
> > > Thnx in advance.
> > >
> > > Stanley
> >
> >
>
>|||I thin k it's better if i create a new thread for this.
"Stanley" wrote:
> Hi Bruce,
> I have deployed the reports and saw that the modified date indeed changed.
> And i just noticed that the textbox was not showing on the same place as
> where i had put it in desgin mode. The textbox was showing a the bottom of
> the chart instead of on the chart where i had put it. That's why i assumed
> that it was showing the old report. But than i have another problem which
> also made me assume that is was showing the old report. I have some custom VB
> code which select a default value for the month parameter. It selects the
> current month and pre-sets that month as the default value when openening the
> report. In preview mode it works fine, but when i deploy it, it doesn't wor.
> I still have to select the value manually.
> This is the VB code:
> public function GetMonth() as string
> GetMonth = Format(Now(),"MMMM")
> end function
> The parameter in the MDX query accepts the whole month name like:
> [Period].[All Period].[2005].[January]
>
> The report contains also a Year parameter which works just fine with VB Code
> (to get this year value). Only the month parameter doens't work.
> You know why?
> Thanks for your help.
> Stanley
> "Bruce L-C [MVP]" wrote:
> > I just deployed an update of 2 reports and a new report and all I did when
> > viewing the details list was to hit the refresh button in IE and it showed
> > the modified date and it showed the new report both.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> > news:%23duxcCx$EHA.3836@.tk2msftngp13.phx.gbl...
> > > Are you deploying from Visual Studio? I question whether it has been
> > > deployed. The most I have ever had to do if this happens to me is to clost
> > > IE and re-open IE. I have never had to do anything with IIS.
> > >
> > >
> > > 1. Do the following. Open up a new IE. Go to where the reports are and
> > click
> > > on the show details and look at the Modified Date.
> > > 2. Deploy
> > > 3. Redo #1 (new IE). Is the Modified Date column being updated?
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "Stanley" <Stanley@.discussions.microsoft.com> wrote in message
> > > news:955191A6-7FA6-4538-8422-29A746690707@.microsoft.com...
> > > > Hi,
> > > >
> > > > I have looked up information about my problem in this group but couldn't
> > > > find any fitting solution.
> > > >
> > > > I have deployed a report to the report server. I've added a textbox to
> > the
> > > > report and delpoyed it again. When openening the report in the
> > > reportserver i
> > > > still get to see the old report (the one without the textbox). I have
> > > tried
> > > > the clearsession argument but did not work. I have cleared my IE cache,
> > > > restarted IIS, Deleted the whole map in the reports manager and deplyed
> > > the
> > > > report again, I don't cache any reports, but still i get to see the old
> > > > report. What could be the problem? I don't know where to look any
> > more.
> > > >
> > > > Thnx in advance.
> > > >
> > > > Stanley
> > >
> > >
> >
> >
> >

Deploying - credentials required

I'm stumped, i've notice a couple have had this issue on this group, have
anyone had success in solving it.
Basically when I attempt to deploy to a remote server I'm propted to login
to SRS located at http://<servername>/reports no amount of credentials
sent work.
I've checked IIS and i'm runnning both web sites with windows integeration.
Can anyone tell me what is going on?
Thanks.I am having the same issue, anyone have a solution?
Thanks,
Geoff
"Namshub" wrote:
> I'm stumped, i've notice a couple have had this issue on this group, have
> anyone had success in solving it.
> Basically when I attempt to deploy to a remote server I'm propted to login
> to SRS located at http://<servername>/reports no amount of credentials
> sent work.
> I've checked IIS and i'm runnning both web sites with windows integeration.
> Can anyone tell me what is going on?
> Thanks.
>
>|||I saw in another post that this was sometimes caused by sharepoint
integration. However, I am not using sharepoint, any ideas?
other thread
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&tid=893df211-dee7-4e99-9fb4-fda8c47585fd&cat=en-us-msdn-enterprise-sqlserver&lang=en&cr=US&sloc=en-us&m=1&p=1
"Namshub" wrote:
> I'm stumped, i've notice a couple have had this issue on this group, have
> anyone had success in solving it.
> Basically when I attempt to deploy to a remote server I'm propted to login
> to SRS located at http://<servername>/reports no amount of credentials
> sent work.
> I've checked IIS and i'm runnning both web sites with windows integeration.
> Can anyone tell me what is going on?
> Thanks.
>
>|||Are you set up for the right role to deploy? If you can be included in the
local admin group on the server where RS resides, that will put you in the
correct role automatically.
The other point to check is sharepoint as the other poster mentioned.
Finally, I once had a weird thing that turned out to be caused by having the
server running DHCP (it was a test server) and that for some reason caused
this symptom for me. I changed it to a fixed IP address and the problem went
away.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Namshub" <Richard.Pullen@.NoSpam.Southend.nhs.uk> wrote in message
news:e0qgGT3zHHA.464@.TK2MSFTNGP02.phx.gbl...
> I'm stumped, i've notice a couple have had this issue on this group, have
> anyone had success in solving it.
> Basically when I attempt to deploy to a remote server I'm propted to login
> to SRS located at http://<servername>/reports no amount of credentials
> sent work.
> I've checked IIS and i'm runnning both web sites with windows
> integeration.
> Can anyone tell me what is going on?
> Thanks.
>|||Thanks for your responses, unfortunatly none of the issues relate to what my
problem is, so it looks like I have a new one.
"Namshub" <Richard.Pullen@.NoSpam.Southend.nhs.uk> wrote in message
news:e0qgGT3zHHA.464@.TK2MSFTNGP02.phx.gbl...
> I'm stumped, i've notice a couple have had this issue on this group, have
> anyone had success in solving it.
> Basically when I attempt to deploy to a remote server I'm propted to login
> to SRS located at http://<servername>/reports no amount of credentials
> sent work.
> I've checked IIS and i'm runnning both web sites with windows
> integeration.
> Can anyone tell me what is going on?
> Thanks.
>|||Incdentally I had an issue with the black Preview with the reports when in
design mode (SQL 2005 sp2 caused this) after requesting the hotfix located
here
http://support.microsoft.com/kb/935356
I have installed it on my development machine, and now have no problems
uploading to the server.
HTH
"Namshub" <Richard.Pullen@.NoSpam.Southend.nhs.uk> wrote in message
news:e0qgGT3zHHA.464@.TK2MSFTNGP02.phx.gbl...
> I'm stumped, i've notice a couple have had this issue on this group, have
> anyone had success in solving it.
> Basically when I attempt to deploy to a remote server I'm propted to login
> to SRS located at http://<servername>/reports no amount of credentials
> sent work.
> I've checked IIS and i'm runnning both web sites with windows
> integeration.
> Can anyone tell me what is going on?
> Thanks.
>

Deploy Reports

Hi all,
I am just wondering is it possible to deploy a report to the report server and only specific a group of users can view it (lets say Content Manager role users) without having to log into the report manager using Content Manager account and manually delete the groups that I do not want to show the reports to? By the time I deployed it and log in using Content Manager role, I am afraid other users might log in and browse the reports, which contain confidential report results to certain users.
Anyone have any idea how to go about solving this situation please share it out. Or guide me to a place where I can find the solution for it. Thanks in advance.
Daren

You can set permissions on folders on the report server and then deploy reports to a particular folder based on the permissions you want for each report.

See this link:

http://msdn2.microsoft.com/en-us/library/ms155804.aspx

|||Thanks Ryan.
Daren

Dependance service or group failed to start - 1068

I am getting an error whenever I try to start the sqlserveragent. This
started happening about three days ago. I have not made any changed to the
computer users or permissions and it is a test environment on a local
computer.
The error is:
The dependency service or group failed to start error 1068
Any suggestions how to fix this error?
R W
Use Event Viewer to see related message(s) in the System log. The most
likely cause is that the SQL Server service can't start for some reason,
which the SQLSERVERAGENT service depends on.
Hope this helps.
Dan Guzman
SQL Server MVP
"R Weeden" <rweeden@.wesd.k12.az.us> wrote in message
news:e0e$2awQGHA.5900@.tk2msftngp13.phx.gbl...
>I am getting an error whenever I try to start the sqlserveragent. This
> started happening about three days ago. I have not made any changed to
> the
> computer users or permissions and it is a test environment on a local
> computer.
> The error is:
> The dependency service or group failed to start error 1068
> Any suggestions how to fix this error?
> R W
>

Dependance service or group failed to start - 1068

I am getting an error whenever I try to start the sqlserveragent. This
started happening about three days ago. I have not made any changed to the
computer users or permissions and it is a test environment on a local
computer.
The error is:
The dependency service or group failed to start error 1068
Any suggestions how to fix this error?
R WUse Event Viewer to see related message(s) in the System log. The most
likely cause is that the SQL Server service can't start for some reason,
which the SQLSERVERAGENT service depends on.
Hope this helps.
Dan Guzman
SQL Server MVP
"R Weeden" <rweeden@.wesd.k12.az.us> wrote in message
news:e0e$2awQGHA.5900@.tk2msftngp13.phx.gbl...
>I am getting an error whenever I try to start the sqlserveragent. This
> started happening about three days ago. I have not made any changed to
> the
> computer users or permissions and it is a test environment on a local
> computer.
> The error is:
> The dependency service or group failed to start error 1068
> Any suggestions how to fix this error?
> R W
>

Deny remote network access to MSDE

HI!
I'd like turn off remote network access for a user group in the user
manager.
Are users of this group still capable of accessing the MSDE while
working on the local machine?
What does local access mean?
Can they access the MSDE via TCP to 127.0.0.1?
Or must they access the MSDE through a named pipe?
Ciao, Michael.
If I'm not mistaken, MSDE 2000 SP3a already disables remote access by
default.
joe.
"Michael Strder" <michael@.stroeder.com> wrote in message
news:sauhi2-5k4.ln1@.nb2.stroeder.com...
> HI!
> I'd like turn off remote network access for a user group in the user
> manager.
> Are users of this group still capable of accessing the MSDE while
> working on the local machine?
> What does local access mean?
> Can they access the MSDE via TCP to 127.0.0.1?
> Or must they access the MSDE through a named pipe?
> Ciao, Michael.

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.

Deny Builtin Administrators

I have denied the Builtin Administrators group with SQL Server, now I don't
have access to recover. Everything seems to run okay, but I don't have
permission to do anything anymore. I don't know the password to the sa
account. This is on an Active Directory domain.
Now I can't start backup exec, b\c of dependencies.
Any help would be greatly appreciated.
Thanks in advance.You're pretty well out of luck if you don't know the SA password and don't
have another administrator. The only thing I can think of is to install
again from scratch and then attach the databases - and write down the SA
password this time.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"dusty" <dusty@.discussions.microsoft.com> wrote in message
news:17A2CB2B-73F2-4DAA-8B18-FC4C636AC714@.microsoft.com...
>I have denied the Builtin Administrators group with SQL Server, now I don't
> have access to recover. Everything seems to run okay, but I don't have
> permission to do anything anymore. I don't know the password to the sa
> account. This is on an Active Directory domain.
> Now I can't start backup exec, b\c of dependencies.
> Any help would be greatly appreciated.
> Thanks in advance.|||Okay. Another Administrator meaning...? Domain Admin?
THanks for the prompt reply.
"Roger Wolter[MSFT]" wrote:

> You're pretty well out of luck if you don't know the SA password and don't
> have another administrator. The only thing I can think of is to install
> again from scratch and then attach the databases - and write down the SA
> password this time.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "dusty" <dusty@.discussions.microsoft.com> wrote in message
> news:17A2CB2B-73F2-4DAA-8B18-FC4C636AC714@.microsoft.com...
>
>|||Another administrator meaning a user who can log in who has admin privileges
in the database. You eliminated all Windows admins already unless you have
specifically granted permissions to a particular user before you denied
Windows admins and forgot the sa password.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"dusty" <dusty@.discussions.microsoft.com> wrote in message
news:5727AD5D-34FD-4FDC-A917-E6B1E237B0A5@.microsoft.com...[vbcol=seagreen]
> Okay. Another Administrator meaning...? Domain Admin?
> THanks for the prompt reply.
> "Roger Wolter[MSFT]" wrote:
>|||Yes, I was sure that's what you meant, but just wanted to confirm. Thanks
for your help Roger.
"Roger Wolter[MSFT]" wrote:

> Another administrator meaning a user who can log in who has admin privileg
es
> in the database. You eliminated all Windows admins already unless you hav
e
> specifically granted permissions to a particular user before you denied
> Windows admins and forgot the sa password.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "dusty" <dusty@.discussions.microsoft.com> wrote in message
> news:5727AD5D-34FD-4FDC-A917-E6B1E237B0A5@.microsoft.com...
>
>