Link to home
Start Free TrialLog in
Avatar of freshnet
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(applicationBlockTableAdapter.Connection.DataSource);
srvSql.Databases[applicationBlockTableAdapter.Connection.Database].Rename("Something Easy");

But that does not solve the login problem
Avatar of Bob Learned
Bob Learned
Flag of United States of America image

What article mentioned creating an Server login?  Do you have SQL Sesrver 2005 Management Studio installed?
Avatar of freshnet
freshnet

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
Avatar of Bob Learned
Bob Learned
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial