I have a join between a table on my local database and a table on a different database on the same server. I reference the non-local database with DatabaseName.TableName. Now I find that the non-local database might be on a different server. I tried ServerName.DatabaseName.TableName, but I got this error: Login failed for user ‘(null)’. [...]
Answer Question | October 12, 2009 5:53 PM
Linked SQL Servers, SQL Database, SQL error messages
What is the best way to access a sql server in another country using the public ip address? I tried linked server unsuccesfully. Please help. Thanks.
Answer Question | July 2, 2009 5:03 AM
Linked SQL Servers, SQL Server Remote Connections
Hi, In oracle database you are able to link the oracle database to a SQLServer 2005 database, I want to be able to link a SQLServer 2005 another SQLServer 2005 database (not another SQLServer 2005), does SQLServer 2005 allow us to do this? Does it only allow server to server linking? Thanks.
Answer Question | April 27, 2009 10:49 AM
Linked SQL Servers, SQL Server 2005, SQL Server database, SQL Server Linked Server
I am trying to create a linked server on SQL Server 2005 to Lotus Notes 6.03. However, I keep getting an error. A system dsn was created with the Lotus NotesSQL driver (8.0). In creating the linked server on SQL Server 2005, Linked Server Name: Same name as System DSN Provider: Microsoft OLE DB Provider [...]
Answer Question | June 30, 2010 1:50 PM
Linked SQL Servers, Lotus Notes, Lotus Notes 6.03, Lotus Notes 6.x, SQL Server 2005
I have 2 servers Server 1 has sql 2000 (SP2) Server 2 has SQl 2000 + SQL 2005 (sp2) Im trying to create a linked server on Server 1 to Server 2 SQL 2005 I can get SQL 2005 linked into SQL 2000 on server 2 itself but when i got to Server 1 and [...]
Answer Question | March 6, 2009 2:34 PM
Linked Server, Linked SQL Servers, SQL Server 2000, SQL Server 2005