freshnet
asked on
Sharing SQL Express database
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(applicationBlockTab leAdapter. Connection .DataSourc e);
srvSql.Databases[applicati onBlockTab leAdapter. Connection .Database] .Rename("S omething Easy");
But that does not solve the login problem
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(applicationBlockTab
srvSql.Databases[applicati
But that does not solve the login problem
What article mentioned creating an Server login? Do you have SQL Sesrver 2005 Management Studio installed?
ASKER
I want my application to carry out the task itself using code, I can not expect my customers to do it via have SQL Sesrver 2005 Management Studio.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.