I want the user of my application to be able to share their database, from this artical i understand how to attach the database, but before any other users can attach to it I have to create a Server login, how do I go about doing this.
Any general tips on how t do this also appreciated if you think I am going down the wrong road.
Rather than attach I could do this
Server srvSql = new Server(applicationBlockTableAdapter.Connection.DataSource);
But that does not solve the login problem