Viewing 15 posts - 3,301 through 3,315 (of 6,401 total)
Have you enabled and configured database mail?
November 20, 2012 at 11:34 am
Well if you use that procedure and pass in the parameters do you get an email from it?
November 20, 2012 at 8:57 am
EXEC msdb.dbo.sp_send_dbmail
@profile_name = '',
@recipients = '',
@body = '',
@subject = '' ;
November 20, 2012 at 8:51 am
Can you send a test mail successfully via sp_send_dbmail?
November 20, 2012 at 8:45 am
Have you restarted the Agent service since you told it which mail profile to use under the Alerts system properties?
November 20, 2012 at 8:38 am
Strange then as if your an admin you shouldn't need to mess with DCOM.
Will keep digging once I have a spare moment here and there but as never running into...
November 20, 2012 at 8:30 am
Have you tried this one
Might be that 2008 R2 creates the MsDTSServer100 DCOM object and 2008 creates the MsDTSServer as I have both in my DCOM as I have both...
November 20, 2012 at 8:13 am
ALTER DATABASE dbname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
November 20, 2012 at 7:54 am
Can you post a screen shot of the error?
I've never had this issue so would be good to see what you see in case its something else other than DCOM.
November 20, 2012 at 7:50 am
Any firewalls between the clients and the servers? Are you connecting to a cluster?
November 20, 2012 at 7:46 am
Microsoft SQL Server Integration Services 11.0 is SQL 2012.
I take it your looking at the MSDN article on Connecting to a Remote Integration Services Server?
If so it looks like you've...
November 20, 2012 at 7:33 am
Well deny backup wont work then if the account is sysadmin, as if your a sysadmin even explicit denies do not take precidence.
November 20, 2012 at 7:08 am
Express has a 1GB memory limit, so are you talking memory as in RAM or are you talking memory as in storage?
November 20, 2012 at 6:31 am
First off, why no backups? System database are just as important to backup as your user backups. Please tell me you backup your Master database at least?
Second on...
November 20, 2012 at 6:06 am
Yes, same issue as what Shell has reported. The Sharepoint crawler was running indexing the sharepoint sites at the same time the database was being backed up, causing the...
November 20, 2012 at 5:51 am
Viewing 15 posts - 3,301 through 3,315 (of 6,401 total)