Found my problem. I had a typo. I needed a space before -E.

I am trying to setup a scheduled task using a .cmd file. I want to backup the databases. I have a script, but when the command runs the...

This one ended up helping the most.

http://www.mssqltips.com/tip.asp?tip=1486

I can't get sqlcmd to run my backup script through scheduled tasks. How would you setup the run line to call the sqlcmd and script?

Thanks.

That worked! I had to add it as admin on the network level.

Thank you.

I have already tried Method 1: Use a SQL Server Agent proxy account.

Create a SQL Server Agent proxy account. This proxy account must use a credential that lets SQL Server...

Yes.

I also noticed the following logins:

PRODUCTION\SQLServer2005MSFTEUser$PRODUCTION$MSSQLSERVER

PRODUCTION\SQLServer2005MSSQLUser$PRODUCTION$MSSQLSERVER

PRODUCTION\SQLServer2005SQLAgentUser$PRODUCTION$MSSQLSERVER

They should be:

DEVELOPMENT\SQLServer2005MSFTEUser$DEVELOPMENT$MSSQLSERVER

DEVELOPMENT\SQLServer2005MSSQLUser$DEVELOPMENT$MSSQLSERVER

DEVELOPMENT\SQLServer2005SQLAgentUser$DEVELOPMENT$MSSQLSERVER

Would below script fix these as well?

exec sp_dropserver PRODUCTION

GO

exec sp_addserver DEVELOPMENT, 'local'

GO

The OS recognizes the development server name correctly. It seems like everything recognizes it correctly except @@servername.

The_SQL_DBA (1/8/2009)

---

If they are member of a Group in windows then take them of this group that way they can't login to SQL. Create an AppUser login with SQL Authentication...

Exactly....thanks for the link.

They are neither domain admins or local admins. Builtin\Administrators is allowed access to SQL Server. They are using Windows Authentication to connect.

Unfortunately updates are being done as inline SQL. Perhaps a trigger that accounts for where the SQL command is coming from would work.

They do not have any server roles. Database roles include public and a role setup by the application.

Adding db_denydatawriter will not stop them from making updates through the application...

I'm dealing with a default instance.