I was just trying out Microsoft SQL Server 2000. I created a sample application which reads in 2 values from a textbox and writes it into a databse. This application works fine on my computer and the values are written to the database (In the connection string, I give my IP address as the datasource so that anyone on the internet can hit this database). However, when I copy this application to another computer and try to run it, it gives me an error "SQL Server does not exist or access is denied." I know this is a minor problem with some setting, but I haven't been able to find the solution on the internet. Can someone whose worked with Microsoft SQL Server 2000 please help me out.

SQL Server is already on mixed mode authentication. It is actually a VB.NET application. When i run the application on my machine, the values get inserted into the database since the database is hosted on my personal laptop. But when i run the same application from a friend's laptop, I get the error message "SQL Server does not exist or access is denied. Below is the snippet of my code:

1. what SQL service pack are you running? SELECT @@VERSION from query analyzer will tell you.2. Are you trying to connect to your database on your local LAN (using private IP addresses like 192.168.x.x) or are you trying to connect over the internet using public IP addresses?3. Do you have a default instance installed, or is this a named instance?

ok, the first step is to install SP3 or SP4 on your database. go to www.microsoft.com/sql and download and install that service pack and see if things change. A reboot is probably required after install btw.

ok, the first step is to install SP3 or SP4 on your database. go to www.microsoft.com/sql and download and install that service pack and see if things change. A reboot is probably required after install btw.