Counter settings: win2k

Showing posts with label win2k. Show all posts

Monday, March 19, 2012

could not obtain information about...

I am getting the following message in my event logs since hitting windows up
date and installing, among others SP4 for win2k.
"SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'Michaels B
ackup Plan'' (0x8E4169EC6E0A93468357CC016A8A9186) - Status: Failed - Invoked
on: 2004-01-19 02:00:00 - Message: The job failed. Unable to determine if
the owner (MYSERVER\mylogin) of job DB Backup Job for DB Maintenance Plan 'M
ichaels Backup Plan' has server access (reason: Could not obtain information
about Windows NT group/user 'MYSERVER\mylogin'. [SQLSTATE 42000] (Error 819
8))."
the only thing that changed was the updates, which can be significant but I
certainly didn't change anything related to my account. I have recreated th
e plan with the same result.
I can open the LOGON section of SQLadmin and see my name there, I can open i
t and close it but if I try to make any changes it says messages similar to
the above on.
KB articles suggested ading the everyone group to the pre2000 users group bu
t that sounds dangerous.
Help? what else can I look at. I am the sysop and should have all the necess
ary rightsIn message <eoafD3t3DHA.2556@.TK2MSFTNGP10.phx.gbl>, mmac <no@.thanks.com>
writes

quote:

>I am getting the following message in my event logs since hitting windows
>update_and installing, among others _SP4 for win2k.
>"SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan
>'Michaels Backup Plan'' (0x8E4169EC6E0A93468357CC016A8A9186) -
>Status: Failed - Invoked on: 2004-01-19 02:00:00 - Message: The job
>failed._ Unable to determine if the owner (MYSERVER\mylogin) of job DB
>Backup Job for DB Maintenance Plan 'Michaels Backup Plan' has server
>access (reason: Could not obtain information about Windows NT
>group/user 'MYSERVER\mylogin'. [SQLSTATE 42000] (Error 8198))."
>the only thing that changed was the updates, which can be significant but
>_I certainly didn't change anything related to my account. I have recreated
>the plan with the same result.
>I can open the LOGON section of SQLadmin and see my name there, I
>can open it and close it but if I try to make any changes it says messages
>similar to the above on.
>KB articles suggested ading the everyone group to the pre2000 users
>group but that sounds dangerous.
>Help? what else can I look at. I am the sysop and should have all the
>necessary rights

I assume you have seen KB 241643, but have you tried the first
workaround "Change the job owner to a standard SQL Server user or system
administrator (sa)."? I have read this many times, and the second option
has never worked for me, so I go straight for option 1. I suspect there
may be other causes, perhaps network issues between SQL and the DC.
PRB: 8198 Error Message Returned from Job Owned by Windows NT
Authenticated User
http://support.microsoft.com?kbid=241643
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com
PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org|||"Darren Green" <darren.green@.reply-to-newsgroup-sqldts.com> wrote in message
news:7r2qD3R8WFEAFwOw@.sqldts.com...

quote:

> In message <eoafD3t3DHA.2556@.TK2MSFTNGP10.phx.gbl>, mmac <no@.thanks.com>
> writes
recreated[QUOTE]
messages[QUOTE]
> I assume you have seen KB 241643, but have you tried the first
> workaround "Change the job owner to a standard SQL Server user or system
> administrator (sa)."? I have read this many times, and the second option
> has never worked for me, so I go straight for option 1. I suspect there
> may be other causes, perhaps network issues between SQL and the DC.
> PRB: 8198 Error Message Returned from Job Owned by Windows NT
> Authenticated User
> http://support.microsoft.com?kbid=241643
>
> --
> Darren Green (SQL Server MVP)
> DTS - http://www.sqldts.com
> PASS - the definitive, global community for SQL Server professionals
> http://www.sqlpass.org
>

|||Lets try that again.
I saw the KB article and I couldn't make option 2 work either so that is
encouraging :-?
The DC and the SQL server are the same machine so comms shouldn't be an
issue.
I'll try creating a new backup plan under sa but could you tell me what a
"Standard Sql Server User " is?
"Darren Green" <darren.green@.reply-to-newsgroup-sqldts.com> wrote in message
news:7r2qD3R8WFEAFwOw@.sqldts.com...

