0

I am using SQL Server 2008. I have to access our company portal database which is maintained by a third party.

They had given me login details. Please explain how to connect to their database. I can't post the link here

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Pavi
  • 335
  • 2
  • 3
  • 20

1 Answers1

0

You should be able to use the linked servers feature for this.

It is used to:

Configure a linked server to enable the SQL Server Database Engine to execute commands against OLE DB data sources outside of the instance of SQL Server.

Oded
  • 489,969
  • 99
  • 883
  • 1,009
  • i am having user name, pass word, database name and database host address. none of these are asking in linked server configuration. please give suggestion what should i do – Pavi Aug 24 '12 at 09:40
  • 1
    @user1594415 - The provider string parameter is the connection string that will contains the credentials. See http://msdn.microsoft.com/en-us/library/ms190479.aspx – Oded Aug 24 '12 at 09:51