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.

connecting to a remote sql server problem..

i have sql server 2000 running on a windows server 2003 machine but have my web application on another windows xp machine

i'm getting access denied from the client machine... the 2 computers are connected by workgroup..

anyone can tell me how and what i need to do to connect to the sql server thanks

Hi There

Are you using impersonation in the web.config?

If not youll be trying to access sql server as the asp.net account on the web server - this wont have access to the db on the other server - either grant access on the sql server to the aspnet account or create a new account on the web server, then use this account using imperonsation in the web.config to access the sql server machine and the database.

Thanks
Gregor

|||

That might be caused by incorrect config of sql server ,issues of permission , connection string error,fire wall blocking...

You'd better elaberate your error message.