quote:

> In message <eoafD3t3DHA.2556@.TK2MSFTNGP10.phx.gbl>, mmac <no@.thanks.com>
> writes
recreated[QUOTE]
messages[QUOTE]
> I assume you have seen KB 241643, but have you tried the first
> workaround "Change the job owner to a standard SQL Server user or system
> administrator (sa)."? I have read this many times, and the second option
> has never worked for me, so I go straight for option 1. I suspect there
> may be other causes, perhaps network issues between SQL and the DC.
> PRB: 8198 Error Message Returned from Job Owned by Windows NT
> Authenticated User
> http://support.microsoft.com?kbid=241643
>
> --
> Darren Green (SQL Server MVP)
> DTS - http://www.sqldts.com
> PASS - the definitive, global community for SQL Server professionals
> http://www.sqlpass.org
>

|||In message <u1fxN$d4DHA.2612@.tk2msftngp13.phx.gbl>, mmac <no@.thanks.com>
writes

quote:

>Lets try that again.
>I saw the KB article and I couldn't make option 2 work either so that is
>encouraging :-?
>The DC and the SQL server are the same machine so comms shouldn't be an
>issue.
>I'll try creating a new backup plan under sa but could you tell me what a
>"Standard Sql Server User " is?
>

A standard SQL Server user, or SQL (Server) login, is what you use as
opposed to and integrated or NT authentication login. This option is
only available if the server is set to Mixed Mode security.
sa is a SQL login, but BUILTIN\Administrators is a integrated login.
Make sense?
Darren

quote:

>"Darren Green" <darren.green@.reply-to-newsgroup-sqldts.com> wrote in messag
e
>news:7r2qD3R8WFEAFwOw@.sqldts.com...
>recreated
>messages
>

Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com
PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Wednesday, March 7, 2012

Could not find server '<server ip address here>' in sysservers.

Hi There,
I am planning on migrating databases from SQL 7 on a WIN2K box to SQL 2000 on a WIN 2003 box. Both are different domains. I have set up several databases to test and most work fine except for some .NET applications where I get this error spasmodically:
Could not find server '<server ip address here>' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.
Im using the IP address of the server in the db connection string. In Master db > sysserver table the server name is VIVID01 and there is no mention of IP address.
Is there a reason why this error occurs only for some of the databases?
thanks - matt.Can you show us which exact statement is failing? Are you trying to use the
4-part naming convention to connect from one server to another. In that
case, you will have to configure that other server as a linked server.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Matt" <Matt@.discussions.microsoft.com> wrote in message
news:5B8A7E57-322A-4674-A95B-1DDC9281DD6A@.microsoft.com...
Hi There,
I am planning on migrating databases from SQL 7 on a WIN2K box to SQL 2000
on a WIN 2003 box. Both are different domains. I have set up several
databases to test and most work fine except for some .NET applications where
I get this error spasmodically:
Could not find server '<server ip address here>' in sysservers. Execute
sp_addlinkedserver to add the server to sysservers.
Im using the IP address of the server in the db connection string. In Master
db > sysserver table the server name is VIVID01 and there is no mention of
IP address.
Is there a reason why this error occurs only for some of the databases?
thanks - matt.|||The statement is:
SELECT * FROM OPENQUERY([<ipaddresshere>],'CCI.dbo.p_GetCMSGroupsByContentID "6918"') WHERE ID = 6
We have used the IP address instead of the server name.
This only fails when using the OPENQUERY statement. If I add a server using sp_addlinkedserver with the IP address specified it works.
"Narayana Vyas Kondreddi" wrote:
> Can you show us which exact statement is failing? Are you trying to use the
> 4-part naming convention to connect from one server to another. In that
> case, you will have to configure that other server as a linked server.
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
>
> "Matt" <Matt@.discussions.microsoft.com> wrote in message
> news:5B8A7E57-322A-4674-A95B-1DDC9281DD6A@.microsoft.com...
> Hi There,
> I am planning on migrating databases from SQL 7 on a WIN2K box to SQL 2000
> on a WIN 2003 box. Both are different domains. I have set up several
> databases to test and most work fine except for some .NET applications where
> I get this error spasmodically:
> Could not find server '<server ip address here>' in sysservers. Execute
> sp_addlinkedserver to add the server to sysservers.
> Im using the IP address of the server in the db connection string. In Master
> db > sysserver table the server name is VIVID01 and there is no mention of
> IP address.
> Is there a reason why this error occurs only for some of the databases?
> thanks - matt.
>
>

