The first thing I would recommend doing is wrap your entire application in a Try/Catch. The message you are getting doesn't tell you any information about what is going on. Try the following:

Try
  ... the start of your app code
Catch e As Exception
  Messagebox.Show(e.Message)
End Try

You can use a standard SQL Server login that gives the users sufficient rights to the database. Make sure SQL Server is set to allow both SQL Server and Windows authentication (this is not the default). Another way is to use Windows only authentication and change you connection string to use integrated security like the following:

Dim connectionString As String = "Data Source=MyServer; Initial Catalog=MyDatabase; Integrated security=true;"

Each person logged into the client machine must have sufficient rights to access the SQL Server data/store procedures.

You don't need to deploy the source files but just the EXE and all the associated libraries(DLLs) that are used in the app. Also, any dependent files (XML, TXT, images, etc.) will also need to be included in the deployment.

>Hi Cathi,
>
>The message is:
>Application has generated an exception that could not be handled.
>
>Process id=0xfff8841d (-490467), Thread id=0xfffd5d69 (-172695).
>
>Click OK to terminate the application.
>Click CANCEL to debug the application.
>
>debug is not on the 98 computer.
>
>You may be right.
>
>I not sure how to create a connection so that all users can use. The connection I setup is the standard that Form Wizard set up. Looking at the connection properties it includes user name and workstation id. Not sure if that gets modified automatically when you try to use the app on another computer.
>
>What files need to be copied to the other computer? Are the files/programs encrpted ie like VFP option to protect source. I downloaded the .net framework from the internet to the 98 computer and than applied the service pack 2, so both have the same .net framework.
>
>Thanks
>Roland
>===========================================================================0
>
>>Roland,
>>
>>What is the error message that you are receiving? It could be related to security rights.
>>
>>>Hi,
>>>
>>>I have a small project with serveral forms that access a Remote SQL 2000 Server. It is on my development computer running XP Pro. I would like to deploy (install) the app onto my other computer which is runing windows 98.
>>>
>>>What is the simple (abc steps) procedure to accomplish this so that I may run/test the app on a different computer. I watched a Microsoft video that said just copy it to the other computer and run. I did that but it does not run; it gets an error message.
>>>
>>>I new to .NET and VB.Net. I have used VFP 6.0 and creation an install is simple. I hope VB.Net install is simple.
>>>
>>>
>>>
>>>Thanks
>>>Roland