Hi,
If you machine have multiple instance then, you need to specify the instance name.
Other wise use only IP/ Name.
Please check on which port SQL server is running
Run this Query through sysadmin
SELECT
e.name as ProtocolName
,ec.local_tcp_port as Port
,ec.local_net_address as IP
FROM
sys.endpoints e
LEFT JOIN
sys.dm_exec_connections ec
ON
ec.endpoint_id = e.endpoint_id
where
e.name = 'TSQL Default TCP'
GROUP BY
e.name
,ec.local_tcp_port
,ec.local_net_address
Then use IP,Port and try again.
Submit an article or tip