Users are receiving the failed login error almost every after 2 days. They have enough permission to the server.

Microsoft (ODBC driver 11 for SQL Server)[SQL Server] Login failed for user...

We have contacted Microsoft and after working with them for 3 months, issue resolved.

Cause

We found that there is an instance mapping for Report Server that maps default instance name (MSSQLSERVER) to...

Anyone?

Update:

I performed the steps described below with option 2 and run the script msdb110_upgrade script and it failed with following error message.

https://www.mssqltips.com/sqlservertip/3519/changing-sql-server-collation-after-installation/

Msg 468, Level 16, State 9, Procedure...

• This reply was modified 2 years, 11 months ago by  EasyBoy.

Update:

Well, i have updated ola script @DirectoryStructure parameter as following to fulfil the requirement.

@DirectoryStructure nvarchar(max) = '{ServerName}${InstanceName}{DirectorySeparator}{BackupType}{DirectorySeparator}{DatabaseName}_{Partial}_{CopyOnly}',

Yes, one month backup includes full, diff and txlog. I had the same concern and First thing that I asked to client why only full?

We already keep 1 month of backup on drive and anything above that should transfer to shared backup network and that is the requirement of client.

Option is greyed out and i can't select MSSQLSERVER.

Issue resolved:

I have removed the IP which was not necessary and not a part of cluster.

Validate Cluster Service and Driver Settings

Description: Validate startup settings used by services and drivers, including the...

Thanks everyone.

I am planning to schedule two jobs on a daily basis.

Start robocopy job to copy from source to destination using below command.

ROBOCOPY \\sourceserver\share \\destinationserver\share /MIR /MT:16

Second job will stop...

Thanks for your response. Would it be possible to explain with the example?

Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. [CLIENT: 10.11.12.13]

Error: 18452, Severity: 14, State: 1.

SSPI handshake failed with error code 0x8009030c, state...

Cannot connect to the server.

------------------------------

ADDITIONAL INFORMATION:

Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. (Microsoft SQL Server, Error: 18452)

• This reply was modified 5 years ago by  EasyBoy.