Merging two dbs: failed

Showing posts with label failed. Show all posts

Wednesday, March 28, 2012

Microsoft SQL Management Studio failed to load

I am running SQL Server 2005 bata on my Windows Server 2003, web edition
machine. Recently got an error that the Bata had expired. I ignored this.
However, other C# apps using the Db started having problems.
Uninstalled .Net Framework Version 2. I downloaded the most
recent version from MS, installed the new version.
Now I can't run Management studio or the profiler. Get the following errors:
'Procedure entry point _CxxFrameHandler3 could not be located in the
dynamic link library MSVCR80.dll '
and a follow on error
..."\v2.0.50215\mscorwks.dll could not be loaded".
How do I get back to being able to use these tools?
Hi
The .NET versions are tightly linked to the SQL Server Betas.
Download the SQL Server September 2005 CTP and the Visual Studio 2005 RC1.
They are the newest and are a perfect match.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"FredC" <FredC@.discussions.microsoft.com> wrote in message
news:72539B05-013B-4A6C-BE1E-ED024A28247C@.microsoft.com...
>I am running SQL Server 2005 bata on my Windows Server 2003, web edition
> machine. Recently got an error that the Bata had expired. I ignored this.
> However, other C# apps using the Db started having problems.
> Uninstalled .Net Framework Version 2. I downloaded the most
> recent version from MS, installed the new version.
> Now I can't run Management studio or the profiler. Get the following
> errors:
> 'Procedure entry point _CxxFrameHandler3 could not be located in the
> dynamic link library MSVCR80.dll '
> and a follow on error
> ..."\v2.0.50215\mscorwks.dll could not be loaded".
> How do I get back to being able to use these tools?
|||Sql server 2005 CTP won't install here. It keeps asking me to insert
disk 2.
|||On Tue, 20 Sep 2005 08:59:05 -0700, "FredC"
<FredC@.discussions.microsoft.com> wrote:

>I am running SQL Server 2005 bata on my Windows Server 2003, web edition
>machine. Recently got an error that the Bata had expired. I ignored this.
>However, other C# apps using the Db started having problems.
>Uninstalled .Net Framework Version 2. I downloaded the most
>recent version from MS, installed the new version.
>Now I can't run Management studio or the profiler. Get the following errors:
> 'Procedure entry point _CxxFrameHandler3 could not be located in the
>dynamic link library MSVCR80.dll '
>and a follow on error
>..."\v2.0.50215\mscorwks.dll could not be loaded".
>How do I get back to being able to use these tools?
In addition to Mike's comments you need to be very careful about
uninstall order of components from the old SQL Server 2005 and .NET
Framework builds. That is described in some detail in the documents
that come with September CTP.
Andrew Watt
MVP - InfoPath
|||I found and downloaded SQL Server September 2005 CTP but I can't find Visual
Studio 2005 RC1. Where do I get it?
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> The .NET versions are tightly linked to the SQL Server Betas.
> Download the SQL Server September 2005 CTP and the Visual Studio 2005 RC1.
> They are the newest and are a perfect match.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "FredC" <FredC@.discussions.microsoft.com> wrote in message
> news:72539B05-013B-4A6C-BE1E-ED024A28247C@.microsoft.com...
>
>
|||Apologies microsoft, after all the things I've been saying about them.
All you do, is...
1. Install everything apart from SQL express, on the RC VS.Net 2005
1. put the "server" ISO on, install everything but the bottom checkbox.
1. put the "client" ISO on, install everything to run from the
harddrive.
1. Put the ISO VS.Net 2005 RC back on, and install the SQL Express.
Hey presto, it all works, including SQL express integrated into VS.Net.
(Now we can use SQL Express, with files, who is going to use Access?)
|||drawnai:
Thanks for the good info. But I got myself into more trouble. I thought I'd
try to uninstall Visual Studio and Sever. All the .Net stuff seems to
uninstall and the Server itself uninstalls, but tools like management studio
and profiler don't. They are in my start menu but not in add and remove
programs. Result is that Sever will not install the new tools. Got any
experience at get rid of this stuff while saving existing databases?
"drawnai@.hotmail.com" wrote:

