March 13, 2020 at 7:13 pm
Here's a strange one that I just cannot figure out.
I have SQL Server 2017 installed on ServerONE with SSMS v17. I have another server, ServerTWO, that has various tools installed including SSMS v13 (but no SQL Server instance). Whenever I log onto ServerONE and try to connect with my domain account, I get the following error:
Error connecting to 'ServerONE\SQLInstance'.
Additional Information:
Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Skd.Sfc)
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
The EXECUTE permission was denied on the object 'xp_msver', database 'mssqlsystemresource', schema 'sys'. (Microsoft SQL Server, Error: 229)
However, if I log onto ServerTWO and use SSMS v13 to connect to ServerONE\SQLInstance, it connects with no issue. Any idea why I can connect remotely but not locally?
March 13, 2020 at 8:12 pm
Did you specify a database during connection? Something tells me the option was set on one instance of SSMS and not the other. You are probably connecting to the default database which may be a system db that you don't have access to.
During connection click on Options -> Connection Properties -> Connect to database
March 13, 2020 at 8:41 pm
Thanks for the direction. As it turns out, my domain account had to be granted execute permission to xp_msver. Which really doesn't make any sense, since I was able to connect remotely, just not when logged on locally. Really weird, but working now. Thanks for the reply!!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply