How to connect SQL Server 2000?

i want to connect SQL Server 2000 with remotely how it will work?

i have a sql server data base on server(domain) in xyz company, they give me following information:

database name

server IP address

database user name

database password

i can connect the same database using networking internet (proxy)

connect internet connection

start proxy connection

i am using a pc from network which is useing proxy for internet.

i open query analyzer

enter IP address, user name and password (which is currect)

though i can't connect sql server

else i can connect the same server which PC is using own internet connection not form network

i want to know that

how can we connect SQL Server using internet connection form network (proxy server)?

where is to enter networ pc IP address?

where is to enter port number?

Hi,

Just a bit of advice. That is a bad practice actually.You'll attract all the hackers in the world to get in to your box. That would force you to open port 1433 in your firewall to everyone else ... with out that port open you won't be able to connect to the server.

that is like saying. "hello world, we've got a 1433 port open "

if your pulling and pushing data to the server

how about using web services instead also

sql server 2000 has builtin support for IIS querries . i just forget the actual name.

just look for it in your start>programs>microsoft sql server 2000 then

look for something there with IIS.

for remote admin administration over the internet i'll strongly recommend this tool

http://www.microsoft.com/downloads/details.aspx?FamilyID=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylang=en

http://www.microsoft.com/downloads/details.aspx?familyid=F0D03472-5E6C-459E-A6D8-6745A729C3C9&displaylang=en

regards,

joey

|||

Hi,r

I would suggest to refer below KBs for Proxy Configuration

http://www.support.microsoft.com/kb/890775

http://support.microsoft.com/kb/216415

and as stated it is not a best practice refer www.sqlsecurity.com 's checklist for securing sql server , i suggest to configure port nomber other then default and set appropriate firewall rules.

Regards

Hemantgiri S. Goswami

how to connect domain SQLSERVER2005 to WORKGROUP SQLSERVER2005

hi

COMPUTER-1

IP ::::: 129.100.100.5

COMPUTER NAME IS ::::: HASH

MEMBER OF DOMAIN

in this computer sqlserver express edition is installed, i want to remove this express becoz in configuration manager it show two SQLSERVER'S are running. when i browse from COMPUTER - 2 for network servers it show server name as HASH/SQLEXPRESS, but not the main SQLSERVER.

COMPUTER -2

IP::::129.100.100.142

COMPUTER NAME::: FEROZ

MEMBER OF WORKGROUP

can anyone help me how to connect these two computers and remove this express edition

iam new to sqlserver configuration

thanks in advance

waiting for eager reply

To remove Express Edition, go to Control Panel/Add & Remove Programs/SQL Server 2005 - Change, and it will show you what is currently installed, and you will be able to chose to remove your Express instance.

As for how to 'connect these two computers', do you mean for database mirroring? It isn't clear from your post, and this is a database mirroring forum.

How to connect Anasysis server in different domain

Please let me know the steps to connect Analysis server 2000 from different domain.

fyi for connecting sql server I am using SQL server authentication and I am able to connect.

try this, it works for me in as 2005:

create a local user on the AS server as yourself. Use the same user name/password that you have on the other domain.

example:

domain dom1:

you are logged on as dom1\bob with password xxxxx

On the AS server, create a local user bob with password xxxx. give bob access to the cubes.

Test your connection.

|||

this also works:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1365877&SiteID=1

|||

Thanks for you information,

It is working now.