> Apologies microsoft, after all the things I've been saying about them.
> All you do, is...
> 1. Install everything apart from SQL express, on the RC VS.Net 2005
> 1. put the "server" ISO on, install everything but the bottom checkbox.
> 1. put the "client" ISO on, install everything to run from the
> harddrive.
> 1. Put the ISO VS.Net 2005 RC back on, and install the SQL Express.
> Hey presto, it all works, including SQL express integrated into VS.Net.
> (Now we can use SQL Express, with files, who is going to use Access?)
>
sql

Friday, March 9, 2012

method to get more info for failed login

Hi,
We are currently tracking SQL Server login failures. But the SQL Server
error log only give infomation about which login has been attempted failed.
Is there a way to tell more info about this failed login, like from which
mechine the failed login came?
Thanks.
Hong Wang wrote:
> Hi,
> We are currently tracking SQL Server login failures. But the SQL
> Server error log only give infomation about which login has been
> attempted failed. Is there a way to tell more info about this failed
> login, like from which mechine the failed login came?
> Thanks.
Yes, you can set up a server-side trace to watch for the Audit Login
Failed event in the Security Audit category. The easiest way to do this
is define the server-side trace from Profiler and then have profiler
save the script for you. use the script in a stored procedure and set
the procedure to auto-start (sp_procoption) when the server starts. All
information is written to a local file onthe server, which is locked by
the trace. You can write a purge procedure that stops the trace and
merges the data from the flat file into table or just copies the file
and then restarts the trace. You have a lot of options here, but the
server-side trace is the way to go.
Use the following columns when defining the trace:
DatabaseID
StartTime
Error
ServerName
Success
TextData
ApplicationName
LoginName
ClientProcessID
SPID
Success will always be 0 for this event. HostName is not passed.
David Gugick
Imceda Software
www.imceda.com

method to get more info for failed login

Hi,
We are currently tracking SQL Server login failures. But the SQL Server
error log only give infomation about which login has been attempted failed.
Is there a way to tell more info about this failed login, like from which
mechine the failed login came?
Thanks.Hong Wang wrote:
> Hi,
> We are currently tracking SQL Server login failures. But the SQL
> Server error log only give infomation about which login has been
> attempted failed. Is there a way to tell more info about this failed
> login, like from which mechine the failed login came?
> Thanks.
Yes, you can set up a server-side trace to watch for the Audit Login
Failed event in the Security Audit category. The easiest way to do this
is define the server-side trace from Profiler and then have profiler
save the script for you. use the script in a stored procedure and set
the procedure to auto-start (sp_procoption) when the server starts. All
information is written to a local file onthe server, which is locked by
the trace. You can write a purge procedure that stops the trace and
merges the data from the flat file into table or just copies the file
and then restarts the trace. You have a lot of options here, but the
server-side trace is the way to go.
Use the following columns when defining the trace:
DatabaseID
StartTime
Error
ServerName
Success
TextData
ApplicationName
LoginName
ClientProcessID
SPID
Success will always be 0 for this event. HostName is not passed.
David Gugick
Imceda Software
www.imceda.com

method to get more info for failed login

Hi,
We are currently tracking SQL Server login failures. But the SQL Server
error log only give infomation about which login has been attempted failed.
Is there a way to tell more info about this failed login, like from which
mechine the failed login came?
Thanks.Hong Wang wrote:
> Hi,
> We are currently tracking SQL Server login failures. But the SQL
> Server error log only give infomation about which login has been
> attempted failed. Is there a way to tell more info about this failed
> login, like from which mechine the failed login came?
> Thanks.
Yes, you can set up a server-side trace to watch for the Audit Login
Failed event in the Security Audit category. The easiest way to do this
is define the server-side trace from Profiler and then have profiler
save the script for you. use the script in a stored procedure and set
the procedure to auto-start (sp_procoption) when the server starts. All
information is written to a local file onthe server, which is locked by
the trace. You can write a purge procedure that stops the trace and
merges the data from the flat file into table or just copies the file
and then restarts the trace. You have a lot of options here, but the
server-side trace is the way to go.
Use the following columns when defining the trace:
DatabaseID
StartTime
Error
ServerName
Success
TextData
ApplicationName
LoginName
ClientProcessID
SPID
Success will always be 0 for this event. HostName is not passed.
David Gugick
Imceda Software
www.imceda.com

Method Refresh of object ICrystalReportViewer3 Failed

