I can connect with sqlcmd successfully. In SSMS with SQLPrompt5,
connecting over VPN to remote SQL2008R2--Microsoft SQL Server, Error: 102.
The ??? marks are reported as 'extended characters' in the SSMS error message. I suspect this is a SQLProfiler select query--Is that your code in the PROFILE CAPTURE below?
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
Incorrect syntax near 'W??'.
Incorrect syntax near 'SmoEnabled'.
Unclosed quotation mark after the character string '
END
END'. (Microsoft SQL Server, Error: 102)
PROFILER CAPTURE:
@microsoftversion / 0x01000000) >= 9 AND ISNULL(IS_SRVROLEMEMBER(N'sysadmin'), 0) = 1
BEGIN
SELECT se.is_admin_endpoint AS N'AdminConnection',
(SELECT CAST(cfg.value AS bit) AS [ConfigValue]
FROM
sys.configurations AS cfg WHERE configuration_id=16387)
AS N'SmoEnabled'
FROM sys.endpoints se
INNER JOIN sys.dm_exec_connections dmc ON dmc.endpoint_id = se.endpoint_id
@spid[/img]
connecting over VPN to remote SQL2008R2--Microsoft SQL Server, Error: 102.
The ??? marks are reported as 'extended characters' in the SSMS error message. I suspect this is a SQLProfiler select query--Is that your code in the PROFILE CAPTURE below?
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
Incorrect syntax near 'W??'.
Incorrect syntax near 'SmoEnabled'.
Unclosed quotation mark after the character string '
END
END'. (Microsoft SQL Server, Error: 102)
PROFILER CAPTURE:
@microsoftversion / 0x01000000) >= 9 AND ISNULL(IS_SRVROLEMEMBER(N'sysadmin'), 0) = 1
BEGIN
SELECT se.is_admin_endpoint AS N'AdminConnection',
(SELECT CAST(cfg.value AS bit) AS [ConfigValue]
FROM
sys.configurations AS cfg WHERE configuration_id=16387)
AS N'SmoEnabled'
FROM sys.endpoints se
INNER JOIN sys.dm_exec_connections dmc ON dmc.endpoint_id = se.endpoint_id
@spid[/img]