Viewing 15 posts - 826 through 840 (of 972 total)
What is the message in the log prior to the Login failed?
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
January 7, 2010 at 7:46 am
A customer will remember that you walked them through getting the problem resolved (especially if it was not your group that needed to fix the issue) versus you just telling...
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
January 7, 2010 at 7:42 am
Hello everyone, I am facing the above error while executing the SSIS package from SQL job.
Does the account the SQL Server Agent runs as have permission to those directories as...
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
January 7, 2010 at 7:35 am
well since all the sites are stopped, try stopping IIS services. If that error still occurs, I would check the default trace file to see if it may show...
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
January 7, 2010 at 7:35 am
Try stopping the Application Pools associated with each web site.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
January 7, 2010 at 7:27 am
The IP in the error would be the source the connection attempt is coming from.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
January 7, 2010 at 7:20 am
If you want SQL Server to access resources over your network/domain the service will have to be running as a Domain account that has access to those resources.
You should create...
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
January 7, 2010 at 7:17 am
What are the security settings for the SSIS package?
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
January 7, 2010 at 7:13 am
First guess: What is the protection level of your package? I have had some issue that if I did not use "EncryptSensitiveWithPassword" when I stored the SSIS package on...
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
January 7, 2010 at 7:11 am
I would go ahead and change the log backup to 3AM.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
January 6, 2010 at 10:04 am
Brian Tabios (1/6/2010)
Maintenance Plan 1
1. Check DB Integrity
2. Full DB Backup
3. Reorganize Index
4. Update Statistics
5. Maintenance Cleanup
6. Clean Up History
The full DB Backup doesn't...
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
January 6, 2010 at 9:49 am
Nothing beats getting it straight from the horses mouth...A good blog posting on a DMV query for gathering I/O Stats from SQL Server 2005
http://glennberrysqlperformance.spaces.live.com/Blog/cns!45041418ECCAA960!2991.entry
Disclaimer: Make sure you understand what the...
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
January 6, 2010 at 7:20 am
Well simple fix (at least to start with) is to patch the server to the current service pack provided by Microsoft.
If that does not stop the error from occuring would...
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
January 6, 2010 at 7:13 am
Do you have those backup jobs trying to output to a log file?
Does that output file give you any more information if you do?
However it does not clear down the...
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
January 6, 2010 at 7:04 am
What are the events following and prior to the 87 error in the Agent log? What are the events in your SQL Server log within the same time frame?
Are...
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
January 6, 2010 at 6:39 am
Viewing 15 posts - 826 through 840 (of 972 total)