1
  • Linked SQL Server problems

    I have 2 servers. Server 1 has SQL 2000 (SP2). Server 2 has SQl 2000 + SQL 2005 (sp2). I'm 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 try to create a linked server to SQl 2005, I get...

    KH155 pointsBadges:
  • Lotus Notes to SQL Server 2005 via 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...

    Awaller5 pointsBadges:
  • Pulling data from tables on different servers

    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...

    CO Bill120 pointsBadges:
  • sql server remote server connection

    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.

    Preethibh5 pointsBadges:
  • Linked SQLServer

    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.

    Db23290 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following