Connecting To Server

Hi,

As you know in SQL Server we must connect to a server to create , manage and execute databases. My problem is, I can't connect. I have searched the web for some information, they all say "write to server name your machine name to connect". I did so and get an error.

the message is ;
An error has occured while establishing a connection to the server.
When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.(provider: Named Pipes Provider,error:40-Could not open a connection to SQL Server)(Microsoft SQL Server,Error :53)

My pc is not connected to a server.

How can I make my pc act like a server so that i can connect to it.

Hi,

This is a usual problem that occurs whilst using SQL Server 2005.

You can resolve this issue by following steps...

Use Surface Area Configuration tool to manage your connection protocol Add SQL Server Service as an Exception in Windows Firewall Use MACHINE_NAME\INSTANCE_NAME to reduce conflicts.|||

firstly thanks for the advise, Now i have a proble in Surface Area Configuration tool.

when I click to surface area configuration for services and connections an error occurs.

it says.

TITLE: Surface Area Configuration

No SQL Server 2005 components were found on the specified computer. Either no components are installed, or you are not an administrator on this computer. (SQLSAC)

now how can i solve this question ?

|||

Welcome,

First, have you logged in as administrator? If not, then do so. If you are using Windows Vista, then even if you are logged in as an administrator, right click the Surface Area Configuration tool and say "Run As Administrator".

This should solve your problem.

I guess, there are no further issues related with this.

Lastly, if all fails, the genuine solution is - re-install If still you are facing problems, let me know.

Mayur Tendulkar

Microsoft Student Partner

|||

Have you installed a SQL Server Edition on your local computer?

|||

Thats a good question, you have to confirm what edition of SQL 2005 you have installed here.

http://www.sql-server-performance.com//faq/?f=143 too fyi.

|||

thanks to everyone tryin to help.

I have solved the problem

|||

Hi,

Its good to know that you have solved the problem.

But if you could post the exact cause and solution over here, then someday - somewhere, it might help others.

Mayur Tendulkar

Microsoft Student Partner