Creating an MSDE instance

[feurich]

Hi there,
An application I work with runs on a MSDE database. I have written an commandline application that creates a database table is this MSDE instance and loads it up with data from a CSV file. Now the problem is that when creating the database table , this table also inherits the user schema of the already existing database. This is unknown to me, but resolves in the fact that the users that accesses the newly created database need to be a local administrator on that machine to acces the data. Now I want to expand my commanline application with the possibilty to create an new MSDE instance with its own security schema. Can some on help me along the way. It needs to be done in c# code.

Thanks

Feurich

 

[PlausiblyDamp]

Could you not just create another login for the users rather than a new instance of MSDE?

 

[feurich]

Well I tried that. The application i have now creates a User with a password. I am able to access the database from an other application but when i try to access the database from the calling application (this is a validation module within a imaging application) I cant access the database with the created user only through SSI and the logged in user has to have Adminrights on the system that has the database.

 

[PlausiblyDamp]

Could you not create a login for the windows account (or a group) that the users login as? Check the SQL help for information on sp_grantlogin

 

[feurich]

This is exactly what i need a grouplogin that grants a domaingroup rights to login on that database. Can you be more specific where I can find the information?

Thanks,

Feurich