Avatar of fskilnik
fskilnik
Flag 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

Microsoft SQL Server

Avatar of undefined
Last Comment
fskilnik

8/22/2022 - Mon
fskilnik

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
EugeneZ

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
fskilnik

ASKER
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.
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
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
fskilnik

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