So your problem has solved after restarting the services.?

Yes model database acts as a template for new databases to be created. so having the model database set to simple has to be done only when needed.

Browser services needs to run when the SQL servers run on the default port and when you have specified a port number for the server you can use that for...

Yes the create data would be updated. But we need to find out when this is firing out to find the root cause. there might be a procedure that might...

For N/W related use network monitor, OS related use perfmon and SQL Server use Profiler to find which one is the hitting the deck and then tune them accordingly.

Its a read only database and data is uploaded only less frequently. Define your server parameters. Read only database needed have much alteration to themseleves as they have no changes...

You can create a maintenance plan to do the task for you. you need to backup, reorganize index, reindex and these sort of tasks can be done easily with MP.

log shipping, database mirroring, point in time restoration, replication they need to be in full logging mode.

You can do that with system side tracing. All you need to trace the events regularly using the system sided stored procedures.

Check for system resources like RAM, CPU, disk, cache, etc. one them is being hevily used. you can do a perfmon to collect the data and analyze for the results.

If your ping and telnet works , then you will be able to access your sql server without issues but you need to use only SQL Server account and not...

Don't run your sql server on local system account. change that to a windows user account with necessary permissions. so that you don't have other issues with accessing network resources....

Use SQL configuration manager to change it. Also check if the user has necessary permissions to start the services and run fine. If possible run the accounts on a domain...

Use profiler to find out when the create procedure is called. You can then easily trace out what is happening and clear the rootcause.

Yes groups and roles will do the trick. With 2005 you can even assign granular permissions to the objects. So assign only those permissions to the users and not that...