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