Re: SQL Server does not exist or access denied

Hi Mike,

no, the Windows firewall is not on. Actually, the WindowsFirewall/ICS
service is disabled.

"Mike Epprecht (SQL MVP)" wrote:

> Hi
>
> Windows 2003 SP1 includes a firewall. Check if it is on.
>
> Regards
> --------------------------------
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
>
> IM: mike@xxxxxxxxxxxx
>
> MVP Program: http://www.microsoft.com/mvp
>
> Blog: http://www.msmvps.com/epprecht/
>
> "Massimo" <Massimo@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:087BADD1-0C35-4546-BEE5-19E70CF22068@xxxxxxxxxxxxxxxx
> > Thank you for the quick reply.
> >
> > I can ping the server successfully and there is no firewall inbetween:
> > both
> > the client and the server are on our intranet.
> >
> >
> > "Mike Epprecht (SQL MVP)" wrote:
> >
> >> Hi
> >>
> >> "SQL Server does not exist or access denied" means that either the server
> >> was not found or it rejected your connection.
> >> It did not even get to SQL Server on the server.
> >>
> >> Check that you host is pingable and that the firewall on the server
> >> allows
> >> for connections on the SQL Server port.
> >>
> >> Regards
> >> --------------------------------
> >> Mike Epprecht, Microsoft SQL Server MVP
> >> Zurich, Switzerland
> >>
> >> IM: mike@xxxxxxxxxxxx
> >>
> >> MVP Program: http://www.microsoft.com/mvp
> >>
> >> Blog: http://www.msmvps.com/epprecht/
> >>
> >> "Massimo" <Massimo@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> >> news:53EA24C2-3839-4DDC-8D47-7B4568F9DA43@xxxxxxxxxxxxxxxx
> >> > Hello everybody,
> >> >
> >> > I am trying to register a new SQL server with enterprise manager and I
> >> > get
> >> > the following error message:
> >> >
> >> > SQL Server does not exist or access denied
> >> >
> >> > The SQL Server (its name is SATURN) is running Windows 2003 SP1.
> >> > SQL Server SP4 is installed and I'm using Windows authentication.
> >> > TCP/IP protocol is enabled and I can ping SATURN successfully.
> >> > My username belogs to a group that has 'System administrator' role.
> >> >
> >> > Thank you in advance for you help
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >> >
> >>
> >>
> >>
>
>
>
.

Relevant Pages

  • Re: newbie Frage zu Server-Explorer - Datenverbindungen
    ... "Microsoft SQL Server " an. ... Ich könnte den Firewall wohl ausschalten, da die Maschine via Proxi ins Netz geht. ... Ich versuche doch nur - lokal innerhalb meiner eigenen Machine - auf der ich als Admin arbeite - hinzubekommen, dass der Servername (oder meinetwegen auch lokal oder was angezeigt wird. ... Im SQL Server Configuration Manager habe ich Shared Memory, Named Pipes, UND TCP/IP Aktiviert. ...
    (microsoft.public.de.german.entwickler.dotnet.datenbank)
  • Re: some thoughts on the Slammer fiasco
    ... it can break SQL server. ... the port its better to do it at the router level so the firewall can do the ... > WTF are you running a software firewall on an SQL box for. ... > firewall of your choice) block port X. ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server does not exist or access denied
    ... > Mike Epprecht, Microsoft SQL Server MVP ... >>> It did not even get to SQL Server on the server. ...
    (microsoft.public.sqlserver.connect)
  • Re: Cannot Crete server object
    ... > Contact your Software Vendor. ... It is not a SQL Server error, ... > Mike Epprecht, Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clients)
  • Re: Cannot connect to SQL Server
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... I see that you said you tried turning off the firewall, but the Windows firewall that is turned on in SP2 causes most of these problems. ... I have checked the Server Network Utility and ClientNetwork Utility: ...
    (microsoft.public.sqlserver.connect)
Loading