How to add existing database to sql server 2012 express
Posted on 2013-06-28
Have just installed minimal SQL2012 Express and need to attach an existing database to it.
This will be used in a small office with two workstations accessing data on sql2012 express server box.
No IT dept - and just want a simple and easy way to administer system.
Need to know where to place the MyData.MDF file and how to assign a database name such as MySqlData to it so i can use a connection string that specifies server MyPC\SQLEXPRESS and database name MySqlData
Also, what else do I need to allow client computers to access this database?