SQL Database as a Service is a very cool feature of Windows Azure Pack. Because the SQL servers are probably internet facing you want to deploy them as secure as possible, maybe even in a different VLAN/Subnet than your WAP servers. “A network-related or instance-specific error occurred while establishing a connection to SQL Server. The […]
Tag: SQL
The EXECUTE permission was denied on the object ‘sp_tables_info_90_rowset_64’
When trying to create a linked server and executing a “select * from” I recieved the following error: OLE DB provider “SQLNCLI11” for linked server “SERVERNAME” returned message “Unspecified error”. Msg 229, Level 14, State 5, Procedure sp_tables_info_90_rowset_64, Line 1 The EXECUTE permission was denied on the object ‘sp_tables_info_90_rowset_64’, database ‘mssqlsystemresource’, schema ‘sys’. Seems like […]
