Connecting to sql server 2000 in a lan

Hi there,

I have 2 servers on our compny'ssql server does not exist or access denied lan, one with fixed ip and the other one with internal ip. I installed SQL server 2000 on the one with internal ip and I want to access it from the other server. when I want to register sql server instanse , I can see the name of that instance in the list but I can't register it. I keep reciving this error : sql server does not exist or access denied!

Could any one told me what to do?

http://www.connectionstrings.com/

|||

Hi,

According to your problem, the following suggestion may be helpful to you.

1, Does firewall exist in your local network? Please adjust your security level of the Firewall.

2, When connecting to the db server, be sure that the SqlServer is running as well as the 1433 port is opening.

3, Have you installed service pack for your SqlServer2000? Because the port of TCP/IP and UDP is denied due to some security known issue on those edition without service pack.

Thanks.

connect via QA with windows auth without joining domain

Hi, I'm using my laptop to connect to a client's internal network. I'd
like to connect to their SqlServer database using Query Analyzer,
Enterprise Manager, osql, etc... They only have Windows Authentication
enabled (they won't change this setting).
When I try to connect in QA I get the authentication failed for user
(null) error.
They've given me a domain login to use when connecting to their
database, but I'm not sure how to use it without logging on to windows
as that user.
I'd prefer not to make my laptop part of their domain. I'd rather use
my regular (local machine) login so I can access my installed programs
and files.
Any thoughts on how I should connect?
Thanks!
Try mapping a drive to a share on a machine in that domain
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
<dinosaur8000@.yahoo.com> wrote in message
news:1133316094.691249.88290@.z14g2000cwz.googlegro ups.com...
> Hi, I'm using my laptop to connect to a client's internal network. I'd
> like to connect to their SqlServer database using Query Analyzer,
> Enterprise Manager, osql, etc... They only have Windows Authentication
> enabled (they won't change this setting).
> When I try to connect in QA I get the authentication failed for user
> (null) error.
> They've given me a domain login to use when connecting to their
> database, but I'm not sure how to use it without logging on to windows
> as that user.
> I'd prefer not to make my laptop part of their domain. I'd rather use
> my regular (local machine) login so I can access my installed programs
> and files.
> Any thoughts on how I should connect?
> Thanks!
>
|||I've done that. I mapped a drive to the machine hosting the SqlServer,
actually. I supply the domain login and I'm able to connect to the
share just fine. However, when I try to connect to the DB through QA or
Enterprise Manager, it doesn't work. Am I missing a step?
Tibor Karaszi wrote:[vbcol=seagreen]
> Try mapping a drive to a share on a machine in that domain
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> <dinosaur8000@.yahoo.com> wrote in message
> news:1133316094.691249.88290@.z14g2000cwz.googlegro ups.com...