SQL server does not exist or access is denied

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Carley - 27 May 2004 11:07 GMT

Hi folks,
I'm no computer expert, so I'll just explain what's
happeing & maybe someone will be able to help!

I have a website & use Access 2000 to connect to the SQL
database in order to modify/add products etc. Normally I
click on the database & it asks for username/pwd and then
connects.

Now it says: "[DBNETLIB][ConnectionOpen Connect()).] SQL
Server does not exist or Access is denied"

Here is what I've done between it working & not working:

- had my hard drive wiped & XPprofessional installed
- changed from cable connection to ASDL
- got a Netgear modem/router with Firewall (way above my
head!)

I am assuming one of these is stopping the connection. I
thought it was maybe the Firewall, but it seems very
complicated! I have no idea what to do!

Help appreciated :)

Reply to this Message

Kevin3NF - 27 May 2004 15:02 GMT

Did you change the machine name? If you are trying to connect to a SQL
Server called Old_Machine, but it is now called new_Machine, that could be
it.

Is SQL Server running? Can you see the data in the tables?

Signature

Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

> Hi folks,
> I'm no computer expert, so I'll just explain what's
[quoted text clipped - 20 lines]
>
> Help appreciated :)

Reply to this Message

- 27 May 2004 17:14 GMT

Hi Kevin,
I'm not really to sure what you're talking about - this
was all set up by someone else & I don't know much about
it.
I just enter my username & password....
Nothing on the server has changed - I think it must be a
setting or something on my PC :(
cheers
C

>-----Original Message-----
>Did you change the machine name? If you are trying to connect to a SQL
[quoted text clipped - 29 lines]
>
>.

Reply to this Message

Nathan & Nichole Carlisle - 31 May 2004 06:09 GMT

Carley,
You said that the firewall is very complicated. If your firewall
configurations are complicated, sometimes they can contain configurations
for blocking certain traffic. Be sure that it isn't blocking SQL Server
traffic or if you can block by port number, make sure it isn't blocking the
SQL port. The default ports for SQL are 1433 and 1434; however, it can be a
different port if the SQL DBA has specified a different port in the server
configuration. I don't normally post answers to these newsgroups, but I
just happen to recently have this problem on a users home PC. Hope this
helps.
Nate

> Hi Kevin,
> I'm not really to sure what you're talking about - this
[quoted text clipped - 48 lines]
> >
> >.

Reply to this Message