Ok so i've never really done ASP.NET before so i thought it would be a good start to make a ticketing system. Now I'm going to need a database to store the tickets etc and user security. My problem is that creating users and roles with the ASP.NET configuration
tool puts them in a seperate database to the database that will be used store the tickets.
However, the tickets need a relationship to the user that submited it. Can someone suggest the best way to do this? E.g build the users and roles into the database that stores the tickets or is it possible to create a relationship between 2 tables in different
databases? Or any other way, i did notice the provider tab in the configuration tool but it didnt really have many options.
Thanks.
-
-
Sven Groot
I'm Commander Shepard and this is my favourite store on the Citadel.
You can specify a database name when running aspnet_regsql.exe.
-
Scott Bryen wrote:Ok so i've never really done ASP.NET before so i thought it would be a good start to make a ticketing system. Now I'm going to need a database to store the tickets etc and user security. My problem is that creating users and roles with the ASP.NET configuration tool puts them in a seperate database to the database that will be used store the tickets.
However, the tickets need a relationship to the user that submited it. Can someone suggest the best way to do this? E.g build the users and roles into the database that stores the tickets or is it possible to create a relationship between 2 tables in different databases? Or any other way, i did notice the provider tab in the configuration tool but it didnt really have many options.
Thanks.
AS Sven Noted, you can specifiy the DB.
Or, if this is an internal corporate application, integrate with AD for your roles and users using Authorization Manager, instead of relying on users and roles stored in a DB. -
Thanks! I think the tool Sven said will be my best bet. Ive tried it out, im just getting some connection errors to SQL Server. I've even changed all the remote connection settings to TCP/IP and named pipes, restarted the service and still the errors. Maybe a reboot will do the job
. -
Sven Groot
I'm Commander Shepard and this is my favourite store on the Citadel.
If you can't get it to connect, if you peruse the command line parameters, you will see you can get it to generate a SQL script instead of actually permorning the actions. Then you can manually run the script against your database.
Thread Closed
This thread is kinda stale and has been closed but if you'd like to continue the conversation, please create a new thread in our Forums,
or Contact Us and let us know.