MSDE not working

I have installed MSDE on a computer but when I try to create an odbc
connection to it, I can't find the server in the list.
It seems that it isn't running, but I have checked the service to see if it
is running, and it is.
I am trying this on a system that has SQL Server for developers on it.
Could this be causing the problem?
Can someone point me in the right direction on this?
How are you tring to connect. I take it this is a named instance so what
error do you get if you try and connect with osql e.g.
osql -E -S.\INSTANCENAME
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Lance Geeck" <lgeeck@.cox.net> wrote in message
news:_RzIc.19690$yc.8850@.fed1read06...
> I have installed MSDE on a computer but when I try to create an odbc
> connection to it, I can't find the server in the list.
> It seems that it isn't running, but I have checked the service to see if
it
> is running, and it is.
> I am trying this on a system that has SQL Server for developers on it.
> Could this be causing the problem?
> Can someone point me in the right direction on this?
>
>
|||Jasper,
Thanks for responding.
The error message says:
[DBNETLIB]SQL Server does not exist or access denied.
[DBNETLIB]ConnectionOpen (Connect() ).
Thanks
Lance
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:uS%23G5vEaEHA.3420@.TK2MSFTNGP12.phx.gbl...
> How are you tring to connect. I take it this is a named instance so what
> error do you get if you try and connect with osql e.g.
> osql -E -S.\INSTANCENAME
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Lance Geeck" <lgeeck@.cox.net> wrote in message
> news:_RzIc.19690$yc.8850@.fed1read06...
> it
>

MSDE not working

I have installed MSDE on a computer but when I try to create an odbc
connection to it, I can't find the server in the list.
It seems that it isn't running, but I have checked the service to see if it
is running, and it is.
I am trying this on a system that has SQL Server for developers on it.
Could this be causing the problem?
Can someone point me in the right direction on this?How are you tring to connect. I take it this is a named instance so what
error do you get if you try and connect with osql e.g.
osql -E -S.\INSTANCENAME
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Lance Geeck" <lgeeck@.cox.net> wrote in message
news:_RzIc.19690$yc.8850@.fed1read06...
> I have installed MSDE on a computer but when I try to create an odbc
> connection to it, I can't find the server in the list.
> It seems that it isn't running, but I have checked the service to see if
it
> is running, and it is.
> I am trying this on a system that has SQL Server for developers on it.
> Could this be causing the problem?
> Can someone point me in the right direction on this?
>
>|||Jasper,
Thanks for responding.
The error message says:
[DBNETLIB]SQL Server does not exist or access denied.
[DBNETLIB]ConnectionOpen (Connect() ).
Thanks
Lance
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:uS%23G5vEaEHA.3420@.TK2MSFTNGP12.phx.gbl...
> How are you tring to connect. I take it this is a named instance so what
> error do you get if you try and connect with osql e.g.
> osql -E -S.\INSTANCENAME
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Lance Geeck" <lgeeck@.cox.net> wrote in message
> news:_RzIc.19690$yc.8850@.fed1read06...
> it
>

MSDE Installation Problem

I have installed MSDE on a computer but when I try to create an ODBC
connection to it, I can't find the server in the ODBC list of servers
available.
I am trying this on a system that has SQL Server 2000 for Developers on it
What does appear in the list are the following:
(local)
CRA-SERVER-2
Cra-Server-2
I don't know why there are two servers listed plus local, but all three
point to
the database setup under SQL Server 2000 for Developers.
It appears that MSDE installed properly. When I look in Component Services,
it is listed as MSSQL$CDC2, status = Started, Startup type = Automatic,
Logon as Local System. CDC2 is the instance name that I specified in the
Setup portion of the MSDE install package.
The directories specified all seem to have the files and data structures.
When I run the OSQL -E -S \CDC2 I get an error. The error message says:
[DBNETLIB]SQL Server does not exist or access denied.
[DBNETLIB]ConnectionOpen (Connect() ).
When I look at the Task Manager, I have 2 copies of sqlservr.exe running. I
Assume one is for SQL Server 2000 Developer and the other is MSDE. (?)
I am a developer and need an ODBC connection to the database in the MSDE
installed CDC2 server. Can someone point me in the right direction for
resolving
this ODBC/SQL Server problem?
Thanks for your help.
Lance
Does this work with SQL authentication?
Meaning,
Osql -Usa -Ppassword sqlserver\instancename?
If it does, then you might want to check
325022 INFO: MSDE Security and Authentication
http://support.microsoft.com/?id=325022
Cheers,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

MSDE Installation Problem

I have installed MSDE on a computer but when I try to create an ODBC
connection to it, I can't find the server in the ODBC list of servers
available.
I am trying this on a system that has SQL Server 2000 for Developers on it
What does appear in the list are the following:
(local)
CRA-SERVER-2
Cra-Server-2
I don't know why there are two servers listed plus local, but all three
point to
the database setup under SQL Server 2000 for Developers.
It appears that MSDE installed properly. When I look in Component Services,
it is listed as MSSQL$CDC2, status = Started, Startup type = Automatic,
Logon as Local System. CDC2 is the instance name that I specified in the
Setup portion of the MSDE install package.
The directories specified all seem to have the files and data structures.
When I run the OSQL -E -S \CDC2 I get an error. The error message says:
[DBNETLIB]SQL Server does not exist or access denied.
[DBNETLIB]ConnectionOpen (Connect() ).
When I look at the Task Manager, I have 2 copies of sqlservr.exe running. I
Assume one is for SQL Server 2000 Developer and the other is MSDE. (?)
I am a developer and need an ODBC connection to the database in the MSDE
installed CDC2 server. Can someone point me in the right direction for
resolving
this ODBC/SQL Server problem?
Thanks for your help.
LanceDoes this work with SQL authentication?
Meaning,
Osql -Usa -Ppassword sqlserver\instancename?
If it does, then you might want to check
325022 INFO: MSDE Security and Authentication
http://support.microsoft.com/?id=325022
Cheers,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.