We have 2 Windows server installed . A installed with Windows 2000 server with SQL server 2000 and B is installed with only Windows 2003.

We setup the SQL database on Windows 2003 using a control panel and the database will be setup remotely on the Windows 2000 server.

Is it possible so that the SQL database file to be placed locally on Windows 2003 server instead on the Windows 2000 server which has the SQL 2000 server installed?