LUGAILA.COM BLOG

Maintenance Plan not emailing report

2011-11-09T06:49:00.001-08:00

You think you have everything configured to send out a report once your SQL Maintenance Plan is finished. You configured your profile, configured the account and email server correctly, and sent a test message and received it. But did you set the profile to be the default profile?

Open SSMS and double click on Database Mail.

Click Manage profile security.

Click Next.

Click the drop down box under Default Profile and select Yes.

Click Next.

Click Finish.

You now should receive email notifications once the Maintenance Plan is done.

Feature '2510d73f-7109-4ccc-8a1c-314894deeb3a' for list template '433' is not installed in this farm

2011-09-07T08:55:00.001-07:00

If you are working with MOSS 2007 you may have ran into the error “Feature '2510d73f-7109-4ccc-8a1c-314894deeb3a' for list template '433' is not installed in this farm”. This happened when I tried to switch to kerberos from NTLM authentication in MOSS 2007. The fix was:

stsadm -o uninstallfeature -force -name ReportListTemplate

Then run:

stsadm -o installfeature -force -name ReportListTemplate

It worked for me but may or may not work for you!

My first post for the month of September!

Configuring a SQL user script

2011-08-31T12:51:00.001-07:00

I have been working on a script to make my job easier at work. The script I needed to create was to take variables set once and create a SQL user account while setting the required permissions. After numerous trials and many failures I have it finished. I figured I would share it with the world so someone else can stop pulling out their hair. If you find a better way let me know.

I make no warranties.

USE [master]
GO

DECLARE
@UName varchar(255),
@Password varchar(255),
@dbName nvarchar(255),
@sqlstmt varchar(200);

/*****SQL USer Account 'change test to what the account is going to be'*/
SET
@UName = 'test'
/*****Password for account 'change test1'*/
SET
@Password = 'test1'
/*****Database you wish to create the account for*/
SET
@dbName = 'CGS_sde'

/*****Setup user in SQL*****/
EXEC ('CREATE LOGIN '+ @UName + ' WITH PASSWORD=''' + @Password + ''', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF');
/*****Setup user in specified database set above*/
EXEC('USE ' + @dbName + ' CREATE USER [' + @UName + '] FOR LOGIN [' + @UName + ']')
/*****Set permissions in database for user*/
EXEC ('USE ' + @dbName + ' EXEC sp_addrolemember ' + 'db_datareader,' + @UName);
EXEC ('USE ' + @dbName + ' EXEC sp_addrolemember ' + 'db_datawriter,' + @UName);
EXEC ('USE ' + @dbName + ' EXEC sp_addrolemember ' + 'db_securityadmin,' + @UName);
EXEC ('USE ' + @dbName + ' GRANT CREATE PROCEDURE TO [' + @UName + ']');
EXEC ('USE ' + @dbName + ' GRANT CREATE TABLE TO [' + @UName + ']');
GO

Going Open Source?

2011-08-05T20:35:00.000-07:00

What would it take for me to ditch my Windows OS and go with a version of Linux? That is a good question! I know I could do email, office (documents, spreadsheets, presentations), web surfing, and blogging with open source. My main thing is all the games that I play are for Windows. Could I survive with using linux? I might have to try an experiment on my home system..........hmmmmm!

Need a laugh

2011-07-25T19:06:00.003-07:00

If you need a good laugh go here: http://damnyouautocorrect.com!

First blog for the site.

2011-07-25T18:56:00.000-07:00

This is my first blog since moving to Blogger.com. I will try to blog about SQL, beer brewing, and other things. This site was orginally for my family's tree, but there was little intrest from the family, so I am doing my own thing!