HATA MESAJI:
"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)"
AÇIKLAMA:
SQL Server Instance' ınıza bağlanırken böyle bir hata mesajıyla karşılaşabilirsiniz.
ÇÖZÜM:
Eğer bu hata mesajını alıyorsanız, belirttiğiniz SQL Server adı doğrudur; fakat bağlanılmaya çalışılan SQL Server servisi çalışmıyordur.
SQL Server servislerinin çalışırlığını kontrol etmek için SQL Server Configuration Manager veya Services MMC' sini (Başlat\Çalıştır = services.msc ENTER) kullanabilirsiniz.
Hakkımda
- Ekrem Önsoy
- MCP, MCDST, MCDBA, MCTS:SQL SERVER 2005, MCITP:DBA, MCSA, MCAD.Net, MCSD.Net, MCBMSP, MCT, SQL Server MVP Http://www.ekremonsoy.net ekrem@compecta.com
Günlük Arşivi
Yararlı Adresler ve Uygulamalar
İzleyiciler
Etiketler
- SQL Server 2008 (9)
- Replication (5)
- System.Data.SqlClient.SqlError (4)
- "Microsoft SQL Server (3)
- SQL SERVER 2005 performans (3)
- SQLCMD (3)
- BACKUP (2)
- Error: 10053 (2)
- Error: 29565 (2)
- Katmai (2)
- Login failed for user (2)
- Microsoft SQL Server (2)
- RestoreContainer::ValidateTargetForCreation (2)
- SQL Server 2005 upgrade (2)
- SQL Server Agent (2)
- SQL Server Setup (2)
- TDSSNIClient (2)
- sql server 2008 certification (2)
- sql server 2008 sertifikasyon (2)
- "String or binary data would be truncated." (1)
- 'LandingPage' is not a valid value for setting 'ACTION' (1)
- (SqlMgmt) (1)
- :[DBNETLIB][ConnectionOpen (Invalid Instance()).]Invalid connection (1)
- A component that you have specified in the ADD_LOCAL property is already installed. (1)
- A connection could not be established to (1)
- A severe error occurred on the current command (1)
- A valid SQL Server installation does not exist in the specified location (1)
- ASP.Net Version Registration Requirement (Warning) (1)
- ASPNET account (1)
- Access denied (ObjectExplorer) (1)
- Access denied to the path (1)
- Active\Active (1)
- Active\Passive (1)
- Ad hoc update to system catalogs is not supported (1)
- Agent XP (1)
- An error has occurred while establishing a connection to the server (1)
- An invalid startup option might have caused the error (1)
- Arithmetic overflow (1)
- Arithmetic overflow error converting numeric to data type numeric. (1)
- Audit (1)
- Auditing (1)
- CREATE DATABASE failed (1)
- Cannot open user default database (1)
- Cannot truncate table (1)
- Class not registered (1)
- Collation (1)
- Compressed Backup (1)
- Connections to SQL Server files (*.mdf) require SQL Server Express 2005 (1)
- Could not allocate enough disk space for a new database on the named disks (1)
- Create failed for JobStep 'Subplan' (1)
- Create maintenance plan failed (1)
- Cursor (1)
- DMF (1)
- Database Hosting (1)
- Database Mail (1)
- Database Mirroring (1)
- Database Snapshot (1)
- Database Upload (1)
- Database cannot be upgraded because it is read-only or has read-only files (1)
- Database diagram support objects cannot be installed because this database does not have a valid owner (1)
- Declarative Management Framework (1)
- Device activation error (1)
- Distributor (1)
- Drop failed for Login (1)
- Düğüm (1)
- Error 0xc002f210 (1)
- Error 5(error not found) occurred while opening file (1)
- Error: 10061 (1)
- Error: 1412" (1)
- Error: 1418" (1)
- Error: 1478" (1)
- Error: 1498 (1)
- Error: 15151 (1)
- Error: 15335 (1)
- Error: 233 (1)
- Error: 4064 (1)
- Error: 5063 (1)
- Error: 53 (1)
- Event ID: 17052 (1)
- FRunCM (1)
- Failback (1)
- Failover (1)
- Full-Text Index Catalog (1)
- GDR 3068 (1)
- GDR update 3054 (1)
- High Availability (1)
- Hosting Toolkit (1)
- IIS Reporting Services (1)
- IP listesi (1)
- IP numarası (1)
- Installation (1)
- Instant File Initialization (1)
- It is acting as a mirror database (1)
- Kayıt Dosyası (1)
- Küme (1)
- LandingPage (1)
- LaunchLocalBootstrapAction (1)
- Login failed (1)
- Login failed for user '(null)'. (1)
- Login failed for user . This user is not associated with a trusted SQL Server connection. (1)
- MCA (1)
- MCITP (1)
- MCPD (1)
- MCT (1)
- MCTS (1)
- MSMQTask.dll (1)
- MSXML (1)
- MVP (1)
- Merge (1)
- Microsoft 2008 Sunucu ve Yazılım Platformu Lansmanı (1)
- Microsoft Certified Trainer (1)
- Microsoft SQL Native Client (0x80004005) (1)
- Microsoft SQL Server 2008 (1)
- Microsoft.SqlServer.MaintenancePlanTasks (1)
- Microsoft.SqlServer.MaintenancePlanTasksUI (1)
- Microsoft.SqlServer.Management.DatabaseMaintenance.TaskUIUtils..ctor() (1)
- Microsoft.SqlServer.Management.MaintenancePlanWizard (1)
- Microsoft.SqlServer.Management.Smo.Agent.JobObjectKey (1)
- Microsoft.SqlServer.Management.Smo.SimpleObjectKey (1)
- Mirror (1)
- Msg 14684 (1)
- NO_LOG (1)
- No connection could be made because the target machine actively refused it (1)
- ODBC SQLState: 42000 (1)
- Object Explorer (1)
- Only one administrator can connect at a time (1)
- Otomatik Yedek (1)
- Principal (1)
- Publisher (1)
- RESTORE (1)
- RESTORE DATABASE is terminating abnormally (1)
- Replikasyon (1)
- Resource Veritabanı (1)
- Retrieving the COM class factory for component with CLSID (1)
- SQL Cluster (1)
- SQL Server 2008 Management Studio Express Edition (1)
- SQL Server Collation (1)
- SQL Server MVP (1)
- SQL Server Protokoller (1)
- SQL Server RS IIS (1)
- SQL Server Replace (1)
- SQL Server Setup could not run (1)
- SQL Server Setup failed to execute a command for server configuration (1)
- SQL Server evaluation period has expired (1)
- SQL Server noktalı virgül (1)
- SQLServer2005MSSQLUser$COMPUTERNAME$MSSQLSERVER (1)
- SQLVDI: Loc=CVDS::Cleanup. Desc=Release(ClientAliveMutex). ErrorCode=(288)Attempt to release mutex not owned by caller. (1)
- SSMS Splash screen (1)
- SSMS ağır (1)
- SSMS yavaş (1)
- Server doesn't support requested (1)
- Server is in single user mode (1)
- Setup cannot write system databases (1)
- Snapshot (1)
- Subquery returned more than 1 value (1)
- Subscriber (1)
- Sürekli Kullanılabilirlik (1)
- Sıkıştırılmış Yedek (1)
- TEMPDB (1)
- TRUNCATE_ONLY (1)
- Table Valued Parameters (1)
- The CREATE DATABASE statement failed (1)
- The database cannot be opened (1)
- The error was [Microsoft][SQL Native Client][SQL Server]Windows NT user or (1)
- The log in this backup set begins at LSN (Bir sayı) (1)
- The physical file name may be incorrect (1)
- The primary file must be at least 3 MB to accommodate a copy of the model database (1)
- The report server has encountered a configuration error (1)
- The request failed or the service did not respond in a timely fashion (1)
- The server network address can not be reached or does not exist (1)
- The server principal "login_adı" is not able to access the database "veritabanı_adı" under the current security context. (1)
- The server principal owns an endpoint and cannot be dropped. (1)
- The service did not start due to a logon failure (1)
- Too many backup devices specified for backup or restore; only 64 are allowed (1)
- Too many backup devices specified for backup or restore; only 64 are allowed. RESTORE DATABASE is terminating abnormally (1)
- Total space allocated must be at least MB to accommodate a copy of the model database (1)
- Transaction Log (1)
- Transactional (1)
- Transactional Replication (1)
- Trigger (1)
- Tuning this edition of SQL Server 2005 is not permitted. (1)
- Unable to cast object of type (1)
- Upgrade Blockers (1)
- User Defined Table Type (1)
- Uzaktan Bağlantı (1)
- Veritabanı gönderme (1)
- Witness (1)
- Yedek (1)
- Yeni Nesil Sertifika (1)
- Your upgrade is blocked. (1)
- dbmslpcn (1)
- error: 26 (1)
- error: 28 (1)
- failed due to the following error: 80040154 (1)
- g\ç (1)
- has insufficient transaction log data to preserve the log backup chain of the principal database (1)
- has not been rolled forward to a point in time that is encompassed in the local copy of the database log (1)
- i\o (1)
- inaccessible files or insufficient memory or disk space (1)
- intellisense (1)
- management studio yavaş (1)
- master database (1)
- network library (1)
- operating system error 3 (1)
- rsreportserver.config (1)
- sector size (1)
- service failed to start due to the following error (1)
- sparse (1)
- sparse columns (1)
- sqlncli.msi (1)
- tablesample (1)
- when the job fails (1)
- when the job succeeds (1)
- which is too recent to apply to the database. An earlier log backup that includes LSN (Bir sayı) can be restored (1)
2 yorum:
Merhaba,
Bu hatayı alıyorum ve bir türlü hatayı gideremedim. Yazdığınız çözüm ile "hizmetler" alanına geldim fakat buradan sonra ne yapmam gerekiyor? Listede SQL Server'a dair herhangi birşey göremedim? (SQL Server 2008 ve win xp sp3 kullanıyorum) Lütfen yardımcı olur musunuz? Teşekkür ederim.
Eğer SQL Server Configuration Manager veya Services MMC' de SQL Server servislerini göremiyorsanız zaten SQL Server servisleri yüklü değildir. Bunun gibi çok durumla karşılaştım. Kullanıcı kurulum yapıyor ve başarılı sonuçlandığını düşünüyor fakat SQL Server servisleri yüklenmemiş oluyor. Management Studio, SSCM gibi araçlar yüklenmiş olması SQL Server servislerinin tamamının da (ki özellikle de Database Engine servisi) sağlıklı bir şekilde yüklenmiş olduğu anlamına gelmiyor.
SQL Server kurulum kayıt dosyalarını (Log dosyaları) incelemenizi ve kurulum sonucunu görmenizi tavsiye ederim.
Yorum Gönder