Link to home
Start Free TrialLog in
Avatar of fskilnik
fskilnikFlag for Brazil

asked on

Create a Local Server Connection


Hi, there.

I had to re-install my SQL Server 2005 product in my Windows XP Pro.

I could create an external server connection successfully (through Management Studio) but not a local one.

I put:

Server Type:  Database Engine
Server Name: (local)
Authentication: Windows Authorization
User Name: FABIO\Fabio (filled automatically and "gray-blocked" , as far as any modification concerned)

I get the following error message:

Cannot connect to (local)
Additional information:

An error has occurred 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)

Thanks,
fskilnik

Avatar of fskilnik
fskilnik
Flag of Brazil image

ASKER

Additional hints:

I tried to "Configure Surface Area for localhost" through the:

"Surface Area Configuration for Services and Connections" and I got the following error message:

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

Well, I AM the administrator and I guess I installed the (web) components mentioned... I re-installed the web components, just in case. It didn´t make any difference (in the error message, too) ...
 
ASKER CERTIFIED SOLUTION
Avatar of EugeneZ
EugeneZ
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Hi EugeneZ and imran_fast.

Sorry for the delay.

I could not find ANY SQL Services in the Configuration Manager. I am (now) re-installing SQL Server 2005 and I will try to do it through the Named Instance (instead of the Default one that I guess I used last time) , thanks to both suggestions.

I will feedback here in (say) 40min.

Thanks a lot,
Fábio.
Avatar of imran_fast
imran_fast

Hi Fabio,
I don't think this is problem with Named or default instance you will find sql services

Inside
Control Panel --> Services --> MSSQLService
I´m back.  :)

I (re?) installed .NET Framework 1.1 (SQL Server installation asked it) and I did as I mentioned before (through the Named Instance). Now I see my local server and it is working as expected!

Thanks for the additional advice, imran_fast!  Let me give you my feedback related to it:

> I don't think this is problem with Named or default instance

You are probably right, but as I did as I mentioned before, I simply cannot tell! The fact is that the Named Instance worked as I would like it too, anyway.

> you will find sql services
Inside
Control Panel --> Services --> MSSQLService

I entered the SQL Server Configuration Manager and, where before it was blank, now I see my local server.

Thanks a lot, both of you.

I will increase from 300 to 400 points and close the question splitting equally between both of you.  

Regards,
Fábio.