Sql Server Alignment problem: sp3

Showing posts with label sp3. Show all posts

Monday, February 13, 2012

Allow access to IUSR_MachineName

In SQL 2000 SP3.
I was trying to follow this page:
http://support.microsoft.com/default.aspx?kbid=3D299987
It's not that I cannot follow it but that I'd prefer to have the accound = that will access the database be IUSR_MachineName. So I gave = IUSR_MachineName the ability to logon on to this database in SQL 2000 = and no other.
I get to the point in the article where it has this for the connection = string:
StrConnect =3D "Provider=3DSQLOLEDB.1;User = ID=3DIUSR_MachineName;Password=3D<strong password>;Initial = Catalog=3Dhesterlogin;" & _
"Network Library=3Ddbmssocn;Data Source=3DMyServer"
and now I am stuck. What do I assign for the password here? The = IUSR_MachineName password is automatically generated by my Internet = Informaion Services and I really do not know how to access it. All = attempts I have made in the past have been well less then satisfatory. = I suppose I could try it again (requires some Windows Scripting) but I'm = hoping there is a better or easier way. Any suggestions? Thanks.
-- George Hester
__________________________________George,
If I understand your question, you need to specify in the connection string
that you want to do a Windows login. There are examples of connection
strings at www.connectionstrings.com.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"George Hester" <hesterloli@.hotmail.com> wrote in message
news:ece5WeTwDHA.2308@.TK2MSFTNGP11.phx.gbl...
In SQL 2000 SP3.
I was trying to follow this page:
http://support.microsoft.com/default.aspx?kbid=299987
It's not that I cannot follow it but that I'd prefer to have the accound
that will access the database be IUSR_MachineName. So I gave
IUSR_MachineName the ability to logon on to this database in SQL 2000 and no
other.
I get to the point in the article where it has this for the connection
string:
StrConnect = "Provider=SQLOLEDB.1;User
ID=IUSR_MachineName;Password=<strong password>;Initial Catalog=hesterlogin;"
& _
"Network Library=dbmssocn;Data Source=MyServer"
and now I am stuck. What do I assign for the password here? The
IUSR_MachineName password is automatically generated by my Internet
Informaion Services and I really do not know how to access it. All attempts
I have made in the past have been well less then satisfatory. I suppose I
could try it again (requires some Windows Scripting) but I'm hoping there is
a better or easier way. Any suggestions? Thanks.
--
George Hester
__________________________________|||Ah maybe trusted? Let me check. Thanks.
-- George Hester
__________________________________
"Tibor Karaszi" =<tibor.please_reply_to_public_forum.karaszi@.cornerstone.se> wrote in =message news:Oy659LawDHA.1788@.tk2msftngp13.phx.gbl...
> George,
> > If I understand your question, you need to specify in the connection =string
> that you want to do a Windows login. There are examples of connection
> strings at www.connectionstrings.com.
> > -- > Tibor Karaszi, SQL Server MVP
> Archive at:
> =http://groups.google.com/groups?oi=3Ddjq&as_ugroup=3Dmicrosoft.public.sql=
server
> > > "George Hester" <hesterloli@.hotmail.com> wrote in message
> news:ece5WeTwDHA.2308@.TK2MSFTNGP11.phx.gbl...
> In SQL 2000 SP3.
> > I was trying to follow this page:
> > http://support.microsoft.com/default.aspx?kbid=3D299987
> > It's not that I cannot follow it but that I'd prefer to have the =accound
> that will access the database be IUSR_MachineName. So I gave
> IUSR_MachineName the ability to logon on to this database in SQL 2000 =and no
> other.
> > I get to the point in the article where it has this for the connection
> string:
> > > StrConnect =3D "Provider=3DSQLOLEDB.1;User
> ID=3DIUSR_MachineName;Password=3D<strong password>;Initial =Catalog=3Dhesterlogin;"
> & _
> "Network Library=3Ddbmssocn;Data Source=3DMyServer"
> > and now I am stuck. What do I assign for the password here? The
> IUSR_MachineName password is automatically generated by my Internet
> Informaion Services and I really do not know how to access it. All =attempts
> I have made in the past have been well less then satisfatory. I =suppose I
> could try it again (requires some Windows Scripting) but I'm hoping =there is
> a better or easier way. Any suggestions? Thanks.
> > -- > George Hester
> __________________________________
> >|||Actually I was hoping to use IUSR_MachineName for the Windows Logon =account. But I see I need to put a password in for the connection =string. As my IIS controls the IUSR_MachineName password I cannot =hardcode that into the connection string. That is my issue. What do I =put in for the password so that IIS can continue to automatically =generate the IUSR_MachineName account's password and use that in my =connection string? Thanks.
-- George Hester
__________________________________
"Tibor Karaszi" =<tibor.please_reply_to_public_forum.karaszi@.cornerstone.se> wrote in =message news:Oy659LawDHA.1788@.tk2msftngp13.phx.gbl...
> George,
> > If I understand your question, you need to specify in the connection =string
> that you want to do a Windows login. There are examples of connection
> strings at www.connectionstrings.com.
> > -- > Tibor Karaszi, SQL Server MVP
> Archive at:
> =http://groups.google.com/groups?oi=3Ddjq&as_ugroup=3Dmicrosoft.public.sql=
server
> > > "George Hester" <hesterloli@.hotmail.com> wrote in message
> news:ece5WeTwDHA.2308@.TK2MSFTNGP11.phx.gbl...
> In SQL 2000 SP3.
> > I was trying to follow this page:
> > http://support.microsoft.com/default.aspx?kbid=3D299987
> > It's not that I cannot follow it but that I'd prefer to have the =accound
> that will access the database be IUSR_MachineName. So I gave
> IUSR_MachineName the ability to logon on to this database in SQL 2000 =and no
> other.
> > I get to the point in the article where it has this for the connection
> string:
> > > StrConnect =3D "Provider=3DSQLOLEDB.1;User
> ID=3DIUSR_MachineName;Password=3D<strong password>;Initial =Catalog=3Dhesterlogin;"
> & _
> "Network Library=3Ddbmssocn;Data Source=3DMyServer"
> > and now I am stuck. What do I assign for the password here? The
> IUSR_MachineName password is automatically generated by my Internet
> Informaion Services and I really do not know how to access it. All =attempts
> I have made in the past have been well less then satisfatory. I =suppose I
> could try it again (requires some Windows Scripting) but I'm hoping =there is
> a better or easier way. Any suggestions? Thanks.
> > -- > George Hester
> __________________________________
> >