Hi,
I am using CR 8, vb6 and protected access2000 .mdb database. In report viewer I used refresh method. But it is raising the runtime error -"Method 'Refresh' of object 'ICrystalReportViewer3' Failed".
Please help me.
Regards
Ashish AnandDo verify database and see|||I have problem with : " Method 'Refresh' of object ICrystalReportViewer3 Failed "

I did verify database but it show error

Please help me, immediate|||I have problem with : " Method 'Refresh' of object ICrystalReportViewer3 Failed "

I did verify database but it show error

Please help me, immediate
What is the new error you got?|||I try verify database more time and I try create new report , but it show error : Method 'Refresh' of object ICrystalReportViewer3 Failed

I think sure : function 'refresh' in CrystalReport 8 was failed

I click button(Refresh) in report then it run ok (have picture: storm)
I don't understand this

Please explain me clearly

Wednesday, March 7, 2012

metadata cleanup 2147199401

Hi,
I'm getting the following error on SQL Server 2005
Error messages:
The Merge Agent failed after detecting that retention-based metadata cleanup
has deleted metadata at the Subscriber for changes not yet sent to the
Publisher. You must reinitialize the subscription (without upload). (Source:
MSSQL_REPL, Error number: MSSQL_REPL-2147199401)
Get help: http://help/MSSQL_REPL-2147199401
The subscription has been running fine for several months and re
initialising is painful due to the size of the DB and the connection speed.
Has anyone encountered this error or know of a fix?
Thanks
NW
There seems to be a bug with this that Microsoft is in the process of trying
to fix (from what I understand). I suggest you open a support incident with
Microsoft on this.
http://www.zetainteractive.com - Shift Happens!
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
"NeilWake" <NeilWake@.discussions.microsoft.com> wrote in message
news:A8E78C08-E908-4D41-A03B-A5BE807C7D7C@.microsoft.com...
> Hi,
> I'm getting the following error on SQL Server 2005
> Error messages:
> The Merge Agent failed after detecting that retention-based metadata
> cleanup
> has deleted metadata at the Subscriber for changes not yet sent to the
> Publisher. You must reinitialize the subscription (without upload).
> (Source:
> MSSQL_REPL, Error number: MSSQL_REPL-2147199401)
> Get help: http://help/MSSQL_REPL-2147199401
> The subscription has been running fine for several months and re
> initialising is painful due to the size of the DB and the connection
> speed.
> Has anyone encountered this error or know of a fix?
> Thanks
> NW
>

Saturday, February 25, 2012

messed up password

I changed the password for the reporting service account on the AD server,
now I can't access my reports. I keep getting logon failed, and every 5
seconds I get logon failures on teh sql server. If I stop the service on
the sql server, the errors go away. I changed the password for the service,
which did not help. Where can I fix this?
Thanks,
Robert ElderThis is a multi-part message in MIME format.
--=_NextPart_000_00DC_01C50F79.58A0A670
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Have you tried this...?
To change Reporting Services access to DB after password changed for =Windows Authentication:
At a Command Prompt, run:
rsconfig -c -u <<The RS UserID>> -p <<The RS User's Password>> -s =<<The RS Server Name>> - d ReportServer -a windows
Should get:
The command completed successfully
BTW: "-d ReportServer" is the name of the database in SQL Server. "-a =windows" says "Windows Authentication"
If you need help on rsconfig, type "rsconfig -h" at the command =prompt.
"Robert Elder" <bobe@.realtechllc.com> wrote in message =news:Oe$c5twDFHA.392@.TK2MSFTNGP14.phx.gbl...
> I changed the password for the reporting service account on the AD =server, > now I can't access my reports. I keep getting logon failed, and every =5 > seconds I get logon failures on teh sql server. If I stop the service =on > the sql server, the errors go away. I changed the password for the =service, > which did not help. Where can I fix this?
> > Thanks,
> Robert Elder > >
--=_NextPart_000_00DC_01C50F79.58A0A670
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

Have you tried this...?
To change Reporting Services access to DB after =password changed for Windows Authentication:
At a Command Prompt, run:
rsconfig -c -u <> -p <> -s <> - d ReportServer -a windows
Should get:
The command completed successfully
BTW: "-d ReportServer" is the name of =the database in SQL Server. "-a windows" says "Windows =Authentication"
If you need help on rsconfig, type ="rsconfig -h" at the command prompt.
"Robert Elder" =wrote in message news:Oe$c5twDFHA.392@.TK2MSFTNGP14.phx.gbl...> I =changed the password for the reporting service account on the AD server, > =now I can't access my reports. I keep getting logon failed, and every 5 => seconds I get logon failures on teh sql server. If I stop the =service on > the sql server, the errors go away. I changed the =password for the service, > which did not help. Where can I fix =this?> > Thanks,> Robert Elder > > =

