SQL Server Performance Forum – Threads Archive
SQL Server 2005 DevelopersI am trying to connect a remote instance of sql server 2005 to my client sql server install using sql server 20005 developers edition, but I keep getting the following error message:
TITLE: Microsoft SQL Server Management Studio
—————————————- Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) For help, click:http://go.microsoft.com/fwlink?ProdName=Microsoft SQL Server&LinkId=20476 —————————————-
ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) —————————————- Invalid column name ‘mirroring_role’.
Invalid column name ‘mirroring_state’.
Invalid column name ‘mirroring_state’. (Microsoft SQL Server, Error: 207) For help, click:http://go.microsoft.com/fwlink?Prod…187&EvtSrc=MSSQLServer&EvtID=207&LinkId=20476 —————————————-
—————————————- I am however able to connect directly from the server (with sql server 2005 enterprise installed). Has anyone else come across this? How did you manage to resolve it?
Ensure the account used to connect both the instances has requried privileges.
I have had similar problem where my account was not a part of SYSADMIn on the remote machine. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.
I have now managed to figure out the problem. The beta version of Sql 2005 Developer was older than than the Enterprise version I ws trying to connect to.