EDIT: YAY! I can post now! Except when I try to post the additional info, it craps out on me... Let me try without the code bit and see if that's the issue.
Okay, here's the additional info:
I know the issue is a SQL Server permission. I'm trying to figure out what permission. The login has permissions on the database with a proc that checks the NAS. I just gave the login sysadmin (for 2 seconds) and suddenly the webpage worked.
So I have db_owner permission in the database that this proc is housed in. I granted EXEC on schema "me" just to be sure that it could execute the proc. Then I even added db_datareader, db_datawriter, and CREATE TABLE permissions in TempDB to be sure. Then I granted EXECUTE and public to the master database.
Still getting the stupid error in the webpage.
This login has no server wide perms. Any thoughts on what permission I can give this login without granting it sysadmin access to run this code?
BTW: The server admin came back with "this login has full permissions to the NAS" before I tested the sysadmin permissions.
Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.