Thursday, February 9, 2012

All Inserts/Updates halted for a 1 minute time period. Looking for a reason why.

We are running SQL 2000 SP3. In looking at a SQL Trace, I noticed that for
a 1 minute time period - there were SQL statements that all finished within
about 10 milliseconds of each other. I immediately suspected blocking as
the culprit but I am 100% sure that blocking was not the cause (I had a
"blocker script" running continuously looking for blocking and nothing
showed up).
When I looked a little closer - I noticed that ALL of these 8 SQL statements
were either Inserting or Updating. All 8 SQL statements were each touching
different tables and were in very small units of work. In looking at the
READS, WRITES and CPU for each of these statements they were all very low.
Again - I have to emphasize there was no database blocking involved.
Furthermore - during this time period I was able to determine that of all
the ~ 6200 SQL statements that were started, these 8 SQL statements were the
only ones updating. All other SL statements were reading only.
This means that for a one-minute time period all Update/Insert activity was
"halted" (without database blocking occurring). Does anyone have an
explanation as to why this could have occurred? Could it be a problem with
cache or transaction log backup?
Also - wanted to indicate that the transaction log backup was not
interfering with this time period. I checked msdb.backupset and I can see
that this questionable time period did not coincide with any t-log backup.
Looking for some advice... Maybe there are some pertainant Perfmon
counters that I could enable?
Thanks in advance!Hi
If you were using sp_blocker_pss80 you may want to decrease the time in your
delay between calls.
You may also want to trace lock escalations, timeouts and deadlocks in
profiler along with events in the audit category such as backup/restore and
DBCC events. Also check out any file expansions in performance monitor.
John
"TJT" wrote:
> We are running SQL 2000 SP3. In looking at a SQL Trace, I noticed that for
> a 1 minute time period - there were SQL statements that all finished within
> about 10 milliseconds of each other. I immediately suspected blocking as
> the culprit but I am 100% sure that blocking was not the cause (I had a
> "blocker script" running continuously looking for blocking and nothing
> showed up).
> When I looked a little closer - I noticed that ALL of these 8 SQL statements
> were either Inserting or Updating. All 8 SQL statements were each touching
> different tables and were in very small units of work. In looking at the
> READS, WRITES and CPU for each of these statements they were all very low.
> Again - I have to emphasize there was no database blocking involved.
> Furthermore - during this time period I was able to determine that of all
> the ~ 6200 SQL statements that were started, these 8 SQL statements were the
> only ones updating. All other SL statements were reading only.
> This means that for a one-minute time period all Update/Insert activity was
> "halted" (without database blocking occurring). Does anyone have an
> explanation as to why this could have occurred? Could it be a problem with
> cache or transaction log backup?
> Also - wanted to indicate that the transaction log backup was not
> interfering with this time period. I checked msdb.backupset and I can see
> that this questionable time period did not coincide with any t-log backup.
> Looking for some advice... Maybe there are some pertainant Perfmon
> counters that I could enable?
> Thanks in advance!
>
>

All free memory gone...

