Re: SQL Server




"Antoine" <mfns-spam15@xxxxxxxxxxxxx> wrote in message
news:h6n6f.9630$6i4.1873@xxxxxxxxxxxxxxxxxxxxxxx
> "YTC449" <robboREMOVETHISBIT@xxxxxxxx> wrote in message
> news:3rua3oFl6atuU1@xxxxxxxxxxxxxxxxx
>> Can anyone assist?
>>
>> I get the message: [DBNETLIB][ConnectionOpen(Connect())] SQL Server does
> not
>> exist or access is denied.
>>
>> This is when attempting to run a program for work that calls a database
> full
>> of PDF files for parts identification on lorry cranes.
>>
>> SQL Service manager shows that \\LAPTOP\PALSOFT - MSSQLServer is running.
>>
>> Is there a missing line or whatever?
>>
>> I don't understand the process so plain English would be a help.
>> It *was* working until I sorted the network connection at home to update
> the
>> Anti Virus and MS Update.
>>
>> Is there a fix?
>
> Er....who can say. Probably has a high likelihood of being related to your
> updates somehow. Antivirus? Which version?

Antivirus is Sophos
Version 5.1.0


> There is a high likelihood something like McAfee can block certain ports,
> perhaps when updated. Do you have the software for this - at a last ditch
> you could try removing, testing then reinstalling the AV.

May try that.

> Also the firewall as already mentioned might be worth checking, but only
> if
> built into the OS. I don't think you are going out to any kind of network
> for this software are you ?

XP Pro.
If it is that then how would I open a port to alow traffic for the
program(s)

>
> Ping is one of your friends here but maybe telnet may also be of use,
> which
> allows you to check connectivity to ports.

>
> But in my humble opinion, this isn't a server SQL you are looking at but
> an
> MSDE one. And it looks like you can in fact get the server manger status
> ok
> on the very laptop?

Does the "Path" in the SQL server need to point at a particular diretory?

Services are running and look like there aren't any errors. They start at
boot so to speak.

> At a last ditch, have you merely tried reloading the software?

Specialist custom software, one off in country and machine specific

> I've had lots of issues with MSDE in my current incarnation with multiple
> version on the same machine etc. If you have no data to lose, it might
> well
> be worth a go (but may only prove that it still doesn't work because of
> some
> update to Antivirus or MS software blocking your connectivity).
>
> This might be a reasonable starting point below also.
>
> http://www.teratrax.com/sql_server/msde/kb/sql_server_access_denied.html

Many thanks thus far


.



Relevant Pages

  • hack using xp_cmdshell
    ... Server, with sp4 and all security updates. ... ProgramName - SQL Exec for NetHakcerIII. ... With all ports closed it runs ...
    (microsoft.public.sqlserver.server)
  • Re: Firewall Ports in an SPS Extranet Environment
    ... I believe that the SQL Resource Kit will outline this for you. ... must be documentation in TechNet or MSDN on ports needed for a SQL server to ... communicate with a web server in the DMZ. ... while its associated SQL Server lives inside the firewall. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: SQL Port Restriction
    ... network adapter of the web server. ... Sensibly though, while SQL listens on ... the comunications back to the client are randomized ports. ...
    (microsoft.public.sqlserver.connect)
  • Re: Changing ports in OE6
    ... If the server is not allowing connections on any ports other than 25 and 110, then you cannot expect OE to connect, or any other email program for that matter. ... I'm not familiar with the specifics of AVG antivirus, but if it's similar to most AV scanners it creates a proxy server on your machine. ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)