Browse by Tags

Address Windowing Extensions (AWE) requires the 'lock pages in memory' privilege which is not currently present in the access token of the process

Published 21 May 8 4:20 AM | SSQA.net

The main difference betwen 32 bit and 64 bit server is Memory, you may be aware about 'Lock Page in memory' privilege to be granted to the SQL Server service accout within 32 bit based servers. This is a operating system based privilege that is...

Filed under: sql server, best practices, 32 bit, 64 bit, configuration, service account, sp_configure, lock pages in memory

Log Shipping error "Unable to copy the initialization file"

Published 3 October 7 6:49 AM | SSQA.net

When configuring log shipping on a highly transactional environment (with SQL Clustering setup), we were hit by above error. All the Logins and their privileges are intact within the primary and standby servers along with Local server policies & group...

Filed under: sql server, high availability, server, login, cluster, log shipping, service account, firewall, unable, filecopy

Database Mirroring: Check the network address name and that the ports for the local and remote endpoints are operational. (Microsoft SQL Server, Error: 1418)

Published 12 September 7 4:56 AM | SSQA.net

The above error is quite common within the database mirroring setup, you could get to see. The intial workaround for this error will be to check whether any network issues are causing this error when the failover is intiated from a Primary server to the...

Filed under: sql server, high availability, security, error, database mirroring, service account, 1418, ports