Tema: Re: SQL agent
Autorius: Info
Data: 2011-11-05 04:36:47
a.. SQL Server Agent can run using a built-in system account or a designated 
Windows account:

  a.. Choose Built-In account to use one of the built-in system accounts as 
the startup account. The drop-down menu gives you three options: Local 
System, Local Service, and Network Service. Local System grants access to 
the local system and certain systemwide privileges, such as Act As Part Of 
The Operating System. Local Service grants access to the local system as a 
regular service account. Network Service grants access to the local system 
and allows SQL Server Agent to access the network, such as when it is 
necessary to connect to remote systems.

  b.. Choose This account to control permissions and privileges using a 
Windows account. Type the user name and password of a Windows domain 
account. You can also click Browse to search for an account in the Select 
User Or Group dialog box.

Pas mane dabar Built-In accounts: Locol system, tai man pabandyti account 
pasirinkti tuomet paleisti sql agent job'a restartavus service, turetu 
suveikti gal.

"Ql2nz" <ql2nz@ql2nz.lt> wrote in message 
news:j91hp7$ar2$1@trimpas.omnitel.net...
> Kokiu vartotoju sukasi SQL Agentas?
>
> "Info"  wrote in message news:j91bp8$3al$1@trimpas.omnitel.net...
>
> oi meluoju, run as tuscia, neduoda nieko pasirinkti...
> "Ql2nz" <ql2nz@ql2nz.lt> wrote in message
> news:j9125f$mnq$1@trimpas.omnitel.net...
>> Kokiu vartotoju vykdomas job'as ?
>>
>>
>> "Info"  wrote in message news:j90tk8$gbt$1@trimpas.omnitel.net...
>>
>> Dar paminesiu, jog
>>
>> useradd Administrator
>> smbpasswd -a Administrator
>>
>> smb.conf
>>
>> samba security = user
>>
>> share kataloge nusirodau:
>>
>> valin users = Administrator
>>
>>
>> taig gaunasi,kad Adminu prisijungus jis ieina i samba kataloga, is kitos
>> vietos praso password, viskas ok, bet kai as smb.conf nusiimu valid users 
>> ir
>> securyti = share, tai man viskas suveikia,nesuveikia
>> is sql duombazes kopijavimas, kai security atsiranda, nors sukurus toki
>> useri ir password jis ieina i ta kataloga ir gali visokius dokumentus 
>> deti
>> ir pan., tik is sql nedraugauja...
>>
>> "Info" <testas@hyperize.lt> wrote in message
>> news:j90so5$eqe$1@trimpas.omnitel.net...
>>> Cia ne express, bet dekui uz nuomone.
>>> Va dar vienas logas, kai bandau daryti rankiniu budu backup bazes:
>>>
>>> 11/04/2011 16:19:28,Backup,Unknown,BACKUP failed to complete the command 
>>> BACKUP DATABASE testas40. Check the backup application log for detailed 
>>> messages.
>>> 11/04/2011 16:19:28,Backup,Unknown,Error: 3041<c/> Severity: 16<c/> 
>>> State: 1.
>>> 11/04/2011 16:19:28,spid82,Unknown,BackupDiskFile::CreateMedia: Backup 
>>> device '\\192.168.0.28\home\testas40.bak' failed to create. Operating 
>>> system error 5(error not found).
>>> 11/04/2011 16:19:28,spid82,Unknown,Error: 18204<c/> Severity: 16<c/> 
>>> State: 1.
>>>
>>> "Didzkis" <didzkis@gmail.com> wrote in message 
>>> news:j90scf$e40$1@trimpas.omnitel.net...
>>>> Bent jau SQL Express 2k5 pastebėjau kad su visokiais sharintais ir 
>>>> mapintais katalogais nedraugauja.
>>>>
>>>>
>>>>
>>>>
>>>> On 2011.11.04 16:17, Info wrote:
>>>
>>>
>>
>