Suface area configuration

Question

Post reply

Suface area configuration

gerel5

SSC Rookie

Points: 29
More actions
June 6, 2010 at 1:03 am

#140767

Hi,
I have installed sql server 2005 management studio express..but I cannot find Suface area configuration in configuration tools.Actually i cannot even find 'Configuration tool' also.How can I install Suface area configuration so that i can allow remote connections.

Viewing 9 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

george sibbald SSC Guru Points: 104210 More actions · Answer 1

not sure you get that tool with the express edition.

Use the sp_configure system stored procedure via a query window in SSMS to allow remote connections. See BOL.

---------------------------------------------------------------------

gerel5 SSC Rookie Points: 29 More actions · Answer 2

Actually I am unable to connect to the server(I mean to my system).whenever I type my server name and authentication credentials,it is showing an error box.Thats the reason i am unable to access query window too.Can I allow remote connections using command prompt.

george sibbald SSC Guru Points: 104210 More actions · Answer 3

you could do it with the sqlcmd utility.

what error do you get trying to connect, and what version of SQL and OS.

---------------------------------------------------------------------

gerel5 SSC Rookie Points: 29 More actions · Answer 4

'Cannot connect to server'..

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).

This is the error i am gettingFor server name I typed in my computer full name and i have opted windows authentication and when I click the connect button i get the above error.

I am using sql server 2005 and os is windows Xp.

george sibbald SSC Guru Points: 104210 More actions · Answer 5

Are you sure the instance is up and running and you have the correct instance name. IIRc for the express edition it is called servername\SQLexpress

---------------------------------------------------------------------

gerel5 SSC Rookie Points: 29 More actions · Answer 6

I have tried typing 'servername\sqlexpress'.but still i get the same error box.Can u give me some online links where I can download sql server 2005.

What I am thinking is may be my firewall and tcp ports are blocking remote connections to sql.when i googled, i found out that we need to open 'surface area configuration' and allow remote connections.But in my system 'surface area configuration tool' did not get installed.

How to know whether the instance is runnning properly or not and how to know my server name.And which authentication should i use?

reply me if u r free ..k..

george sibbald SSC Guru Points: 104210 More actions · Answer 7

http://www.microsoft.com/sqlserver/2005/en/us/express.aspx

check administrative tools\services

That error normally occurs because instance is not running, its not usually because remote connections are not enabled

---------------------------------------------------------------------

gerel5 SSC Rookie Points: 29 More actions · Answer 8

There is no Sql server 2005 instance in Admistrative tool/sevices.What should I do now?I have installed and uninstalled sqlserver 2005 many times but still I get the same erorr.Is there any solution?