deploying vb.net app with database on server

Question

I have an application that accesses a sql server 2008 database. The server and database is stored on my local harddrive and I would like to learn to scale this up to having multiple users in our office access the application which I will i deploy on a server. For now the database will stay on my pc until I am ready to put it on a dedicated server for myself but for now how do I allow the application still to access my database. Here is my current connection string:

 <add key="ConnectionString" value="Data Source=.;Initial Catalog=SearchEngine;User ID=sa;Password=pss;Trusted_Connection=False;" />

Now I know how to deploy a general vb.net application but what I dont know is what to do with the database.

Please help with any advice

Answer 1

What is your problem`?

• Deploy the application
• Change the connection string to point to your server. Note the "Data Source=." in the Connection string? That "." is the server name - it points to the local machine. Put in the db server name there.
• Make sure your database is reachable (i.e. no local firewall, tcp enabled on network). Especially the last point is important - new SQL Servers per default are not rachable externally, you need to change that with the configuration tools.