SQL SERVER – trouble shooting after installation FIX : ERROR : (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error: ) This is just a quick refresher. Make sure to bookmark this as you never know when you would need this solution. Let us check into the steps to resolve this error. 1) SQL Server should be up and running. Go to All Programs >> Microsoft SQL Server 2008 >> Configuration Tools >> SQL Server Configuration Manager >> SQL Server Services, and check if SQL Server service status is “Running”. 2) Enable TCP/IP in SQL Server Configuration When two or more SQL Servers are connected across network they do all communication using TCP/IP. The default port of SQL Server installation is 1433. This port can be changed through SQL Server Configuration Manager . TCP/IP should be enabled for SQL Server to be connected. Go to All Programs >> Microsoft SQL Server 2008 ...
Postingan
Error : attributes do not match. present attributes (directory compressed) included attributes (0) Cause: Sql server will validate the installation folder during the setup process to check if no Archive attribute as set on the installation folder The installation folder includes “C:\Program Files\Microsoft SQL Server and if you have it C:\Program Files (x86)\Microsoft SQL Server.” Solution: - Go to SQL server installation directory - C:\Program Files\Microsoft SQL Server - C:\Program Files (x86)\Microsoft SQL Server - Right click on the folder and go to properties - Click on general tab and click on Advanced and uncheck the option “Folder is ready for archiving” - Try doing the installation again it will be successful
Error: Could not load type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSPackageSigning100' from assembly 'Microsoft.SqlServer.DTSRuntimeWrap, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'.. Resolution: Tools – Options – Business Intelligence Designers – Integration Services Designers – General – Check digital signature when loading a package then "unchecked" the box thanks to: https://gjsrinivas.wordpress.com/2012/12/23/could-not-load-type-microsoft-sqlserver-dts-runtime-wrapper-idtspackagesigning100-from-assembly-microsoft-sqlserver-dtsruntimewrap-version10-0-0-0-cultureneutral-publickeytoken89845dcd8080/
Pernahkan anda setelah sukses menginstal SQL Server namun kesulitan untuk melakukan koneksi dari client (komputer lain?) Saya pernah dan itu sangat menyita waktu bahkan bisa bikin frustasi. Padahal ada trik yang mudah untuk mengetahui pada port berapakah service MSSQL berjalan setelah kita melakukan instalasi? Salah satu caranya adalah Copy atau ketikkan perintah berikut di SSMS, Execute dan lihatlah hasilnya: set nocount on DECLARE @test varchar(20), @key varchar(100) if charindex('\',@@servername,0) <>0 begin set @key = 'SOFTWARE\MICROSOFT\Microsoft SQL Server\'+@@servicename+'\MSSQLServer\Supersocketnetlib\TCP' end else begin set @key = 'SOFTWARE\MICROSOFT\MSSQLServer\MSSQLServer\Supersocketnetlib\TCP' end EXEC master..xp_regread @rootkey='HKEY_LOCAL_MACHINE',@key=@key,@value_name='Tcpport',@value=@test OUTPUT SELECT 'Server Name: '+@@servername + ' Port Number:'+convert(varchar(10),@test)
*** Misal USB Flash disk ada di drive G: ** *** DVD Installer WIN7 ada di drive E:, atau bisa juga pakai file image (extension: ISO,img,nrg, dll) *** dan dimount ke drive E:, atau diextract ke folder *** Klik Start Run ( kalo di Windows 7/8, Klik " Search program and files "), ketikkan "CMD" prompt (Klik kanan "run it as administrator"). Ikuti step by step command promt di bawah: C:\Windows\system32>DISKPART DISKPART> LIST VOL DISKPART> SELECT VOL 5 *** asumsi USB flash disk ada pd vol 5 *** DISKPART> ACTIVE DISKPART> EXIT C:\Windows\system32>PATH E:\BOOT C:\Windows\system32>BOOTSECT /NT60 G: C:\Windows\system32>XCOPY /S E:\. G:\ C:\WINDOWS\SYSTEM32>EXIT *** USB flash disk sdh bisa dipakai utk booting, pastikan urutan booting di BIOS sudah USB pada ururtan pertama *** *** Mudah bukan? Selamat mencoba ***