Viewing 15 posts - 76 through 90 (of 90 total)
Without knowing your specific configuration or performance issues, some quick rules of thumb.
- ensure that Trend Micro (or any AV for that matter) does not perform real-time scanning on...
January 10, 2009 at 5:09 am
Hi Doug,
Sorry, I missed the bit about SQL 2000. Sort of important in your case. I've much more experience with SQL 2005 so take my advice with a...
January 10, 2009 at 4:57 am
If you do not set Min and Max memory within your SQL Instance configuration, it will use as much memory as it needs. This includes RAM and page. ...
January 10, 2009 at 1:28 am
Ensure you have enough RAM for SQL Server + OS + other apps / supporting services.
Enable the Lock Pages privilege for the service account running SQL Database Engine
Set Max RAM...
January 10, 2009 at 1:16 am
smunson (1/9/2009)
January 9, 2009 at 5:14 pm
Publishing SQL Server information to Active Directory is only of any use if you have client applications that query Active Directory for such information.
When you publish SQL Server to AD,...
January 9, 2009 at 5:09 pm
If you must make a direct connection to SQL from a remote location and expose your SQL Server outside of your network, then you should at the very least require...
January 8, 2009 at 7:41 am
Is the existing cluster group IP Address in the same subnet as the cluster IP address in the new cluster? If it's not, then it won't work.
You can test...
January 8, 2009 at 7:35 am
When you say you are unable to login locally, do you mean via a sql connection (such as SSMS) or RDP to the Windows server?
Do you have Allow Logons -...
January 8, 2009 at 7:32 am
Sounds like you may have a kerberos authentication issue.
When you install / start SQL Server, it attempts to create the required SPNs for you. However, if the service account...
January 8, 2009 at 7:30 am
Manish Khattar has posted information regarding this recently in the thread Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
You can find the post here --> http://www.sqlservercentral.com/Forums/Topic626429-359-1.aspx
January 8, 2009 at 7:14 am
As much as possible, try to adhere to the principal of least privilege. It is difficult to tell you what permissions / privileges are necessary to achieve a set...
January 8, 2009 at 7:07 am
Check out the thread here --> SQL Server Active Directory Helper Service http://www.sqlservercentral.com/Forums/Topic436979-112-1.aspx
January 8, 2009 at 6:59 am
Check the Application and Security logs in Event Viewer.
Services often fail to start because they do not have the correct privileges. If this is the case, and you have...
January 8, 2009 at 6:51 am
The Active Directory Helper won't start manually. By default the service is Disabled. The SQL Server Database Engine handles the use of this service.
It publishes SQL Server information...
January 8, 2009 at 5:48 am
Viewing 15 posts - 76 through 90 (of 90 total)