berbagisolusi
hostname
Getting Client IP Address from SQL Server
First you must open blocked xp_cmdshell command sp_configure ‘show advanced options’,1 GO RECONFIGURE GO sp_configure xp_cmdshell,1 GO RECONFIGURE You can try this action to check your reconfigure is active and already use EXEC master.dbo.xp_cmdshell ‘ipconfig’ Second, please copy this procedure to getting IP address after SQL Server resulting client HOST NAME : USE [dbname] GO … Continue reading
MsSQL Server (Error : Connection Timeout) or (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error: )
1. HOST If you have that’s problem first check your host. If you didn’t success made connection using IP addres, try using YOURHOSTNAME/SERVICE_NAME Example your IP 192.168.1.111, and your host : TheGeek-Area, sqlserver service NETSQLSERVER, then you can write the host is TheGeek-Area/NETSQLSERVER 2. SQL Server should be up and running. Go to All Programs … Continue reading
Web Statistic
berbagisolusi 