sqlcmd and powershell and a failed login

I am confused.

I have a command line that executes as expected in a CMD shell but doesn't
in a PowerSehll box. Specifically, the following fails:
& sqlcmd -E -S (local)\SQLExpress -d adatabase -i ascript.sql
while this suceeds in a DOS box
sqlcmd -E -S (local)\SQLExpress -d adatabase -i ascript.sql

The error is
Cannot open database "adatabase" requested by the login. The login
failed. Msg 18456, Level 14, State 1, Server localname\SQLExpress, login
failed for user 'domain\me'

Now, if I just
& sqlcmd -S (local)\SQLExpress
I get to an interactive rpompt and I can then "use" and execute DDL
statements. So I must be missing some part of the security setting for
PowerShell that are different from the DOS box, and I am wondering if y'all
could help me figure out what.

TIA

I know, the -E is redundant. I cd to the folder where th script lives. The
database exists. TCP for the database is enable, as is named pipes. The
current login is a user in the database mapping to the dbo schema.

--
I'm not sayin' anything, I'm just sayin'

I was surprised also, but then wondered... Are you using Vista or 2008?
Might this have to do with whether you're running PowerShell with
Administrator priviledges?

Marco

--
Microsoft MVP - Windows PowerShell
http://www.microsoft.com/mvp

PowerGadgets MVP
http://www.powergadgets.com/mvp

Blog:
http://marcoshaw.blogspot.com

--
I''m not sayin'' anything, I''m just sayin''


"Marco Shaw [MVP]" wrote:
XP SP2 is the OS. And the aco**** is root on the local box.

On XP SP2, this worked for me:
PSH> sqlcmd -E -S "(local)\sqlexpress" -d database_name

Marco

--
Microsoft MVP - Windows PowerShell
http://www.microsoft.com/mvp

PowerGadgets MVP
http://www.powergadgets.com/mvp

Blog:
http://marcoshaw.blogspot.com

> You put quotes around the server name, but not around the database name.
Does that have any significance?

SkipSailors wrote: I'm also using the v2 CTP2. Things might parse differently if you're
using v1... The above worked for me. My database name was a simple
string (no spaces or special characters).

Marco

I just installed the CTP2 on my local machine and ran the script again. No
joy. My database name is also simple, only ASCII-type characters in the name
with no spaces or tabs or anything

SkipSailors wrote: I'll think about it, but I'm not sure what the cause might be at this
point...

Marco