Intermittent SQL 7 Login problem

Access 2000 application on client can log-in to SQL server using one of the SQL server logins.

Problem is that from certain clients you can log in using ANY id.

From other clients, the login attempt produces the SQL Server login box.

Any ideas why this might be ?

Client is Win2000.

All help would be appreciated!Have u tried connecting to sql from same box with diff network usernames ?

U prob running integrated security ?|||The login box should not come up at all ! That's the problem.

For the clients where it is the correct behaviour, you do not see the login box at all after starting the application.

However, when you start the application from some clients on the network, then the login box appears ...

Thanks.|||Sorry I'm not familiar with Access 2000 very much.

I was wondering wheter some clients are getting into sql via integrated security - taking the clients network login credentials by default - & if that fails the sql security login then the Login Box appears

Have u tried connecting to sql from same box with diff network usernames

Is it Box or user specific SQL Security Access problem.|||Try WINDOWS AUTHENTICATION on SQLSErver side.|||Originally posted by Satya
Try WINDOWS AUTHENTICATION on SQLSErver side.

Hi Satya -
I do not understand - could you please explain what you mean in more detail?

Many thanks.

Interesting question

hi,
I am thinking if Transactional backup is based on the data in the
Transaction Log. what if i set up a the Log Reader to be run every 1 hour,
but within that 1 hour, i do a transactional backup and issue the command
"CheckPoint"!!! Can the log reader still be able to read what i have changed
before the backup?
Thanks
Ed
Ed,
transactions are only removed from the transaction log once sp_repldone has
been issued. This is called by the log reader agent, so backing up the log,
using simple recovery mode, issuing checkpoints etc won't make any
difference.
HTH,
Paul Ibison, SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||transactions are never removed from the log otherwise doing any form of
recovery using the log would be useless. Rather they are marked as
replicated.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:%23X7hZXnKFHA.3512@.TK2MSFTNGP15.phx.gbl...
> Ed,
> transactions are only removed from the transaction log once sp_repldone
has
> been issued. This is called by the log reader agent, so backing up the
log,
> using simple recovery mode, issuing checkpoints etc won't make any
> difference.
> HTH,
> Paul Ibison, SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||Thanks for the correction! What I meant is that they can
be removed on backup of the log or truncation, although
my Englissh let me down
Rgds,
Paul
|||I thought that was what you meant, but it wasn't clear And you know me -
I am very easily confused.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:142101c52afc$b2e69bf0$a601280a@.phx.gbl...
> Thanks for the correction! What I meant is that they can
> be removed on backup of the log or truncation, although
> my Englissh let me down
> Rgds,
> Paul
>

Interesting Grouping problem...

Alright, I hope somebody can help me with this...

I have a database that keeps a log of people going in and out of our building. It records whether they entered or exited along with the current date/time. Now I'm trying to pull those values from the table; I want a count of the entrances, a count of the exits, and the time range, grouped by a half hour. A sample row of what I want would look like:

TimeRange Entered Exited
9:00-9:30 5 3

Does anyone know what sort of a SQL Statement I could use to do this? It's been driving me crazy! I'd like to do it all in one stored proc.

Thank ya,
Joe FioriniIs this the kind of thing you're after?

CREATE PROCEDURE [dbo].[getRecordsBetween]
(
@.startDate datetime,
@.endDate datetime = null
)
AS

if @.endDate is null
begin
set @.endDate = dateadd(minute, 30, @.startDate)
end

select *
from register
where dateIn > @.startDate and dateIn < @.endDate

RETURN

Register is the name of the table where the records are stored, and on this querey we're checking for the time signed in (rather than signed out).

Hope it helps

Dan|||you can probably do it with plain sql, no need for a stored proc

what are the columns called and what are their datatypes?

rudy
http://rudy.ca/|||It would be easier to do on an hourly basis.

You'd do something like:

select datepart(hh,TheTimestamp) as hour, Name, Type
into #t1
from SourceData

select hour,
sum (case when Type='Entry' then 1 else 0 end)as Entries,
sum (case when Type='Exit' then 1 else 0 end)as Exits,
from #t1

You could then join on a lookup table for the hour to give texts like "09:00 to 10:00"

Ask me if you need more details on this

Or

If you had Names in your input data you could group by name as follows:

select Name
sum(case when hour=1 and Type='Entry' then 1 else 0 end)as EntryHour1,
sum(case when hour=2 and Type='Entry' then 1 else 0 end)as EntryHour2,
sum(case when hour=3 and Type='Entry' then 1 else 0 end)as EntryHour3,
sum(case when hour=4 and Type='Entry' then 1 else 0 end)as EntryHour4,
...etc...
sum(case when hour=1 and Type='Exit' then 1 else 0 end)as ExitHour1,
sum(case when hour=2 and Type='Exit' then 1 else 0 end)as ExitHour2,
sum(case when hour=3 and Type='Exit' then 1 else 0 end)as ExitHour3,
sum(case when hour=4 and Type='Exit' then 1 else 0 end)as ExitHour4,
...etc...
from #t1
group by Name

Hope this helps.

- Andy Abelsql

interesting error message

Hi,
I keep geeting this error message in one of my servers.
Replication: agent failed.: Unable to expand message 17055 [-1073724769]
18265 Log backed up: Database: mine, creation date(time):
2004/08/11(14:41:52), first LSN: 10:14151:1, last LSN: 10:14151:1, number of
dump devices: 1, device informa... ..
There is no replication configured on the server. The backup job is also
successful. What is this message about?
I don't know, but if it's really from August 11 of last year, are you sure
it's still relevant?
On 3/2/05 8:45 PM, in article
545CADDF-C5EF-48A2-967F-A4246D13D306@.microsoft.com, "Bharath"
<Bharath@.discussions.microsoft.com> wrote:

> Hi,
> I keep geeting this error message in one of my servers.
> Replication: agent failed.: Unable to expand message 17055 [-1073724769]
> 18265 Log backed up: Database: mine, creation date(time):
> 2004/08/11(14:41:52), first LSN: 10:14151:1, last LSN: 10:14151:1, number of
> dump devices: 1, device informa... ..
>
> There is no replication configured on the server. The backup job is also
> successful. What is this message about?
|||Aaron,
It is relevant - I think the message is of Aug 11 - because the db was
created on Aug 11th 2004 - but it is a current message only.
"Aaron [SQL Server MVP]" wrote:

> I don't know, but if it's really from August 11 of last year, are you sure
> it's still relevant?
>
> On 3/2/05 8:45 PM, in article
> 545CADDF-C5EF-48A2-967F-A4246D13D306@.microsoft.com, "Bharath"
> <Bharath@.discussions.microsoft.com> wrote:
>
>

interesting error message