Hi!
I am running MS SQL 2000 Ent sp3 + MS Windows 2000 Datacenter on a
server with 16Gb memory. Total available memory is typically ~200MB
and pretty stable. I use Max Server Memory of 15700MB. Today I could
see a very unusual behavior: the available memory gone from 200MB to
4MB in few seconds. I decreased the Max Server Memory by 200MB:
sp_configure [max server memory (MB)], 15500
reconfigure with override
go
It did not help much: it has 8MB available memory now. The server has
a lot of paging.
What is happening to the server?
Thanks.You should run Windows performance monitor and see who is using the
memory... It is in the processes section...
"Roust_m" <roustam@.hotbox.ru> wrote in message
news:a388fd78.0312010553.2bf2d450@.posting.google.com...
> Hi!
> I am running MS SQL 2000 Ent sp3 + MS Windows 2000 Datacenter on a
> server with 16Gb memory. Total available memory is typically ~200MB
> and pretty stable. I use Max Server Memory of 15700MB. Today I could
> see a very unusual behavior: the available memory gone from 200MB to
> 4MB in few seconds. I decreased the Max Server Memory by 200MB:
> sp_configure [max server memory (MB)], 15500
> reconfigure with override
> go
> It did not help much: it has 8MB available memory now. The server has
> a lot of paging.
> What is happening to the server?
> Thanks.|||AWE memory is not dynamic so changing max server memory won't have any
effect until you restart the service. You really need to leave more room for
the OS, try setting max server memory to 14 GB and monitoring its stability.
Also make sure the /3GB switch is not in boot.ini - just use the /PAE
switch. There is a fair bit of OS overhead in managing AWE memory so you
need to give the OS room to breathe.
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Roust_m" <roustam@.hotbox.ru> wrote in message
news:a388fd78.0312010553.2bf2d450@.posting.google.com...
Hi!
I am running MS SQL 2000 Ent sp3 + MS Windows 2000 Datacenter on a
server with 16Gb memory. Total available memory is typically ~200MB
and pretty stable. I use Max Server Memory of 15700MB. Today I could
see a very unusual behavior: the available memory gone from 200MB to
4MB in few seconds. I decreased the Max Server Memory by 200MB:
sp_configure [max server memory (MB)], 15500
reconfigure with override
go
It did not help much: it has 8MB available memory now. The server has
a lot of paging.
What is happening to the server?
Thanks.|||Performance monitor does not show processes that eat that much memory.
It does not show memory usage correctly with AWE enabled.
"Wayne Snyder" <wsnyder@.computeredservices.com> wrote in message news:<uZllf7BuDHA.3536@.tk2msftngp13.phx.gbl>...
> You should run Windows performance monitor and see who is using the
> memory... It is in the processes section...
>
> "Roust_m" <roustam@.hotbox.ru> wrote in message
> news:a388fd78.0312010553.2bf2d450@.posting.google.com...
> > Hi!
> >
> > I am running MS SQL 2000 Ent sp3 + MS Windows 2000 Datacenter on a
> > server with 16Gb memory. Total available memory is typically ~200MB
> > and pretty stable. I use Max Server Memory of 15700MB. Today I could
> > see a very unusual behavior: the available memory gone from 200MB to
> > 4MB in few seconds. I decreased the Max Server Memory by 200MB:
> >
> > sp_configure [max server memory (MB)], 15500
> > reconfigure with override
> > go
> >
> > It did not help much: it has 8MB available memory now. The server has
> > a lot of paging.
> >
> > What is happening to the server?
> >
> > Thanks.|||It did work fine for 3 months with 200MB available memory.
This article:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;274750
states that you need 1GB for OS only if you have 32+GB RAM:
"When you allocate SQL Server AWE memory on a 32 GB system, Windows
2000 may require at least 1 GB memory to manage AWE. "
As for /3G switch, I also seen an article stating that you need it for
up to 16GB RAM.
Anyway it did work fine...
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message news:<OFS92FEuDHA.3436@.tk2msftngp13.phx.gbl>...
> AWE memory is not dynamic so changing max server memory won't have any
> effect until you restart the service. You really need to leave more room for
> the OS, try setting max server memory to 14 GB and monitoring its stability.
> Also make sure the /3GB switch is not in boot.ini - just use the /PAE
> switch. There is a fair bit of OS overhead in managing AWE memory so you
> need to give the OS room to breathe.
> --
> HTH
> Jasper Smith (SQL Server MVP)
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Roust_m" <roustam@.hotbox.ru> wrote in message
> news:a388fd78.0312010553.2bf2d450@.posting.google.com...
> Hi!
> I am running MS SQL 2000 Ent sp3 + MS Windows 2000 Datacenter on a
> server with 16Gb memory. Total available memory is typically ~200MB
> and pretty stable. I use Max Server Memory of 15700MB. Today I could
> see a very unusual behavior: the available memory gone from 200MB to
> 4MB in few seconds. I decreased the Max Server Memory by 200MB:
> sp_configure [max server memory (MB)], 15500
> reconfigure with override
> go
> It did not help much: it has 8MB available memory now. The server has
> a lot of paging.
> What is happening to the server?
> Thanks.|||Windows 2000 Datacenter Server Does Not Locate Memory Greater Than 16 GB
http://support.microsoft.com/default.aspx?scid=kb;EN-US;292934
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message news:<OFS92FEuDHA.3436@.tk2msftngp13.phx.gbl>...
> AWE memory is not dynamic so changing max server memory won't have any
> effect until you restart the service. You really need to leave more room for
> the OS, try setting max server memory to 14 GB and monitoring its stability.
> Also make sure the /3GB switch is not in boot.ini - just use the /PAE
> switch. There is a fair bit of OS overhead in managing AWE memory so you
> need to give the OS room to breathe.
> --
> HTH
> Jasper Smith (SQL Server MVP)
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Roust_m" <roustam@.hotbox.ru> wrote in message
> news:a388fd78.0312010553.2bf2d450@.posting.google.com...
> Hi!
> I am running MS SQL 2000 Ent sp3 + MS Windows 2000 Datacenter on a
> server with 16Gb memory. Total available memory is typically ~200MB
> and pretty stable. I use Max Server Memory of 15700MB. Today I could
> see a very unusual behavior: the available memory gone from 200MB to
> 4MB in few seconds. I decreased the Max Server Memory by 200MB:
> sp_configure [max server memory (MB)], 15500
> reconfigure with override
> go
> It did not help much: it has 8MB available memory now. The server has
> a lot of paging.
> What is happening to the server?
> Thanks.

