Share via

Fixing an Instance of SQL Server 2014 - After Cleanning up some duplicte files.

Flávio Rocha 21 Reputation points
2020-08-27T01:55:39.787+00:00

Hi Folks, This is my first time using this forum. I regularly use the C# Forum.

The question is:
I recently used the CCleaner to sweep out some duplicate files in my notebook, and of course there was a lot of them of all kinds, included SQL Server, and also Visual Studio files .

After cleaning up, I got a problem to connect the SQL Server 2014, and also to open my project with Visual Studio 2017.

How can I fix the instance, without changing the server name and etc., once that all connection of the project is based on that specific instance, I have a lot of forms using the connection to the Server.

And to get worse, my CDRom is not working, which I could not use the midia to try to solve this issue.

Is there any angel who could save my hours of life in front my notebook?

Thanks to all of you. I appreciated your help.

Error:

TITLE: Connect to Server

Cannot connect to DESKTOP-3O98051.

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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476

O sistema não pode encontrar o arquivo especificado --> My Translation **"the system can not find the specified file"

BUTTONS:

OK

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,053 questions
0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. m 4,271 Reputation points
    2020-08-27T07:14:27.897+00:00

    Hi @Flávio Rocha ,

    This error usually means that the client can't find the SQL Server instance. This normally happens when at least one of the following problems exist:

    The name of the computer hosting the SQL Server
    Instance does not resolve the the correct IP
    The TCP port number is not specified correctly

    Troubleshooting: https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/troubleshoot-connecting-to-the-sql-server-database-engine?view=sql-server-ver15

    BR,
    Mia
    If the reply is helped,please do "Accept Answer".

    0 comments
  2. m 4,271 Reputation points
    2020-08-28T01:38:54.353+00:00

    Hi @Flávio Rocha ,

    Is the reply helpful?

    BR,
    Mia
    If the reply is helped,please do "Accept Answer".--Mia

    0 comments
  3. m 4,271 Reputation points
    2020-09-01T06:34:59.353+00:00

    Hi @Flávio Rocha ,

    Is the reply helpful?

    BR,
    Mia
    If the reply is helped,please do "Accept Answer".--Mia

    0 comments
  4. Flávio Rocha 21 Reputation points
    2020-09-03T02:53:21.357+00:00

    Hello Yuximiao, sorry for answering late, I apologize for that.

    I had to fix it with a Service Pack 3, after the installation, everything worked fine.

    Thanks for your help.

    Best Regards.