SpikeB Posted February 4, 2011 Share Posted February 4, 2011 Ive installed SQL Server 2008 R2 DataCenter Edition and im trying to use the default instance for Backup Exec 2010 by Symantic however when i reach the choose sql server section im told to add logon permission to my-domain.com\Administrator (should have access already). in SQL Server Management Studio the default login name is the netbios name of the server and attempting to create my-domain.com\Administrator gives Windows NT user or group not found. Has anyone expierenced the same problem or know a solution ? Link to comment https://www.neowin.net/forum/topic/973476-sql-server-2008-and-backup-exec-2010/ Share on other sites More sharing options...
sc302 Veteran Posted February 4, 2011 Veteran Share Posted February 4, 2011 try computername\administrator vs domainname\administrator Link to comment https://www.neowin.net/forum/topic/973476-sql-server-2008-and-backup-exec-2010/#findComment-593666698 Share on other sites More sharing options...
SpikeB Posted February 4, 2011 Author Share Posted February 4, 2011 In backup exec it asks me would i like to create computername\Administrator and then says it allready exsists (without letting me continue) and in SQL Server Management Studio computername\Administrator gives Windows NT user or group not found. Link to comment https://www.neowin.net/forum/topic/973476-sql-server-2008-and-backup-exec-2010/#findComment-593666796 Share on other sites More sharing options...
sc302 Veteran Posted February 4, 2011 Veteran Share Posted February 4, 2011 If you could setup with a teamviewer session I could take a look. It sounds like something is not configured properly on the backup server end (proper username and password combo). Click the join a session link, not the download full. Full install will not work on windows server without licensing. Link to comment https://www.neowin.net/forum/topic/973476-sql-server-2008-and-backup-exec-2010/#findComment-593666940 Share on other sites More sharing options...
SpikeB Posted February 4, 2011 Author Share Posted February 4, 2011 Sure ill pm you in a second thanks for the help Link to comment https://www.neowin.net/forum/topic/973476-sql-server-2008-and-backup-exec-2010/#findComment-593666968 Share on other sites More sharing options...
garethevans1986 Posted February 7, 2011 Share Posted February 7, 2011 I use a script: USE MASTER; DECLARE @BackupLocation VARCHAR(max) DECLARE @BackupFileName VARCHAR(max) DECLARE @DatabaseName VARCHAR(max) DECLARE @FullBackupLocation VARCHAR(max) DECLARE @BackupName VARCHAR(MAX) DECLARE @DayNumber VARCHAR(max) SET @DatabaseName = 'DBName' SET @BackupLocation = 'D:\BackupLocation\' IF DATEPART(DD, GETDATE()) < 10 SET @DayNumber = '0' + CAST(DATEPART(DD, GETDATE()) AS VARCHAR) ELSE SET @DayNumber = CAST(DATEPART(DD, GETDATE()) AS VARCHAR) SET @BackupFileName = @DatabaseName + '_' + CAST(DATEPART(yyyy, GETDATE()) as VARCHAR) + CAST(DATEPART(MM, GETDATE()) AS VARCHAR) + @DayNumber + '_' + CAST(DATEPART(HH, GETDATE()) AS VARCHAR) + CAST(DATEPART(MINUTE, GETDATE()) AS VARCHAR) + CAST(DATEPART(SECOND, GETDATE()) AS VARCHAR) +'.BAK' SET @BackupName = 'Full Backup of ' + @DatabaseName SET @FullBackupLocation = @BackupLocation + '\\' + @BackupFileName PRINT 'BackupFileName: ' + @BackupFileName PRINT 'BackupName: ' + @BackupName PRINT 'BackupLocation: ' + @BackupLocation PRINT 'FullBackupLocation: ' + @FullBackupLocation BACKUP DATABASE [BEDB] TO DISK = @FullBackupLocation WITH FORMAT, COMPRESSION, NAME = @BackupName GO Change: SET @DatabaseName = 'DBName' SET @BackupLocation = 'D:\BackupLocation\' Use SQL Agent to run the job. GE Link to comment https://www.neowin.net/forum/topic/973476-sql-server-2008-and-backup-exec-2010/#findComment-593673690 Share on other sites More sharing options...
sc302 Veteran Posted February 7, 2011 Veteran Share Posted February 7, 2011 He isn't trying to back it up. He is trting to use sql as the dbe vs sql express. I believe the sql install is fudged and pointed him to either read the install manual or make a vm instance of a backup server usimg sql express. Link to comment https://www.neowin.net/forum/topic/973476-sql-server-2008-and-backup-exec-2010/#findComment-593673728 Share on other sites More sharing options...
garethevans1986 Posted February 8, 2011 Share Posted February 8, 2011 *Face palm* Note to self: Read the whole thread.... Link to comment https://www.neowin.net/forum/topic/973476-sql-server-2008-and-backup-exec-2010/#findComment-593677578 Share on other sites More sharing options...
Recommended Posts