All DB maintenance plans fail

MS SQL 2000 SP3 on a Windows 2003 SP1 Server. Both SQL services are running
under an Administrator account. The database maintenance plans to backup
the server databases were also created when that account was logged onto the
server.
When I originally setup the maintenance plan backups with the wizard they
worked fine, but now they do not. I have repeatedly deleted them and tried
other domain admin accounts and local admin accounts without any luck. When
I review the log under the jobs it says access denied. I have attached the
DB Maintenace Plan......txt log data to show what it is recording.
===========================
Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
'DATABASE' as 'MYDOMAIN\Administrator' (trusted)
Starting maintenance plan 'DB Maintenance Plan' on 10/3/2006 9:06:04 AM
[1] Database Manufacturing Tracking: Check Data and Index Linkage...
** Execution Time: 0 hrs, 0 mins, 54 secs **
[2] Database Northwind: Check Data and Index Linkage...
** Execution Time: 0 hrs, 0 mins, 1 secs **
[3] Database pubs: Check Data and Index Linkage...
** Execution Time: 0 hrs, 0 mins, 1 secs **
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5070: [Microsoft][ODBC SQL
Server Driver][SQL Server]Database state cannot be changed while other users
are using the database 'QualityProposed'
[Microsoft][ODBC SQL Server Driver][SQL Server]ALTER DATABASE statement
failed.
[Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption command failed.
[4] Database QualityProposed: Check Data and Index Linkage...
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft][ODBC SQL
Server Driver][SQL Server]Repair statement not processed. Database needs to
be in single user mode.
The following errors were found:
[Microsoft][ODBC SQL Server Driver][SQL Server]Repair statement not
processed. Database needs to be in single user mode.
** Execution Time: 0 hrs, 0 mins, 1 secs **
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5070: [Microsoft][ODBC SQL
Server Driver][SQL Server]Database state cannot be changed while other users
are using the database 'QualityTracking'
[Microsoft][ODBC SQL Server Driver][SQL Server]ALTER DATABASE statement
failed.
[Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption command failed.
[5] Database QualityTracking: Check Data and Index Linkage...
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft][ODBC SQL
Server Driver][SQL Server]Repair statement not processed. Database needs to
be in single user mode.
The following errors were found:
[Microsoft][ODBC SQL Server Driver][SQL Server]Repair statement not
processed. Database needs to be in single user mode.
** Execution Time: 0 hrs, 0 mins, 1 secs **
[6] Database Manufacturing Tracking: Database Backup...
Destination: [\\.\Tape0]
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3279: [Microsoft][ODBC SQL
Server Driver][SQL Server]Access is denied due to a password failure
[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is
terminating abnormally.
[7] Database Northwind: Database Backup...
Destination: [\\.\Tape0]
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3279: [Microsoft][ODBC SQL
Server Driver][SQL Server]Access is denied due to a password failure
[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is
terminating abnormally.
[8] Database pubs: Database Backup...
Destination: [\\.\Tape0]
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3279: [Microsoft][ODBC SQL
Server Driver][SQL Server]Access is denied due to a password failure
[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is
terminating abnormally.
[9] Database QualityProposed: Database Backup...
The backup was not performed since data verification errors were found.
[10] Database QualityTracking: Database Backup...
The backup was not performed since data verification errors were found.
Deleting old text reports... 0 file(s) deleted.
End of maintenance plan 'DB Maintenance Plan' on 10/3/2006 9:08:02 AM
SQLMAINT.EXE Process Exit Code: 1 (Failed)Jordon,
Sounds like you are trying to put the database into single user mode which
it doesn't like.
Remove the Check Database Integrity option and you can run the Backup,
Re-index and re-calc stats elements in multi user mode.
Cheers
Andy
"Jordan" <none@.here.com> wrote in message
news:OjgzTJ05GHA.696@.TK2MSFTNGP06.phx.gbl...
> MS SQL 2000 SP3 on a Windows 2003 SP1 Server. Both SQL services are
> running under an Administrator account. The database maintenance plans to
> backup the server databases were also created when that account was logged
> onto the server.
> When I originally setup the maintenance plan backups with the wizard they
> worked fine, but now they do not. I have repeatedly deleted them and
> tried other domain admin accounts and local admin accounts without any
> luck. When I review the log under the jobs it says access denied. I have
> attached the DB Maintenace Plan......txt log data to show what it is
> recording.
>
> ===========================> Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
> 'DATABASE' as 'MYDOMAIN\Administrator' (trusted)
> Starting maintenance plan 'DB Maintenance Plan' on 10/3/2006 9:06:04 AM
> [1] Database Manufacturing Tracking: Check Data and Index Linkage...
> ** Execution Time: 0 hrs, 0 mins, 54 secs **
> [2] Database Northwind: Check Data and Index Linkage...
> ** Execution Time: 0 hrs, 0 mins, 1 secs **
> [3] Database pubs: Check Data and Index Linkage...
> ** Execution Time: 0 hrs, 0 mins, 1 secs **
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5070: [Microsoft][ODBC
> SQL Server Driver][SQL Server]Database state cannot be changed while other
> users are using the database 'QualityProposed'
> [Microsoft][ODBC SQL Server Driver][SQL Server]ALTER DATABASE statement
> failed.
> [Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption command failed.
> [4] Database QualityProposed: Check Data and Index Linkage...
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft][ODBC
> SQL Server Driver][SQL Server]Repair statement not processed. Database
> needs to be in single user mode.
> The following errors were found:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Repair statement not
> processed. Database needs to be in single user mode.
> ** Execution Time: 0 hrs, 0 mins, 1 secs **
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5070: [Microsoft][ODBC
> SQL Server Driver][SQL Server]Database state cannot be changed while other
> users are using the database 'QualityTracking'
> [Microsoft][ODBC SQL Server Driver][SQL Server]ALTER DATABASE statement
> failed.
> [Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption command failed.
> [5] Database QualityTracking: Check Data and Index Linkage...
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft][ODBC
> SQL Server Driver][SQL Server]Repair statement not processed. Database
> needs to be in single user mode.
> The following errors were found:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Repair statement not
> processed. Database needs to be in single user mode.
> ** Execution Time: 0 hrs, 0 mins, 1 secs **
> [6] Database Manufacturing Tracking: Database Backup...
> Destination: [\\.\Tape0]
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3279: [Microsoft][ODBC
> SQL Server Driver][SQL Server]Access is denied due to a password failure
> [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is
> terminating abnormally.
> [7] Database Northwind: Database Backup...
> Destination: [\\.\Tape0]
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3279: [Microsoft][ODBC
> SQL Server Driver][SQL Server]Access is denied due to a password failure
> [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is
> terminating abnormally.
> [8] Database pubs: Database Backup...
> Destination: [\\.\Tape0]
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3279: [Microsoft][ODBC
> SQL Server Driver][SQL Server]Access is denied due to a password failure
> [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is
> terminating abnormally.
> [9] Database QualityProposed: Database Backup...
> The backup was not performed since data verification errors were found.
> [10] Database QualityTracking: Database Backup...
> The backup was not performed since data verification errors were found.
> Deleting old text reports... 0 file(s) deleted.
> End of maintenance plan 'DB Maintenance Plan' on 10/3/2006 9:08:02 AM
> SQLMAINT.EXE Process Exit Code: 1 (Failed)
>|||I have also tried to break up all the actions into single jobs. For
instance on the backups I had the maintenance schedule just backup the
non-system databases at 2 in the morning and they still failed.
"Andrew Copeland" <andycuk@.community.nospam> wrote in message
news:%23oH4ud05GHA.4608@.TK2MSFTNGP03.phx.gbl...
> Jordon,
> Sounds like you are trying to put the database into single user mode which
> it doesn't like.
> Remove the Check Database Integrity option and you can run the Backup,
> Re-index and re-calc stats elements in multi user mode.
> Cheers
> Andy
> "Jordan" <none@.here.com> wrote in message
> news:OjgzTJ05GHA.696@.TK2MSFTNGP06.phx.gbl...
>> MS SQL 2000 SP3 on a Windows 2003 SP1 Server. Both SQL services are
>> running under an Administrator account. The database maintenance plans
>> to backup the server databases were also created when that account was
>> logged onto the server.
>> When I originally setup the maintenance plan backups with the wizard they
>> worked fine, but now they do not. I have repeatedly deleted them and
>> tried other domain admin accounts and local admin accounts without any
>> luck. When I review the log under the jobs it says access denied. I
>> have attached the DB Maintenace Plan......txt log data to show what it
>> is recording.
>>
>> ===========================>> Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
>> 'DATABASE' as 'MYDOMAIN\Administrator' (trusted)
>> Starting maintenance plan 'DB Maintenance Plan' on 10/3/2006 9:06:04 AM
>> [1] Database Manufacturing Tracking: Check Data and Index Linkage...
>> ** Execution Time: 0 hrs, 0 mins, 54 secs **
>> [2] Database Northwind: Check Data and Index Linkage...
>> ** Execution Time: 0 hrs, 0 mins, 1 secs **
>> [3] Database pubs: Check Data and Index Linkage...
>> ** Execution Time: 0 hrs, 0 mins, 1 secs **
>> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5070: [Microsoft][ODBC
>> SQL Server Driver][SQL Server]Database state cannot be changed while
>> other users are using the database 'QualityProposed'
>> [Microsoft][ODBC SQL Server Driver][SQL Server]ALTER DATABASE statement
>> failed.
>> [Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption command
>> failed.
>> [4] Database QualityProposed: Check Data and Index Linkage...
>> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft][ODBC
>> SQL Server Driver][SQL Server]Repair statement not processed. Database
>> needs to be in single user mode.
>> The following errors were found:
>> [Microsoft][ODBC SQL Server Driver][SQL Server]Repair statement not
>> processed. Database needs to be in single user mode.
>> ** Execution Time: 0 hrs, 0 mins, 1 secs **
>> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5070: [Microsoft][ODBC
>> SQL Server Driver][SQL Server]Database state cannot be changed while
>> other users are using the database 'QualityTracking'
>> [Microsoft][ODBC SQL Server Driver][SQL Server]ALTER DATABASE statement
>> failed.
>> [Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption command
>> failed.
>> [5] Database QualityTracking: Check Data and Index Linkage...
>> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft][ODBC
>> SQL Server Driver][SQL Server]Repair statement not processed. Database
>> needs to be in single user mode.
>> The following errors were found:
>> [Microsoft][ODBC SQL Server Driver][SQL Server]Repair statement not
>> processed. Database needs to be in single user mode.
>> ** Execution Time: 0 hrs, 0 mins, 1 secs **
>> [6] Database Manufacturing Tracking: Database Backup...
>> Destination: [\\.\Tape0]
>> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3279: [Microsoft][ODBC
>> SQL Server Driver][SQL Server]Access is denied due to a password failure
>> [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is
>> terminating abnormally.
>> [7] Database Northwind: Database Backup...
>> Destination: [\\.\Tape0]
>> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3279: [Microsoft][ODBC
>> SQL Server Driver][SQL Server]Access is denied due to a password failure
>> [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is
>> terminating abnormally.
>> [8] Database pubs: Database Backup...
>> Destination: [\\.\Tape0]
>> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3279: [Microsoft][ODBC
>> SQL Server Driver][SQL Server]Access is denied due to a password failure
>> [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is
>> terminating abnormally.
>> [9] Database QualityProposed: Database Backup...
>> The backup was not performed since data verification errors were
>> found.
>> [10] Database QualityTracking: Database Backup...
>> The backup was not performed since data verification errors were
>> found.
>> Deleting old text reports... 0 file(s) deleted.
>> End of maintenance plan 'DB Maintenance Plan' on 10/3/2006 9:08:02 AM
>> SQLMAINT.EXE Process Exit Code: 1 (Failed)
>>
>|||Jordon,
Your order database is still in use so you really need to ensure that all
actions are stopped as the ALTER DATABASE command issued here needs to
change the database into single user mode.
Can you check the monitor to see what is using the database out of hours?
Regards
Andy
"Jordan" <none@.here.com> wrote in message
news:e4YwwaB6GHA.3732@.TK2MSFTNGP05.phx.gbl...
>I have also tried to break up all the actions into single jobs. For
>instance on the backups I had the maintenance schedule just backup the
>non-system databases at 2 in the morning and they still failed.
>
> "Andrew Copeland" <andycuk@.community.nospam> wrote in message
> news:%23oH4ud05GHA.4608@.TK2MSFTNGP03.phx.gbl...
>> Jordon,
>> Sounds like you are trying to put the database into single user mode
>> which it doesn't like.
>> Remove the Check Database Integrity option and you can run the Backup,
>> Re-index and re-calc stats elements in multi user mode.
>> Cheers
>> Andy
>> "Jordan" <none@.here.com> wrote in message
>> news:OjgzTJ05GHA.696@.TK2MSFTNGP06.phx.gbl...
>> MS SQL 2000 SP3 on a Windows 2003 SP1 Server. Both SQL services are
>> running under an Administrator account. The database maintenance plans
>> to backup the server databases were also created when that account was
>> logged onto the server.
>> When I originally setup the maintenance plan backups with the wizard
>> they worked fine, but now they do not. I have repeatedly deleted them
>> and tried other domain admin accounts and local admin accounts without
>> any luck. When I review the log under the jobs it says access denied.
>> I have attached the DB Maintenace Plan......txt log data to show what
>> it is recording.
>>
>> ===========================>> Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL
>> Server 'DATABASE' as 'MYDOMAIN\Administrator' (trusted)
>> Starting maintenance plan 'DB Maintenance Plan' on 10/3/2006 9:06:04 AM
>> [1] Database Manufacturing Tracking: Check Data and Index Linkage...
>> ** Execution Time: 0 hrs, 0 mins, 54 secs **
>> [2] Database Northwind: Check Data and Index Linkage...
>> ** Execution Time: 0 hrs, 0 mins, 1 secs **
>> [3] Database pubs: Check Data and Index Linkage...
>> ** Execution Time: 0 hrs, 0 mins, 1 secs **
>> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5070: [Microsoft][ODBC
>> SQL Server Driver][SQL Server]Database state cannot be changed while
>> other users are using the database 'QualityProposed'
>> [Microsoft][ODBC SQL Server Driver][SQL Server]ALTER DATABASE statement
>> failed.
>> [Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption command
>> failed.
>> [4] Database QualityProposed: Check Data and Index Linkage...
>> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft][ODBC
>> SQL Server Driver][SQL Server]Repair statement not processed. Database
>> needs to be in single user mode.
>> The following errors were found:
>> [Microsoft][ODBC SQL Server Driver][SQL Server]Repair statement not
>> processed. Database needs to be in single user mode.
>> ** Execution Time: 0 hrs, 0 mins, 1 secs **
>> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5070: [Microsoft][ODBC
>> SQL Server Driver][SQL Server]Database state cannot be changed while
>> other users are using the database 'QualityTracking'
>> [Microsoft][ODBC SQL Server Driver][SQL Server]ALTER DATABASE statement
>> failed.
>> [Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption command
>> failed.
>> [5] Database QualityTracking: Check Data and Index Linkage...
>> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft][ODBC
>> SQL Server Driver][SQL Server]Repair statement not processed. Database
>> needs to be in single user mode.
>> The following errors were found:
>> [Microsoft][ODBC SQL Server Driver][SQL Server]Repair statement not
>> processed. Database needs to be in single user mode.
>> ** Execution Time: 0 hrs, 0 mins, 1 secs **
>> [6] Database Manufacturing Tracking: Database Backup...
>> Destination: [\\.\Tape0]
>> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3279: [Microsoft][ODBC
>> SQL Server Driver][SQL Server]Access is denied due to a password failure
>> [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is
>> terminating abnormally.
>> [7] Database Northwind: Database Backup...
>> Destination: [\\.\Tape0]
>> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3279: [Microsoft][ODBC
>> SQL Server Driver][SQL Server]Access is denied due to a password failure
>> [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is
>> terminating abnormally.
>> [8] Database pubs: Database Backup...
>> Destination: [\\.\Tape0]
>> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3279: [Microsoft][ODBC
>> SQL Server Driver][SQL Server]Access is denied due to a password failure
>> [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is
>> terminating abnormally.
>> [9] Database QualityProposed: Database Backup...
>> The backup was not performed since data verification errors were
>> found.
>> [10] Database QualityTracking: Database Backup...
>> The backup was not performed since data verification errors were
>> found.
>> Deleting old text reports... 0 file(s) deleted.
>> End of maintenance plan 'DB Maintenance Plan' on 10/3/2006 9:08:02 AM
>> SQLMAINT.EXE Process Exit Code: 1 (Failed)
>>
>>
>|||I managed to track it down to the owner name on the tasks being
Administrator@.mydomain.com rather than MYDOMAIN\Administror.
The funny thing is that the services start as MYDOMAIN\Administrator and I
log in as that to manage maintenace plans but the individual tasks in the
plan all have that @.mydomain.com user. Changing these to the x\x format
took care of the problem
Thanks .
"Andrew Copeland" <andycuk@.community.nospam> wrote in message
news:eUkdSfT6GHA.4132@.TK2MSFTNGP05.phx.gbl...
> Jordon,
> Your order database is still in use so you really need to ensure that all
> actions are stopped as the ALTER DATABASE command issued here needs to
> change the database into single user mode.
> Can you check the monitor to see what is using the database out of hours?
> Regards
> Andy
> "Jordan" <none@.here.com> wrote in message
> news:e4YwwaB6GHA.3732@.TK2MSFTNGP05.phx.gbl...
>>I have also tried to break up all the actions into single jobs. For
>>instance on the backups I had the maintenance schedule just backup the
>>non-system databases at 2 in the morning and they still failed.
>>
>> "Andrew Copeland" <andycuk@.community.nospam> wrote in message
>> news:%23oH4ud05GHA.4608@.TK2MSFTNGP03.phx.gbl...
>> Jordon,
>> Sounds like you are trying to put the database into single user mode
>> which it doesn't like.
>> Remove the Check Database Integrity option and you can run the Backup,
>> Re-index and re-calc stats elements in multi user mode.
>> Cheers
>> Andy
>> "Jordan" <none@.here.com> wrote in message
>> news:OjgzTJ05GHA.696@.TK2MSFTNGP06.phx.gbl...
>> MS SQL 2000 SP3 on a Windows 2003 SP1 Server. Both SQL services are
>> running under an Administrator account. The database maintenance plans
>> to backup the server databases were also created when that account was
>> logged onto the server.
>> When I originally setup the maintenance plan backups with the wizard
>> they worked fine, but now they do not. I have repeatedly deleted them
>> and tried other domain admin accounts and local admin accounts without
>> any luck. When I review the log under the jobs it says access denied.
>> I have attached the DB Maintenace Plan......txt log data to show what
>> it is recording.
>>
>> ===========================>> Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL
>> Server 'DATABASE' as 'MYDOMAIN\Administrator' (trusted)
>> Starting maintenance plan 'DB Maintenance Plan' on 10/3/2006 9:06:04 AM
>> [1] Database Manufacturing Tracking: Check Data and Index Linkage...
>> ** Execution Time: 0 hrs, 0 mins, 54 secs **
>> [2] Database Northwind: Check Data and Index Linkage...
>> ** Execution Time: 0 hrs, 0 mins, 1 secs **
>> [3] Database pubs: Check Data and Index Linkage...
>> ** Execution Time: 0 hrs, 0 mins, 1 secs **
>> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5070: [Microsoft][ODBC
>> SQL Server Driver][SQL Server]Database state cannot be changed while
>> other users are using the database 'QualityProposed'
>> [Microsoft][ODBC SQL Server Driver][SQL Server]ALTER DATABASE statement
>> failed.
>> [Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption command
>> failed.
>> [4] Database QualityProposed: Check Data and Index Linkage...
>> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft][ODBC
>> SQL Server Driver][SQL Server]Repair statement not processed. Database
>> needs to be in single user mode.
>> The following errors were found:
>> [Microsoft][ODBC SQL Server Driver][SQL Server]Repair statement not
>> processed. Database needs to be in single user mode.
>> ** Execution Time: 0 hrs, 0 mins, 1 secs **
>> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 5070: [Microsoft][ODBC
>> SQL Server Driver][SQL Server]Database state cannot be changed while
>> other users are using the database 'QualityTracking'
>> [Microsoft][ODBC SQL Server Driver][SQL Server]ALTER DATABASE statement
>> failed.
>> [Microsoft][ODBC SQL Server Driver][SQL Server]sp_dboption command
>> failed.
>> [5] Database QualityTracking: Check Data and Index Linkage...
>> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft][ODBC
>> SQL Server Driver][SQL Server]Repair statement not processed. Database
>> needs to be in single user mode.
>> The following errors were found:
>> [Microsoft][ODBC SQL Server Driver][SQL Server]Repair statement not
>> processed. Database needs to be in single user mode.
>> ** Execution Time: 0 hrs, 0 mins, 1 secs **
>> [6] Database Manufacturing Tracking: Database Backup...
>> Destination: [\\.\Tape0]
>> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3279: [Microsoft][ODBC
>> SQL Server Driver][SQL Server]Access is denied due to a password
>> failure
>> [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is
>> terminating abnormally.
>> [7] Database Northwind: Database Backup...
>> Destination: [\\.\Tape0]
>> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3279: [Microsoft][ODBC
>> SQL Server Driver][SQL Server]Access is denied due to a password
>> failure
>> [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is
>> terminating abnormally.
>> [8] Database pubs: Database Backup...
>> Destination: [\\.\Tape0]
>> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3279: [Microsoft][ODBC
>> SQL Server Driver][SQL Server]Access is denied due to a password
>> failure
>> [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is
>> terminating abnormally.
>> [9] Database QualityProposed: Database Backup...
>> The backup was not performed since data verification errors were
>> found.
>> [10] Database QualityTracking: Database Backup...
>> The backup was not performed since data verification errors were
>> found.
>> Deleting old text reports... 0 file(s) deleted.
>> End of maintenance plan 'DB Maintenance Plan' on 10/3/2006 9:08:02 AM
>> SQLMAINT.EXE Process Exit Code: 1 (Failed)
>>
>>
>>
>

Monday, February 13, 2012

Allow access to IUSR_MachineName

Thursday, February 9, 2012

All Inserts/Updates halted for a 1 minute time period. Looking for a reason why.

All free memory gone...

All DB maintenance plans fail

All DB maintenance plans fail

All DB maintenance plans fail

Sql Server Alignment problem

Blog Archive

About Me