SQL Server 2008
I recently created a new database on a clients development server and was trying to setup a job which would perform an insert daily at about 07:00. I created a T-SQL script and the upload ran successfully. I then migrated the script to an SP and ran that also ran without problem, but when I created the job and attempted to run the job manually, I get the following error:
Executed as user: XXXXX\yyyy.
Cannot bulk load because the file "P:\Pathname\Subpathname\F
t" could not be opened.
Operating system error code 3(The system cannot find the path specified.).
[SQLSTATE 42000] (Error 4861). The step failed.
I dug a bit further into the properties of this new database and there are no users or roles displayed in the SSMS Database Properties - Permission window. When I tried to add the appropriate domain\user to this database, I received an "Object name could not be found" message in a popup dialog box, even though I'm currently logged in with that account.
When I go to the server logins in SSMS and select the account the I want to grant permissions to (my current login), it will not let me change the User displayed in the Users Mapped to this login at the top of the page, or change the roles that the account has to that particular database.
I've tried changing the roles for the database with:
EXEC sp_addrolemember N'db_datareader', N'XXXXX\yyyy'
EXEC sp_addrolemember 'db_datawriter', 'XXXXX\yyyy'
but those commands result in error message 15410 User or role 'XXXXX\YYYY' does not exist in this database.
This Domain\user account is listed in the server Security folder (it is what I am log in as) and is assigned sysadmin server role.
What am I doing wrong?