How to connect to sql server 2000 on a LAN?

[Mohammed Seidu]

Can someone help me with the connection string for connecting to sql server 2000 on a machine named 'pserver'? I don't know what I am doing wrong but I can connect without problem from my local machine but get error messages when I try connecting from a different machine.

[ck9663]

Is your local machine the same machine where your SQL Server is?

~~ CK

[Mohammed Seidu]

Yes, the local machine is the machine with Sql Server installed on.

[dinukumaradas]

What kind of error message is showing?
Please make sure that windows firewall is turned off.

[Mohammed Seidu]

I turned off the firewall and still gets the error. Please give me a sample string to compare to mine.


Thank you.