Trajnim databaze – troubleshooting

Problemet e lidhura me: 1) Service, 2) Network, 3) Login

*Kontrollohet:

  1. A eshte SQL Service i ndezur si sherbim
    1. Master DB Corrupted?
    2. Model DB Corrupted?
    3. TempDB path not found?
  2. nslookup (name resolution) te SQL Server instance
  3. Ping Server IP
  4. A logohesh ne windows server ku eshte instalu SQL Server per te eleminuar Network-un. (Ketu logohesh me Shared Memory Protocol)
  5. A eshte TCP/IP (ose Named Pipes) Enabled ne SQL Server
  6. A duhet qe ky login te futet ne SQL Server?
    1. A eshte bere locked out?
    2. A ka permissions to connect?
  7. Nese autentikimi behet me Domain Controller a mund te lidhet SQL Server me Domain Controller?
  8. PER CDO GJE KONSULTOHU ME SQL SERVER LOG DHE WINDOWS SYSTEM LOG.