I was just trying out Microsoft SQL Server 2000. I created a sample VB.NET 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.

Make sure the connection string is the same, or if you are using integrated security, make sure that both users which run the application has the appriopriate rights to the database server.

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:


Dim insert_values as string = "'" + textbox1.text + "','" + textbox2.text + "'"

Dim cnOra As New OleDbConnection("Provider=sqloledb;Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=pubs;User ID=sa;Password=asdasd")

            cnOra.Open()

     Dim cmdUpdate As New OleDbCommand _
        ("INSERT INTO APP_STR(PARAM_NM,PARAM_VAL) VALUES(" + insert_values + ")", cnOra)
                cmdUpdate.CommandType = CommandType.Text

                cmdUpdate.ExecuteNonQuery()

I think if I understand what your saying is that you have to connect from one computer to the other to get to ths same sql server. You wrote your app to connect to your local computers sql server. When you run your app on your friends computer it doesn't have a local sql server to connect to. You have to connect to your computers SQL. Basically networking is involved. Try to connect by ip address or machine name to start with.