HELP! CANNOT CONNECT TO SQL SERVER

I need help urgently to connect to SQL Server on my desktop (running on
Windows XP Pro, with Office Developer installed) from my laptop (also running
Windows XP Pro). Both machines communicate easily as I transfer files between
the two.

But now I am working on an Access Project, and need to work from the laptop
occasionally. So I need to connect to the Access Project on the desktop. When
I pick *File/Connection/Data Link Properties-Connection Tab* from the laptop,
the server name on the desktop is shown when the two machines are connected,
but does not when they are not. However i have not been able to connect to
the server, probably because of the "gibberish" on the other Tabs of the Data
Link Properties.

Can someone help me out please?
--
Glint

So...are we to guess the error message?

Do you see a list of databases in that dropdown?

When you pick the server/db and click test connection....what happens?

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions


"Glint" wrote in message
...
I need help urgently to connect to SQL Server on my desktop (running on
Windows XP Pro, with Office Developer installed) from my laptop (also
running
Windows XP Pro). Both machines communicate easily as I transfer files
between
the two.

But now I am working on an Access Project, and need to work from the
laptop
occasionally. So I need to connect to the Access Project on the desktop.
When
I pick *File/Connection/Data Link Properties-Connection Tab* from the
laptop,
the server name on the desktop is shown when the two machines are
connected,
but does not when they are not. However i have not been able to connect to
the server, probably because of the "gibberish" on the other Tabs of the
Data
Link Properties.

Can someone help me out please?
--
Glint

When I test connection, I get the error message:

*Test Connection failed because of an error in initializing provider.
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied.*
--
gbenga


"Kevin3NF" wrote:

So...are we to guess the error message?

Do you see a list of databases in that dropdown?

When you pick the server/db and click test connection....what happens?

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions


"Glint" wrote in message
...
I need help urgently to connect to SQL Server on my desktop (running on
Windows XP Pro, with Office Developer installed) from my laptop (also
running
Windows XP Pro). Both machines communicate easily as I transfer files
between
the two.

But now I am working on an Access Project, and need to work from the
laptop
occasionally. So I need to connect to the Access Project on the desktop.
When
I pick *File/Connection/Data Link Properties-Connection Tab* from the
laptop,
the server name on the desktop is shown when the two machines are
connected,
but does not when they are not. However i have not been able to connect to
the server, probably because of the "gibberish" on the other Tabs of the
Data
Link Properties.

Can someone help me out please?
--
Glint

Turn off the firewall that SP2 installed on both machines (if they are at
Sp2...). Startrunfirewall.cpl
Try again.

If that fails:
Go to the desktop where the SQL Server is, open up Control paneladmin
toolsservices. make sure MS SQL Server Service is running. If not, start
it.
Try again.

Post results

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions


"Glint" wrote in message
...
When I test connection, I get the error message:

*Test Connection failed because of an error in initializing provider.
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied.*
--
gbenga


"Kevin3NF" wrote:

So...are we to guess the error message?

Do you see a list of databases in that dropdown?

When you pick the server/db and click test connection....what happens?

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions


"Glint" wrote in message
...
I need help urgently to connect to SQL Server on my desktop (running on
Windows XP Pro, with Office Developer installed) from my laptop (also
running
Windows XP Pro). Both machines communicate easily as I transfer files
between
the two.

But now I am working on an Access Project, and need to work from the
laptop
occasionally. So I need to connect to the Access Project on the
desktop.
When
I pick *File/Connection/Data Link Properties-Connection Tab* from the
laptop,
the server name on the desktop is shown when the two machines are
connected,
but does not when they are not. However i have not been able to connect
to
the server, probably because of the "gibberish" on the other Tabs of
the
Data
Link Properties.

Can someone help me out please?
--
Glint

The Firewall was turned off in both machines. *StartRunFirewall.cpl*
produced error message: *Windows cannot find 'firewall.cpl.'* in both
machines.
-
Glint


"Kevin3NF" wrote:

Turn off the firewall that SP2 installed on both machines (if they are at
Sp2...). Startrunfirewall.cpl
Try again.

If that fails:
Go to the desktop where the SQL Server is, open up Control paneladmin
toolsservices. make sure MS SQL Server Service is running. If not, start
it.
Try again.

