I am using SQLServer 2008 Express and Visual Web Developer 2010 Express. SQLServer is installed on a 2003 server computer on the domain while Visual web developer is installed on a different 2003 server on the domain - this machine is the webserver.
The webserver will have some asp.net web pages linked to a database on the SQLserver. I am using windows authentication to allow domain users to access the database through the web pages.
When I installed SQLServer and Visual Web Developer I was logged onto the (this computer) option rather than the domain. When I created my database in SQLServer I was also not logged into the domain. In SQL server I was able to create a logon account with MyDomainName\MyWebServerName$.
Is this the normal way to install and use these 2 programs? Or should I have logged onto the domain and installed the programs. Should the database and associated tables be created while I am logged into the domain?
I am just not sure which is the correct way to go.
Any advice much appeciated