Re: How to connect to a remote server from a local studio manager

My Linksys RVS4000 (the router that's used to connect my network to the ADSL network modem) is designed to host VPN connections. This can also be done with a dedicated ISA server, but that's not really necessary now that the routers have gotten so smart. Once you have this router in place, you can easily use any (modern) Windows client to establish a VPN connection to the network. Users would authenticate via the network's Domain controller and be permitted access to the net given the constraints of their domain account. This data is encrypted and permits your client applications to open connections as if they were on the local area network. And no, I don't use the Linksys VPN client software.

hth

--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker’s Guide to Visual Studio and SQL Server (7th Edition)
http://betav.com/blog/billva
____________________________________________________________________________________________



"goldenrate" <goldenrate@xxxxxxxxxxxxx> wrote in message news:A300B785-D585-4350-8447-C91D11A036E9@xxxxxxxxxxxxxxxx
Thank You Bill, Thank you Mark,

I think that what I'm looking to do is something that has been suggested by
Bill. That is, I'd like to see my remote server as part of my Local Network
and then, so I think, I'll be able to see it listed as an option of the
'Server Name' drop down list on MSSQL Server Management Studio (connect to
server widow).

If so, i need to set up a VPN connection to Server2003. I must say that I
have never set up such a connection and I'd like to have more information
regarding this topic.

Thank you both for your help.

David

"William (Bill) Vaughn" wrote:

Ah, I wouldn't use straight TCP/IP--it's too dangerous and not particularly
reliable. I would setup a VPN connection to protect the data and add a
degree of stability to the connection. With a VPN connection the external
server(s) should be visible to each other and to the tools you'll use to
access them.

--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker’s Guide to Visual Studio and SQL Server (7th Edition)
http://betav.com/blog/billva
____________________________________________________________________________________________



"goldenrate" <goldenrate@xxxxxxxxxxxxx> wrote in message
news:AFA90545-C591-455B-8EB8-6DA41341E2EC@xxxxxxxxxxxxxxxx
> Hi Marke,
> Thank you for upur prompt response.
>
> I think I need to further clarify my scenario. I have 2 machines, one
> local
> (California) and one remote (Arizona). On both I have MSSQL2008 > ENTERPRISE
> installed. On both instances of MSSQL2008 I use Windows Authentication > to
> login.
>
> I'd assume that in order to conect to the remote computer, the server > name
> should be something like <remoteServerIPAddress>:1433, which is the > port
> that
> SQL2008 is listen to, and then apply my credentials (windows
> authentication
> of the remote?). Does it make any sense to you?
>
> I read your solution again and realized that I might need to make some
> preperations tio connect to my database remotely. Maybee I should have
> added
> the remote computer first to my network (if so I dont know how), or
> configure
> my remote computer/ server in some way.
>
> All Best,
> David
> "Mark Han[MSFT]" wrote:
>
>> Hi Customer,
>>
>> Thank you for using Microsoft MSDN Managed Newsgroup. My name is Mark
>> Han.
>> I am glad to work with you on this issue.
>>
>> Based on the description, I understand that you would like to use
>> management studio to connect to a remote SQL Server. Is it correct?If >> I
>> have misunderstood, please tell me. That will help us resolve the >> issue
>> quickly.
>>
>> To address your concern, I would like to explain the following.
>> 1 to use management studio to connect to a remote SQL Server, you just
>> need
>> to type the remote SQL Server name in the 'server name'. For example:
>> MICROSOF-7F6FD3\share( machine_name\instance_name)
>>
>> 2 to find a remote SQL Server in management studio "connect to server"
>> dialog, please click server-> click "browse for more"-> choose >> "network
>> servers"
>>
>> If there is anything unclear or you need me further explain, please
>> email
>> me and then I will send some screen-shot to you. My email address is
>> v-fathan@xxxxxxxxxxxxxxxxxxxx(remove online)
>>
>> Hope the above helpful. Thanks.
>>
>> Best regards,
>> Mark Han
>> Microsoft Online Community Support
>> ===========================================================
>> Delighting our customers is our #1 priority. We welcome your
>> comments and suggestions about how we can improve the
>> support we provide to you. Please feel free to let my manager
>> know what you think of the level of service provided. You can
>> send feedback directly to my manager at: msdnmg@xxxxxxxxxxxxxx
>> ===========================================================
>> Get notification to my posts through email? Please refer to
>> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
>> ications.
>>
>> Note: MSDN Managed Newsgroup support offering is for non-urgent issues
>> where an initial response from the community or
>> a Microsoft Support Engineer within 2 business day is acceptable. >> Please
>> note that each follow up response may take approximately
>> 2 business days as the support professional working with you may need
>> further investigation to reach the most efficient resolution.
>> The offering is not appropriate for situations that require urgent,
>> real-time or phone-based interactions. Issues of this nature are
>> best handled working with a dedicated Microsoft Support Engineer by
>> contacting Microsoft Customer Support Services (CSS) at
>> http://msdn.microsoft.com/en-us/subscriptions/aa948874.aspx
>>
>> ============================================================
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> =========================================================
>>
>>

.

Relevant Pages

  • RE: Poor XP network performance 2003 LAN
    ... We have 3 meg bonded T1 in Corp office and the network is as follows, ... when I remote VPN into the LAN I can ... pull data from shared drive on the server or shared folders on PC's. ... However if I setup a Linux or Mac OSX ...
    (microsoft.public.windows.server.general)
  • Can Not connect to IPC$ Share while processing a CCR
    ... CCM log shows the SMS server successfully connecting to the Admin$ share, but the attempt to connect to the IPC$ shares of these systems fails with an error 5. ... Logical Disk Manager Administrative Service ... Network Associates Task Manager ... Remote Access Auto Connection Manager ...
    (microsoft.public.sms.setup)
  • RE: Poor XP network performance 2003 LAN
    ... We have 3 meg bonded T1 in Corp office and the network is as follows, ... when I remote VPN into the LAN I can ... I pull/push data to the server I can do it @ 350KBps and with the VPN ... OS X and even the Windows 2003 server has great performance but from outside ...
    (microsoft.public.windows.server.general)
  • Re: Site-to-Site with ISA 2004
    ... When you try connecting to the remote office on ... SBS server, the VPN doesn't work. ... <machines on the network I am able to connect to the client's office. ...
    (microsoft.public.windows.server.sbs)
  • Re: Trouble with remote access Brand NEW SBS2003 Install
    ... >> server name (right click MNP and find computers on network) I can then ... > and reconnecting the VPN got it back. ... > to remote users via remote desktop, which not only gives access to files ...
    (microsoft.public.windows.server.sbs)
Quantcast