Remote-server registration

Does MSDE support registering a (remote) sql-server.
I am trying to replicate between two computers on the Internet (both XP).
Is this a futile attempt ... must the publisher be a "full" instance of SQL
server?
check out this link:
http://support.microsoft.com/default...;en-us;Q324992
MSDE 2000 can act as both a Publisher or Distributor, and a Subscriber, and it can replicate between MSDE versions and regular versions of SQL Server. Additionally, you cannot use it for transactional publication, but you can use it as a Publisher of snap
shot replication, and merge replication, and as a Subscriber to all three types of publications.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Robert A. DiFrancesco" wrote:

> Does MSDE support registering a (remote) sql-server.
> I am trying to replicate between two computers on the Internet (both XP).
> Is this a futile attempt ... must the publisher be a "full" instance of SQL
> server?
>
>
sql

Remotely connecting sql Server

Hi,
I'm Connecting to server on the internet. When I connect with the SQL Query analyzer it works fine.
but when I open the Enterprise Manager & Click on the database then It loads all the databases from the server. & it takes a lot of time. What I want that to load only specific databases or any other method by which I can improve its performance.
I hope you get that.
thanks in advance,
Das
I don't think you can change that behavior, but you can certainly increase
the timeout value for Enterprise Manager. For more informaiton, see:
http://vyaskn.tripod.com/sql_server_tools_faq.htm#q7
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Das" <anonymous@.discussions.microsoft.com> wrote in message
news:A50CF25F-A767-4BA9-BE5E-5E046346F362@.microsoft.com...
Hi,
I'm Connecting to server on the internet. When I connect with the SQL Query
analyzer it works fine.
but when I open the Enterprise Manager & Click on the database then It
loads all the databases from the server. & it takes a lot of time. What I
want that to load only specific databases or any other method by which I can
improve its performance.
I hope you get that.
thanks in advance,
Das

Remote SQL admin across the internet

Hi,

What is a secure way or accepted method to make database changes,IE: edit tables, add sprocs. ect. on a server being ran by an ASP.NET hosting service across the internet?

Thank you
-heywadeYou should check out theData Access Security section of "Building Secure ASP.NET Applications: Authentication, Authorization, and Secure Communication" in Microsoft's Patterns & Practices series.

Terri|||Thanks Terri,

That is a great artical. Alot of that is out of My control though. An ASP.NET hosting service said that I would use Enterprize manager to admin My "would be" database across the internet. They didn't mention using SSL, also the use of IPSec wouldn't work on My end with NAT. So I guess I'll have to follow up with them. I didn't know the SSL would work with an SQL server...cool.

Thanks again
-heywade

Remote Manage

Before I just manage the SQL serve in LAN.
Right now i have a SQL server on internet I want to Remote manage
Can I still use QA and Enterprise Manager ?Yes, you can use Query Analyzer and SQL Enterprise Manager to manage a server that is open to the Internet. I would consider making an exception at your firewall to allow that server to remain part of your NT domain, so that you can use NT Authentication instead of SQL Authentication.

-PatP|||how can I set some config on my Enterprise manager or QA?|||Huh? I don't understand what you are asking.

-PatP|||Sorry about confuse,

I dont have this kind of experience. Before i just install client software like
QA or Enterprise in my PC ,i can use this software manage my SQL Server on LAN.
Right now another SQL server on WAN ,i dont know can i use QA to find
SQL server or I have to get some remote software to log on remote server
and use remote server's QA?

Do i make me clearly?|||Now I understand the question better!

When you are making the connection to the server in Query Analyzer, type either the server's name or IP address into the box labled SQL Server. Except for the lack of ability to enumerate remote servers (having Query Analyzer locate the SQL Servers and provide a list of them for you), the connection process is exactly the same as a "local" SQL Server.

-PatP

Remote login to MSDE 2000 (Desktop)

My question is, is it possible to connect to an SQL database using the MSDE 2000 SP3a edition over the internet? And if so, how do I set it up? Thank you in advance.::My question is, is it possible to connect to an SQL database using the MSDE 2000 SP3a
::edition over the internet?

Yes.

::And if so, how do I set it up?

You mean after making sure you can connect to the server from the internet, having a firewall in place etc.?

Not at all. There is nothing left to configure after this.

EVERY MSDE installation automatically accepts connections from the network, and guess what - the internet is just a network.

Remote database connection through internet still not working

