SIGN UP MEMBER LOGIN:    
ARTICLE

Installation of SQL Server 2005

Posted by Vilas Gite Articles | Databases & DBA April 21, 2011
Learn how to install SQL Server 2005.
Reader Level:


Using Windows 7 Ultimate, after installation of SQL Server 2005, an error occurrs 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.

Login to add your contents and source code to this article
share this article :
post comment
 

Good article

Posted by Dinesh Beniwal Apr 21, 2011
6 Months Free & No Setup Fees ASP.NET Hosting!
Become a Sponsor
PREMIUM SPONSORS
  • ceTE software specializes in components for dynamic PDF generation and manipulation. The DynamicPDF™ product line allows you to dynamically generate PDF documents, merge PDF documents and new content to existing PDF documents from within your applications. Visit DynamicPDF here
    Get 2 Months Free of ASP.NET Hosting for Only $4.95/month! Receive FREE MS SQL and MySQL Databases Including ASP.NET 4/3.5, MVC 3.0, Silverlight 4, Windows 2008/IIS 7.0 Plus FREE IIS 7 Modules. Host UNLIMITED ASP.NET Web Sites - Click Here!
Become a Sponsor