Post results

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions


"Glint" wrote in message
...
When I test connection, I get the error message:

*Test Connection failed because of an error in initializing provider.
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied.*
--
gbenga


"Kevin3NF" wrote:

So...are we to guess the error message?

Do you see a list of databases in that dropdown?

When you pick the server/db and click test connection....what happens?

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions


"Glint" wrote in message
...
I need help urgently to connect to SQL Server on my desktop (running on
Windows XP Pro, with Office Developer installed) from my laptop (also
running
Windows XP Pro). Both machines communicate easily as I transfer files
between
the two.

But now I am working on an Access Project, and need to work from the
laptop
occasionally. So I need to connect to the Access Project on the
desktop.
When
I pick *File/Connection/Data Link Properties-Connection Tab* from the
laptop,
the server name on the desktop is shown when the two machines are
connected,
but does not when they are not. However i have not been able to connect
to
the server, probably because of the "gibberish" on the other Tabs of
the
Data
Link Properties.

Can someone help me out please?
--
Glint

So you're probably on SP1 or RTM edition.

What were the results of part two...checking the MS SQL Server Service?

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions


"Glint" wrote in message
...
The Firewall was turned off in both machines. *StartRunFirewall.cpl*
produced error message: *Windows cannot find 'firewall.cpl.'* in both
machines.
-
Glint


"Kevin3NF" wrote:

Turn off the firewall that SP2 installed on both machines (if they are at
Sp2...). Startrunfirewall.cpl
Try again.

If that fails:
Go to the desktop where the SQL Server is, open up Control paneladmin
toolsservices. make sure MS SQL Server Service is running. If not,
start
it.
Try again.

Post results

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions


"Glint" wrote in message
...
When I test connection, I get the error message:

*Test Connection failed because of an error in initializing provider.
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access
denied.*
--
gbenga


"Kevin3NF" wrote:

So...are we to guess the error message?

Do you see a list of databases in that dropdown?

When you pick the server/db and click test connection....what happens?

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area
DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions


"Glint" wrote in message
...
I need help urgently to connect to SQL Server on my desktop (running
on
Windows XP Pro, with Office Developer installed) from my laptop
(also
running
Windows XP Pro). Both machines communicate easily as I transfer
files
between
the two.

But now I am working on an Access Project, and need to work from the
laptop
occasionally. So I need to connect to the Access Project on the
desktop.
When
I pick *File/Connection/Data Link Properties-Connection Tab* from
the
laptop,
the server name on the desktop is shown when the two machines are
connected,
but does not when they are not. However i have not been able to
connect
to
the server, probably because of the "gibberish" on the other Tabs of
the
Data
Link Properties.

Can someone help me out please?
--
Glint

The MS SQL Server service was always on, on auto.
--
Glint


"Kevin3NF" wrote:

So you're probably on SP1 or RTM edition.

What were the results of part two...checking the MS SQL Server Service?

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions


"Glint" wrote in message
...
The Firewall was turned off in both machines. *StartRunFirewall.cpl*
produced error message: *Windows cannot find 'firewall.cpl.'* in both
machines.
-
Glint


"Kevin3NF" wrote:

Turn off the firewall that SP2 installed on both machines (if they are at
Sp2...). Startrunfirewall.cpl
Try again.

If that fails:
Go to the desktop where the SQL Server is, open up Control paneladmin
toolsservices. make sure MS SQL Server Service is running. If not,
start
it.
Try again.

Post results

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions


"Glint" wrote in message
...
When I test connection, I get the error message:

*Test Connection failed because of an error in initializing provider.
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access
denied.*
--
gbenga


"Kevin3NF" wrote:

So...are we to guess the error message?

Do you see a list of databases in that dropdown?

When you pick the server/db and click test connection....what happens?

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area
DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions


"Glint" wrote in message
...
I need help urgently to connect to SQL Server on my desktop (running
on
Windows XP Pro, with Office Developer installed) from my laptop
(also
running
Windows XP Pro). Both machines communicate easily as I transfer
files
between
the two.