I am trying to have a ADO OLEDB connection by the UDL tool. However, it
still reports that there is no SQL server or no permission to access the
server. How can I test whether there was no contact at all or was it a
permission issue ?
I also use a forward URL which is routed by the DNS to the server IP adress.
Could that be the problem ? I enforced not to use the internet IP adress
because the router establishes a LAN connecion (both server and client
resides on same LAN) and doesn't connect through the internet as I figured
out.
Which steps should i perform in the right sequence in order to find the
problem ?
regards,
OscarHi,
I have the same problem but I just want to connect the SQL Server database
in my Windows2003 Server std webserver on my local entreprise manager...
No firewall between the two machines...
Thanks
LJ
www.eztree-msdn.com
"Oscar" <oku@.xs4all.nl> a crit dans le message de
news:4057ab71$0$28004$e4fe514c@.dreader17
.news.xs4all.nl...
> I am trying to have a ADO OLEDB connection by the UDL tool. However, it
> still reports that there is no SQL server or no permission to access the
> server. How can I test whether there was no contact at all or was it a
> permission issue ?
> I also use a forward URL which is routed by the DNS to the server IP
adress.
> Could that be the problem ? I enforced not to use the internet IP adress
> because the router establishes a LAN connecion (both server and client
> resides on same LAN) and doesn't connect through the internet as I figured
> out.
> Which steps should i perform in the right sequence in order to find the
> problem ?
> regards,
> Oscar
>

Remote Database

Dear ALL,
I've a customer of mine asked me for a web hosting , and internet site
contains a SQL database.
It seems to be very simple but customer wants database at his office, so my
problem is what is the most suitable solution to make communicate web and
database remotely in order to accomplish security requirements ?
Is it enough SQL SP3 installed and tcp 1433 opened or I have to establish a
VPN for example ?
Regards
Alberto
Brivio
Alberto Brivio
(tel. 1 9 9 2 4 9 8 9 8)
Exposing SQL Server on the net is not a good idea at all, but your customer
has at least three options to secure it:
- Using IP filtering rules to prevent connects from addresses other than web
server's address. He also generally need to implement data encryption using
SSL to do not expose plain data (and espesially SQL passwords!) to public
network during transfer. The simplest method but doesn't implement caller
authentication
- Using IPSec to encrypt/filter and authenticate such connections
- Using VPN which also doing authentication and encryption
WBR, Evergray
Words mean nothing...
"Alberto Brivio" <a.brivio@.adb.it> wrote in message
news:uX5MAIMMGHA.2992@.tk2msftngp13.phx.gbl...
> Dear ALL,
> I've a customer of mine asked me for a web hosting , and internet site
> contains a SQL database.
> It seems to be very simple but customer wants database at his office, so
> my problem is what is the most suitable solution to make communicate web
> and database remotely in order to accomplish security requirements ?
> Is it enough SQL SP3 installed and tcp 1433 opened or I have to establish
> a VPN for example ?
>
> Regards
> Alberto
> Brivio
> --
>
> Alberto Brivio
> (tel. 1 9 9 2 4 9 8 9 8)
>

Remote Database

Dear ALL,
I've a customer of mine asked me for a web hosting , and internet site
contains a SQL database.
It seems to be very simple but customer wants database at his office, so my
problem is what is the most suitable solution to make communicate web and
database remotely in order to accomplish security requirements ?
Is it enough SQL SP3 installed and tcp 1433 opened or I have to establish a
VPN for example ?
Regards
Alberto
Brivio
Alberto Brivio
(tel. 1 9 9 2 4 9 8 9 8)Exposing SQL Server on the net is not a good idea at all, but your customer
has at least three options to secure it:
- Using IP filtering rules to prevent connects from addresses other than web
server's address. He also generally need to implement data encryption using
SSL to do not expose plain data (and espesially SQL passwords!) to public
network during transfer. The simplest method but doesn't implement caller
authentication
- Using IPSec to encrypt/filter and authenticate such connections
- Using VPN which also doing authentication and encryption
WBR, Evergray
--
Words mean nothing...
"Alberto Brivio" <a.brivio@.adb.it> wrote in message
news:uX5MAIMMGHA.2992@.tk2msftngp13.phx.gbl...
> Dear ALL,
> I've a customer of mine asked me for a web hosting , and internet site
> contains a SQL database.
> It seems to be very simple but customer wants database at his office, so
> my problem is what is the most suitable solution to make communicate web
> and database remotely in order to accomplish security requirements ?
> Is it enough SQL SP3 installed and tcp 1433 opened or I have to establish
> a VPN for example ?
>
> Regards
> Alberto
> Brivio
> --
>
> Alberto Brivio
> (tel. 1 9 9 2 4 9 8 9 8)
>