SQLServer 2008 Express and Visual Web Developer on Domain machines

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  
 
SandS1955Asked:
Who is Participating?
 
Ryan McCauleyData and Analytics ManagerCommented:
Whether you log in locally or using a domain account when you install software is irrelevant - the software installs the same way. Personal user settings (like your start menu or how the IDE is configured) are user specific, so you'll have to reconfigure those when you log in as your domain user, but the applicaitons will continue to work just fine.

SQL Server detects that it's being installed on a domain-connected computer regardless of how you logged in when you installed it, so you're fine there - it will work normally. Additionally, creating databases on the server isn't impacted at all by who you're logged in as when you create them.

I don't think you have anything to worry about here - everything should work the same as if you'd logged in as a domain user first and then installed both of these applications.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.