Hi,
I keep geeting this error message in one of my servers.
Replication: agent failed.: Unable to expand message 17055 [-1073724769]
18265 Log backed up: Database: mine, creation date(time):
2004/08/11(14:41:52), first LSN: 10:14151:1, last LSN: 10:14151:1, number of
dump devices: 1, device informa... ..
There is no replication configured on the server. The backup job is also
successful. What is this message about?I don't know, but if it's really from August 11 of last year, are you sure
it's still relevant?
On 3/2/05 8:45 PM, in article
545CADDF-C5EF-48A2-967F-A4246D13D306@.microsoft.com, "Bharath"
<Bharath@.discussions.microsoft.com> wrote:
> Hi,
> I keep geeting this error message in one of my servers.
> Replication: agent failed.: Unable to expand message 17055 [-1073724769]
> 18265 Log backed up: Database: mine, creation date(time):
> 2004/08/11(14:41:52), first LSN: 10:14151:1, last LSN: 10:14151:1, number of
> dump devices: 1, device informa... ..
>
> There is no replication configured on the server. The backup job is also
> successful. What is this message about?|||Aaron,
It is relevant - I think the message is of Aug 11 - because the db was
created on Aug 11th 2004 - but it is a current message only.
"Aaron [SQL Server MVP]" wrote:
> I don't know, but if it's really from August 11 of last year, are you sure
> it's still relevant?
>
> On 3/2/05 8:45 PM, in article
> 545CADDF-C5EF-48A2-967F-A4246D13D306@.microsoft.com, "Bharath"
> <Bharath@.discussions.microsoft.com> wrote:
> > Hi,
> >
> > I keep geeting this error message in one of my servers.
> >
> > Replication: agent failed.: Unable to expand message 17055 [-1073724769]
> > 18265 Log backed up: Database: mine, creation date(time):
> > 2004/08/11(14:41:52), first LSN: 10:14151:1, last LSN: 10:14151:1, number of
> > dump devices: 1, device informa... ..
> >
> >
> > There is no replication configured on the server. The backup job is also
> > successful. What is this message about?
>

interesting error message

Hi,
I keep geeting this error message in one of my servers.
Replication: agent failed.: Unable to expand message 17055 [-1073724769]
18265 Log backed up: Database: mine, creation date(time):
2004/08/11(14:41:52), first LSN: 10:14151:1, last LSN: 10:14151:1, number of
dump devices: 1, device informa... ..
There is no replication configured on the server. The backup job is also
successful. What is this message about?I don't know, but if it's really from August 11 of last year, are you sure
it's still relevant?
On 3/2/05 8:45 PM, in article
545CADDF-C5EF-48A2-967F-A4246D13D306@.microsoft.com, "Bharath"
<Bharath@.discussions.microsoft.com> wrote:

> Hi,
> I keep geeting this error message in one of my servers.
> Replication: agent failed.: Unable to expand message 17055 [-107372476
9]
> 18265 Log backed up: Database: mine, creation date(time):
> 2004/08/11(14:41:52), first LSN: 10:14151:1, last LSN: 10:14151:1, number
of
> dump devices: 1, device informa... ..
>
> There is no replication configured on the server. The backup job is also
> successful. What is this message about?|||Aaron,
It is relevant - I think the message is of Aug 11 - because the db was
created on Aug 11th 2004 - but it is a current message only.
"Aaron [SQL Server MVP]" wrote:

> I don't know, but if it's really from August 11 of last year, are you sure
> it's still relevant?
>
> On 3/2/05 8:45 PM, in article
> 545CADDF-C5EF-48A2-967F-A4246D13D306@.microsoft.com, "Bharath"
> <Bharath@.discussions.microsoft.com> wrote:
>
>

Interesting custom functionality in Reports ... highlighting?

Hello,

I have a report of processes which either go into a Log table or an Error log table. They also have start / finish datetimes and a timespan value. So I want to report the process elapsed time or the error condition, depending on which table the process finished up in.

I then compare the elapsed time to the timespan and then show either a red flag (errored) green flag(worked within timespan) or yellow flag(worked but ran over allotted time) depending on what happened.

Is this possible?

I think it would be easy for me to get the info I want into a dataset using .net code but how do you link that in with SSRS?

Any help appreciated,

Thanks.

Try putting something like this into the background color property of the textbox you want to highlight:

=Switch(Fields!Error.Value = 1, "Red", Fields!timespan.Value > [AllottedTimeValue] , "Yellow", Fields!timespan.Value <= [AllottedTimeValue], "Green")

Hope this helps.

Jarret

sql

Intercept SQL : Spy / Driver-level / SQL Server Log...

Hello all,
We need to reverse engineer a very large application written in
PowerBuilder / SQL Server to port to .NET.
We have only binaries of application not source code.
What are tools / log facilitites / spy appliations that shall allow us
to see exact SQL that is being carried by driver to SQL server ? Can
we see that in the ASCII form before it gets complied at Server end?
Thanks for your time.
- KA"Kedar Agarkar" <ideas2050@.math.net> wrote in message
news:6e80e9e2.0310080343.48c8a818@.posting.google.com...
> We need to reverse engineer a very large application written in
> PowerBuilder / SQL Server to port to .NET.
> What are tools / log facilitites / spy appliations that shall allow us
> to see exact SQL that is being carried by driver to SQL server ? Can
> we see that in the ASCII form before it gets complied at Server end?
Use the Profiler, unless it's 6.5, in which case us the Trace facility. Good
luck in your project.
Kind Regards, Howard

Intercept SQL : Spy / Driver-level / SQL Server Log...

Hello all,

We need to reverse engineer a very large application written in
PowerBuilder / SQL Server to port to .NET.

We have only binaries of application not source code.

What are tools / log facilitites / spy appliations that shall allow us
to see exact SQL that is being carried by driver to SQL server ? Can
we see that in the ASCII form before it gets complied at Server end?

Thanks for your time.

- KA"Kedar Agarkar" <ideas2050@.math.net> wrote in message
news:6e80e9e2.0310080343.48c8a818@.posting.google.c om...
> We need to reverse engineer a very large application written in
> PowerBuilder / SQL Server to port to .NET.
> What are tools / log facilitites / spy appliations that shall allow us
> to see exact SQL that is being carried by driver to SQL server ? Can
> we see that in the ASCII form before it gets complied at Server end?

Use the Profiler, unless it's 6.5, in which case us the Trace facility. Good
luck in your project.

Kind Regards, Howard

Integrity Check Failure

