Unable to connect to SQL Server 2008

June 4th, 2010 // 11:06 pm @ Amar

When you first install SQL Server 2008, you are unable to connect to the SQL Server from another machine in the network. You have enabled remote connections and still whenever you try to connect, you get an access denied error.

Make sure the SQL Server Browser service is running. It is required in order to listen for incoming connections. It may even be Disabled ( as in the case of SQL 2008 R2 Enterprise ).

Category : SQL Server

Latest Posts

Migrating to Office 365
by Amar on July 29, 2011
Office 365 now available to purchase
by Amar on June 28, 2011
Visual Studio 2010 code formatting bug
by Amar on February 25, 2011
Happy New Year
by Amar on January 4, 2011
Ultimate SharePoint 2010 Development Rig
by Amar on October 4, 2010

Testimonials

"Amar clearly has a thorough knowledge of Sharepoint, this knowledge, coupled with his professionalism and dedication made him a tremendous asset to the project. He was the key contributor to the later stages of the project delivery effort (the really difficult bit, long hours and hard work that puts huge demands on people), and I can state categorically that without his focussed dedication and hard work we would not have been able to meet the timescales imposed upon the project."

Tim Ellis , Sharepoint Project Manager , Royal Bank of Scotland

Unable to connect to SQL Server 2008