Hi!
I'm using MSSQL 2005 Express, win7 64bit.
linked Server error:
TITLE: Microsoft SQL Server Management Studio Express
------------------------------
"The linked server has been updated but failed a connection test. Do you want to edit the linked server properties?"
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "GAMESERVER".
OLE DB provider "MSDASQL" for linked server "GAMESERVER" returned message "[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Invalid Instance()).&qu ...
Go to the complete details ...