DB Maintenance Plan for Integrity Check is failing. DB Backup, Transaction
Log backup and Optimizations are successful. I canâ't determine if itâ's
failing to run or if itâ's running
and finding a problem. The logs are not indicating any reasons for failure.
Integrity check is successful on other DBâ's. Thanks for being there to help.1. Define a report file for the plan and check that report file for error messages.
2. Run DBCC CHECKDB from query analyzer using the NO_INFOMSGS options.
3. http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:6D6C7BC0-F4E3-496E-9BDD-0BBD8B1882A9@.microsoft.com...
> DB Maintenance Plan for Integrity Check is failing. DB Backup, Transaction
> Log backup and Optimizations are successful. I canâ't determine if itâ's
> failing to run or if itâ's running
> and finding a problem. The logs are not indicating any reasons for failure.
> Integrity check is successful on other DBâ's. Thanks for being there to help.
>|||Thanks Tibor. Can you direct me to a location that indicates the procedure for
defining a report?
"Tibor Karaszi" wrote:
> 1. Define a report file for the plan and check that report file for error messages.
> 2. Run DBCC CHECKDB from query analyzer using the NO_INFOMSGS options.
> 3. http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
> news:6D6C7BC0-F4E3-496E-9BDD-0BBD8B1882A9@.microsoft.com...
> > DB Maintenance Plan for Integrity Check is failing. DB Backup, Transaction
> > Log backup and Optimizations are successful. I canâ't determine if itâ's
> > failing to run or if itâ's running
> > and finding a problem. The logs are not indicating any reasons for failure.
> > Integrity check is successful on other DBâ's. Thanks for being there to help.
> >
>|||EM, Management, Maintenance Plans, right-click your plan to open it. The right-most ( think) tab has
this option. You can also right-click an existing plan and open (something like) history and try to
find the error messages there. I don't use maint plans, so it is a little bit sketchy...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:C2AD0678-EF85-4F5B-9D99-B5B219EE9540@.microsoft.com...
> Thanks Tibor. Can you direct me to a location that indicates the procedure for
> defining a report?
> "Tibor Karaszi" wrote:
>> 1. Define a report file for the plan and check that report file for error messages.
>> 2. Run DBCC CHECKDB from query analyzer using the NO_INFOMSGS options.
>> 3. http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
>> news:6D6C7BC0-F4E3-496E-9BDD-0BBD8B1882A9@.microsoft.com...
>> > DB Maintenance Plan for Integrity Check is failing. DB Backup, Transaction
>> > Log backup and Optimizations are successful. I canâ't determine if itâ's
>> > failing to run or if itâ's running
>> > and finding a problem. The logs are not indicating any reasons for failure.
>> > Integrity check is successful on other DBâ's. Thanks for being there to help.
>> >
>>|||Thanks for your help
"Tibor Karaszi" wrote:
> EM, Management, Maintenance Plans, right-click your plan to open it. The right-most ( think) tab has
> this option. You can also right-click an existing plan and open (something like) history and try to
> find the error messages there. I don't use maint plans, so it is a little bit sketchy...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
> news:C2AD0678-EF85-4F5B-9D99-B5B219EE9540@.microsoft.com...
> > Thanks Tibor. Can you direct me to a location that indicates the procedure for
> > defining a report?
> >
> > "Tibor Karaszi" wrote:
> >
> >> 1. Define a report file for the plan and check that report file for error messages.
> >>
> >> 2. Run DBCC CHECKDB from query analyzer using the NO_INFOMSGS options.
> >>
> >> 3. http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >>
> >>
> >> "coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
> >> news:6D6C7BC0-F4E3-496E-9BDD-0BBD8B1882A9@.microsoft.com...
> >> > DB Maintenance Plan for Integrity Check is failing. DB Backup, Transaction
> >> > Log backup and Optimizations are successful. I canâ't determine if itâ's
> >> > failing to run or if itâ's running
> >> > and finding a problem. The logs are not indicating any reasons for failure.
> >> > Integrity check is successful on other DBâ's. Thanks for being there to help.
> >> >
> >>
> >>
>

Integrity Check and Transaction Log

