• Some users have recently had their accounts hijacked. It seems that the now defunct EVGA forums might have compromised your password there and seems many are using the same PW here. We would suggest you UPDATE YOUR PASSWORD and TURN ON 2FA for your account here to further secure it. None of the compromised accounts had 2FA turned on.
    Once you have enabled 2FA, your account will be updated soon to show a badge, letting other members know that you use 2FA to protect your account. This should be beneficial for everyone that uses FSFT.

sql server 2000 on a remote host

E

exel

n00b
Joined
Jan 21, 2006
Messages
48
I have sql server 2000 running on a win2k server at work, and I wish to access some
of the databases from home. How could I accomplish this?
I am trying to query the databases for a web application.

Sorry if I didnt post too many details, I am in a hurry now!


Thanks in advance,
 
I would set up and use a VPN to do this. That is the most secure route. Your second option is to give access to it accross the internet, which can open the server up to all types of bad things if it hasn't been secured properly.
 
would configuring win2k server for remote access be of any help?
 
exel said:
would configuring win2k server for remote access be of any help?
Click to expand...
What excatly do you mean by remote access? If you are refering to Remote Desktop/Terminal Services then no, it won't help.
 
MorfiusX said:
What excatly do you mean by remote access? If you are refering to Remote Desktop/Terminal Services then no, it won't help.
Click to expand...

sorry, I know I wasnt too clear.
Basically, there is a computer that is running windows 2000 server. On this computer, I have sql server 2000 installed, and I have some databases on it.
I was wondering how I can query the databases that are running on this machine from
a different computer. Assume the windows 2000 server machine is sitting near me and I am trying to access the database from another computer.
Hope that helps :)
 
It depends on what you are doing. If you are writing an app that uses a databse, you will have to make a connection to the server, then to the database, then run your query. How all of that is done varies base on the language and application you are coding in.

Now, if you are just wanting to manage the server and excute a query alone, the you can install the SQL tools on the remote machine and use Enterprise Manager or any of the other standard tools that comes with SQL 2000.
 
MorfiusX said:
It depends on what you are doing. If you are writing an app that uses a databse, you will have to make a connection to the server, then to the database, then run your query. How all of that is done varies base on the language and application you are coding in.

Now, if you are just wanting to manage the server and excute a query alone, the you can install the SQL tools on the remote machine and use Enterprise Manager or any of the other standard tools that comes with SQL 2000.
Click to expand...

Thanks for the information!

I just found out (its a new job) that I will be using the SQL 2000 Desktop Engine. Hmm...I never used the Desktop Engine :-( I hope I can install some Desktop Toops such as query analyzer....
 
The tools for SQL Server can be used for the desktop engine (MSDE), but not within the technacalities of the license aggreement. You just have enable TCP/IP for MSDE.

If you want to be legit, then many third parties make applications to manage MSDE. Do this from svrnetcn.exe.
 
MorfiusX said:
The tools for SQL Server can be used for the desktop engine (MSDE), but not within the technacalities of the license aggreement. You just have enable TCP/IP for MSDE.

If you want to be legit, then many third parties make applications to manage MSDE. Do this from svrnetcn.exe.
Click to expand...

I never worked on MSDE before, so this may sound like a stupid question.
How do you enable TCP/IP for MSDE?

Edit: n/m. I just ran svrnetcn.exe and I saw that TCP/IP is on the Enabled Protocols List.

Hmmm....are there any MSDE Tutorials out there?
 
MSDE is just a limited version of SQL 2000. It limitations are 2gb database size, (I think) 1gb of RAM usage, and a sigle processor/thread.
 
I see that the Jet Engine stores all the application data in a single .mdb file.
Can I use MSDE to access the .mdb database?

This is getting a little off topic now....could I PM you MorfiusX to ask a few more questions ?
 
SQL Server 2005 Express would let you do remote I believe, if not get the Developer version of 2000 or 2005 both are around $50 from amazon.
 
benamaster said:
SQL Server 2005 Express would let you do remote I believe, if not get the Developer version of 2000 or 2005 both are around $50 from amazon.
Click to expand...
The problem is some stuff that was written to use SQL 2000 will not work correctly in SQL 2005. Case in point: SolarWinds Orion Network Performance Monitor.
 
You must log in or register to reply here.
Back
Top