Well. I have SSMS installed in the local machine. And I need every day create backup in the server.
I know what is the problem here. Account which I use don't have permission rights for create backup in the server.
The server and local machine have same accounts name, but the domain is different and that is the real problem.
My question is: Is it possible to create backup file on the server using application who is installed in local machine.
Using SQL Server Configuration Manager, you first need to figure out which User is starting the SQL Server service on the server.
You are looking for Account Name such as NT Service\MSSQLSERVER or a local or domain account.
You can follow this: SQL Server Configuration Manager. But don't change the configuration, you only need to copy the name of the account.
Once you know which account is used, go to the server and give this user the right to write on the folder where you wan't to create the backups or on a parent folder.