Re: Getting "SQL Server does not exist or access denied" error messages

From: ringo (ringo.1a25o3_at_mail.mcse.ms)
Date: 07/27/04 

Date: Tue, 27 Jul 2004 10:07:42 -0500

I am having a similar problem. i am not very experienced programmer and
wrote a program in vb.net which connected fine to my local copy of sql.
the db admin set up ODBC's for the remote servers and i got the same
error. i tried using odbc's on my local machine and fixing the
problem, but i can't for the life of me figure it out. When i test the
connection in the odbc setup,it connects great. i just cannot do it
via the program. I used the odbc connection string and put the
passwords and id in the string code before i try to open the
connection. very confused. any help would be greatly appreciated.
thanks

Chris

Val Mazur wrote:
> *Hi Rod,
>
> If this is was fine before, then I would suspect that it is an issue
> related
> to the security. Usually this error happens when client does not
> have
> permissions to connect to the SQL Server. Could be that last changes
> in a
> fixes were related to the security issues. Do you know which patches
> were
> installed exactly. If yes, then you could check KB articles for them
> to see
> if installation of them does not change any security settings.
>
> --
> Val Mazur
> Microsoft MVP
>
>
> "Rod" <Rod@NO.SPAM> wrote in message
> news:u05d8jpaEHA.4092@TK2MSFTNGP11.phx.gbl...
> > For some reason, this week we started to get "SQL Server does not
> exist or
> > access denied" error messages when attempting to connect to our SQL
> Server
> > databases. This only affects people who dial into our network. But
> this
> > seems to be a rather complicated situation, so let me explain.
> >
> > We have a couple of VB6 applications we've written. People log into
> our
> > network and get authenticated on our network (username, password
> and
> > domain
> > must be specified). We have a test server with SQL Server 2000
> installed.
> > The test server is a Windows 2000 Server. The production server has
> SQL
> > Server 2000 installed also, but it is a Windows 2003 Server. I have
> found,
> > for example, that I can define an ODBC DSN to the test database
> and
> > retrieve
> > data just fine, but I can NOT do the same thing to the production
> database
> > on the production server. However, our users were able to do so up
> until
> > Tuesday of this week. The only thing I can think of which has
> changed is I
> > applied the 5 critical updates that Microsoft related
> Tuesday/Wednesday on
> > the DHCP server. But the DHCP server is not either the production
> or test
> > database servers, so I have no idea why that should make any
> difference at
> > all.
> >
> > Does anyone have any idea why this problem is now showing up?
> >
> > Rod
> >
> >
> >
> > * 

--
ringo
------------------------------------------------------------------------
Posted via http://www.mcse.ms
------------------------------------------------------------------------
View this thread: http://www.mcse.ms/message862704.html

Relevant Pages

  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Complicated Connection Problems bewteen ADP and SQL Server
    ... This database ... expertise for getting the user workstations talking to the SQL Server. ... connection would fail and the adp wouldn't be able to talk to the server. ... might be in my ADO connection string. ...
    (microsoft.public.access.adp.sqlserver)
  • Complicated Connection Problem between ADP and SQL Server
    ... This database ... expertise for getting the user workstations talking to the SQL Server. ... connection would fail and the adp wouldn't be able to talk to the server. ... might be in my ADO connection string. ...
    (microsoft.public.sqlserver.connect)
  • Re: upsizing to sql 2005
    ... the word SERVER in it, ... You can access to the database by multiple means (Access, ... and how does it update the SQL database with the new records in Access? ... Query Name: Arcadia - ARC ...
    (microsoft.public.access.queries)