If you work in Financial based Enterprise then Sarbanes-Oxley is not a new concept for you as per American law that regulates the accountability of publicly owned companies. Just to talk about t he main purpose of the law it to make sure the financial
Read More...
When you are setting up SQL Server cluster you should think about security privileges that is required for the Cluster Administrator account and SQL Server services account. Do not attempt to use same account for both the serivces, as it will be single
Read More...
Scenario is like this: Error generated when trying to register the Linked server between 2 SQL instances. SQL Server setup information is as follows: provider:SQL native Client Product Name: SQLNCL1 Data Source: Somewhere IN this world (SQLServer 2000
Read More...
This was the question raised by a newbie DBA at my workplace! Endpoint in generic network terms they are the objects that represent a communication point between the server and client. In SQL Server as per the Authentication mode (Windows only & mixed)
Read More...