Access sql server from one place to another.

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

Access sql server from one place to another.

Author

Topic

blocker
Yak Posting Veteran

89 Posts

Posted - 2010-03-22 : 21:09:09

Good day.

I just want to know the complete steps on how to access 2 sql server with the same database from one place to another with static ip address.

Thank you for any ideas. God bless.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-03-22 : 21:15:14

You can use a linked server to query a remote database. To use an IP address, just setup an alias that points to the IP address and then use the alias name as the linked server name. You can create aliases in the Configuration Manager tool. You can create linked servers in Management Studio.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

blocker
Yak Posting Veteran

89 Posts

Posted - 2010-03-23 : 20:58:48

thank you for the idea.try this out and post the result back.

God bless.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-03-23 : 21:03:51

No problem.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources