Regarding msdb permissions, I gave dtsadmin, dtstlduser, and SQLAgentReader, and my users use the proxy account to run the jobs.

BTW, the answer to this was for the application to be reloaded so that it could export the .dll files again. Once done, everything worked.

I'm new to Reporting Services also, but I finally managed to find at least some of this information. Oddly enough, you go to Add/Remove Programs -> Microsoft SQL Server...

BTW, I am running SQL Server 2005 SP3.

Awesome! Yes, almost all of our databases are VERY small, hence the reason I am not used to such questions in regards to SQL. (The DB2 database is...

I've just been jumping through hoops as another user locked his id. I found the following method to work: Uncheck the "Login is locked out" and uncheck "Enforce...

That's exactly what I wound up having to do. And, yes, you're right. That's stupid! :crazy:

I am having the same issue. I have a sql-authenticated id that is locked out due to numerous incorrect passwords. I go in as the system admin, change...

We were always pleased with ERwin.

If it is a production database, I would recommend the full database recovery model with frequent backups of the transaction log if it is normally large.  Also, remember that if...

Remember to perform a full database backup if you choose to run the DBCC shrinkfile command.  Since that command is not logged, it will invalidate your transaction log flow, thereby...

I had a similar issue.  Try stopping and restarting the instance.  Give it some time to allow the Exchange Server (if that's what you're using) to process, then you should...

You can always backup your transaction log with truncate_only then perform a shrink on the log files to make them smaller.  This should reclaim the space on your drive.  After...

Have you tried using the Export Data option in EM and checked the box for "copy SQL Server logins" on the "default options" button in the wizard?  This should allow...

Delete that user from the database, then you should be able to change it with no problem.  (When you change owner and go back under users for that database, you'll...