--=_NextPart_000_00DC_01C50F79.58A0A670--

message: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. (severity 14)

Hi Im getting the following error when trying to connect to a php page...any ideas

message: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. (severity 14)

Hi,

seems that you tried to impersonate the WebUser at the SQL Server database. The question would be what you want to use, wheter Windows Authentication or SQL Authentication ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Monday, February 20, 2012

message in sql server error log

What can cause the message "Login failed for user 'DOMAIN\COMPUTER$' " every
20 sec? the instance is Standard SQL server 2000 with mixed security mode
and sql server service accout is domain admin member. The application that
use database is working fine but out error log fills up very fast. I will
appreciate any advise."Eli Milkova" <EliMilkova@.discussions.microsoft.com> wrote in message
news:4A68C8F3-CFAC-4D46-BAD2-B33E7616C53F@.microsoft.com...
> What can cause the message "Login failed for user 'DOMAIN\COMPUTER$' "
> every
> 20 sec? the instance is Standard SQL server 2000 with mixed security mode
> and sql server service accout is domain admin member. The application that
> use database is working fine but out error log fills up very fast. I will
> appreciate any advise.
Just a guess here, but that domain account will need to have local admin
permissions on your SQL Server.
In addition, you may need to set the Run As a Service permission, or Log On
as a Service.. Something like that. <shrug>
I'm sure others can expand on this.
Rick Sawtell
MCT, MCSD, MCDBA|||Is this showing up in sql errorlog or system log ?
Is the COMPUTER in DOMAIN\COMPUTER$ the local computer or a remote computer
?
How did you set the service account user names ?
Have you thought about setting and audit (Remember SQL Can do C2), and
watching realtime with profiler ?
Is this computer a domain contoler and/r any FSMO Role
BTW: It is bad practice to run sql services with admin privilages
"Eli Milkova" <EliMilkova@.discussions.microsoft.com> wrote in message
news:4A68C8F3-CFAC-4D46-BAD2-B33E7616C53F@.microsoft.com...
> What can cause the message "Login failed for user 'DOMAIN\COMPUTER$' "
> every
> 20 sec? the instance is Standard SQL server 2000 with mixed security mode
> and sql server service accout is domain admin member. The application that
> use database is working fine but out error log fills up very fast. I will
> appreciate any advise.|||"David J. Cartwright" <davidcartwright@.hotmail.com> wrote in message
news:ee1GqLtvFHA.3152@.TK2MSFTNGP12.phx.gbl...
> Is this showing up in sql errorlog or system log ?
> Is the COMPUTER in DOMAIN\COMPUTER$ the local computer or a remote
> computer ?
> How did you set the service account user names ?
> Have you thought about setting and audit (Remember SQL Can do C2), and
> watching realtime with profiler ?
> Is this computer a domain contoler and/r any FSMO Role
> BTW: It is bad practice to run sql services with admin privilages
>
Don't they need local admin rights? It's been a while since I've had to do
a setup like that.
Rick Sawtell|||"David J. Cartwright" wrote:
> Is this showing up in sql errorlog or system log ?
 In sql error log
> Is the COMPUTER in DOMAIN\COMPUTER$ the local computer or a remote computer
> ?
 DOMAIN\COMPUTER$ is for the remote computer.
> How did you set the service account user names ?
 members of domain admin group
> Have you thought about setting and audit (Remember SQL Can do C2), and
> watching realtime with profiler ?
 I did this the message appears when application account
DOMAIN\appaccount is login / logout to sql server. Its not a threat at all so
no sence to use C2
> Is this computer a domain contoler and/r any FSMO Role
 no the computer thats tryng to log is standalone backup server
> BTW: It is bad practice to run sql services with admin privilages
 we are in process of changing this
