LearnItFirst User Forum

 SQL Server 2008 SSAS Training Videos
Welcome Guest Search | New Posts | Members | Log In | Register

SQL Server Forum - LearnItFirst.com » Transact-SQL Programming » DML (SELECT, INSERT, UPDATE, DELETE) Questions » surface area configuration in sql server 2005
surface area configuration in sql server 2005 Options
Previous Topic · Next Topic
agqtzb
Posted: Sunday, June 06, 2010 1:34:17 AM
Rank: Newbie

Joined: 6/6/2010
Posts: 1
Points: 3
Where do you live?: Hyderabad
 Hi,
I have installed sql server 2005 management studio express.And when I click on 'connect' button after entering my server name and authentication credentials,it is showing a pop up box like 'Cannot connect to server'..additional Information:A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified).

Now i have googled it and even i found the solution too...the thing is i have to go to Start > All Programs > SQL Server 2005 > Configuration Tools > SQL Server Surface Area Configuration and then do some actions.But I cannot find 'SQL Server Surface Area Configuration' and even i cannot find 'configuration tools'.

My system shows like the following:
Start > All Programs > Microsoft SQL Server 2005 >sql server 2005 management studio express.

Did I wrongly install sql server 2005 management studio express or is there any other process so that i can install 'SQL Server Surface Area Configuration' also.
I have been struggling with this problem since three weeks.Can i download sql server 2005 completely from Internet.
Back to top
 
Scott Whigham
Posted: Sunday, June 06, 2010 3:01:37 PM


Rank: Super Mod

Joined: 3/20/2006
Posts: 476
Points: 1,053
Where do you live?: Dallas, TX
 Do you have the SQL Server Configuration Manager installed? I don't have a server w/ Express on it to test it but you can change your TCP setting using it as well.
Back to top
Web  
Users browsing this topic
Guest


Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

© Copyright 2004-2009 LearnItFirst.com LLC. All rights reserved. All trademarks remain the property of their respective owners. This site is not affiliated in any way with the Microsoft Corporation.