But now I am working on an Access Project, and need to work from the
laptop
occasionally. So I need to connect to the Access Project on the
desktop.
When
I pick *File/Connection/Data Link Properties-Connection Tab* from
the
laptop,
the server name on the desktop is shown when the two machines are
connected,
but does not when they are not. However i have not been able to
connect
to
the server, probably because of the "gibberish" on the other Tabs of
the
Data
Link Properties.

Can someone help me out please?
--
Glint

Go into the LOG folder in the SQL Server install directory

on my machine:
C:\Program Files\Microsoft SQL Server\MSSQL\LOG

Look in the file called ERRORLOG (no extension) for lines like:

2005-05-05 17:25:51.72 server SQL server listening on 172.20.1.72: 1433.
2005-05-05 17:25:51.72 server SQL server listening on 127.0.0.1: 1433.
2005-05-05 17:25:52.38 server SQL server listening on TCP, Named Pipes.

Paste those lines back.

My day ends at 5:00 Central....highly unlikely that I will see this thread
between then and 8am Monday morning

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions


"Glint" wrote in message
...
The MS SQL Server service was always on, on auto.
--
Glint


"Kevin3NF" wrote:

So you're probably on SP1 or RTM edition.

What were the results of part two...checking the MS SQL Server Service?

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions


"Glint" wrote in message
...
The Firewall was turned off in both machines. *StartRunFirewall.cpl*
produced error message: *Windows cannot find 'firewall.cpl.'* in both
machines.
-
Glint


"Kevin3NF" wrote:

Turn off the firewall that SP2 installed on both machines (if they are
at
Sp2...). Startrunfirewall.cpl
Try again.

If that fails:
Go to the desktop where the SQL Server is, open up Control
paneladmin
toolsservices. make sure MS SQL Server Service is running. If not,
start
it.
Try again.

Post results

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area
DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions


"Glint" wrote in message
...
When I test connection, I get the error message:

*Test Connection failed because of an error in initializing
provider.
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access
denied.*
--
gbenga


"Kevin3NF" wrote:

So...are we to guess the error message?

Do you see a list of databases in that dropdown?

When you pick the server/db and click test connection....what
happens?

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area
DBAs.

www.experts-exchange.com - experts compete for points to answer
your
questions


"Glint" wrote in message
...
I need help urgently to connect to SQL Server on my desktop
(running
on
Windows XP Pro, with Office Developer installed) from my laptop
(also
running
Windows XP Pro). Both machines communicate easily as I transfer
files
between
the two.

But now I am working on an Access Project, and need to work from
the
laptop
occasionally. So I need to connect to the Access Project on the
desktop.
When
I pick *File/Connection/Data Link Properties-Connection Tab* from
the
laptop,
the server name on the desktop is shown when the two machines are
connected,
but does not when they are not. However i have not been able to
connect
to
the server, probably because of the "gibberish" on the other Tabs
of
the
Data
Link Properties.

Can someone help me out please?
--
Glint

Thanx Kevin,
I really appreciate your help so far. Kindly take up the thread when you get
back.
I will go try your suggestions right away.
--
Glint


"Kevin3NF" wrote:

Go into the LOG folder in the SQL Server install directory

on my machine:
C:\Program Files\Microsoft SQL Server\MSSQL\LOG

Look in the file called ERRORLOG (no extension) for lines like:

2005-05-05 17:25:51.72 server SQL server listening on 172.20.1.72: 1433.
2005-05-05 17:25:51.72 server SQL server listening on 127.0.0.1: 1433.
2005-05-05 17:25:52.38 server SQL server listening on TCP, Named Pipes.

Paste those lines back.

My day ends at 5:00 Central....highly unlikely that I will see this thread
between then and 8am Monday morning

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions


"Glint" wrote in message
...
The MS SQL Server service was always on, on auto.
--
Glint


"Kevin3NF" wrote:

So you're probably on SP1 or RTM edition.

What were the results of part two...checking the MS SQL Server Service?

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions


"Glint" wrote in message
...
The Firewall was turned off in both machines. *StartRunFirewall.cpl*
produced error message: *Windows cannot find 'firewall.cpl.'* in both
machines.
-
Glint


"Kevin3NF" wrote:

Turn off the firewall that SP2 installed on both machines (if they are
at
Sp2...). Startrunfirewall.cpl
Try again.