Could not find server '<server ip address here>' in sysservers.

Friday, February 17, 2012

Corruption Problem- need some advice

Hi all,
we have been using SQL7 for a number of years on a Win2K box without so much
as one hiccup. Recently went out bought a new HP Server and SQL2000.
Installed it all, moved all the databases - and everything seemed to be
working fine.
A couple of weeks ago we had a problem with our biggest database (about 1gb
in size). Users were getting some errors from the app that uses it. I did a
DBCC CHECKDB on that database and it was coming up with almost 1000
inconsistencies etc etc. Tried Repair, to no avail and in the end just had
to Restore form backup - lost about a half a days work - not critical for
us.
Spoke to a few DBA's who said that it sounded Hardware related. Spoke to our
local IT support who we got the HP's from and they did a quick look and
everything came up OK.
A couple of days ago the same problem occurred. At a loss to explain what is
happening, so I'm hoping a few of you may be able to help.
One thing I did notice was that Write Cache was set on the server to 50%
Read 50% Write. I have only now changed it to 100% and No Write caching.
Could the above have caused it (50% Read 50% Write), or is it more than
likely I could have further corruption ? We haven't , I believe, had any
power outages or system crashes leading up to these corruptions.
Any help you could give me would be greatly appreciated.
cheers,
Adam
Adam,
While it's quite possible that you are hitting some SQL bug which corrupts
your database, it is far more likely that you may have some hardware or
driver related problem on that server. I would advise you to install the
latest SQL hotfix and update all your firmware and drivers. If you have
enabled /PAE in BOOT.INI then apply the PAE fix Q838765. Also review your
event logs in detail for ANY hardware-related errors and warnings. Use
SQLIOSTRESS to try to flush out I/O problems.
Going to the latest SQL build (i.e. 1007 or higher) will fix all known SQL
corruption bugs, but also enable new SQL Server I/O auditing features, such
as detection for stale read and lost writes, and perform consistency checks
on all pages read from the disk. Check all your database for corruption
before applying the hotfix. Then enable trace flags -T818 and -T806.
Lastly, the following articles contain more information about SQL I/O
requirements and how hardware problems may lead to corruption.
http://support.microsoft.com/kb/841776
http://support.microsoft.com/kb/826433
http://support.microsoft.com/kb/231619
http://www.microsoft.com/technet/pro...lIObasics.mspx
Adrian
"acs68" <adamst@.NOSPAMlaidley.qld.gov.au> wrote in message
news:eGuhUzPUFHA.2056@.tk2msftngp13.phx.gbl...
> Hi all,
> we have been using SQL7 for a number of years on a Win2K box without so
> much as one hiccup. Recently went out bought a new HP Server and SQL2000.
> Installed it all, moved all the databases - and everything seemed to be
> working fine.
> A couple of weeks ago we had a problem with our biggest database (about
> 1gb in size). Users were getting some errors from the app that uses it. I
> did a DBCC CHECKDB on that database and it was coming up with almost 1000
> inconsistencies etc etc. Tried Repair, to no avail and in the end just had
> to Restore form backup - lost about a half a days work - not critical for
> us.
> Spoke to a few DBA's who said that it sounded Hardware related. Spoke to
> our local IT support who we got the HP's from and they did a quick look
> and everything came up OK.
> A couple of days ago the same problem occurred. At a loss to explain what
> is happening, so I'm hoping a few of you may be able to help.
> One thing I did notice was that Write Cache was set on the server to 50%
> Read 50% Write. I have only now changed it to 100% and No Write caching.
> Could the above have caused it (50% Read 50% Write), or is it more than
> likely I could have further corruption ? We haven't , I believe, had any
> power outages or system crashes leading up to these corruptions.
> Any help you could give me would be greatly appreciated.
> cheers,
> Adam
>
|||Thanks for that advice Adrian, will look into it now.
cheers,
Adam
"Adrian Zajkeskovic" <azajkeskovic@.hotmail.com> wrote in message
news:Wp-dnacXw-zo4-TfRVn-3A@.rogers.com...
> Adam,
> While it's quite possible that you are hitting some SQL bug which corrupts
> your database, it is far more likely that you may have some hardware or
> driver related problem on that server. I would advise you to install the
> latest SQL hotfix and update all your firmware and drivers. If you have
> enabled /PAE in BOOT.INI then apply the PAE fix Q838765. Also review your
> event logs in detail for ANY hardware-related errors and warnings. Use
> SQLIOSTRESS to try to flush out I/O problems.
> Going to the latest SQL build (i.e. 1007 or higher) will fix all known SQL
> corruption bugs, but also enable new SQL Server I/O auditing features,
> such as detection for stale read and lost writes, and perform consistency
> checks on all pages read from the disk. Check all your database for
> corruption before applying the hotfix. Then enable trace flags -T818
> and -T806.
> Lastly, the following articles contain more information about SQL I/O
> requirements and how hardware problems may lead to corruption.
> http://support.microsoft.com/kb/841776
> http://support.microsoft.com/kb/826433
> http://support.microsoft.com/kb/231619
> http://www.microsoft.com/technet/pro...lIObasics.mspx
> Adrian
>
>
> "acs68" <adamst@.NOSPAMlaidley.qld.gov.au> wrote in message
> news:eGuhUzPUFHA.2056@.tk2msftngp13.phx.gbl...
>

