Microsoft sql server ошибка 1225

  • Remove From My Forums

  • Question

  • I encountered a problem with my SQL Server 2014 Standard edition. It is denying me access to the Management Studio and I cannot access the SQL Server from Visual Studio. The error message reads,

    «Cannot connect to SQL. 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: TCP Provider, error: 0 — the remote computer refused the network connection.) (Microsoft SQL Server, Error: 1225).  The remote computer refused the network connection.»

    My SQL Server is a stand-alone installation and I have all the permissions.  I would be grateful if anyone could help me with tips on how to solve this problem.

    Thank you.

    Longinus.

    LOE

Источник
  • Remove From My Forums

  • Question

  • I encountered a problem with my SQL Server 2014 Standard edition. It is denying me access to the Management Studio and I cannot access the SQL Server from Visual Studio. The error message reads,

    «Cannot connect to SQL. 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: TCP Provider, error: 0 — the remote computer refused the network connection.) (Microsoft SQL Server, Error: 1225).  The remote computer refused the network connection.»

    My SQL Server is a stand-alone installation and I have all the permissions.  I would be grateful if anyone could help me with tips on how to solve this problem.

    Thank you.

    Longinus.

    LOE

Источник

My Active Directory auditor suddenly failing and taking up all CPU resources. I have reviewed logs and see that there is issue to connect to [easyazon_link identifier=”B01MYVV6T0″ locale=”US” tag=”wn0d5-20″] MSSQL server [/easyazon_link] instance which is holding the database with auditor logs. I am trying to log in to [easyazon_link identifier=”0735658145″ locale=”US” tag=”wn0d5-20″] MSSQL [/easyazon_link] via the MSSQL Management Studio and getting error message 1225 – connectivity issue.

Here is the how to fix it and gain your connectivity back:

  1. Click WindowsKey + R and enter services.msc
  2. Once Services opens scroll down and locate service SQL Server
  3. Highlight the service and click START
  4. Wait for the service to start and retry to connect to your MSSQL instance

It should now work again and you will be able to connect to your MSSQL instance and run queries.

Источник

When try to connect to SQL Server from Microsoft Server Management Studio, I got an error: 1225 occurred; few days ago, it was working fine, but now this error occurs:

Screen Shot Error: 1225 in Microsoft Server Management Studio

When try to start SQL Server from Services (local) Error 3417 occurred
Screen Shot Error: 3417 in Services (local)

When try to start to SQL Service Agent through services, then another error #1068 occurs:

Screen Shot Error: 1068 in Services (local)

jarlh's user avatar

jarlh

42.7k8 gold badges45 silver badges64 bronze badges

asked Mar 8, 2018 at 6:11

Coder...'s user avatar

2

When I faced similar issue, I did following:

  1. In windows RUN type eventvwr.msc (or go to WindowsEventViewer)
  2. Windows Event viewer will be opened.
  3. Go to Application Events
  4. Try to login to sql server again (it will fail of-course)
  5. Now refersh the ApplicationEvents again.
  6. You will see the recent error even logged.

This will tell you exact error.

In my case, my SQL version was expired. And I only knew it from event log.

The only solution I had was to re-install sql server.

answered Mar 8, 2018 at 6:20

SSD's user avatar

SSDSSD

1,3732 gold badges13 silver badges20 bronze badges

Who knows the mess you made. Just go to: 

Start > Microsoft SQL Server 2019 > SQL Server Installation Center > Maintenance > Repair

and when it asks to «browse to the media folder» I found mine under 

C:\SQL2019\Developer_ENU

the SETUP:EXE file is what you are looking for

enter image description here

follow all the steps of the Repair tool and you will be good to go

answered May 24, 2020 at 21:57

Francesco Mantovani's user avatar

answered Feb 4, 2021 at 12:13

MikeRyz's user avatar

MikeRyzMikeRyz

2191 gold badge4 silver badges18 bronze badges

Источник
  • Remove From My Forums

  • Question

  • The remote computer refused the network connection… I’m getting this error message which probably is very generic and I apologize for that however, not sure how to resolve this issue… So far I’m able to fix it by resetting my Setting > Accounts
    «Sign in with a local account instead» to using my online Microsoft account… This problem came about when I started using my company’s VPN link to remote desktop into work… However, now it’s back again and not sure what to do? 
    Maybe this isn’t related but ever since my company started using a more secure method to log into work from home, my home system thinks the network is disconnected and I no longer can access any external devices, my SQL server, etc. until I disconnect
    the VPN link and even then specifically my SQL Server will still give me that error message Error: 1225?

Answers

  • which port is running for mssql ?

    On a default instance, SQL Server listens on TCP/1433 by default. This can be changed. On a named instance, unless configured differently, SQL Server listens on a dynamic TCP port. What that means is should SQL Server discover that the port is in use, it will
    pick another TCP port. How clients usually find the right port in the case of a named instance is by talking to the SQL Server Listener Service/SQL Browser. That listens on UDP/1434 and cannot be changed. If you have a named instance, you can configure a static
    port and if you have a need to use Kerberos authentication/delegation, you should.

    What you’ll need to determine is what port your SQL Server is listening on. Then you’ll need to get with your networking/security folks to determine if they allow communication to that port via VPN. If they are, as indicated, check your firewall settings. Some
    systems have multiple firewalls (my laptop is an example). If so, you’ll need to check all the firewalls on your system.

    If all of those are correct, verify the server doesn’t have an IPSEC policy that restricts access to the SQL Server port via IP address. That also could result in you being blocked.

    http://stackoverflow.com/questions/669372/not-connecting-to-sql-server-over-vpn

    Please click Mark As Answer if my post helped.

    • Proposed as answer by

      Thursday, January 7, 2016 10:35 AM

    • Marked as answer by
      Lydia ZhangMicrosoft contingent staff
      Friday, January 8, 2016 6:42 AM

Источник

Понравилась статья? Поделить с друзьями:
  • Microsoft sql server ошибка 1222
  • Microsoft sql server management studio ошибка 18456
  • Microsoft solitaire collection ежедневные задания ошибка загрузки
  • Microsoft setup bootstrapper office 2016 ошибка
  • Microsoft setup bootstrapper office 2013 ошибка