If that fails:
Go to the desktop where the SQL Server is, open up Control
paneladmin
toolsservices. make sure MS SQL Server Service is running. If not,
start
it.
Try again.

Post results

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area
DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions


"Glint" wrote in message
...
When I test connection, I get the error message:

*Test Connection failed because of an error in initializing
provider.
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access
denied.*
--
gbenga


"Kevin3NF" wrote:

So...are we to guess the error message?

Do you see a list of databases in that dropdown?

When you pick the server/db and click test connection....what
happens?

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area
DBAs.

www.experts-exchange.com - experts compete for points to answer
your
questions


"Glint" wrote in message
...
I need help urgently to connect to SQL Server on my desktop
(running
on
Windows XP Pro, with Office Developer installed) from my laptop
(also
running
Windows XP Pro). Both machines communicate easily as I transfer
files
between
the two.

But now I am working on an Access Project, and need to work from
the
laptop
occasionally. So I need to connect to the Access Project on the
desktop.
When
I pick *File/Connection/Data Link Properties-Connection Tab* from
the
laptop,
the server name on the desktop is shown when the two machines are
connected,
but does not when they are not. However i have not been able to
connect
to
the server, probably because of the "gibberish" on the other Tabs
of
the
Data
Link Properties.

Can someone help me out please?
--
Glint

1 hour left...fire 'em at me while I'm here :-)

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions


"Glint" wrote in message
...
Thanx Kevin,
I really appreciate your help so far. Kindly take up the thread when you
get
back.
I will go try your suggestions right away.
--
Glint


"Kevin3NF" wrote:

Go into the LOG folder in the SQL Server install directory

on my machine:
C:\Program Files\Microsoft SQL Server\MSSQL\LOG

Look in the file called ERRORLOG (no extension) for lines like:

2005-05-05 17:25:51.72 server SQL server listening on 172.20.1.72:
1433.
2005-05-05 17:25:51.72 server SQL server listening on 127.0.0.1: 1433.
2005-05-05 17:25:52.38 server SQL server listening on TCP, Named
Pipes.

Paste those lines back.

My day ends at 5:00 Central....highly unlikely that I will see this
thread
between then and 8am Monday morning

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions


"Glint" wrote in message
...
The MS SQL Server service was always on, on auto.
--
Glint


"Kevin3NF" wrote:

So you're probably on SP1 or RTM edition.

What were the results of part two...checking the MS SQL Server
Service?

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area
DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions


"Glint" wrote in message
...
The Firewall was turned off in both machines.
*StartRunFirewall.cpl*
produced error message: *Windows cannot find 'firewall.cpl.'* in
both
machines.
-
Glint


"Kevin3NF" wrote:

Turn off the firewall that SP2 installed on both machines (if they
are
at
Sp2...). Startrunfirewall.cpl
Try again.

If that fails:
Go to the desktop where the SQL Server is, open up Control
paneladmin
toolsservices. make sure MS SQL Server Service is running. If
not,
start
it.
Try again.

Post results

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area
DBAs.

www.experts-exchange.com - experts compete for points to answer
your
questions


"Glint" wrote in message
...
When I test connection, I get the error message:

*Test Connection failed because of an error in initializing
provider.
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist
or
access
denied.*
--
gbenga


"Kevin3NF" wrote:

So...are we to guess the error message?

Do you see a list of databases in that dropdown?

When you pick the server/db and click test connection....what
happens?

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth
area
DBAs.

www.experts-exchange.com - experts compete for points to answer
your
questions


"Glint" wrote in message
...
I need help urgently to connect to SQL Server on my desktop
(running
on
Windows XP Pro, with Office Developer installed) from my
laptop
(also
running
Windows XP Pro). Both machines communicate easily as I
transfer
files
between
the two.

But now I am working on an Access Project, and need to work
from
the
laptop
occasionally. So I need to connect to the Access Project on
the
desktop.
When
I pick *File/Connection/Data Link Properties-Connection Tab*
from
the
laptop,
the server name on the desktop is shown when the two machines
are
connected,
but does not when they are not. However i have not been able
to
connect
to
the server, probably because of the "gibberish" on the other
Tabs
of
the
Data
Link Properties.

Can someone help me out please?
--
Glint