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.
| Author |
Topic |
|
gorganite
Starting Member
2 Posts |
 Posted - 2006-06-22 : 02:58:52
|
| how do i connect my SQL Server DB remotly with my desktop eddition SQL server runing on WinXP Pro. my DB is locate on Dedicated Web Server running on Windows 2003 Server.regards, |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-06-22 : 03:13:54
|
Create a Linked Server.In Books Online, I can readHow to set up a linked server (Enterprise Manager)To set up a linked server Expand a server group, and then expand a server.Expand Security, right-click Linked Servers, and then click New Linked Server.Click the General tab, and in the Linked server box, type the name of the server to link.Under Server type, click a selection. If you select Other data source, you will have to specify provider properties. Peter LarssonHelsingborg, Sweden |
 |
|
|
gorganite
Starting Member
2 Posts |
Posted - 2006-06-22 : 03:26:32
|
i think you didnt get my point, i said i have SQL Server on my Dedicated web Server to whihc i need to make connection to bakcup or restore y data bases.quote:
Originally posted by Peso
Create a Linked Server.In Books Online, I can readHow to set up a linked server (Enterprise Manager)To set up a linked server Expand a server group, and then expand a server.Expand Security, right-click Linked Servers, and then click New Linked Server.Click the General tab, and in the Linked server box, type the name of the server to link.Under Server type, click a selection. If you select Other data source, you will have to specify provider properties. Peter LarssonHelsingborg, Sweden
|
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-06-22 : 03:54:00
|
| you need to ask your hosting company to assist you, otherwise if you have connection via apps, then you can probably script out the objects and transfer the datai would suggest backup but my guess is that you don't have permission on the server aside from the apps level--------------------keeping it simple... |
|
|
|
|
|
|
|
|
Remote Connection