Newbie:why osql doesn't let me logon ?

I need to move tempdb from c: drive to d:on the local server.
I try to go to osql to perform the deattach database command, but here is
what I get:
My user is an administrator on the local SQL server.
C:>osql -U myuser
Password:
Login failed for user 'myuser. Reason: not associated with a trusted SQL
Server connectionIf you are local administrator and you have mixed authentification activated
you can easily login with
OSQL -E
else you have to provide a password with
OSQL -UUsername -PPassword
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Magoo" <magoo-nospam@.hotmail.com> schrieb im Newsbeitrag
news:OgpRnrYUFHA.3244@.TK2MSFTNGP15.phx.gbl...
>I need to move tempdb from c: drive to d:on the local server.
> I try to go to osql to perform the deattach database command, but here is
> what I get:
> My user is an administrator on the local SQL server.
> C:>osql -U myuser
> Password:
> Login failed for user 'myuser. Reason: not associated with a trusted SQL
> Server connection
>
>|||Does your SQL Server allow SQL server authentication, or only NT
authentication?
"Magoo" <magoo-nospam@.hotmail.com> wrote in message
news:OgpRnrYUFHA.3244@.TK2MSFTNGP15.phx.gbl...
>I need to move tempdb from c: drive to d:on the local server.
> I try to go to osql to perform the deattach database command, but here is
> what I get:
> My user is an administrator on the local SQL server.
> C:>osql -U myuser
> Password:
> Login failed for user 'myuser. Reason: not associated with a trusted SQL
> Server connection
>
>|||Only NT auth.
"Lisa Pearlson" <no@.spam.plz> wrote in message
news:OGeDv5aUFHA.228@.TK2MSFTNGP12.phx.gbl...
> Does your SQL Server allow SQL server authentication, or only NT
> authentication?
>
> "Magoo" <magoo-nospam@.hotmail.com> wrote in message
> news:OgpRnrYUFHA.3244@.TK2MSFTNGP15.phx.gbl...
> >I need to move tempdb from c: drive to d:on the local server.
> > I try to go to osql to perform the deattach database command, but here
is
> > what I get:
> > My user is an administrator on the local SQL server.
> >
> > C:>osql -U myuser
> > Password:
> > Login failed for user 'myuser. Reason: not associated with a trusted SQL
> > Server connection
> >
> >
> >
> >
>|||Then OSQL -U won´t work. YOu hav to use OSQL -E instead (to use Integrated
authentification)
HTH, Jens Suessmeyer.
--
https://www.sqlserver2005.de
--
"Magoo" <magoo-nospam@.hotmail.com> schrieb im Newsbeitrag
news:%23waUTUbUFHA.2128@.TK2MSFTNGP15.phx.gbl...
> Only NT auth.
> "Lisa Pearlson" <no@.spam.plz> wrote in message
> news:OGeDv5aUFHA.228@.TK2MSFTNGP12.phx.gbl...
>> Does your SQL Server allow SQL server authentication, or only NT
>> authentication?
>>
>> "Magoo" <magoo-nospam@.hotmail.com> wrote in message
>> news:OgpRnrYUFHA.3244@.TK2MSFTNGP15.phx.gbl...
>> >I need to move tempdb from c: drive to d:on the local server.
>> > I try to go to osql to perform the deattach database command, but here
> is
>> > what I get:
>> > My user is an administrator on the local SQL server.
>> >
>> > C:>osql -U myuser
>> > Password:
>> > Login failed for user 'myuser. Reason: not associated with a trusted
>> > SQL
>> > Server connection
>> >
>> >
>> >
>> >
>>
>|||Ok, so now I do osql -E
Then a prompt appears.
I go there and I do:
1>sp_detach_db tempdb
Nothing happens. I see that my tempdb continues where it is.
How can I move the tempdb to another drive then ?
"Jens Süßmeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:ezj%23gZbUFHA.3280@.TK2MSFTNGP09.phx.gbl...
> Then OSQL -U won´t work. YOu hav to use OSQL -E instead (to use Integrated
> authentification)
> HTH, Jens Suessmeyer.
> --
> https://www.sqlserver2005.de
> --
> "Magoo" <magoo-nospam@.hotmail.com> schrieb im Newsbeitrag
> news:%23waUTUbUFHA.2128@.TK2MSFTNGP15.phx.gbl...
> > Only NT auth.
> >
> > "Lisa Pearlson" <no@.spam.plz> wrote in message
> > news:OGeDv5aUFHA.228@.TK2MSFTNGP12.phx.gbl...
> >> Does your SQL Server allow SQL server authentication, or only NT
> >> authentication?
> >>
> >>
> >> "Magoo" <magoo-nospam@.hotmail.com> wrote in message
> >> news:OgpRnrYUFHA.3244@.TK2MSFTNGP15.phx.gbl...
> >> >I need to move tempdb from c: drive to d:on the local server.
> >> > I try to go to osql to perform the deattach database command, but
here
> > is
> >> > what I get:
> >> > My user is an administrator on the local SQL server.
> >> >
> >> > C:>osql -U myuser
> >> > Password:
> >> > Login failed for user 'myuser. Reason: not associated with a trusted
> >> > SQL
> >> > Server connection
> >> >
> >> >
> >> >
> >> >
> >>
> >>
> >
> >
>|||And GO ! ;-)
> 1>sp_detach_db tempdb
> 2>GO
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Magoo" <magoo-nospam@.hotmail.com> schrieb im Newsbeitrag
news:%23cS9YfbUFHA.1044@.TK2MSFTNGP10.phx.gbl...
> Ok, so now I do osql -E
> Then a prompt appears.
> I go there and I do:
> 1>sp_detach_db tempdb
> Nothing happens. I see that my tempdb continues where it is.
> How can I move the tempdb to another drive then ?
> "Jens Süßmeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote
> in
> message news:ezj%23gZbUFHA.3280@.TK2MSFTNGP09.phx.gbl...
>> Then OSQL -U won´t work. YOu hav to use OSQL -E instead (to use
>> Integrated
>> authentification)
>> HTH, Jens Suessmeyer.
>> --
>> https://www.sqlserver2005.de
>> --
>> "Magoo" <magoo-nospam@.hotmail.com> schrieb im Newsbeitrag
>> news:%23waUTUbUFHA.2128@.TK2MSFTNGP15.phx.gbl...
>> > Only NT auth.
>> >
>> > "Lisa Pearlson" <no@.spam.plz> wrote in message
>> > news:OGeDv5aUFHA.228@.TK2MSFTNGP12.phx.gbl...
>> >> Does your SQL Server allow SQL server authentication, or only NT
>> >> authentication?
>> >>
>> >>
>> >> "Magoo" <magoo-nospam@.hotmail.com> wrote in message
>> >> news:OgpRnrYUFHA.3244@.TK2MSFTNGP15.phx.gbl...
>> >> >I need to move tempdb from c: drive to d:on the local server.
>> >> > I try to go to osql to perform the deattach database command, but
> here
>> > is
>> >> > what I get:
>> >> > My user is an administrator on the local SQL server.
>> >> >
>> >> > C:>osql -U myuser
>> >> > Password:
>> >> > Login failed for user 'myuser. Reason: not associated with a trusted
>> >> > SQL
>> >> > Server connection
>> >> >
>> >> >
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >
>>
>