Using Windows 7 Ultimate, after installation of SQL Server 2005, an error occurs regarding Connection. (Settings for Database Engine)
Login failed for user 'Admin\vilas'. (Microsoft SQL Server, Error : 18456)

vk.gif
To resolve this error please follow the steps given below:
  • Set Security Permissions for SQL Server 2005---Properties.

    vk1.gif

    vk2.gif
  • Select Security tab and give the permissions for user name.

    vk3.gif

  • Run SQL Server 2005 --- now the System has been given a server name by default and loads SQL Server 2005 successfully.

    vk4.gif

Enjoy database creation in SQL Server 2005.