Tips for me about SQL Server 2005

1, Cannot login the SQL Server 2005 using SQL Server Authentication mode.
   Check the following options:
   A: check the authentication mode of the sql server 2005.
      [When installing the sql server, you can specify mixed authentication mode{Windows and SQL Server Authentication}]
  B: Allow remote access [Make sure the checkbox is checked under the property>security of the server]

 C: Make sure the port [1433] of the server was not occupied by other application.

2, How to detect version info of the SQL Server 2005
 select serverproperty('productversion') as Version_No,
          serverproperty('productlevel') as SP_No,
          serverproperty('edition') as edition