When trying to start SQL 2000 from dos prompt.
I changed the start up locations -D -L -E for my server from EM
server properties, Moved the Data and log files (MDF and LDFs), then tried
to
restart the server and it failed. I duplicated all files to their original
locations,
and again tried to restart from command-line with -d -l but nothing works...
When I changed the Server Properties I used capital D, and when I try to
start
SQL from DOS I get "Invalid command option D."
Please help me !! what Have I done to myself
Does anyone have any idea what I need to do to get this server backup'
Thanks!!WANNABE wrote:
> When trying to start SQL 2000 from dos prompt.
> I changed the start up locations -D -L -E for my server from EM
> server properties, Moved the Data and log files (MDF and LDFs), then tried
> to
> restart the server and it failed. I duplicated all files to their original
> locations,
> and again tried to restart from command-line with -d -l but nothing works...
> When I changed the Server Properties I used capital D, and when I try to
> start
> SQL from DOS I get "Invalid command option D."
> Please help me !! what Have I done to myself
> Does anyone have any idea what I need to do to get this server backup'
> Thanks!!
>
What is the EXACT command, including switches, that you are running from
the DOS prompt?
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||You need to put back the model database to where it used to be. The reference to the model database
is *inside* master.mdf. SQL Server cannot start without model since it cannot create tempdb, and SQL
Server cannot live without tempdb. You probably want to do the same for msdb, and other user
database, but those will not prohibit SQL Server from starting. You really should read KB 224071
first... :-)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"WANNABE" <breichenbach AT istate DOT com> wrote in message
news:O%23ITWuKvGHA.4460@.TK2MSFTNGP04.phx.gbl...
> When trying to start SQL 2000 from dos prompt.
> I changed the start up locations -D -L -E for my server from EM
> server properties, Moved the Data and log files (MDF and LDFs), then tried to
> restart the server and it failed. I duplicated all files to their original locations,
> and again tried to restart from command-line with -d -l but nothing works...
> When I changed the Server Properties I used capital D, and when I try to start
> SQL from DOS I get "Invalid command option D."
> Please help me !! what Have I done to myself
> Does anyone have any idea what I need to do to get this server backup'
> Thanks!!
>|||Thanks, but I do have all dbs in both places, and it still wont start. I
try "sqlservr" and it returns the "Invalid command option D."
error
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23FpPvYLvGHA.428@.TK2MSFTNGP03.phx.gbl...
> You need to put back the model database to where it used to be. The
> reference to the model database is *inside* master.mdf. SQL Server cannot
> start without model since it cannot create tempdb, and SQL Server cannot
> live without tempdb. You probably want to do the same for msdb, and other
> user database, but those will not prohibit SQL Server from starting. You
> really should read KB 224071 first... :-)
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "WANNABE" <breichenbach AT istate DOT com> wrote in message
> news:O%23ITWuKvGHA.4460@.TK2MSFTNGP04.phx.gbl...
>> When trying to start SQL 2000 from dos prompt.
>> I changed the start up locations -D -L -E for my server from EM
>> server properties, Moved the Data and log files (MDF and LDFs), then
>> tried to
>> restart the server and it failed. I duplicated all files to their
>> original locations,
>> and again tried to restart from command-line with -d -l but nothing
>> works...
>> When I changed the Server Properties I used capital D, and when I try to
>> start
>> SQL from DOS I get "Invalid command option D."
>> Please help me !! what Have I done to myself
>> Does anyone have any idea what I need to do to get this server backup'
>> Thanks!!
>|||Can you post what you try to execute in the command prompt? Also, the switches to SQL Server
programs are case sensitive.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"WANNABE" <breichenbach AT istate DOT com> wrote in message
news:e%23rPBuLvGHA.4460@.TK2MSFTNGP05.phx.gbl...
> Thanks, but I do have all dbs in both places, and it still wont start. I try "sqlservr" and it
> returns the "Invalid command option D."
> error
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:%23FpPvYLvGHA.428@.TK2MSFTNGP03.phx.gbl...
>> You need to put back the model database to where it used to be. The reference to the model
>> database is *inside* master.mdf. SQL Server cannot start without model since it cannot create
>> tempdb, and SQL Server cannot live without tempdb. You probably want to do the same for msdb, and
>> other user database, but those will not prohibit SQL Server from starting. You really should read
>> KB 224071 first... :-)
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "WANNABE" <breichenbach AT istate DOT com> wrote in message
>> news:O%23ITWuKvGHA.4460@.TK2MSFTNGP04.phx.gbl...
>> When trying to start SQL 2000 from dos prompt.
>> I changed the start up locations -D -L -E for my server from EM
>> server properties, Moved the Data and log files (MDF and LDFs), then tried to
>> restart the server and it failed. I duplicated all files to their original locations,
>> and again tried to restart from command-line with -d -l but nothing works...
>> When I changed the Server Properties I used capital D, and when I try to start
>> SQL from DOS I get "Invalid command option D."
>> Please help me !! what Have I done to myself
>> Does anyone have any idea what I need to do to get this server backup'
>> Thanks!!
>>
>|||I will be gone until next Tuesday.. I'll repost this if I still need help..
All I enter from the command line prompt is
sqlservr
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23dIFp4LvGHA.324@.TK2MSFTNGP06.phx.gbl...
> Can you post what you try to execute in the command prompt? Also, the
> switches to SQL Server programs are case sensitive.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "WANNABE" <breichenbach AT istate DOT com> wrote in message
> news:e%23rPBuLvGHA.4460@.TK2MSFTNGP05.phx.gbl...
>> Thanks, but I do have all dbs in both places, and it still wont start. I
>> try "sqlservr" and it returns the "Invalid command option D."
>> error
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
>> in message news:%23FpPvYLvGHA.428@.TK2MSFTNGP03.phx.gbl...
>> You need to put back the model database to where it used to be. The
>> reference to the model database is *inside* master.mdf. SQL Server
>> cannot start without model since it cannot create tempdb, and SQL Server
>> cannot live without tempdb. You probably want to do the same for msdb,
>> and other user database, but those will not prohibit SQL Server from
>> starting. You really should read KB 224071 first... :-)
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "WANNABE" <breichenbach AT istate DOT com> wrote in message
>> news:O%23ITWuKvGHA.4460@.TK2MSFTNGP04.phx.gbl...
>> When trying to start SQL 2000 from dos prompt.
>> I changed the start up locations -D -L -E for my server from EM
>> server properties, Moved the Data and log files (MDF and LDFs), then
>> tried to
>> restart the server and it failed. I duplicated all files to their
>> original locations,
>> and again tried to restart from command-line with -d -l but nothing
>> works...
>> When I changed the Server Properties I used capital D, and when I try
>> to start
>> SQL from DOS I get "Invalid command option D."
>> Please help me !! what Have I done to myself
>> Does anyone have any idea what I need to do to get this server backup'
>> Thanks!!
>>
>>
>|||If you only run sqlservr from command line, then the parameters are picked up from the registry. I
suggest you edit the registry to put in the right case, d instead of D.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"WANNABE" <breichenbach AT istate DOT com> wrote in message
news:OspGsOMvGHA.4436@.TK2MSFTNGP05.phx.gbl...
>I will be gone until next Tuesday.. I'll repost this if I still need help..
> All I enter from the command line prompt is
> sqlservr
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:%23dIFp4LvGHA.324@.TK2MSFTNGP06.phx.gbl...
>> Can you post what you try to execute in the command prompt? Also, the switches to SQL Server
>> programs are case sensitive.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "WANNABE" <breichenbach AT istate DOT com> wrote in message
>> news:e%23rPBuLvGHA.4460@.TK2MSFTNGP05.phx.gbl...
>> Thanks, but I do have all dbs in both places, and it still wont start. I try "sqlservr" and it
>> returns the "Invalid command option D."
>> error
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
>> news:%23FpPvYLvGHA.428@.TK2MSFTNGP03.phx.gbl...
>> You need to put back the model database to where it used to be. The reference to the model
>> database is *inside* master.mdf. SQL Server cannot start without model since it cannot create
>> tempdb, and SQL Server cannot live without tempdb. You probably want to do the same for msdb,
>> and other user database, but those will not prohibit SQL Server from starting. You really
>> should read KB 224071 first... :-)
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "WANNABE" <breichenbach AT istate DOT com> wrote in message
>> news:O%23ITWuKvGHA.4460@.TK2MSFTNGP04.phx.gbl...
>> When trying to start SQL 2000 from dos prompt.
>> I changed the start up locations -D -L -E for my server from EM
>> server properties, Moved the Data and log files (MDF and LDFs), then tried to
>> restart the server and it failed. I duplicated all files to their original locations,
>> and again tried to restart from command-line with -d -l but nothing works...
>> When I changed the Server Properties I used capital D, and when I try to start
>> SQL from DOS I get "Invalid command option D."
>> Please help me !! what Have I done to myself
>> Does anyone have any idea what I need to do to get this server backup'
>> Thanks!!
>>
>>
>
Showing posts with label prompt. Show all posts
Showing posts with label prompt. Show all posts
Sunday, February 19, 2012
"Invalid command option D."
When trying to start SQL 2000 from dos prompt.
I changed the start up locations -D -L -E for my server from EM
server properties, Moved the Data and log files (MDF and LDFs), then tried
to
restart the server and it failed. I duplicated all files to their original
locations,
and again tried to restart from command-line with -d -l but nothing works...
When I changed the Server Properties I used capital D, and when I try to
start
SQL from DOS I get "Invalid command option D."
Please help me !! what Have I done to myself
Does anyone have any idea what I need to do to get this server backup'
Thanks!!WANNABE wrote:
> When trying to start SQL 2000 from dos prompt.
> I changed the start up locations -D -L -E for my server from EM
> server properties, Moved the Data and log files (MDF and LDFs), then tried
> to
> restart the server and it failed. I duplicated all files to their origina
l
> locations,
> and again tried to restart from command-line with -d -l but nothing works.
.
> When I changed the Server Properties I used capital D, and when I try to
> start
> SQL from DOS I get "Invalid command option D."
> Please help me !! what Have I done to myself
> Does anyone have any idea what I need to do to get this server backup'
> Thanks!!
>
What is the EXACT command, including switches, that you are running from
the DOS prompt?
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||You need to put back the model database to where it used to be. The referenc
e to the model database
is *inside* master.mdf. SQL Server cannot start without model since it canno
t create tempdb, and SQL
Server cannot live without tempdb. You probably want to do the same for msdb
, and other user
database, but those will not prohibit SQL Server from starting. You really s
hould read KB 224071
first... :-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"WANNABE" <breichenbach AT istate DOT com> wrote in message
news:O%23ITWuKvGHA.4460@.TK2MSFTNGP04.phx.gbl...
> When trying to start SQL 2000 from dos prompt.
> I changed the start up locations -D -L -E for my server from EM
> server properties, Moved the Data and log files (MDF and LDFs), then tried
to
> restart the server and it failed. I duplicated all files to their origina
l locations,
> and again tried to restart from command-line with -d -l but nothing works.
.
> When I changed the Server Properties I used capital D, and when I try to s
tart
> SQL from DOS I get "Invalid command option D."
> Please help me !! what Have I done to myself
> Does anyone have any idea what I need to do to get this server backup'
> Thanks!!
>|||Thanks, but I do have all dbs in both places, and it still wont start. I
try "sqlservr" and it returns the "Invalid command option D."
error
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23FpPvYLvGHA.428@.TK2MSFTNGP03.phx.gbl...
> You need to put back the model database to where it used to be. The
> reference to the model database is *inside* master.mdf. SQL Server cannot
> start without model since it cannot create tempdb, and SQL Server cannot
> live without tempdb. You probably want to do the same for msdb, and other
> user database, but those will not prohibit SQL Server from starting. You
> really should read KB 224071 first... :-)
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "WANNABE" <breichenbach AT istate DOT com> wrote in message
> news:O%23ITWuKvGHA.4460@.TK2MSFTNGP04.phx.gbl...
>|||Can you post what you try to execute in the command prompt? Also, the switch
es to SQL Server
programs are case sensitive.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"WANNABE" <breichenbach AT istate DOT com> wrote in message
news:e%23rPBuLvGHA.4460@.TK2MSFTNGP05.phx.gbl...
> Thanks, but I do have all dbs in both places, and it still wont start. I
try "sqlservr" and it
> returns the "Invalid command option D."
> error
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n message
> news:%23FpPvYLvGHA.428@.TK2MSFTNGP03.phx.gbl...
>|||I will be gone until next Tuesday.. I'll repost this if I still need help..
All I enter from the command line prompt is
sqlservr
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23dIFp4LvGHA.324@.TK2MSFTNGP06.phx.gbl...
> Can you post what you try to execute in the command prompt? Also, the
> switches to SQL Server programs are case sensitive.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "WANNABE" <breichenbach AT istate DOT com> wrote in message
> news:e%23rPBuLvGHA.4460@.TK2MSFTNGP05.phx.gbl...
>|||If you only run sqlservr from command line, then the parameters are picked u
p from the registry. I
suggest you edit the registry to put in the right case, d instead of D.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"WANNABE" <breichenbach AT istate DOT com> wrote in message
news:OspGsOMvGHA.4436@.TK2MSFTNGP05.phx.gbl...
>I will be gone until next Tuesday.. I'll repost this if I still need help.
.
> All I enter from the command line prompt is
> sqlservr
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n message
> news:%23dIFp4LvGHA.324@.TK2MSFTNGP06.phx.gbl...
>
I changed the start up locations -D -L -E for my server from EM
server properties, Moved the Data and log files (MDF and LDFs), then tried
to
restart the server and it failed. I duplicated all files to their original
locations,
and again tried to restart from command-line with -d -l but nothing works...
When I changed the Server Properties I used capital D, and when I try to
start
SQL from DOS I get "Invalid command option D."
Please help me !! what Have I done to myself
Does anyone have any idea what I need to do to get this server backup'
Thanks!!WANNABE wrote:
> When trying to start SQL 2000 from dos prompt.
> I changed the start up locations -D -L -E for my server from EM
> server properties, Moved the Data and log files (MDF and LDFs), then tried
> to
> restart the server and it failed. I duplicated all files to their origina
l
> locations,
> and again tried to restart from command-line with -d -l but nothing works.
.
> When I changed the Server Properties I used capital D, and when I try to
> start
> SQL from DOS I get "Invalid command option D."
> Please help me !! what Have I done to myself
> Does anyone have any idea what I need to do to get this server backup'
> Thanks!!
>
What is the EXACT command, including switches, that you are running from
the DOS prompt?
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||You need to put back the model database to where it used to be. The referenc
e to the model database
is *inside* master.mdf. SQL Server cannot start without model since it canno
t create tempdb, and SQL
Server cannot live without tempdb. You probably want to do the same for msdb
, and other user
database, but those will not prohibit SQL Server from starting. You really s
hould read KB 224071
first... :-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"WANNABE" <breichenbach AT istate DOT com> wrote in message
news:O%23ITWuKvGHA.4460@.TK2MSFTNGP04.phx.gbl...
> When trying to start SQL 2000 from dos prompt.
> I changed the start up locations -D -L -E for my server from EM
> server properties, Moved the Data and log files (MDF and LDFs), then tried
to
> restart the server and it failed. I duplicated all files to their origina
l locations,
> and again tried to restart from command-line with -d -l but nothing works.
.
> When I changed the Server Properties I used capital D, and when I try to s
tart
> SQL from DOS I get "Invalid command option D."
> Please help me !! what Have I done to myself
> Does anyone have any idea what I need to do to get this server backup'
> Thanks!!
>|||Thanks, but I do have all dbs in both places, and it still wont start. I
try "sqlservr" and it returns the "Invalid command option D."
error
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23FpPvYLvGHA.428@.TK2MSFTNGP03.phx.gbl...
> You need to put back the model database to where it used to be. The
> reference to the model database is *inside* master.mdf. SQL Server cannot
> start without model since it cannot create tempdb, and SQL Server cannot
> live without tempdb. You probably want to do the same for msdb, and other
> user database, but those will not prohibit SQL Server from starting. You
> really should read KB 224071 first... :-)
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "WANNABE" <breichenbach AT istate DOT com> wrote in message
> news:O%23ITWuKvGHA.4460@.TK2MSFTNGP04.phx.gbl...
>|||Can you post what you try to execute in the command prompt? Also, the switch
es to SQL Server
programs are case sensitive.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"WANNABE" <breichenbach AT istate DOT com> wrote in message
news:e%23rPBuLvGHA.4460@.TK2MSFTNGP05.phx.gbl...
> Thanks, but I do have all dbs in both places, and it still wont start. I
try "sqlservr" and it
> returns the "Invalid command option D."
> error
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n message
> news:%23FpPvYLvGHA.428@.TK2MSFTNGP03.phx.gbl...
>|||I will be gone until next Tuesday.. I'll repost this if I still need help..
All I enter from the command line prompt is
sqlservr
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23dIFp4LvGHA.324@.TK2MSFTNGP06.phx.gbl...
> Can you post what you try to execute in the command prompt? Also, the
> switches to SQL Server programs are case sensitive.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "WANNABE" <breichenbach AT istate DOT com> wrote in message
> news:e%23rPBuLvGHA.4460@.TK2MSFTNGP05.phx.gbl...
>|||If you only run sqlservr from command line, then the parameters are picked u
p from the registry. I
suggest you edit the registry to put in the right case, d instead of D.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"WANNABE" <breichenbach AT istate DOT com> wrote in message
news:OspGsOMvGHA.4436@.TK2MSFTNGP05.phx.gbl...
>I will be gone until next Tuesday.. I'll repost this if I still need help.
.
> All I enter from the command line prompt is
> sqlservr
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n message
> news:%23dIFp4LvGHA.324@.TK2MSFTNGP06.phx.gbl...
>
Saturday, February 11, 2012
"confirm password" prompt after importing database
I'm running SQL Server 2000 on a Windows 2003 Server with the latest
SQL SP and hotfixes applied.
Today, I made a mistake while importing a new database into my SQL
Server. When choosing my options in the DTS wizard, I forgot to uncheck
the "Copy database users and database roles" and "copy object level
permissions" boxes under the Security options.
After running the import, whenever I try to edit any SQL user from a
remote client running Enterprise Manager, I am always prompted to
"confirm password." I cannot simply type in the password in that box
though, I have to actually type the password into the main user
properties window, then type it again to confirm the password. After
doing both, the changes are saved.
This ONLY happens from a remote Enterprise Manager client though. If I
use EM on the local server, I'm not prompted to confirm the password
when I edit users.
Can anyone provide some guidance on how I can fix this?
Thanks!
JasonThis can occur after appying MS03-031: Cumulative Security Patch for SQL
Server to the client running EM
FIX: You are prompted for password confirmation after you change a standard
SQL Server login
http://support.microsoft.com/?kbid=826161
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
"Jason S." <jasolution@.yahoo.com> wrote in message
news:1109789594.428951.221670@.g14g2000cwa.googlegroups.com...
> I'm running SQL Server 2000 on a Windows 2003 Server with the latest
> SQL SP and hotfixes applied.
> Today, I made a mistake while importing a new database into my SQL
> Server. When choosing my options in the DTS wizard, I forgot to uncheck
> the "Copy database users and database roles" and "copy object level
> permissions" boxes under the Security options.
> After running the import, whenever I try to edit any SQL user from a
> remote client running Enterprise Manager, I am always prompted to
> "confirm password." I cannot simply type in the password in that box
> though, I have to actually type the password into the main user
> properties window, then type it again to confirm the password. After
> doing both, the changes are saved.
> This ONLY happens from a remote Enterprise Manager client though. If I
> use EM on the local server, I'm not prompted to confirm the password
> when I edit users.
> Can anyone provide some guidance on how I can fix this?
> Thanks!
> Jason
>|||Jasper,
Thank you for taking time to respond.
I had found that posting, but I'd already patched the server with that
hotfix quite awhile ago, and the symptoms are not quite the same here.
With my issue, I am able to save the changes I made to the user, but it
just requires me to enter the password and confirm it every time I make
any change to a user. Also, this issue only occurs when I using
Enterprise Manager from a remote machine, but if I edit the users using
EM on the local machine, I do not get prompted to confirm the password.
Any other thoughts?
Thanks,
Jason|||The hotfix is for the client as well as the server (like you say it's
confined to the client and doesn't occur on the server). You need to run the
hotfix from the KB on the client.
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
"Jason S." <jasolution@.yahoo.com> wrote in message
news:1109790531.728123.199310@.f14g2000cwb.googlegroups.com...
> Jasper,
> Thank you for taking time to respond.
> I had found that posting, but I'd already patched the server with that
> hotfix quite awhile ago, and the symptoms are not quite the same here.
> With my issue, I am able to save the changes I made to the user, but it
> just requires me to enter the password and confirm it every time I make
> any change to a user. Also, this issue only occurs when I using
> Enterprise Manager from a remote machine, but if I edit the users using
> EM on the local machine, I do not get prompted to confirm the password.
> Any other thoughts?
> Thanks,
> Jason
>|||Jasper,
Thanks, that was it. I didn't realize that it was a patch for client EM
also.
Thanks again!
Jason
SQL SP and hotfixes applied.
Today, I made a mistake while importing a new database into my SQL
Server. When choosing my options in the DTS wizard, I forgot to uncheck
the "Copy database users and database roles" and "copy object level
permissions" boxes under the Security options.
After running the import, whenever I try to edit any SQL user from a
remote client running Enterprise Manager, I am always prompted to
"confirm password." I cannot simply type in the password in that box
though, I have to actually type the password into the main user
properties window, then type it again to confirm the password. After
doing both, the changes are saved.
This ONLY happens from a remote Enterprise Manager client though. If I
use EM on the local server, I'm not prompted to confirm the password
when I edit users.
Can anyone provide some guidance on how I can fix this?
Thanks!
JasonThis can occur after appying MS03-031: Cumulative Security Patch for SQL
Server to the client running EM
FIX: You are prompted for password confirmation after you change a standard
SQL Server login
http://support.microsoft.com/?kbid=826161
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
"Jason S." <jasolution@.yahoo.com> wrote in message
news:1109789594.428951.221670@.g14g2000cwa.googlegroups.com...
> I'm running SQL Server 2000 on a Windows 2003 Server with the latest
> SQL SP and hotfixes applied.
> Today, I made a mistake while importing a new database into my SQL
> Server. When choosing my options in the DTS wizard, I forgot to uncheck
> the "Copy database users and database roles" and "copy object level
> permissions" boxes under the Security options.
> After running the import, whenever I try to edit any SQL user from a
> remote client running Enterprise Manager, I am always prompted to
> "confirm password." I cannot simply type in the password in that box
> though, I have to actually type the password into the main user
> properties window, then type it again to confirm the password. After
> doing both, the changes are saved.
> This ONLY happens from a remote Enterprise Manager client though. If I
> use EM on the local server, I'm not prompted to confirm the password
> when I edit users.
> Can anyone provide some guidance on how I can fix this?
> Thanks!
> Jason
>|||Jasper,
Thank you for taking time to respond.
I had found that posting, but I'd already patched the server with that
hotfix quite awhile ago, and the symptoms are not quite the same here.
With my issue, I am able to save the changes I made to the user, but it
just requires me to enter the password and confirm it every time I make
any change to a user. Also, this issue only occurs when I using
Enterprise Manager from a remote machine, but if I edit the users using
EM on the local machine, I do not get prompted to confirm the password.
Any other thoughts?
Thanks,
Jason|||The hotfix is for the client as well as the server (like you say it's
confined to the client and doesn't occur on the server). You need to run the
hotfix from the KB on the client.
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
"Jason S." <jasolution@.yahoo.com> wrote in message
news:1109790531.728123.199310@.f14g2000cwb.googlegroups.com...
> Jasper,
> Thank you for taking time to respond.
> I had found that posting, but I'd already patched the server with that
> hotfix quite awhile ago, and the symptoms are not quite the same here.
> With my issue, I am able to save the changes I made to the user, but it
> just requires me to enter the password and confirm it every time I make
> any change to a user. Also, this issue only occurs when I using
> Enterprise Manager from a remote machine, but if I edit the users using
> EM on the local machine, I do not get prompted to confirm the password.
> Any other thoughts?
> Thanks,
> Jason
>|||Jasper,
Thanks, that was it. I didn't realize that it was a patch for client EM
also.
Thanks again!
Jason
"confirm password" prompt after importing database
I'm running SQL Server 2000 on a Windows 2003 Server with the latest
SQL SP and hotfixes applied.
Today, I made a mistake while importing a new database into my SQL
Server. When choosing my options in the DTS wizard, I forgot to uncheck
the "Copy database users and database roles" and "copy object level
permissions" boxes under the Security options.
After running the import, whenever I try to edit any SQL user from a
remote client running Enterprise Manager, I am always prompted to
"confirm password." I cannot simply type in the password in that box
though, I have to actually type the password into the main user
properties window, then type it again to confirm the password. After
doing both, the changes are saved.
This ONLY happens from a remote Enterprise Manager client though. If I
use EM on the local server, I'm not prompted to confirm the password
when I edit users.
Can anyone provide some guidance on how I can fix this?
Thanks!
JasonThis can occur after appying MS03-031: Cumulative Security Patch for SQL
Server to the client running EM
FIX: You are prompted for password confirmation after you change a standard
SQL Server login
http://support.microsoft.com/?kbid=826161
--
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
"Jason S." <jasolution@.yahoo.com> wrote in message
news:1109789594.428951.221670@.g14g2000cwa.googlegroups.com...
> I'm running SQL Server 2000 on a Windows 2003 Server with the latest
> SQL SP and hotfixes applied.
> Today, I made a mistake while importing a new database into my SQL
> Server. When choosing my options in the DTS wizard, I forgot to uncheck
> the "Copy database users and database roles" and "copy object level
> permissions" boxes under the Security options.
> After running the import, whenever I try to edit any SQL user from a
> remote client running Enterprise Manager, I am always prompted to
> "confirm password." I cannot simply type in the password in that box
> though, I have to actually type the password into the main user
> properties window, then type it again to confirm the password. After
> doing both, the changes are saved.
> This ONLY happens from a remote Enterprise Manager client though. If I
> use EM on the local server, I'm not prompted to confirm the password
> when I edit users.
> Can anyone provide some guidance on how I can fix this?
> Thanks!
> Jason
>|||Jasper,
Thank you for taking time to respond.
I had found that posting, but I'd already patched the server with that
hotfix quite awhile ago, and the symptoms are not quite the same here.
With my issue, I am able to save the changes I made to the user, but it
just requires me to enter the password and confirm it every time I make
any change to a user. Also, this issue only occurs when I using
Enterprise Manager from a remote machine, but if I edit the users using
EM on the local machine, I do not get prompted to confirm the password.
Any other thoughts?
Thanks,
Jason|||The hotfix is for the client as well as the server (like you say it's
confined to the client and doesn't occur on the server). You need to run the
hotfix from the KB on the client.
--
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
"Jason S." <jasolution@.yahoo.com> wrote in message
news:1109790531.728123.199310@.f14g2000cwb.googlegroups.com...
> Jasper,
> Thank you for taking time to respond.
> I had found that posting, but I'd already patched the server with that
> hotfix quite awhile ago, and the symptoms are not quite the same here.
> With my issue, I am able to save the changes I made to the user, but it
> just requires me to enter the password and confirm it every time I make
> any change to a user. Also, this issue only occurs when I using
> Enterprise Manager from a remote machine, but if I edit the users using
> EM on the local machine, I do not get prompted to confirm the password.
> Any other thoughts?
> Thanks,
> Jason
>|||Jasper,
Thanks, that was it. I didn't realize that it was a patch for client EM
also.
Thanks again!
Jason
SQL SP and hotfixes applied.
Today, I made a mistake while importing a new database into my SQL
Server. When choosing my options in the DTS wizard, I forgot to uncheck
the "Copy database users and database roles" and "copy object level
permissions" boxes under the Security options.
After running the import, whenever I try to edit any SQL user from a
remote client running Enterprise Manager, I am always prompted to
"confirm password." I cannot simply type in the password in that box
though, I have to actually type the password into the main user
properties window, then type it again to confirm the password. After
doing both, the changes are saved.
This ONLY happens from a remote Enterprise Manager client though. If I
use EM on the local server, I'm not prompted to confirm the password
when I edit users.
Can anyone provide some guidance on how I can fix this?
Thanks!
JasonThis can occur after appying MS03-031: Cumulative Security Patch for SQL
Server to the client running EM
FIX: You are prompted for password confirmation after you change a standard
SQL Server login
http://support.microsoft.com/?kbid=826161
--
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
"Jason S." <jasolution@.yahoo.com> wrote in message
news:1109789594.428951.221670@.g14g2000cwa.googlegroups.com...
> I'm running SQL Server 2000 on a Windows 2003 Server with the latest
> SQL SP and hotfixes applied.
> Today, I made a mistake while importing a new database into my SQL
> Server. When choosing my options in the DTS wizard, I forgot to uncheck
> the "Copy database users and database roles" and "copy object level
> permissions" boxes under the Security options.
> After running the import, whenever I try to edit any SQL user from a
> remote client running Enterprise Manager, I am always prompted to
> "confirm password." I cannot simply type in the password in that box
> though, I have to actually type the password into the main user
> properties window, then type it again to confirm the password. After
> doing both, the changes are saved.
> This ONLY happens from a remote Enterprise Manager client though. If I
> use EM on the local server, I'm not prompted to confirm the password
> when I edit users.
> Can anyone provide some guidance on how I can fix this?
> Thanks!
> Jason
>|||Jasper,
Thank you for taking time to respond.
I had found that posting, but I'd already patched the server with that
hotfix quite awhile ago, and the symptoms are not quite the same here.
With my issue, I am able to save the changes I made to the user, but it
just requires me to enter the password and confirm it every time I make
any change to a user. Also, this issue only occurs when I using
Enterprise Manager from a remote machine, but if I edit the users using
EM on the local machine, I do not get prompted to confirm the password.
Any other thoughts?
Thanks,
Jason|||The hotfix is for the client as well as the server (like you say it's
confined to the client and doesn't occur on the server). You need to run the
hotfix from the KB on the client.
--
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
"Jason S." <jasolution@.yahoo.com> wrote in message
news:1109790531.728123.199310@.f14g2000cwb.googlegroups.com...
> Jasper,
> Thank you for taking time to respond.
> I had found that posting, but I'd already patched the server with that
> hotfix quite awhile ago, and the symptoms are not quite the same here.
> With my issue, I am able to save the changes I made to the user, but it
> just requires me to enter the password and confirm it every time I make
> any change to a user. Also, this issue only occurs when I using
> Enterprise Manager from a remote machine, but if I edit the users using
> EM on the local machine, I do not get prompted to confirm the password.
> Any other thoughts?
> Thanks,
> Jason
>|||Jasper,
Thanks, that was it. I didn't realize that it was a patch for client EM
also.
Thanks again!
Jason
"confirm password" prompt after importing database
I'm running SQL Server 2000 on a Windows 2003 Server with the latest
SQL SP and hotfixes applied.
Today, I made a mistake while importing a new database into my SQL
Server. When choosing my options in the DTS wizard, I forgot to uncheck
the "Copy database users and database roles" and "copy object level
permissions" boxes under the Security options.
After running the import, whenever I try to edit any SQL user from a
remote client running Enterprise Manager, I am always prompted to
"confirm password." I cannot simply type in the password in that box
though, I have to actually type the password into the main user
properties window, then type it again to confirm the password. After
doing both, the changes are saved.
This ONLY happens from a remote Enterprise Manager client though. If I
use EM on the local server, I'm not prompted to confirm the password
when I edit users.
Can anyone provide some guidance on how I can fix this?
Thanks!
Jason
This can occur after appying MS03-031: Cumulative Security Patch for SQL
Server to the client running EM
FIX: You are prompted for password confirmation after you change a standard
SQL Server login
http://support.microsoft.com/?kbid=826161
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
"Jason S." <jasolution@.yahoo.com> wrote in message
news:1109789594.428951.221670@.g14g2000cwa.googlegr oups.com...
> I'm running SQL Server 2000 on a Windows 2003 Server with the latest
> SQL SP and hotfixes applied.
> Today, I made a mistake while importing a new database into my SQL
> Server. When choosing my options in the DTS wizard, I forgot to uncheck
> the "Copy database users and database roles" and "copy object level
> permissions" boxes under the Security options.
> After running the import, whenever I try to edit any SQL user from a
> remote client running Enterprise Manager, I am always prompted to
> "confirm password." I cannot simply type in the password in that box
> though, I have to actually type the password into the main user
> properties window, then type it again to confirm the password. After
> doing both, the changes are saved.
> This ONLY happens from a remote Enterprise Manager client though. If I
> use EM on the local server, I'm not prompted to confirm the password
> when I edit users.
> Can anyone provide some guidance on how I can fix this?
> Thanks!
> Jason
>
|||Jasper,
Thank you for taking time to respond.
I had found that posting, but I'd already patched the server with that
hotfix quite awhile ago, and the symptoms are not quite the same here.
With my issue, I am able to save the changes I made to the user, but it
just requires me to enter the password and confirm it every time I make
any change to a user. Also, this issue only occurs when I using
Enterprise Manager from a remote machine, but if I edit the users using
EM on the local machine, I do not get prompted to confirm the password.
Any other thoughts?
Thanks,
Jason
|||The hotfix is for the client as well as the server (like you say it's
confined to the client and doesn't occur on the server). You need to run the
hotfix from the KB on the client.
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
"Jason S." <jasolution@.yahoo.com> wrote in message
news:1109790531.728123.199310@.f14g2000cwb.googlegr oups.com...
> Jasper,
> Thank you for taking time to respond.
> I had found that posting, but I'd already patched the server with that
> hotfix quite awhile ago, and the symptoms are not quite the same here.
> With my issue, I am able to save the changes I made to the user, but it
> just requires me to enter the password and confirm it every time I make
> any change to a user. Also, this issue only occurs when I using
> Enterprise Manager from a remote machine, but if I edit the users using
> EM on the local machine, I do not get prompted to confirm the password.
> Any other thoughts?
> Thanks,
> Jason
>
|||Jasper,
Thanks, that was it. I didn't realize that it was a patch for client EM
also.
Thanks again!
Jason
SQL SP and hotfixes applied.
Today, I made a mistake while importing a new database into my SQL
Server. When choosing my options in the DTS wizard, I forgot to uncheck
the "Copy database users and database roles" and "copy object level
permissions" boxes under the Security options.
After running the import, whenever I try to edit any SQL user from a
remote client running Enterprise Manager, I am always prompted to
"confirm password." I cannot simply type in the password in that box
though, I have to actually type the password into the main user
properties window, then type it again to confirm the password. After
doing both, the changes are saved.
This ONLY happens from a remote Enterprise Manager client though. If I
use EM on the local server, I'm not prompted to confirm the password
when I edit users.
Can anyone provide some guidance on how I can fix this?
Thanks!
Jason
This can occur after appying MS03-031: Cumulative Security Patch for SQL
Server to the client running EM
FIX: You are prompted for password confirmation after you change a standard
SQL Server login
http://support.microsoft.com/?kbid=826161
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
"Jason S." <jasolution@.yahoo.com> wrote in message
news:1109789594.428951.221670@.g14g2000cwa.googlegr oups.com...
> I'm running SQL Server 2000 on a Windows 2003 Server with the latest
> SQL SP and hotfixes applied.
> Today, I made a mistake while importing a new database into my SQL
> Server. When choosing my options in the DTS wizard, I forgot to uncheck
> the "Copy database users and database roles" and "copy object level
> permissions" boxes under the Security options.
> After running the import, whenever I try to edit any SQL user from a
> remote client running Enterprise Manager, I am always prompted to
> "confirm password." I cannot simply type in the password in that box
> though, I have to actually type the password into the main user
> properties window, then type it again to confirm the password. After
> doing both, the changes are saved.
> This ONLY happens from a remote Enterprise Manager client though. If I
> use EM on the local server, I'm not prompted to confirm the password
> when I edit users.
> Can anyone provide some guidance on how I can fix this?
> Thanks!
> Jason
>
|||Jasper,
Thank you for taking time to respond.
I had found that posting, but I'd already patched the server with that
hotfix quite awhile ago, and the symptoms are not quite the same here.
With my issue, I am able to save the changes I made to the user, but it
just requires me to enter the password and confirm it every time I make
any change to a user. Also, this issue only occurs when I using
Enterprise Manager from a remote machine, but if I edit the users using
EM on the local machine, I do not get prompted to confirm the password.
Any other thoughts?
Thanks,
Jason
|||The hotfix is for the client as well as the server (like you say it's
confined to the client and doesn't occur on the server). You need to run the
hotfix from the KB on the client.
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
"Jason S." <jasolution@.yahoo.com> wrote in message
news:1109790531.728123.199310@.f14g2000cwb.googlegr oups.com...
> Jasper,
> Thank you for taking time to respond.
> I had found that posting, but I'd already patched the server with that
> hotfix quite awhile ago, and the symptoms are not quite the same here.
> With my issue, I am able to save the changes I made to the user, but it
> just requires me to enter the password and confirm it every time I make
> any change to a user. Also, this issue only occurs when I using
> Enterprise Manager from a remote machine, but if I edit the users using
> EM on the local machine, I do not get prompted to confirm the password.
> Any other thoughts?
> Thanks,
> Jason
>
|||Jasper,
Thanks, that was it. I didn't realize that it was a patch for client EM
also.
Thanks again!
Jason
Subscribe to:
Posts (Atom)
