SQL server does not exist or access is denied

  • Thread starter Thread starter Carley
  • Start date Start date
C

Carley

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 :)
 
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
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?

--
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
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 :)
Click to expand...


.
Click to expand...
 
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
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
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?

--
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
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 :)
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top