ODBC connection problems....

Also posted in the MSDE section...
From: "Chris" <Chris@.discussions.microsoft.com>
Subject: MSDE / ODBC install problem...please help...
Date: Tuesday, October 25, 2005 9:41 PM
I have installed MSDE (and ODBC) at my client site on their 2003 server. I
have attached my SQL database via Teratrax Database Manager to the MSDE
server however when I try to setup the ODBC connection it doesn't list the
database in the drop-down. I cannot attach to the database from my notebook
either because I am not authenticated onto their domain.
I have also applied the regedit on the LoginMode key setting it to 2 and
rebooted but I still cannot connect to the database via the ODBC manager.
What am I doing wrong? I am NOT good with the scripts for configuring
things
- generally I use the Enterprise Manager.Hi
If you don't have Enterprise Manager you may want to try logging in with
SQL. You don't say what SQL user your are using and if they have access to
this database. If you can connect to a database on that server then you may
want to see what sp_helpdb returns, you could also use sp_attach_db to
attach the original files to the server.
John
"Chris Marsh" <cmarsh@.synergy-intl.com> wrote in message
news:uSbDAWe2FHA.1268@.TK2MSFTNGP10.phx.gbl...
> Also posted in the MSDE section...
> From: "Chris" <Chris@.discussions.microsoft.com>
> Subject: MSDE / ODBC install problem...please help...
> Date: Tuesday, October 25, 2005 9:41 PM
> I have installed MSDE (and ODBC) at my client site on their 2003 server.
> I
> have attached my SQL database via Teratrax Database Manager to the MSDE
> server however when I try to setup the ODBC connection it doesn't list the
> database in the drop-down. I cannot attach to the database from my
> notebook
> either because I am not authenticated onto their domain.
> I have also applied the regedit on the LoginMode key setting it to 2 and
> rebooted but I still cannot connect to the database via the ODBC manager.
> What am I doing wrong? I am NOT good with the scripts for configuring
> things
> - generally I use the Enterprise Manager.
>