I'd have thought AWE would be needed for this. Did you set AWE on in SQL Server?

Did you change the account usinig Enterprise Manager/Config manager? If not, you could be missing permissions.

Thanks for the update

I think you have things a little out of order.

I'm not sure you need to disconnect from the domain, but wouldn't you create all the partitions and copy the files,...

You can set the default file to be the NDF in the database properties. Then you can move the tables that experience growth to the new file by recreating their...

Very nice. Hope you had good boots for the outing.

We've got a blizzard in Denver today. Stuck in the house all day, horses locked up because of the 30+mph winds...

Don't mind Bob. He's got brain freeze from standing outside the office door too long looking for the sun

I'm not sure there's less infrastructure required, but it's an argument being made by salesforce.com, SAAS, and others since they do some help desk stuff for their software.

I do agree...

Event Viewer also shows. Not sure of the entry, but you can filter on the service and check on the #.

Do you mean you created an SSIS package?

http://msdn2.microsoft.com/en-us/library/ms141701.aspx

http://p2p.wrox.com/topic.asp?TOPIC_ID=39302

No difference. They are the same thing. Scheduling inside the plan adds a job to the server. With SP2 you'll be able to add multiple schedules.

I would agree with Colin. Answering these in an interview and getting the job lets you and the employer down. Especially if you cannot even find the answers in Books...

Have you checked these:

http://support.microsoft.com/kb/891719

http://support.microsoft.com/kb/907649

http://groups.google.com/group/microsoft.public.sqlserver.server/browse_thread/thread/822f0a40f9205c78/3e0e36ae06c87637%233e0e36ae06c87637

Third vote for app roles. Andy Warren has written about them and this is why he doesn't like Windows auth for anything other than login. Prefers to have them connect...

Brian,

Glad it's working, but can you tell us the ini file? Someone might run into this again and it would be nice if they saw your solution.

Thanks