Design question.

Posted By: Scott Bryen | Aug 3rd, 2007 @ 7:50 AM
page 1 of 1
Comments: 4 | Views: 941
#Aug 3rd, 2007 @ 7:50 AM
Scott Bryen
Scott Bryen
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.
#Aug 3rd, 2007 @ 8:12 AM
Sven Groot
Sven Groot
My name has 9 letters. Coincidence? I think not...
You can specify a database name when running aspnet_regsql.exe.
#Aug 3rd, 2007 @ 8:28 AM
phreaks
phreaks
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.
#Aug 3rd, 2007 @ 11:08 AM
Scott Bryen
Scott Bryen
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 Tongue Out.
#Aug 3rd, 2007 @ 8:46 PM
Sven Groot
Sven Groot
My name has 9 letters. Coincidence? I think not...
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.
page 1 of 1
Comments: 4 | Views: 941
Microsoft Communities