OSQL SA Password Restrictions involving # & ^ symbols

Is anyone aware of such a restriction? All my SQL Jobs etc run fine with my
SA account & password that includes both a # and a ^, but when I try to run
jobs from OSQL the job fails with a bad password error. Naturally, I have
double checked the password entry. I have also tried running a simple oqsl
job under an account that uses just plain aplhanumeric characters in the
password & that runs fine.
Thanks,
Nick.
use double quotation marks (")... osql -S<server> -U<user> -P <"password">
"Nick" wrote:

> Is anyone aware of such a restriction? All my SQL Jobs etc run fine with my
> SA account & password that includes both a # and a ^, but when I try to run
> jobs from OSQL the job fails with a bad password error. Naturally, I have
> double checked the password entry. I have also tried running a simple oqsl
> job under an account that uses just plain aplhanumeric characters in the
> password & that runs fine.
> Thanks,
> Nick.

OSQL SA Password Restrictions involving # & ^ symbols

Is anyone aware of such a restriction? All my SQL Jobs etc run fine with my
SA account & password that includes both a # and a ^, but when I try to run
jobs from OSQL the job fails with a bad password error. Naturally, I have
double checked the password entry. I have also tried running a simple oqsl
job under an account that uses just plain aplhanumeric characters in the
password & that runs fine.
Thanks,
Nick.use double quotation marks (")... osql -S<server> -U<user> -P <"password">
"Nick" wrote:

> Is anyone aware of such a restriction? All my SQL Jobs etc run fine with m
y
> SA account & password that includes both a # and a ^, but when I try to r
un
> jobs from OSQL the job fails with a bad password error. Naturally, I have
> double checked the password entry. I have also tried running a simple oqsl
> job under an account that uses just plain aplhanumeric characters in the
> password & that runs fine.
> Thanks,
> Nick.

OSQL SA Password Restrictions involving # & ^ symbols

Is anyone aware of such a restriction? All my SQL Jobs etc run fine with my
SA account & password that includes both a # and a ^, but when I try to run
jobs from OSQL the job fails with a bad password error. Naturally, I have
double checked the password entry. I have also tried running a simple oqsl
job under an account that uses just plain aplhanumeric characters in the
password & that runs fine.
Thanks,
Nick.use double quotation marks (")... osql -S<server> -U<user> -P <"password">
"Nick" wrote:
> Is anyone aware of such a restriction? All my SQL Jobs etc run fine with my
> SA account & password that includes both a # and a ^, but when I try to run
> jobs from OSQL the job fails with a bad password error. Naturally, I have
> double checked the password entry. I have also tried running a simple oqsl
> job under an account that uses just plain aplhanumeric characters in the
> password & that runs fine.
> Thanks,
> Nick.

OSQL prompts for password

Hello,
I have a batch file setup for backing up an msde 2000 database but the only
way it will run is by inserting -Usa -Ppassword. I don't want to expose the
sa password and I would like to use windows authentication so I've included
the -E switch. However, it prompts for a password and no matter what I put
in it fails with invalid password and my user login name. The password that
I enter is correct and the server is setup with Windows Authentication. The
batch file is called from an application and I don't want the user to to
have to enter a password, I just want the process to run when started.
Here's How I'm calling the sql script.
OSQL -E -iTestBackup.sql
TIA
Vic
Problem Solved! The switch should be uppercase E and I had lower case which
means echo.

OSQL prompts for password

Hello,
I have a batch file setup for backing up an msde 2000 database but the only
way it will run is by inserting -Usa -Ppassword. I don't want to expose the
sa password and I would like to use windows authentication so I've included
the -E switch. However, it prompts for a password and no matter what I put
in it fails with invalid password and my user login name. The password that
I enter is correct and the server is setup with Windows Authentication. The
batch file is called from an application and I don't want the user to to
have to enter a password, I just want the process to run when started.
Here's How I'm calling the sql script.
OSQL -E -iTestBackup.sql
TIA
VicProblem Solved! The switch should be uppercase E and I had lower case which
means echo.

OSQL prompts for password

Hello,
I have a batch file setup for backing up an msde 2000 database but the only
way it will run is by inserting -Usa -Ppassword. I don't want to expose the
sa password and I would like to use windows authentication so I've included
the -E switch. However, it prompts for a password and no matter what I put
in it fails with invalid password and my user login name. The password that
I enter is correct and the server is setup with Windows Authentication. The
batch file is called from an application and I don't want the user to to
have to enter a password, I just want the process to run when started.
Here's How I'm calling the sql script.
OSQL -E -iTestBackup.sql
TIA
VicProblem Solved! The switch should be uppercase E and I had lower case which
means echo.

osql batch

Hi
I want to run a batch file containg osql commands but do not want the user
to be able to see the sa password. Is there any way of doing this?
Thanks> I want to run a batch file containg osql commands but do not want the user
> to be able to see the sa password. Is there any way of doing this?
Use trusted connection (-E parameter) instead of sql login/password.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com|||Thanks
"Dejan Sarka" wrote:
> > I want to run a batch file containg osql commands but do not want the user
> > to be able to see the sa password. Is there any way of doing this?
> Use trusted connection (-E parameter) instead of sql login/password.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
>
>

osql batch

Hi
I want to run a batch file containg osql commands but do not want the user
to be able to see the sa password. Is there any way of doing this?
Thanks
> I want to run a batch file containg osql commands but do not want the user
> to be able to see the sa password. Is there any way of doing this?
Use trusted connection (-E parameter) instead of sql login/password.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
|||Thanks
"Dejan Sarka" wrote:

> Use trusted connection (-E parameter) instead of sql login/password.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
>
>

osql batch

Hi
I want to run a batch file containg osql commands but do not want the user
to be able to see the sa password. Is there any way of doing this?
Thanks> I want to run a batch file containg osql commands but do not want the user
> to be able to see the sa password. Is there any way of doing this?
Use trusted connection (-E parameter) instead of sql login/password.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com|||Thanks
"Dejan Sarka" wrote:

> Use trusted connection (-E parameter) instead of sql login/password.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
>
>

osql

I tried to issue this utitlity with T-SQL in my machine, but it asked me the
system administrator's password, how do I know this password at my local SQL
Server ?Alan wrote:
> I tried to issue this utitlity with T-SQL in my machine, but it asked
> me the system administrator's password, how do I know this password
> at my local SQL Server ?
Specify your loing credentials when you call osql. See BOL for more
information.
--
David Gugick
Imceda Software
www.imceda.com|||Alan
You may be able to use the -E switch to connect using a trusted connection.
ie. OSQL -Sservername -E
For a full list of OSQL switches refer to the osql Utility in SQL Server
Books on Line or run OSQL /? from the command line.
--
--
Peter Ward
WARDY IT Solutions
--
"Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
news:Od7KzB6yEHA.2016@.TK2MSFTNGP15.phx.gbl...
> I tried to issue this utitlity with T-SQL in my machine, but it asked me
the
> system administrator's password, how do I know this password at my local
SQL
> Server ?
>|||YOu may also use a standard SQL login like
osql -SServername -UyourSQLlogin -PPassword
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"P. Ward" <peter@.online.wardyit.com> wrote in message
news:%23aB1XQ9yEHA.2192@.TK2MSFTNGP14.phx.gbl...
> Alan
> You may be able to use the -E switch to connect using a trusted
connection.
> ie. OSQL -Sservername -E
> For a full list of OSQL switches refer to the osql Utility in SQL Server
> Books on Line or run OSQL /? from the command line.
> --
> --
> Peter Ward
> WARDY IT Solutions
> --
> "Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
> news:Od7KzB6yEHA.2016@.TK2MSFTNGP15.phx.gbl...
> > I tried to issue this utitlity with T-SQL in my machine, but it asked me
> the
> > system administrator's password, how do I know this password at my local
> SQL
> > Server ?
> >
> >
>

osql

I tried to issue this utitlity with T-SQL in my machine, but it asked me the
system administrator's password, how do I know this password at my local SQL
Server ?
Alan wrote:
> I tried to issue this utitlity with T-SQL in my machine, but it asked
> me the system administrator's password, how do I know this password
> at my local SQL Server ?
Specify your loing credentials when you call osql. See BOL for more
information.
David Gugick
Imceda Software
www.imceda.com
|||Alan
You may be able to use the -E switch to connect using a trusted connection.
ie. OSQL -Sservername -E
For a full list of OSQL switches refer to the osql Utility in SQL Server
Books on Line or run OSQL /? from the command line.
--
Peter Ward
WARDY IT Solutions
"Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
news:Od7KzB6yEHA.2016@.TK2MSFTNGP15.phx.gbl...
> I tried to issue this utitlity with T-SQL in my machine, but it asked me
the
> system administrator's password, how do I know this password at my local
SQL
> Server ?
>
|||YOu may also use a standard SQL login like
osql -SServername -UyourSQLlogin -PPassword
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"P. Ward" <peter@.online.wardyit.com> wrote in message
news:%23aB1XQ9yEHA.2192@.TK2MSFTNGP14.phx.gbl...
> Alan
> You may be able to use the -E switch to connect using a trusted
connection.
> ie. OSQL -Sservername -E
> For a full list of OSQL switches refer to the osql Utility in SQL Server
> Books on Line or run OSQL /? from the command line.
> --
> --
> Peter Ward
> WARDY IT Solutions
> --
> "Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
> news:Od7KzB6yEHA.2016@.TK2MSFTNGP15.phx.gbl...
> the
> SQL
>

osql

I tried to issue this utitlity with T-SQL in my machine, but it asked me the
system administrator's password, how do I know this password at my local SQL
Server ?Alan wrote:
> I tried to issue this utitlity with T-SQL in my machine, but it asked
> me the system administrator's password, how do I know this password
> at my local SQL Server ?
Specify your loing credentials when you call osql. See BOL for more
information.
David Gugick
Imceda Software
www.imceda.com|||Alan
You may be able to use the -E switch to connect using a trusted connection.
ie. OSQL -Sservername -E
For a full list of OSQL switches refer to the osql Utility in SQL Server
Books on Line or run OSQL /? from the command line.
--
Peter Ward
WARDY IT Solutions
--
"Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
news:Od7KzB6yEHA.2016@.TK2MSFTNGP15.phx.gbl...
> I tried to issue this utitlity with T-SQL in my machine, but it asked me
the
> system administrator's password, how do I know this password at my local
SQL
> Server ?
>|||YOu may also use a standard SQL login like
osql -SServername -UyourSQLlogin -PPassword
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"P. Ward" <peter@.online.wardyit.com> wrote in message
news:%23aB1XQ9yEHA.2192@.TK2MSFTNGP14.phx.gbl...
> Alan
> You may be able to use the -E switch to connect using a trusted
connection.
> ie. OSQL -Sservername -E
> For a full list of OSQL switches refer to the osql Utility in SQL Server
> Books on Line or run OSQL /? from the command line.
> --
> --
> Peter Ward
> WARDY IT Solutions
> --
> "Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
> news:Od7KzB6yEHA.2016@.TK2MSFTNGP15.phx.gbl...
> the
> SQL
>