Corruption Problem- need some advice

Hi all,
we have been using SQL7 for a number of years on a Win2K box without so much
as one hiccup. Recently went out bought a new HP Server and SQL2000.
Installed it all, moved all the databases - and everything seemed to be
working fine.
A couple of weeks ago we had a problem with our biggest database (about 1gb
in size). Users were getting some errors from the app that uses it. I did a
DBCC CHECKDB on that database and it was coming up with almost 1000
inconsistencies etc etc. Tried Repair, to no avail and in the end just had
to Restore form backup - lost about a half a days work - not critical for
us.
Spoke to a few DBA's who said that it sounded Hardware related. Spoke to our
local IT support who we got the HP's from and they did a quick look and
everything came up OK.
A couple of days ago the same problem occurred. At a loss to explain what is
happening, so I'm hoping a few of you may be able to help.
One thing I did notice was that Write Cache was set on the server to 50%
Read 50% Write. I have only now changed it to 100% and No Write caching.
Could the above have caused it (50% Read 50% Write), or is it more than
likely I could have further corruption ? We haven't , I believe, had any
power outages or system crashes leading up to these corruptions.
Any help you could give me would be greatly appreciated.
cheers,
AdamAdam,
While it's quite possible that you are hitting some SQL bug which corrupts
your database, it is far more likely that you may have some hardware or
driver related problem on that server. I would advise you to install the
latest SQL hotfix and update all your firmware and drivers. If you have
enabled /PAE in BOOT.INI then apply the PAE fix Q838765. Also review your
event logs in detail for ANY hardware-related errors and warnings. Use
SQLIOSTRESS to try to flush out I/O problems.
Going to the latest SQL build (i.e. 1007 or higher) will fix all known SQL
corruption bugs, but also enable new SQL Server I/O auditing features, such
as detection for stale read and lost writes, and perform consistency checks
on all pages read from the disk. Check all your database for corruption
before applying the hotfix. Then enable trace flags -T818 and -T806.
Lastly, the following articles contain more information about SQL I/O
requirements and how hardware problems may lead to corruption.
http://support.microsoft.com/kb/841776
http://support.microsoft.com/kb/826433
http://support.microsoft.com/kb/231619
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlIObasics.mspx
Adrian
"acs68" <adamst@.NOSPAMlaidley.qld.gov.au> wrote in message
news:eGuhUzPUFHA.2056@.tk2msftngp13.phx.gbl...
> Hi all,
> we have been using SQL7 for a number of years on a Win2K box without so
> much as one hiccup. Recently went out bought a new HP Server and SQL2000.
> Installed it all, moved all the databases - and everything seemed to be
> working fine.
> A couple of weeks ago we had a problem with our biggest database (about
> 1gb in size). Users were getting some errors from the app that uses it. I
> did a DBCC CHECKDB on that database and it was coming up with almost 1000
> inconsistencies etc etc. Tried Repair, to no avail and in the end just had
> to Restore form backup - lost about a half a days work - not critical for
> us.
> Spoke to a few DBA's who said that it sounded Hardware related. Spoke to
> our local IT support who we got the HP's from and they did a quick look
> and everything came up OK.
> A couple of days ago the same problem occurred. At a loss to explain what
> is happening, so I'm hoping a few of you may be able to help.
> One thing I did notice was that Write Cache was set on the server to 50%
> Read 50% Write. I have only now changed it to 100% and No Write caching.
> Could the above have caused it (50% Read 50% Write), or is it more than
> likely I could have further corruption ? We haven't , I believe, had any
> power outages or system crashes leading up to these corruptions.
> Any help you could give me would be greatly appreciated.
> cheers,
> Adam
>|||Thanks for that advice Adrian, will look into it now.
cheers,
Adam
"Adrian Zajkeskovic" <azajkeskovic@.hotmail.com> wrote in message
news:Wp-dnacXw-zo4-TfRVn-3A@.rogers.com...
> Adam,
> While it's quite possible that you are hitting some SQL bug which corrupts
> your database, it is far more likely that you may have some hardware or
> driver related problem on that server. I would advise you to install the
> latest SQL hotfix and update all your firmware and drivers. If you have
> enabled /PAE in BOOT.INI then apply the PAE fix Q838765. Also review your
> event logs in detail for ANY hardware-related errors and warnings. Use
> SQLIOSTRESS to try to flush out I/O problems.
> Going to the latest SQL build (i.e. 1007 or higher) will fix all known SQL
> corruption bugs, but also enable new SQL Server I/O auditing features,
> such as detection for stale read and lost writes, and perform consistency
> checks on all pages read from the disk. Check all your database for
> corruption before applying the hotfix. Then enable trace flags -T818
> and -T806.
> Lastly, the following articles contain more information about SQL I/O
> requirements and how hardware problems may lead to corruption.
> http://support.microsoft.com/kb/841776
> http://support.microsoft.com/kb/826433
> http://support.microsoft.com/kb/231619
> http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlIObasics.mspx
> Adrian
>
>
> "acs68" <adamst@.NOSPAMlaidley.qld.gov.au> wrote in message
> news:eGuhUzPUFHA.2056@.tk2msftngp13.phx.gbl...
>> Hi all,
>> we have been using SQL7 for a number of years on a Win2K box without so
>> much as one hiccup. Recently went out bought a new HP Server and SQL2000.
>> Installed it all, moved all the databases - and everything seemed to be
>> working fine.
>> A couple of weeks ago we had a problem with our biggest database (about
>> 1gb in size). Users were getting some errors from the app that uses it. I
>> did a DBCC CHECKDB on that database and it was coming up with almost 1000
>> inconsistencies etc etc. Tried Repair, to no avail and in the end just
>> had to Restore form backup - lost about a half a days work - not critical
>> for us.
>> Spoke to a few DBA's who said that it sounded Hardware related. Spoke to
>> our local IT support who we got the HP's from and they did a quick look
>> and everything came up OK.
>> A couple of days ago the same problem occurred. At a loss to explain what
>> is happening, so I'm hoping a few of you may be able to help.
>> One thing I did notice was that Write Cache was set on the server to 50%
>> Read 50% Write. I have only now changed it to 100% and No Write caching.
>> Could the above have caused it (50% Read 50% Write), or is it more than
>> likely I could have further corruption ? We haven't , I believe, had any
>> power outages or system crashes leading up to these corruptions.
>> Any help you could give me would be greatly appreciated.
>> cheers,
>> Adam
>

Monday, March 19, 2012

could not obtain information about...

Wednesday, March 7, 2012

Could not find server '<server ip address here>' in sysservers.

Could not find server '<server ip address here>' in sysservers.

Could not find server '<server ip address here>' in sysservers.

Friday, February 17, 2012

Corruption Problem- need some advice

Corruption Problem- need some advice

Counter settings

Blog Archive

About Me