SQL Server does not exist or access denied. - nothings changed

[Mike]

Everything has worked fine for about a month, then all of
a sudden I get this error message:

Sql server access denied or does not exist.

I have not changed anything on my router, sql server or
anything. Does anyone have any clues on what could have
went wrong?

Thanks, despartly in need.

Mike

[Jeff Cochran]

On Tue, 17 Feb 2004 06:41:46 -0800, "Mike"
<anonymous@discussions.microsoft.com> wrote:

>Everything has worked fine for about a month, then all of
>a sudden I get this error message:
>
>Sql server access denied or does not exist.
>
>I have not changed anything on my router, sql server or
>anything. Does anyone have any clues on what could have
>went wrong?

Well, first, if it worked, then didn't work, *something* changed. You
may not know what it was though.

You'll need to give us some more details to help as well. Does the
server exist? In terms of the system with the application? Can you
access it with Enterprise Manager or Query Analyzer? Using the same
account/password the app uses?

How about event log entries? Or a simple connection and query page?

Did you add a personal firewall, do a security update, change AV
software, or anything else on the system?

Jeff

[Aaron Bertrand - MVP]

You're going to have to provide more information. Can you ping the database
server? By name? By IP address? Are you sure the SQL Server service is
running? What account is it running under? Are you using Windows
Authentication or SQL Server authentication, and have you tried both? Have
you tried using a different user (e.g. a domain admin or sa)? Is there
anything in the event log of the SQL Server? Can you connect to other SQL
Servers from the client machine? Can other machines connect to the SQL
Server machine?

In other words, it doesn't sound like you've done a lot of legwork yet...

--
Aaron Bertrand
SQL Server MVP
[url]http://www.aspfaq.com/[/url]




"Mike" <anonymous@discussions.microsoft.com> wrote in message
news:1137401c3f564$2b373940$a301280a@phx.gbl...

> Everything has worked fine for about a month, then all of
> a sudden I get this error message:
>
> Sql server access denied or does not exist.
>
> I have not changed anything on my router, sql server or
> anything. Does anyone have any clues on what could have
> went wrong?
>
> Thanks, despartly in need.
>
> Mike

[kie]

when i installed mcafee personal firewall, i blocked access for sql
server, then granted access to sql server. this resulted in the error:

Error Type:
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access denied.

when accessing my local database via ASP.

so i uninstalled mcafee personal web server having been unable how to
make it give all access back to sql server.

my problem remains.

i transferred my database to another sql server 2000 on my network
while i work this out.

kie