It's new and it's untested on their product. That's always a risk, though in the case of SQL Server 2005 it's probably a low one.

To the original poster, out...

A couple of other things.

1) When you use AWE memory, disregard the value in Task Manager. You cannot rely on it to be correct.

2) If Target and Total Memory are...

Typically if it wouldn't be able to listen, that's because another process has that port. However, in those cases you'd see the error reported in the SQL Server event log....

1. Only a member of the sysadmin fixed server role within SQL Server can stop a trace. So I'm not sure what you mean by this.

2. What you might be...

Are you installing with a user account that has administrative rights over the computer?

This doesn't show SQL Server even attempting to listen on TCP/IP. Verify the configuration. If it's correct, be sure to restart SQL Server.

Yes. You can move tempdb after the installation. This Microsoft KB article gives instructions on how to move all databases, system ones included:

How to move SQL...

Well, unless you've got an SMTP server listening on a non-standard port, do you need your code to connect to anything other than port 25? I agree it's one of...

The guest user must be left on for master and tempdb. There was a thread a while back where Andy Leonard played around with forcing access off by manually updating...

PromptSQL? Oh, it's nice. Very nice.

Specify a connection of <server>,<port>. For instance: myserver,3155. Or use an alias using cliconfg.exe.

I selected the Dev Tools install when I did my SQL2K install, which is probably why I have it on my system. Never know when you might actually need something...

Are you able to connect to SQL Server using that domain account, say through Query Analyzer?

Default path for it is (this is a SQL Server 2000 path):

C:\Program Files\Microsoft SQL Server\80\Tools\DevTools\Include

Don't see it at all on the SQL2K5 side.

Yes, input validation. You trap for the known mechanisms for SQL Injection. For instance look for single quotes coming in and double 'em. Watch for the --. Most of...