Running the Integrity Check (I think this is DBCC CHECKDB)
as part of a Database Maintenance Plan creates a
transaction log that is roughly the size of the database.
This is causing a problem where a large database is
filling up the disk. The simple answer is to get a bigger
disk, but how can I run the Integrity Check and not have
my tlog grow so much? Is this possible?
SQL BOL says "If actively performing transactions while
DBCC CHECKDB is running, the transaction log continues to
grow because the DBCC command blocks log truncation until
it has finished reading the log." However, the integrity
check occurs early in the morning (1am) and there are no
users in the database.
Thanks,
DeanAfter you run the checkdb, you could kick off a full backup then
truncate the log if you do not have users connecting.
HTH
Ray Higdon MCSE, MCDBA, CCNA
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!|||Ray,
Yes, I could do that, and effectively am, only the next
day as part of the DB Maintenance Plan. My question comes
because I can't reproduce this tlog growth on other
databases. I've got several situations where it is
happening, but I can't pin down exactly why it's
occuring. I'm just about sure the DB Maint. Plan is the
culprit because of the timing.
Dean
>--Original Message--
>After you run the checkdb, you could kick off a full
backup then
>truncate the log if you do not have users connecting.
>HTH
>Ray Higdon MCSE, MCDBA, CCNA
>*** Sent via Developersdex http://www.developersdex.com
***
>Don't just participate in USENET...get rewarded for it!
>.
>|||Sounds more like the log is filling up due to the optimization (DBREINDEX)
portion of the MP and not the DBCC CHECKDB.
--
Andrew J. Kelly
SQL Server MVP
"Dean Beckley" <dean@.omegagroup.com> wrote in message
news:02f801c34a46$b1aff210$a401280a@.phx.gbl...
> Ray,
> Yes, I could do that, and effectively am, only the next
> day as part of the DB Maintenance Plan. My question comes
> because I can't reproduce this tlog growth on other
> databases. I've got several situations where it is
> happening, but I can't pin down exactly why it's
> occuring. I'm just about sure the DB Maint. Plan is the
> culprit because of the timing.
> Dean
> >--Original Message--
> >After you run the checkdb, you could kick off a full
> backup then
> >truncate the log if you do not have users connecting.
> >
> >HTH
> >
> >Ray Higdon MCSE, MCDBA, CCNA
> >
> >*** Sent via Developersdex http://www.developersdex.com
> ***
> >Don't just participate in USENET...get rewarded for it!
> >.
> >|||I can guarantee you that CHECKDB itself does not generate log records
(unless you're running repair) so something else _must_ be running at the
same as the check.
Regards,
Paul.
--
Paul Randal
DBCC Technical Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:OkScA8mSDHA.3192@.tk2msftngp13.phx.gbl...
> Sounds more like the log is filling up due to the optimization (DBREINDEX)
> portion of the MP and not the DBCC CHECKDB.
> --
> Andrew J. Kelly
> SQL Server MVP
>
> "Dean Beckley" <dean@.omegagroup.com> wrote in message
> news:02f801c34a46$b1aff210$a401280a@.phx.gbl...
> > Ray,
> >
> > Yes, I could do that, and effectively am, only the next
> > day as part of the DB Maintenance Plan. My question comes
> > because I can't reproduce this tlog growth on other
> > databases. I've got several situations where it is
> > happening, but I can't pin down exactly why it's
> > occuring. I'm just about sure the DB Maint. Plan is the
> > culprit because of the timing.
> >
> > Dean
> > >--Original Message--
> > >After you run the checkdb, you could kick off a full
> > backup then
> > >truncate the log if you do not have users connecting.
> > >
> > >HTH
> > >
> > >Ray Higdon MCSE, MCDBA, CCNA
> > >
> > >*** Sent via Developersdex http://www.developersdex.com
> > ***
> > >Don't just participate in USENET...get rewarded for it!
> > >.
> > >
>|||Yes, I guess I made it sound more like a question than a statement. DBCC
CHECKDB does not manipulate the data so there is no need to log.
--
Andrew J. Kelly
SQL Server MVP
"Paul S Randal [MS]" <prandal@.online.microsoft.com> wrote in message
news:Oxzrk7uSDHA.2276@.TK2MSFTNGP10.phx.gbl...
> I can guarantee you that CHECKDB itself does not generate log records
> (unless you're running repair) so something else _must_ be running at the
> same as the check.
> Regards,
> Paul.
> --
> Paul Randal
> DBCC Technical Lead, Microsoft SQL Server Storage Engine
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:OkScA8mSDHA.3192@.tk2msftngp13.phx.gbl...
> > Sounds more like the log is filling up due to the optimization
(DBREINDEX)
> > portion of the MP and not the DBCC CHECKDB.
> >
> > --
> >
> > Andrew J. Kelly
> > SQL Server MVP
> >
> >
> > "Dean Beckley" <dean@.omegagroup.com> wrote in message
> > news:02f801c34a46$b1aff210$a401280a@.phx.gbl...
> > > Ray,
> > >
> > > Yes, I could do that, and effectively am, only the next
> > > day as part of the DB Maintenance Plan. My question comes
> > > because I can't reproduce this tlog growth on other
> > > databases. I've got several situations where it is
> > > happening, but I can't pin down exactly why it's
> > > occuring. I'm just about sure the DB Maint. Plan is the
> > > culprit because of the timing.
> > >
> > > Dean
> > > >--Original Message--
> > > >After you run the checkdb, you could kick off a full
> > > backup then
> > > >truncate the log if you do not have users connecting.
> > > >
> > > >HTH
> > > >
> > > >Ray Higdon MCSE, MCDBA, CCNA
> > > >
> > > >*** Sent via Developersdex http://www.developersdex.com
> > > ***
> > > >Don't just participate in USENET...get rewarded for it!
> > > >.
> > > >
> >
> >
>

Integrity and Optimization failures

Hi All-
I have a websense log database that the Optimization and Integrity check
jobs fail on. My problem is I cannot determine WHY exactly these jobs have
failed. If I run the DBCC CHECKDB and DBCC SHOWCONTIG commands nothing
appears to be a problem. I even tried running the optimization and integrit
y
checks while the database is in single user mode to no avail. How can I A.
determine what the problem is and B. correct it?
Thank You for your help in advance!
--GREENTHUMB--I suggest you specify a report file for the Maint plan and check for specifi
c error messages in that
report file.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
news:B77C25CE-B5FA-4CF2-AF33-EC4383B0F947@.microsoft.com...
> Hi All-
> I have a websense log database that the Optimization and Integrity check
> jobs fail on. My problem is I cannot determine WHY exactly these jobs hav
e
> failed. If I run the DBCC CHECKDB and DBCC SHOWCONTIG commands nothing
> appears to be a problem. I even tried running the optimization and integr
ity
> checks while the database is in single user mode to no avail. How can I A
.
> determine what the problem is and B. correct it?
> Thank You for your help in advance!
> --GREENTHUMB--|||Hi Tibor-
I have enabled writing to the Event Log and notification to my e-mail but
the error message is extremely vague:
Event Type: Warning
Event Source: SQLSERVERAGENT
Event Category: Job Engine
Event ID: 208
Date: 4/20/2005
Time: 10:13:13 AM
User: N/A
Computer: XXXXXXXXX
Description:
SQL Server Scheduled Job 'Integrity Checks Job for DB Maintenance Plan
'Integrity check for wslogdb55'' (0xAAA25C1534A233429802DCAD2F19BC91) -
Status: Failed - Invoked on: 2005-04-20 10:13:06 - Message: The job failed.
The Job was invoked by User XXX\ADMINISTRATOR. The last step to run was ste
p
1 (Step 1).
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
"Tibor Karaszi" wrote:

> I suggest you specify a report file for the Maint plan and check for speci
fic error messages in that
> report file.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
> news:B77C25CE-B5FA-4CF2-AF33-EC4383B0F947@.microsoft.com...
>
>|||The vagueness of that message is exactly why I suggested to specify in the m
aint plan to create a
report file. In there you will find the error messages from SQL Server.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
news:67884CB9-7C98-4242-A4AC-900F49ACD0E7@.microsoft.com...[vbcol=seagreen]
> Hi Tibor-
> I have enabled writing to the Event Log and notification to my e-mail but
> the error message is extremely vague:
> Event Type: Warning
> Event Source: SQLSERVERAGENT
> Event Category: Job Engine
> Event ID: 208
> Date: 4/20/2005
> Time: 10:13:13 AM
> User: N/A
> Computer: XXXXXXXXX
> Description:
> SQL Server Scheduled Job 'Integrity Checks Job for DB Maintenance Plan
> 'Integrity check for wslogdb55'' (0xAAA25C1534A233429802DCAD2F19BC91) -
> Status: Failed - Invoked on: 2005-04-20 10:13:06 - Message: The job failed
.
> The Job was invoked by User XXX\ADMINISTRATOR. The last step to run was s
tep
> 1 (Step 1).
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
> "Tibor Karaszi" wrote:
>|||Hi Tibor-
Okay - I enabled the reports and the error given is "database is already
open and can only have one user at a time". However, I checked Single User
Mode *AND* even detached and re-attached and set to Single User to no avail.
I also checked Process info. but that database was not being accessed. Any
ideas?
Thank You!!!
--GREENTHUMB--
Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
'ORCRASV005' as 'GWN\services' (trusted)
Starting maintenance plan 'Integrity check for wslogdb55' on 4/20/2005
6:35:03 PM
[1] Database wslogdb55: Check Data and Index Linkage...
[Microsoft SQL-DMO] Error 22285: [SQL-DMO]Database 'wslogdb55' is al
ready
open and can only have one user at a time.
The following errors were found:
[Microsoft][ODBC SQL Server Driver][SQL Server]Database 'wslogdb
55' is
already open and can only have one user at a time.
** Execution Time: 0 hrs, 0 mins, 4 secs **
End of maintenance plan 'Integrity check for wslogdb55' on 4/20/2005 6:35:07
PM
SQLMAINT.EXE Process Exit Code: 1 (Failed)
"Tibor Karaszi" wrote:

> The vagueness of that message is exactly why I suggested to specify in the
maint plan to create a
> report file. In there you will find the error messages from SQL Server.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
> news:67884CB9-7C98-4242-A4AC-900F49ACD0E7@.microsoft.com...
>
>|||You need to uncheck the checkbox in the maintenance plan that says to
"Repair minor problems" and it should work fine. When you have that checked
it tries to put the db in single user mode and if it can't it errors. You
really don't want it repairing things on it's own anyway.
Andrew J. Kelly SQL MVP
"GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
news:432B45E0-DA60-455B-AA32-84EC8FCC3700@.microsoft.com...[vbcol=seagreen]
> Hi Tibor-
> Okay - I enabled the reports and the error given is "database is already
> open and can only have one user at a time". However, I checked Single
> User
> Mode *AND* even detached and re-attached and set to Single User to no
> avail.
> I also checked Process info. but that database was not being accessed.
> Any
> ideas?
> Thank You!!!
> --GREENTHUMB--
>
> Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
> 'ORCRASV005' as 'GWN\services' (trusted)
> Starting maintenance plan 'Integrity check for wslogdb55' on 4/20/2005
> 6:35:03 PM
> [1] Database wslogdb55: Check Data and Index Linkage...
> [Microsoft SQL-DMO] Error 22285: [SQL-DMO]Database 'wslogdb55' is
already
> open and can only have one user at a time.
> The following errors were found:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Database 'wslog
db55' is
> already open and can only have one user at a time.
> ** Execution Time: 0 hrs, 0 mins, 4 secs **
> End of maintenance plan 'Integrity check for wslogdb55' on 4/20/2005
> 6:35:07
> PM
> SQLMAINT.EXE Process Exit Code: 1 (Failed)
> "Tibor Karaszi" wrote:
>|||Since this job is checking database integrity, is this always a good
practice?

Integrity and Optimization failures

Hi All-
I have a websense log database that the Optimization and Integrity check
jobs fail on. My problem is I cannot determine WHY exactly these jobs have
failed. If I run the DBCC CHECKDB and DBCC SHOWCONTIG commands nothing
appears to be a problem. I even tried running the optimization and integrity
checks while the database is in single user mode to no avail. How can I A.
determine what the problem is and B. correct it?
Thank You for your help in advance!
--GREENTHUMB--I suggest you specify a report file for the Maint plan and check for specific error messages in that
report file.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
news:B77C25CE-B5FA-4CF2-AF33-EC4383B0F947@.microsoft.com...
> Hi All-
> I have a websense log database that the Optimization and Integrity check
> jobs fail on. My problem is I cannot determine WHY exactly these jobs have
> failed. If I run the DBCC CHECKDB and DBCC SHOWCONTIG commands nothing
> appears to be a problem. I even tried running the optimization and integrity
> checks while the database is in single user mode to no avail. How can I A.
> determine what the problem is and B. correct it?
> Thank You for your help in advance!
> --GREENTHUMB--|||Hi Tibor-
I have enabled writing to the Event Log and notification to my e-mail but
the error message is extremely vague:
Event Type: Warning
Event Source: SQLSERVERAGENT
Event Category: Job Engine
Event ID: 208
Date: 4/20/2005
Time: 10:13:13 AM
User: N/A
Computer: XXXXXXXXX
Description:
SQL Server Scheduled Job 'Integrity Checks Job for DB Maintenance Plan
'Integrity check for wslogdb55'' (0xAAA25C1534A233429802DCAD2F19BC91) -
Status: Failed - Invoked on: 2005-04-20 10:13:06 - Message: The job failed.
The Job was invoked by User XXX\ADMINISTRATOR. The last step to run was step
1 (Step 1).
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
"Tibor Karaszi" wrote:
> I suggest you specify a report file for the Maint plan and check for specific error messages in that
> report file.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
> news:B77C25CE-B5FA-4CF2-AF33-EC4383B0F947@.microsoft.com...
> > Hi All-
> >
> > I have a websense log database that the Optimization and Integrity check
> > jobs fail on. My problem is I cannot determine WHY exactly these jobs have
> > failed. If I run the DBCC CHECKDB and DBCC SHOWCONTIG commands nothing
> > appears to be a problem. I even tried running the optimization and integrity
> > checks while the database is in single user mode to no avail. How can I A.
> > determine what the problem is and B. correct it?
> >
> > Thank You for your help in advance!
> >
> > --GREENTHUMB--
>
>|||The vagueness of that message is exactly why I suggested to specify in the maint plan to create a
report file. In there you will find the error messages from SQL Server.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
news:67884CB9-7C98-4242-A4AC-900F49ACD0E7@.microsoft.com...
> Hi Tibor-
> I have enabled writing to the Event Log and notification to my e-mail but
> the error message is extremely vague:
> Event Type: Warning
> Event Source: SQLSERVERAGENT
> Event Category: Job Engine
> Event ID: 208
> Date: 4/20/2005
> Time: 10:13:13 AM
> User: N/A
> Computer: XXXXXXXXX
> Description:
> SQL Server Scheduled Job 'Integrity Checks Job for DB Maintenance Plan
> 'Integrity check for wslogdb55'' (0xAAA25C1534A233429802DCAD2F19BC91) -
> Status: Failed - Invoked on: 2005-04-20 10:13:06 - Message: The job failed.
> The Job was invoked by User XXX\ADMINISTRATOR. The last step to run was step
> 1 (Step 1).
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
> "Tibor Karaszi" wrote:
>> I suggest you specify a report file for the Maint plan and check for specific error messages in
>> that
>> report file.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
>> news:B77C25CE-B5FA-4CF2-AF33-EC4383B0F947@.microsoft.com...
>> > Hi All-
>> >
>> > I have a websense log database that the Optimization and Integrity check
>> > jobs fail on. My problem is I cannot determine WHY exactly these jobs have
>> > failed. If I run the DBCC CHECKDB and DBCC SHOWCONTIG commands nothing
>> > appears to be a problem. I even tried running the optimization and integrity
>> > checks while the database is in single user mode to no avail. How can I A.
>> > determine what the problem is and B. correct it?
>> >
>> > Thank You for your help in advance!
>> >
>> > --GREENTHUMB--
>>|||Hi Tibor-
Okay - I enabled the reports and the error given is "database is already
open and can only have one user at a time". However, I checked Single User
Mode *AND* even detached and re-attached and set to Single User to no avail.
I also checked Process info. but that database was not being accessed. Any
ideas?
Thank You!!!
--GREENTHUMB--
Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
'ORCRASV005' as 'GWN\services' (trusted)
Starting maintenance plan 'Integrity check for wslogdb55' on 4/20/2005
6:35:03 PM
[1] Database wslogdb55: Check Data and Index Linkage...
[Microsoft SQL-DMO] Error 22285: [SQL-DMO]Database 'wslogdb55' is already
open and can only have one user at a time.
The following errors were found:
[Microsoft][ODBC SQL Server Driver][SQL Server]Database 'wslogdb55' is
already open and can only have one user at a time.
** Execution Time: 0 hrs, 0 mins, 4 secs **
End of maintenance plan 'Integrity check for wslogdb55' on 4/20/2005 6:35:07
PM
SQLMAINT.EXE Process Exit Code: 1 (Failed)
"Tibor Karaszi" wrote:
> The vagueness of that message is exactly why I suggested to specify in the maint plan to create a
> report file. In there you will find the error messages from SQL Server.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
> news:67884CB9-7C98-4242-A4AC-900F49ACD0E7@.microsoft.com...
> > Hi Tibor-
> >
> > I have enabled writing to the Event Log and notification to my e-mail but
> > the error message is extremely vague:
> >
> > Event Type: Warning
> > Event Source: SQLSERVERAGENT
> > Event Category: Job Engine
> > Event ID: 208
> > Date: 4/20/2005
> > Time: 10:13:13 AM
> > User: N/A
> > Computer: XXXXXXXXX
> > Description:
> > SQL Server Scheduled Job 'Integrity Checks Job for DB Maintenance Plan
> > 'Integrity check for wslogdb55'' (0xAAA25C1534A233429802DCAD2F19BC91) -
> > Status: Failed - Invoked on: 2005-04-20 10:13:06 - Message: The job failed.
> > The Job was invoked by User XXX\ADMINISTRATOR. The last step to run was step
> > 1 (Step 1).
> >
> > For more information, see Help and Support Center at
> > http://go.microsoft.com/fwlink/events.asp.
> >
> >
> > "Tibor Karaszi" wrote:
> >
> >> I suggest you specify a report file for the Maint plan and check for specific error messages in
> >> that
> >> report file.
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >>
> >>
> >> "GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
> >> news:B77C25CE-B5FA-4CF2-AF33-EC4383B0F947@.microsoft.com...
> >> > Hi All-
> >> >
> >> > I have a websense log database that the Optimization and Integrity check
> >> > jobs fail on. My problem is I cannot determine WHY exactly these jobs have
> >> > failed. If I run the DBCC CHECKDB and DBCC SHOWCONTIG commands nothing
> >> > appears to be a problem. I even tried running the optimization and integrity
> >> > checks while the database is in single user mode to no avail. How can I A.
> >> > determine what the problem is and B. correct it?
> >> >
> >> > Thank You for your help in advance!
> >> >
> >> > --GREENTHUMB--
> >>
> >>
> >>
>
>|||You need to uncheck the checkbox in the maintenance plan that says to
"Repair minor problems" and it should work fine. When you have that checked
it tries to put the db in single user mode and if it can't it errors. You
really don't want it repairing things on it's own anyway.
--
Andrew J. Kelly SQL MVP
"GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
news:432B45E0-DA60-455B-AA32-84EC8FCC3700@.microsoft.com...
> Hi Tibor-
> Okay - I enabled the reports and the error given is "database is already
> open and can only have one user at a time". However, I checked Single
> User
> Mode *AND* even detached and re-attached and set to Single User to no
> avail.
> I also checked Process info. but that database was not being accessed.
> Any
> ideas?
> Thank You!!!
> --GREENTHUMB--
>
> Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
> 'ORCRASV005' as 'GWN\services' (trusted)
> Starting maintenance plan 'Integrity check for wslogdb55' on 4/20/2005
> 6:35:03 PM
> [1] Database wslogdb55: Check Data and Index Linkage...
> [Microsoft SQL-DMO] Error 22285: [SQL-DMO]Database 'wslogdb55' is already
> open and can only have one user at a time.
> The following errors were found:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Database 'wslogdb55' is
> already open and can only have one user at a time.
> ** Execution Time: 0 hrs, 0 mins, 4 secs **
> End of maintenance plan 'Integrity check for wslogdb55' on 4/20/2005
> 6:35:07
> PM
> SQLMAINT.EXE Process Exit Code: 1 (Failed)
> "Tibor Karaszi" wrote:
>> The vagueness of that message is exactly why I suggested to specify in
>> the maint plan to create a
>> report file. In there you will find the error messages from SQL Server.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
>> news:67884CB9-7C98-4242-A4AC-900F49ACD0E7@.microsoft.com...
>> > Hi Tibor-
>> >
>> > I have enabled writing to the Event Log and notification to my e-mail
>> > but
>> > the error message is extremely vague:
>> >
>> > Event Type: Warning
>> > Event Source: SQLSERVERAGENT
>> > Event Category: Job Engine
>> > Event ID: 208
>> > Date: 4/20/2005
>> > Time: 10:13:13 AM
>> > User: N/A
>> > Computer: XXXXXXXXX
>> > Description:
>> > SQL Server Scheduled Job 'Integrity Checks Job for DB Maintenance Plan
>> > 'Integrity check for wslogdb55'' (0xAAA25C1534A233429802DCAD2F19BC91) -
>> > Status: Failed - Invoked on: 2005-04-20 10:13:06 - Message: The job
>> > failed.
>> > The Job was invoked by User XXX\ADMINISTRATOR. The last step to run
>> > was step
>> > 1 (Step 1).
>> >
>> > For more information, see Help and Support Center at
>> > http://go.microsoft.com/fwlink/events.asp.
>> >
>> >
>> > "Tibor Karaszi" wrote:
>> >
>> >> I suggest you specify a report file for the Maint plan and check for
>> >> specific error messages in
>> >> that
>> >> report file.
>> >>
>> >> --
>> >> Tibor Karaszi, SQL Server MVP
>> >> http://www.karaszi.com/sqlserver/default.asp
>> >> http://www.solidqualitylearning.com/
>> >>
>> >>
>> >> "GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
>> >> news:B77C25CE-B5FA-4CF2-AF33-EC4383B0F947@.microsoft.com...
>> >> > Hi All-
>> >> >
>> >> > I have a websense log database that the Optimization and Integrity
>> >> > check
>> >> > jobs fail on. My problem is I cannot determine WHY exactly these
>> >> > jobs have
>> >> > failed. If I run the DBCC CHECKDB and DBCC SHOWCONTIG commands
>> >> > nothing
>> >> > appears to be a problem. I even tried running the optimization and
>> >> > integrity
>> >> > checks while the database is in single user mode to no avail. How
>> >> > can I A.
>> >> > determine what the problem is and B. correct it?
>> >> >
>> >> > Thank You for your help in advance!
>> >> >
>> >> > --GREENTHUMB--
>> >>
>> >>
>> >>
>>

Integrity and Optimization failures

Hi All-
I have a websense log database that the Optimization and Integrity check
jobs fail on. My problem is I cannot determine WHY exactly these jobs have
failed. If I run the DBCC CHECKDB and DBCC SHOWCONTIG commands nothing
appears to be a problem. I even tried running the optimization and integrity
checks while the database is in single user mode to no avail. How can I A.
determine what the problem is and B. correct it?
Thank You for your help in advance!
--GREENTHUMB--
I suggest you specify a report file for the Maint plan and check for specific error messages in that
report file.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
news:B77C25CE-B5FA-4CF2-AF33-EC4383B0F947@.microsoft.com...
> Hi All-
> I have a websense log database that the Optimization and Integrity check
> jobs fail on. My problem is I cannot determine WHY exactly these jobs have
> failed. If I run the DBCC CHECKDB and DBCC SHOWCONTIG commands nothing
> appears to be a problem. I even tried running the optimization and integrity
> checks while the database is in single user mode to no avail. How can I A.
> determine what the problem is and B. correct it?
> Thank You for your help in advance!
> --GREENTHUMB--
|||Hi Tibor-
I have enabled writing to the Event Log and notification to my e-mail but
the error message is extremely vague:
Event Type:Warning
Event Source:SQLSERVERAGENT
Event Category:Job Engine
Event ID:208
Date:4/20/2005
Time:10:13:13 AM
User:N/A
Computer:XXXXXXXXX
Description:
SQL Server Scheduled Job 'Integrity Checks Job for DB Maintenance Plan
'Integrity check for wslogdb55'' (0xAAA25C1534A233429802DCAD2F19BC91) -
Status: Failed - Invoked on: 2005-04-20 10:13:06 - Message: The job failed.
The Job was invoked by User XXX\ADMINISTRATOR. The last step to run was step
1 (Step 1).
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
"Tibor Karaszi" wrote:

> I suggest you specify a report file for the Maint plan and check for specific error messages in that
> report file.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
> news:B77C25CE-B5FA-4CF2-AF33-EC4383B0F947@.microsoft.com...
>
>
|||The vagueness of that message is exactly why I suggested to specify in the maint plan to create a
report file. In there you will find the error messages from SQL Server.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
news:67884CB9-7C98-4242-A4AC-900F49ACD0E7@.microsoft.com...[vbcol=seagreen]
> Hi Tibor-
> I have enabled writing to the Event Log and notification to my e-mail but
> the error message is extremely vague:
> Event Type: Warning
> Event Source: SQLSERVERAGENT
> Event Category: Job Engine
> Event ID: 208
> Date: 4/20/2005
> Time: 10:13:13 AM
> User: N/A
> Computer: XXXXXXXXX
> Description:
> SQL Server Scheduled Job 'Integrity Checks Job for DB Maintenance Plan
> 'Integrity check for wslogdb55'' (0xAAA25C1534A233429802DCAD2F19BC91) -
> Status: Failed - Invoked on: 2005-04-20 10:13:06 - Message: The job failed.
> The Job was invoked by User XXX\ADMINISTRATOR. The last step to run was step
> 1 (Step 1).
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
> "Tibor Karaszi" wrote:
|||Hi Tibor-
Okay - I enabled the reports and the error given is "database is already
open and can only have one user at a time". However, I checked Single User
Mode *AND* even detached and re-attached and set to Single User to no avail.
I also checked Process info. but that database was not being accessed. Any
ideas?
Thank You!!!
--GREENTHUMB--
Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
'ORCRASV005' as 'GWN\services' (trusted)
Starting maintenance plan 'Integrity check for wslogdb55' on 4/20/2005
6:35:03 PM
[1] Database wslogdb55: Check Data and Index Linkage...
[Microsoft SQL-DMO] Error 22285: [SQL-DMO]Database 'wslogdb55' is already
open and can only have one user at a time.
The following errors were found:
[Microsoft][ODBC SQL Server Driver][SQL Server]Database 'wslogdb55' is
already open and can only have one user at a time.
** Execution Time: 0 hrs, 0 mins, 4 secs **
End of maintenance plan 'Integrity check for wslogdb55' on 4/20/2005 6:35:07
PM
SQLMAINT.EXE Process Exit Code: 1 (Failed)
"Tibor Karaszi" wrote:

> The vagueness of that message is exactly why I suggested to specify in the maint plan to create a
> report file. In there you will find the error messages from SQL Server.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
> news:67884CB9-7C98-4242-A4AC-900F49ACD0E7@.microsoft.com...
>
>
|||You need to uncheck the checkbox in the maintenance plan that says to
"Repair minor problems" and it should work fine. When you have that checked
it tries to put the db in single user mode and if it can't it errors. You
really don't want it repairing things on it's own anyway.
Andrew J. Kelly SQL MVP
"GreenThumb" <GreenThumb@.discussions.microsoft.com> wrote in message
news:432B45E0-DA60-455B-AA32-84EC8FCC3700@.microsoft.com...[vbcol=seagreen]
> Hi Tibor-
> Okay - I enabled the reports and the error given is "database is already
> open and can only have one user at a time". However, I checked Single
> User
> Mode *AND* even detached and re-attached and set to Single User to no
> avail.
> I also checked Process info. but that database was not being accessed.
> Any
> ideas?
> Thank You!!!
> --GREENTHUMB--
>
> Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
> 'ORCRASV005' as 'GWN\services' (trusted)
> Starting maintenance plan 'Integrity check for wslogdb55' on 4/20/2005
> 6:35:03 PM
> [1] Database wslogdb55: Check Data and Index Linkage...
> [Microsoft SQL-DMO] Error 22285: [SQL-DMO]Database 'wslogdb55' is already
> open and can only have one user at a time.
> The following errors were found:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Database 'wslogdb55' is
> already open and can only have one user at a time.
> ** Execution Time: 0 hrs, 0 mins, 4 secs **
> End of maintenance plan 'Integrity check for wslogdb55' on 4/20/2005
> 6:35:07
> PM
> SQLMAINT.EXE Process Exit Code: 1 (Failed)
> "Tibor Karaszi" wrote:
|||Since this job is checking database integrity, is this always a good
practice?

Integration Services Login

How do I add myself into the Integration Services? so I can use SQL Server
Management Studio to log in Integration Services
First I tried loggin into the SQL Server 2005 itself using 'sa', add my NT
login as a login ie 'SomeGroup\SomeloginName', open the properties for the N
T
Login name & assign all roles including sysadmin to the name.
Then, go back to SQL Server Management Studio to connect to Integration
Services, it still say access deny
Thanks
--
MVP888Hi,
From your descriptions, I understood you are not able to connect SSIS with
the account even you have assigned SA privilege. If I have misunderstood
your concern, please feel free to point it out.
First of all, please use SQL Server Configuration Manager to make sure you
have started SQL Server Intergration Services.
Secondly, have you tried use both Windows Authentication and SQL
Authentication to login the SSIS?
Thirdly, is it possible for you to show us some screen shot?
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.|||Thanks Michael
1. SQL Server Integration Services started because I can login using the NT
account that was used to install the SQL Server but not other NT accounts.
2. I can not switch over to use the SQL Authentication option when I log
into Integration Services because it is grayed out. However, I do have the
SQL Authentication option when I log into the SQL Server Database itself.
(Why is that).
3.I have problem pasting the screen, but here is what on the error screen
when I try to log into SSIS
Cannot connect to ldqcedcmcache1.--> my machine name
Additional Information:
-->Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
--> Connect to SSIS Service on machine “ldqcedcmcache1” failed:
Access is denied.|||Hi,
[vbcol=seagreen]
the[vbcol=seagreen]
itself.[vbcol=seagreen]
Only Microsoft Windows Authentication is available for SSIS. Windows
Authentication mode allows a user to connect through a Windows user account.
For more detailed information, check the BOL topic below
Connect to Server (Integration Services)
http://msdn2.microsoft.com/en-us/library/ms183366(en-US,SQL.90).aspx
[vbcol=seagreen]
Since the SSIS will only allow Windows Authentication, please make sure
your Windows Account has sufficient privilege to SSIS.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi,
I've just fixed this problem myself. This probably isn't the proper fix,
but I found that adding the user to the local machine's (ie the SQL Server's
local group) administrators group gave me the rights to log on.
This is only a quick fix, but the issue must be that whatever user you want
to access integrations services must need certain levels of access to the
OS, most likely the ability to start and stop services.
Its a starting point anyway!
Regards
Brett
"MVP888" wrote:
[vbcol=seagreen]
> Thanks Michael
> 1. SQL Server Integration Services started because I can login using the N
T
> account that was used to install the SQL Server but not other NT accounts.
> 2. I can not switch over to use the SQL Authentication option when I log
> into Integration Services because it is grayed out. However, I do have th
e
> SQL Authentication option when I log into the SQL Server Database itself.
> (Why is that).
> 3.I have problem pasting the screen, but here is what on the error screen
> when I try to log into SSIS
> Cannot connect to ldqcedcmcache1.--> my machine name
> Additional Information:
> -->Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
> --> Connect to SSIS Service on machine “ldqcedcmcache1” failed:
> Access is denied.
> .
> --> Connect to SSIS Service on machine “ldqcedcmcache1” fail
ed:
> Access is denied.
> .
> Thanks Again.
> --
> MVP888
>
> "Michael Cheng [MSFT]" wrote:
>|||I was pleased to find this subject posted on the technet board, but somewhat
dissappointed in the resolution. I too am getting the exact error as posted
by the originator. I just CANNOT get connected to an installation of
Integration Services other than the one running on my machine (Developer
Edition).
Where do I specify that a Domain Group has access to the Integration
Services? I can go to the Database Engine and give the group rights on the
server, but that only applies to the Database Engine, not the Integration
Services.
Do I need to do like Brett Hargreaves pointed out and add the Domain Group
to the local server's administrator group. I like to think there is a better
solution that that.
**********************************[vbcol
=seagreen]
> Since the SSIS will only allow Windows Authentication, please make sure
> your Windows Account has sufficient privilege to SSIS.[/vbcol]
***********************************
Where do I go to make that happen?
Thank you in advance.
ToddC
"Michael Cheng [MSFT]" wrote:

> Hi,
>
> the
> itself.
> Only Microsoft Windows Authentication is available for SSIS. Windows
> Authentication mode allows a user to connect through a Windows user accoun
t.
> For more detailed information, check the BOL topic below
> Connect to Server (Integration Services)
> http://msdn2.microsoft.com/en-us/library/ms183366(en-US,SQL.90).aspx
>
> Since the SSIS will only allow Windows Authentication, please make sure
> your Windows Account has sufficient privilege to SSIS.
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
=============
> This posting is provided "AS IS" with no warranties, and confers no rights
.
>|||I've installed SQL2005 on my desktop, and have no problem connecting to "dat
abase engine" for databases, jobs etc, but when I try to connect to Integrat
ion Services from my desktop, I get the error:
Connect to SSIS Service on machine "SQL_TestServer" failed:
Access is denied.
I'm a member of sysadmin within SQL, as well as an administrator on the serv
er. I don't have any problem when I log on to the server directly via Remot
e Desktop and open IS. Am I missing something obvious ?

Integration Services log report pack - provided by Microsoft - US date format issue

Hello all,
Microsoft provides a report pack of RS reports to use with
Integration
Services standard logging.
The link is here
http://www.microsoft.com/downloads/details.aspx?FamilyID=526e1fce-7ad5-4a54-b62c-13ffcd114a73&DisplayLang=en#QuickInfoContainer
I have been trying to use these reports in the UK and have come
across
a problem with the date formatting. The reports seem to expect the
date formatting in the report parameters to be in US format. I have
changed all the report language settings to UK - English and the date
formatting in the datasets that supply the parameter values all use
ANSI dates (format 102), but I still get date conversion errors when
trying to return the datasets unless I input the dates in US format.
Any advice on how to get around this issue would be greatly
appreciated.
ThanksOn 26 Mar, 14:31, "weelin" <wee...@.gmail.com> wrote:
> Hello all,
> Microsoft provides a report pack of RS reports to use with
> Integration
> Services standard logging.
> The link is herehttp://www.microsoft.com/downloads/details.aspx?FamilyID=526e1fce-7ad...
> I have been trying to use these reports in the UK and have come
> across
> a problem with the date formatting. The reports seem to expect the
> date formatting in the report parameters to be in US format. I have
> changed all the report language settings to UK - English and the date
> formatting in the datasets that supply the parameter values all use
> ANSI dates (format 102), but I still get date conversion errors when
> trying to return the datasets unless I input the dates in US format.
> Any advice on how to get around this issue would be greatly
> appreciated.
> Thanks
As a follow-up, I have found that the only way to run the report is
via Internat Explorer browser AFTER setting the locale of the browser
to US-English so that it passes the date parameters in the correct
format. Obviously, this is not a practical solution, so if anyone has
found a proper solution, please let me know.
Thanks