Moving an asp.net project to a deployment server. This project displays Crystal Reports. The reports need to log into the SQL database housed on the development server. Login was never a problem before becasue the asp.net and SQL were running on the same server. Now they are not. How do I add computer_account/aspnet to the SQL users group?
For example, it was easy to add oldComputer/aspnet to the users in SQL Enterprise Manager becasue oldComputer was on the same computer domain.
Now I wish to add newComputer/aspnet to the instance of SQL running on oldComputer.
I feel like I'm talking in circles. Basically I want to add an aspnet user from another machine on to my SQL database users.