> "Eli Milkova" <EliMilkova@.discussions.microsoft.com> wrote in message
> news:4A68C8F3-CFAC-4D46-BAD2-B33E7616C53F@.microsoft.com...
> > What can cause the message "Login failed for user 'DOMAIN\COMPUTER$' "
> > every
> > 20 sec? the instance is Standard SQL server 2000 with mixed security mode
> > and sql server service accout is domain admin member. The application that
> > use database is working fine but out error log fills up very fast. I will
> > appreciate any advise.
>
>|||SQL Server only *needs access to its files (system files, and dta
files...usualy C:\Program Files\Microsoft SQL Server..." and its reqistry
keys...
to keep a machine more secure minimize the access that the service account
have
If the service is running with local admin rights...and the sql server is
hacked, then the whole system is comprimised (CmdExec)
"Rick Sawtell" <r_sawtell@.hotmail.com> wrote in message
news:O4X4EVtvFHA.1252@.TK2MSFTNGP09.phx.gbl...
> "David J. Cartwright" <davidcartwright@.hotmail.com> wrote in message
> news:ee1GqLtvFHA.3152@.TK2MSFTNGP12.phx.gbl...
>> Is this showing up in sql errorlog or system log ?
>> Is the COMPUTER in DOMAIN\COMPUTER$ the local computer or a remote
>> computer ?
>> How did you set the service account user names ?
>> Have you thought about setting and audit (Remember SQL Can do C2), and
>> watching realtime with profiler ?
>> Is this computer a domain contoler and/r any FSMO Role
>> BTW: It is bad practice to run sql services with admin privilages
>>
> Don't they need local admin rights? It's been a while since I've had to
> do a setup like that.
> Rick Sawtell
>|||Is the account 'appacccount' loging in from an application on this remote
computer?
The only other time i have seen DOMAIN\COMPUTER$ (With the $ sign) is when
the computer domain account has gotten out of sync. But i dont know why this
would show up in the sql log...if this is the computer that the appaccount
acount is loging in from and they happen at same time...i would check make
sure that the computers account is in synce...ie thats its p/w has been
set/reset with the domain
did you mean server is a 'member' server or is it realy a 'standolone'
server...?
- David
"Eli Milkova" <EliMilkova@.discussions.microsoft.com> wrote in message
news:30150C5D-30EC-4325-908D-86FB7D52E81B@.microsoft.com...
>
> "David J. Cartwright" wrote:
>> Is this showing up in sql errorlog or system log ?
> In sql error log
>> Is the COMPUTER in DOMAIN\COMPUTER$ the local computer or a remote
>> computer
>> ?
> DOMAIN\COMPUTER$ is for the remote computer.
>> How did you set the service account user names ?
> members of domain admin group
>> Have you thought about setting and audit (Remember SQL Can do C2), and
>> watching realtime with profiler ?
> I did this the message appears when application account
> DOMAIN\appaccount is login / logout to sql server. Its not a threat at all
> so
> no sence to use C2
>> Is this computer a domain contoler and/r any FSMO Role
> no the computer thats tryng to log is standalone backup server
>> BTW: It is bad practice to run sql services with admin privilages
> we are in process of changing this
>> "Eli Milkova" <EliMilkova@.discussions.microsoft.com> wrote in message
>> news:4A68C8F3-CFAC-4D46-BAD2-B33E7616C53F@.microsoft.com...
>> > What can cause the message "Login failed for user 'DOMAIN\COMPUTER$' "
>> > every
>> > 20 sec? the instance is Standard SQL server 2000 with mixed security
>> > mode
>> > and sql server service accout is domain admin member. The application
>> > that
>> > use database is working fine but out error log fills up very fast. I
>> > will
>> > appreciate any advise.
>>|||thanks David,
please see my answers below
"David J. Cartwright" wrote:
> Is the account 'appacccount' loging in from an application on this remote
> computer?
 yes ...exactly from the same server
> The only other time i have seen DOMAIN\COMPUTER$ (With the $ sign) is when
> the computer domain account has gotten out of sync. But i dont know why this
> would show up in the sql log...if this is the computer that the appaccount
> acount is loging in from and they happen at same time...i would check make
> sure that the computers account is in synce...ie thats its p/w has been
> set/reset with the domain
How can I check computer account? pls advise
> did you mean server is a 'member' server or is it realy a 'standolone'
> server...?
>
 its standalone server
> - David
> "Eli Milkova" <EliMilkova@.discussions.microsoft.com> wrote in message
> news:30150C5D-30EC-4325-908D-86FB7D52E81B@.microsoft.com...
> >
> >
> > "David J. Cartwright" wrote:
> >
> >> Is this showing up in sql errorlog or system log ?
> > In sql error log
> >
> >> Is the COMPUTER in DOMAIN\COMPUTER$ the local computer or a remote
> >> computer
> >> ?
> > DOMAIN\COMPUTER$ is for the remote computer.
> >
> >> How did you set the service account user names ?
> > members of domain admin group
> >
> >> Have you thought about setting and audit (Remember SQL Can do C2), and
> >> watching realtime with profiler ?
> > I did this the message appears when application account
> > DOMAIN\appaccount is login / logout to sql server. Its not a threat at all
> > so
> > no sence to use C2
> >
> >> Is this computer a domain contoler and/r any FSMO Role
> > no the computer thats tryng to log is standalone backup server
> >
> >> BTW: It is bad practice to run sql services with admin privilages
> > we are in process of changing this
> >>
> >> "Eli Milkova" <EliMilkova@.discussions.microsoft.com> wrote in message
> >> news:4A68C8F3-CFAC-4D46-BAD2-B33E7616C53F@.microsoft.com...
> >> > What can cause the message "Login failed for user 'DOMAIN\COMPUTER$' "
> >> > every
> >> > 20 sec? the instance is Standard SQL server 2000 with mixed security
> >> > mode
> >> > and sql server service accout is domain admin member. The application
> >> > that
> >> > use database is working fine but out error log fills up very fast. I
> >> > will
> >> > appreciate any advise.
> >>
> >>
> >>
>
>|||O.K lemmi get this straight...the sql server is a 'standalone' server,
meaning that it is NOT a member of the domain, but it is using domain
accounts (more specificaly, a domain admin account) to run the services '
also what kinda domain is this NT4/2000/2003 ? and what level is it running
at ? (this will help me answer the computer account prob)
---
http://support.microsoft.com/default.aspx?scid=kb;en-us;325850
http://support.microsoft.com/default.aspx?scid=kb;en-us;260575
---
"Eli Milkova" <EliMilkova@.discussions.microsoft.com> wrote in message
news:AB1FE5AD-002B-42A6-B2F7-16DD0E355586@.microsoft.com...
> thanks David,
> please see my answers below
> "David J. Cartwright" wrote:
>> Is the account 'appacccount' loging in from an application on this remote
>> computer?
> yes ...exactly from the same server
>> The only other time i have seen DOMAIN\COMPUTER$ (With the $ sign) is
>> when
>> the computer domain account has gotten out of sync. But i dont know why
>> this
>> would show up in the sql log...if this is the computer that the
>> appaccount
>> acount is loging in from and they happen at same time...i would check
>> make
>> sure that the computers account is in synce...ie thats its p/w has been
>> set/reset with the domain
> How can I check computer account? pls advise
>> did you mean server is a 'member' server or is it realy a 'standolone'
>> server...?
> its standalone server
>> - David
>> "Eli Milkova" <EliMilkova@.discussions.microsoft.com> wrote in message
>> news:30150C5D-30EC-4325-908D-86FB7D52E81B@.microsoft.com...
>> >
>> >
>> > "David J. Cartwright" wrote:
>> >
>> >> Is this showing up in sql errorlog or system log ?
>> > In sql error log
>> >
>> >> Is the COMPUTER in DOMAIN\COMPUTER$ the local computer or a remote
>> >> computer
>> >> ?
>> > DOMAIN\COMPUTER$ is for the remote computer.
>> >
>> >> How did you set the service account user names ?
>> > members of domain admin group
>> >
>> >> Have you thought about setting and audit (Remember SQL Can do C2), and
>> >> watching realtime with profiler ?
>> > I did this the message appears when application account
>> > DOMAIN\appaccount is login / logout to sql server. Its not a threat at
>> > all
>> > so
>> > no sence to use C2
>> >
>> >> Is this computer a domain contoler and/r any FSMO Role
>> > no the computer thats tryng to log is standalone backup server
>> >
>> >> BTW: It is bad practice to run sql services with admin privilages
>> > we are in process of changing this
>> >>
>> >> "Eli Milkova" <EliMilkova@.discussions.microsoft.com> wrote in message
>> >> news:4A68C8F3-CFAC-4D46-BAD2-B33E7616C53F@.microsoft.com...
>> >> > What can cause the message "Login failed for user 'DOMAIN\COMPUTER$'
>> >> > "
>> >> > every
>> >> > 20 sec? the instance is Standard SQL server 2000 with mixed
>> >> > security
>> >> > mode
>> >> > and sql server service accout is domain admin member. The
>> >> > application
>> >> > that
>> >> > use database is working fine but out error log fills up very fast. I
>> >> > will
>> >> > appreciate any advise.
>> >>
>> >>
>> >>
>>|||ok ...there is misunderstanding no not that kind of standalone server : ) its
just an application server obviously a domain member
and ...w2000 domain
"David J. Cartwright" wrote:
> O.K lemmi get this straight...the sql server is a 'standalone' server,
> meaning that it is NOT a member of the domain, but it is using domain
> accounts (more specificaly, a domain admin account) to run the services '
> also what kinda domain is this NT4/2000/2003 ? and what level is it running
> at ? (this will help me answer the computer account prob)
> ---
> http://support.microsoft.com/default.aspx?scid=kb;en-us;325850
> http://support.microsoft.com/default.aspx?scid=kb;en-us;260575
> ---
> "Eli Milkova" <EliMilkova@.discussions.microsoft.com> wrote in message
> news:AB1FE5AD-002B-42A6-B2F7-16DD0E355586@.microsoft.com...
> >
> > thanks David,
> >
> > please see my answers below
> > "David J. Cartwright" wrote:
> >
> >> Is the account 'appacccount' loging in from an application on this remote
> >> computer?
> > yes ...exactly from the same server
> >> The only other time i have seen DOMAIN\COMPUTER$ (With the $ sign) is
> >> when
> >> the computer domain account has gotten out of sync. But i dont know why
> >> this
> >> would show up in the sql log...if this is the computer that the
> >> appaccount
> >> acount is loging in from and they happen at same time...i would check
> >> make
> >> sure that the computers account is in synce...ie thats its p/w has been
> >> set/reset with the domain
> > How can I check computer account? pls advise
> >> did you mean server is a 'member' server or is it realy a 'standolone'
> >> server...?
> >>
> > its standalone server
> >> - David
> >>
> >> "Eli Milkova" <EliMilkova@.discussions.microsoft.com> wrote in message
> >> news:30150C5D-30EC-4325-908D-86FB7D52E81B@.microsoft.com...
> >> >
> >> >
> >> > "David J. Cartwright" wrote:
> >> >
> >> >> Is this showing up in sql errorlog or system log ?
> >> > In sql error log
> >> >
> >> >> Is the COMPUTER in DOMAIN\COMPUTER$ the local computer or a remote
> >> >> computer
> >> >> ?
> >> > DOMAIN\COMPUTER$ is for the remote computer.
> >> >
> >> >> How did you set the service account user names ?
> >> > members of domain admin group
> >> >
> >> >> Have you thought about setting and audit (Remember SQL Can do C2), and
> >> >> watching realtime with profiler ?
> >> > I did this the message appears when application account
> >> > DOMAIN\appaccount is login / logout to sql server. Its not a threat at
> >> > all
> >> > so
> >> > no sence to use C2
> >> >
> >> >> Is this computer a domain contoler and/r any FSMO Role
> >> > no the computer thats tryng to log is standalone backup server
> >> >
> >> >> BTW: It is bad practice to run sql services with admin privilages
> >> > we are in process of changing this
> >> >>
> >> >> "Eli Milkova" <EliMilkova@.discussions.microsoft.com> wrote in message
> >> >> news:4A68C8F3-CFAC-4D46-BAD2-B33E7616C53F@.microsoft.com...
> >> >> > What can cause the message "Login failed for user 'DOMAIN\COMPUTER$'
> >> >> > "
> >> >> > every
> >> >> > 20 sec? the instance is Standard SQL server 2000 with mixed
> >> >> > security
> >> >> > mode
> >> >> > and sql server service accout is domain admin member. The
> >> >> > application
> >> >> > that
> >> >> > use database is working fine but out error log fills up very fast. I
> >> >> > will
> >> >> > appreciate any advise.
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||I ve created new login for that account 'domain\computer$' and the problem
was fixed
"Eli Milkova" wrote:
> ok ...there is misunderstanding no not that kind of standalone server : ) its
> just an application server obviously a domain member
> and ...w2000 domain
> "David J. Cartwright" wrote:
> > O.K lemmi get this straight...the sql server is a 'standalone' server,
> > meaning that it is NOT a member of the domain, but it is using domain
> > accounts (more specificaly, a domain admin account) to run the services '
> >
> > also what kinda domain is this NT4/2000/2003 ? and what level is it running
> > at ? (this will help me answer the computer account prob)
> > ---
> > http://support.microsoft.com/default.aspx?scid=kb;en-us;325850
> > http://support.microsoft.com/default.aspx?scid=kb;en-us;260575
> > ---
> >
> > "Eli Milkova" <EliMilkova@.discussions.microsoft.com> wrote in message
> > news:AB1FE5AD-002B-42A6-B2F7-16DD0E355586@.microsoft.com...
> > >
> > > thanks David,
> > >
> > > please see my answers below
> > > "David J. Cartwright" wrote:
> > >
> > >> Is the account 'appacccount' loging in from an application on this remote
> > >> computer?
> > > yes ...exactly from the same server
> > >> The only other time i have seen DOMAIN\COMPUTER$ (With the $ sign) is
> > >> when
> > >> the computer domain account has gotten out of sync. But i dont know why
> > >> this
> > >> would show up in the sql log...if this is the computer that the
> > >> appaccount
> > >> acount is loging in from and they happen at same time...i would check
> > >> make
> > >> sure that the computers account is in synce...ie thats its p/w has been
> > >> set/reset with the domain
> > > How can I check computer account? pls advise
> > >> did you mean server is a 'member' server or is it realy a 'standolone'
> > >> server...?
> > >>
> > > its standalone server
> > >> - David
> > >>
> > >> "Eli Milkova" <EliMilkova@.discussions.microsoft.com> wrote in message
> > >> news:30150C5D-30EC-4325-908D-86FB7D52E81B@.microsoft.com...
> > >> >
> > >> >
> > >> > "David J. Cartwright" wrote:
> > >> >
> > >> >> Is this showing up in sql errorlog or system log ?
> > >> > In sql error log
> > >> >
> > >> >> Is the COMPUTER in DOMAIN\COMPUTER$ the local computer or a remote
> > >> >> computer
> > >> >> ?
> > >> > DOMAIN\COMPUTER$ is for the remote computer.
> > >> >
> > >> >> How did you set the service account user names ?
> > >> > members of domain admin group
> > >> >
> > >> >> Have you thought about setting and audit (Remember SQL Can do C2), and
> > >> >> watching realtime with profiler ?
> > >> > I did this the message appears when application account
> > >> > DOMAIN\appaccount is login / logout to sql server. Its not a threat at
> > >> > all
> > >> > so
> > >> > no sence to use C2
> > >> >
> > >> >> Is this computer a domain contoler and/r any FSMO Role
> > >> > no the computer thats tryng to log is standalone backup server
> > >> >
> > >> >> BTW: It is bad practice to run sql services with admin privilages
> > >> > we are in process of changing this
> > >> >>
> > >> >> "Eli Milkova" <EliMilkova@.discussions.microsoft.com> wrote in message
> > >> >> news:4A68C8F3-CFAC-4D46-BAD2-B33E7616C53F@.microsoft.com...
> > >> >> > What can cause the message "Login failed for user 'DOMAIN\COMPUTER$'
> > >> >> > "
> > >> >> > every
> > >> >> > 20 sec? the instance is Standard SQL server 2000 with mixed
> > >> >> > security
> > >> >> > mode
> > >> >> > and sql server service accout is domain admin member. The
> > >> >> > application
> > >> >> > that
> > >> >> > use database is working fine but out error log fills up very fast. I
> > >> >> > will
> > >> >> > appreciate any advise.
> > >> >>
> > >> >>
> > >> >>
> > >>
> > >>
> > >>
> >
> >
> >

Wednesday, March 28, 2012

Microsoft SQL Management Studio failed to load

Friday, March 9, 2012

method to get more info for failed login

method to get more info for failed login

method to get more info for failed login

Method Refresh of object ICrystalReportViewer3 Failed

Wednesday, March 7, 2012

metadata cleanup 2147199401

Saturday, February 25, 2012

messed up password

message: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. (severity 14)

Monday, February 20, 2012

message in sql server error log

message in sql server error log

message in sql server error log

Merging two dbs

Blog Archive

About Me