Monday, August 12, 2013

[MS SQL Server] "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON")

[MS SQL Server] "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON")

"Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON")

Posted: 12 Aug 2013 01:49 AM PDT

I have a user who get this error when querying tables in another database from the same server.select * from AdOps.dbo.tblRCP_Source where name like '%american%egg%'and this is the error message: Msg 18456, Level 14, State 1, Line 1Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.If they run the command from the adops database the query works. I have dealt with this error when it comes to linked servers but this database is on the same server. It happens to and from any database on the server, not just adops. Thanks...

Database mirroring cannot be enabled while the database has offline files. Error 5003

Posted: 12 Aug 2013 01:38 AM PDT

Dear colleagues, need help!!!Set up mirroring between two servers A - principial, B - mirror:Created certificates, created endpoints for server instances using its certificate,created logins at units, created at B RESTORE DATABASE and RESTORE LOG with the WITH NORECOVERY.Run on the server BALTER DATABASE DBName SET PARTNER = 'TCP://110.110.10.15:5024'; GOThat's finished successfully. Run on the server AALTER DATABASE DBName SET PARTNER = 'TCP://110.110.10.16:5024'; GOgot the following error:"Msg 5003, Level 16, State 1, Line 1Database mirroring cannot be enabled while the database has offline files."Done it many times, the result is the same.Configuration: Windows Server 2003 SP2 at both servers, servers is not at domain.Principial SQL Server 2008, mirror SQL Server 2008R2. Returns are not planned. DB around 800Gb. Partitioned tables exists.Just for testing created test database on the server A, and restored it on Server B and turn on mirroring.It is well earned.The basic database can't be mirrored!Please prompt me, what is the reason for this behavior?Shortly before this, did this operation on the test servers with the same configuration,mirroring worked without problems.thanks.

log file growth on particular time

Posted: 11 Aug 2013 10:25 PM PDT

Hi Experts,How can i prove whether the file growth happened on particular time ? We had space crunch in tempdb and i killed a transaction which released enough space but is there any way that i can show that the log growth happened on this particular time?Thanks IN Advance.
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog