Connect to sql server remotely

[fjleon]

I was skimming through the WRKRDBDIRE and ADDRDBDIRE commands and it says that it can connect to remote servers, but i don't understand if that means that i can connect to different database types. It that case, i want to connect to microsoft sql server 2000.

So i used WRKRDBDIRE to create an entry to connect to database MYBD with its ip address, *IP as connection type and port 1433. I launched service STRTCPSVR SERVER(*DDM) and tried to connect with sql server:

connect to MYDB user MYUSER using 'mypass'

But i get an error SQ30080 (communication error)

So, can this be done? If so, what should i check first?

[Mercury]

Re: Connect to sql server remotely

Look here.

[fjleon]

Re: Connect to sql server remotely

that seems great and i will definitely try it out, however i was looking for some way to use strsql with sql server, that way not all users need to have installing query analyzer or another tool. thanks

[pentergark]

It is true, I am looking for how to configure correctly or how to make the connection using addrdbdire. I'm trying to move forward and when I don't move on I'll put the error ... or the solution ;-)