How do I make a case sensitive query.
For e.g
Select * from myTable where Password='AaBb'
and
Select * from myTable where Password='aabb'
returns same records.
How do I make a case sensitive query so that 'AaBb' and 'aabb' are different(a) collate the column as case sensitive (see collate in books online, 2000
only)
(b) make the entire database case sensitive
(c) convert each side of the comparison to varbinary
"Arsalan" <arsalan_aslam@.hotmail.com> wrote in message
news:eWJg9y$aDHA.384@.TK2MSFTNGP12.phx.gbl...
> How do I make a case sensitive query.
> For e.g
> Select * from myTable where Password='AaBb'
> and
> Select * from myTable where Password='aabb'
> returns same records.
> How do I make a case sensitive query so that 'AaBb' and 'aabb' are
different
>
>sql
Showing posts with label password. Show all posts
Showing posts with label password. Show all posts
Sunday, March 25, 2012
Case sensitive Password check while logging into SQL Server
Hi,
Is there any way to check the password just to allow into the SQL Server
when it matches with the database password including Case.
My problem is I used a sqlserver connection string to login to my sql
server db. But it is allowing me, even though the user types the password in
any case.
Eg: If i have a password as "pwd" for user "Guest"
It is allowing to enter into the db even the user enters "PWD" or "Pwd"
in any way as the password.
I tried even with Query Analyzer. In that also it is not checking the
password for case sensitive. Is there any way to check the password with
case sensitive. I think the sql server internally should check with case
sensitive for a password.
Please help me.
VenkatSee if this helps:
http://vyaskn.tripod.com/case_sensi..._sql_server.htm
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Venkat" <tammana@.inooga.com> wrote in message
news:%23OjVfCUjFHA.3544@.TK2MSFTNGP15.phx.gbl...
> Hi,
> Is there any way to check the password just to allow into the SQL
> Server when it matches with the database password including Case.
> My problem is I used a sqlserver connection string to login to my sql
> server db. But it is allowing me, even though the user types the password
> in any case.
> Eg: If i have a password as "pwd" for user "Guest"
> It is allowing to enter into the db even the user enters "PWD" or "Pwd"
> in any way as the password.
> I tried even with Query Analyzer. In that also it is not checking the
> password for case sensitive. Is there any way to check the password with
> case sensitive. I think the sql server internally should check with case
> sensitive for a password.
> Please help me.
> --
> Venkat
>|||Thanks for your link. But my problem has not been solved.
My problem is why the sql server is checking for a case sensitive
information while logging into the sql server. I am not maintaining any user
tables for passwords. I am just talking about the SQL Server Login using
Query Analyzer.
While logging into the Query Analyzer the password is not validated
using case sensitive. Instead the password is checked using Case-insensitive
mode. It is allowing the user even he typed a mixed case password for a
login which is created using a small case password while creating a user
account.
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:%23s6eofVjFHA.3064@.TK2MSFTNGP15.phx.gbl...
> See if this helps:
> http://vyaskn.tripod.com/case_sensi..._sql_server.htm
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
> "Venkat" <tammana@.inooga.com> wrote in message
> news:%23OjVfCUjFHA.3544@.TK2MSFTNGP15.phx.gbl...
>|||Case-sensitivity for SQL Server login passwords is determined by your
instance default collation. It seems you are using an instance with a
case-insensitive collation.
Hope this helps.
Dan Guzman
SQL Server MVP
"Venkat" <tammana@.inooga.com> wrote in message
news:%232NfH6bjFHA.2852@.TK2MSFTNGP15.phx.gbl...
> Thanks for your link. But my problem has not been solved.
> My problem is why the sql server is checking for a case sensitive
> information while logging into the sql server. I am not maintaining any
> user tables for passwords. I am just talking about the SQL Server Login
> using Query Analyzer.
> While logging into the Query Analyzer the password is not validated
> using case sensitive. Instead the password is checked using
> Case-insensitive mode. It is allowing the user even he typed a mixed case
> password for a login which is created using a small case password while
> creating a user account.
>
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:%23s6eofVjFHA.3064@.TK2MSFTNGP15.phx.gbl...
>
Is there any way to check the password just to allow into the SQL Server
when it matches with the database password including Case.
My problem is I used a sqlserver connection string to login to my sql
server db. But it is allowing me, even though the user types the password in
any case.
Eg: If i have a password as "pwd" for user "Guest"
It is allowing to enter into the db even the user enters "PWD" or "Pwd"
in any way as the password.
I tried even with Query Analyzer. In that also it is not checking the
password for case sensitive. Is there any way to check the password with
case sensitive. I think the sql server internally should check with case
sensitive for a password.
Please help me.
VenkatSee if this helps:
http://vyaskn.tripod.com/case_sensi..._sql_server.htm
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Venkat" <tammana@.inooga.com> wrote in message
news:%23OjVfCUjFHA.3544@.TK2MSFTNGP15.phx.gbl...
> Hi,
> Is there any way to check the password just to allow into the SQL
> Server when it matches with the database password including Case.
> My problem is I used a sqlserver connection string to login to my sql
> server db. But it is allowing me, even though the user types the password
> in any case.
> Eg: If i have a password as "pwd" for user "Guest"
> It is allowing to enter into the db even the user enters "PWD" or "Pwd"
> in any way as the password.
> I tried even with Query Analyzer. In that also it is not checking the
> password for case sensitive. Is there any way to check the password with
> case sensitive. I think the sql server internally should check with case
> sensitive for a password.
> Please help me.
> --
> Venkat
>|||Thanks for your link. But my problem has not been solved.
My problem is why the sql server is checking for a case sensitive
information while logging into the sql server. I am not maintaining any user
tables for passwords. I am just talking about the SQL Server Login using
Query Analyzer.
While logging into the Query Analyzer the password is not validated
using case sensitive. Instead the password is checked using Case-insensitive
mode. It is allowing the user even he typed a mixed case password for a
login which is created using a small case password while creating a user
account.
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:%23s6eofVjFHA.3064@.TK2MSFTNGP15.phx.gbl...
> See if this helps:
> http://vyaskn.tripod.com/case_sensi..._sql_server.htm
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
> "Venkat" <tammana@.inooga.com> wrote in message
> news:%23OjVfCUjFHA.3544@.TK2MSFTNGP15.phx.gbl...
>|||Case-sensitivity for SQL Server login passwords is determined by your
instance default collation. It seems you are using an instance with a
case-insensitive collation.
Hope this helps.
Dan Guzman
SQL Server MVP
"Venkat" <tammana@.inooga.com> wrote in message
news:%232NfH6bjFHA.2852@.TK2MSFTNGP15.phx.gbl...
> Thanks for your link. But my problem has not been solved.
> My problem is why the sql server is checking for a case sensitive
> information while logging into the sql server. I am not maintaining any
> user tables for passwords. I am just talking about the SQL Server Login
> using Query Analyzer.
> While logging into the Query Analyzer the password is not validated
> using case sensitive. Instead the password is checked using
> Case-insensitive mode. It is allowing the user even he typed a mixed case
> password for a login which is created using a small case password while
> creating a user account.
>
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:%23s6eofVjFHA.3064@.TK2MSFTNGP15.phx.gbl...
>
Thursday, March 22, 2012
Case insensitivity problem
I have an application that needs to check users' log on credentials from a
web front end.
The web front end passes the user name and password to a stored procedure
and, if the stored procedure finds someone with those credentials then it
returns the user's ID.
Trouble is that SQLServer has been installed to be case insensitive, so
"password" = "PASSWORD"
Is there anything that I can do in the stored procedure that can make the
select statement case sensitive for this particular query?
Thanks
Griff> Is there anything that I can do in the stored procedure that can make the
> select statement case sensitive for this particular query?
Of course.
http://www.aspfaq.com/2152|||http://vyaskn.tripod.com/case_sensi..._sql_server.htm
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"Griff" <Howling@.The.Moon> wrote in message
news:OS5efhMqFHA.1556@.TK2MSFTNGP12.phx.gbl...
> I have an application that needs to check users' log on credentials from a
> web front end.
> The web front end passes the user name and password to a stored procedure
> and, if the stored procedure finds someone with those credentials then it
> returns the user's ID.
> Trouble is that SQLServer has been installed to be case insensitive, so
> "password" = "PASSWORD"
> Is there anything that I can do in the stored procedure that can make the
> select statement case sensitive for this particular query?
> Thanks
> Griff
>|||Try to convert them to a binary and then compare...
Marcel van Eijkel
( www.vaneijkel.com )sql
web front end.
The web front end passes the user name and password to a stored procedure
and, if the stored procedure finds someone with those credentials then it
returns the user's ID.
Trouble is that SQLServer has been installed to be case insensitive, so
"password" = "PASSWORD"
Is there anything that I can do in the stored procedure that can make the
select statement case sensitive for this particular query?
Thanks
Griff> Is there anything that I can do in the stored procedure that can make the
> select statement case sensitive for this particular query?
Of course.
http://www.aspfaq.com/2152|||http://vyaskn.tripod.com/case_sensi..._sql_server.htm
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"Griff" <Howling@.The.Moon> wrote in message
news:OS5efhMqFHA.1556@.TK2MSFTNGP12.phx.gbl...
> I have an application that needs to check users' log on credentials from a
> web front end.
> The web front end passes the user name and password to a stored procedure
> and, if the stored procedure finds someone with those credentials then it
> returns the user's ID.
> Trouble is that SQLServer has been installed to be case insensitive, so
> "password" = "PASSWORD"
> Is there anything that I can do in the stored procedure that can make the
> select statement case sensitive for this particular query?
> Thanks
> Griff
>|||Try to convert them to a binary and then compare...
Marcel van Eijkel
( www.vaneijkel.com )sql
Tuesday, February 14, 2012
Can't use the cdw to log onto a sql 6.5 from sql 2000
I'm trying to use the CDW to copy a database from sql 6.5
to sql server 2000 from the 2000 server. Somehow, whatever
password I use doesn't seem to work. Is there something
wrong I'm doing? Does anyone has any idea on what I should
do?AFIK, you can't use the CDW with 6.5. The source needs to be
SQL 7 or SQL 2000.
-Sue
On Tue, 30 Sep 2003 12:13:41 -0700, "james"
<jmcfarlane@.usa-direct.com> wrote:
>I'm trying to use the CDW to copy a database from sql 6.5
>to sql server 2000 from the 2000 server. Somehow, whatever
>password I use doesn't seem to work. Is there something
>wrong I'm doing? Does anyone has any idea on what I should
>do?
to sql server 2000 from the 2000 server. Somehow, whatever
password I use doesn't seem to work. Is there something
wrong I'm doing? Does anyone has any idea on what I should
do?AFIK, you can't use the CDW with 6.5. The source needs to be
SQL 7 or SQL 2000.
-Sue
On Tue, 30 Sep 2003 12:13:41 -0700, "james"
<jmcfarlane@.usa-direct.com> wrote:
>I'm trying to use the CDW to copy a database from sql 6.5
>to sql server 2000 from the 2000 server. Somehow, whatever
>password I use doesn't seem to work. Is there something
>wrong I'm doing? Does anyone has any idea on what I should
>do?
Friday, February 10, 2012
Can't transfer user logins and password from 6.5 to 2000
I tried the upgrade wizard and I am getting this error:
"Unable to connect to the Export Server. Please verify that you are an NT
Administrator on that machine"
I am an NT Administrator on that box.
I also tried the script located
http://groups-beta.google.com/group/microsoft.public.sqlserver.security/browse_thread/thread/2eaa09c3d7d7bd1e/099a55c7fbed5496?q=copy+sql+6.5+logins+to+sql+2000&rnum=10#099a55c7fbed5496
but when I run it, it gives me alot of errors. Can anyone help me with any
suggestions. Thanks.
--
New SQL Server DBA
--
New SQL Server DBAI would just script them out, type in the passwords, and go on down the road
personally. Provided you don't have too many SQL Logins.
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:DA21112C-28CC-482B-851B-129A1761706C@.microsoft.com...
>I tried the upgrade wizard and I am getting this error:
> "Unable to connect to the Export Server. Please verify that you are an NT
> Administrator on that machine"
> I am an NT Administrator on that box.
> I also tried the script located
> http://groups-beta.google.com/group/microsoft.public.sqlserver.security/browse_thread/thread/2eaa09c3d7d7bd1e/099a55c7fbed5496?q=copy+sql+6.5+logins+to+sql+2000&rnum=10#099a55c7fbed5496
> but when I run it, it gives me alot of errors. Can anyone help me with
> any
> suggestions. Thanks.
> --
> New SQL Server DBA
> --
> New SQL Server DBA|||What do you mean by trying in the password, how do I get the passwords since
they are encrypted? Thanks.
"ChrisR" wrote:
> I would just script them out, type in the passwords, and go on down the road
> personally. Provided you don't have too many SQL Logins.
>
> "Newbie" <Newbie@.discussions.microsoft.com> wrote in message
> news:DA21112C-28CC-482B-851B-129A1761706C@.microsoft.com...
> >I tried the upgrade wizard and I am getting this error:
> > "Unable to connect to the Export Server. Please verify that you are an NT
> > Administrator on that machine"
> >
> > I am an NT Administrator on that box.
> >
> > I also tried the script located
> > http://groups-beta.google.com/group/microsoft.public.sqlserver.security/browse_thread/thread/2eaa09c3d7d7bd1e/099a55c7fbed5496?q=copy+sql+6.5+logins+to+sql+2000&rnum=10#099a55c7fbed5496
> >
> > but when I run it, it gives me alot of errors. Can anyone help me with
> > any
> > suggestions. Thanks.
> > --
> > New SQL Server DBA
> >
> > --
> > New SQL Server DBA
>
>|||Script them out in encrypted form and use that same encrypted for when creating them in SQL2K (check
out the parameters for sp_addlogin). Also, see if the KB article that has sp_help_revlogin (search
for that word) has something you can use in order to facilitate the scripting of your current
logins.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:72B8DCD1-2758-4CFD-899E-120560CD14BA@.microsoft.com...
> What do you mean by trying in the password, how do I get the passwords since
> they are encrypted? Thanks.
> "ChrisR" wrote:
>> I would just script them out, type in the passwords, and go on down the road
>> personally. Provided you don't have too many SQL Logins.
>>
>> "Newbie" <Newbie@.discussions.microsoft.com> wrote in message
>> news:DA21112C-28CC-482B-851B-129A1761706C@.microsoft.com...
>> >I tried the upgrade wizard and I am getting this error:
>> > "Unable to connect to the Export Server. Please verify that you are an NT
>> > Administrator on that machine"
>> >
>> > I am an NT Administrator on that box.
>> >
>> > I also tried the script located
>> > http://groups-beta.google.com/group/microsoft.public.sqlserver.security/browse_thread/thread/2eaa09c3d7d7bd1e/099a55c7fbed5496?q=copy+sql+6.5+logins+to+sql+2000&rnum=10#099a55c7fbed5496
>> >
>> > but when I run it, it gives me alot of errors. Can anyone help me with
>> > any
>> > suggestions. Thanks.
>> > --
>> > New SQL Server DBA
>> >
>> > --
>> > New SQL Server DBA
>>
"Unable to connect to the Export Server. Please verify that you are an NT
Administrator on that machine"
I am an NT Administrator on that box.
I also tried the script located
http://groups-beta.google.com/group/microsoft.public.sqlserver.security/browse_thread/thread/2eaa09c3d7d7bd1e/099a55c7fbed5496?q=copy+sql+6.5+logins+to+sql+2000&rnum=10#099a55c7fbed5496
but when I run it, it gives me alot of errors. Can anyone help me with any
suggestions. Thanks.
--
New SQL Server DBA
--
New SQL Server DBAI would just script them out, type in the passwords, and go on down the road
personally. Provided you don't have too many SQL Logins.
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:DA21112C-28CC-482B-851B-129A1761706C@.microsoft.com...
>I tried the upgrade wizard and I am getting this error:
> "Unable to connect to the Export Server. Please verify that you are an NT
> Administrator on that machine"
> I am an NT Administrator on that box.
> I also tried the script located
> http://groups-beta.google.com/group/microsoft.public.sqlserver.security/browse_thread/thread/2eaa09c3d7d7bd1e/099a55c7fbed5496?q=copy+sql+6.5+logins+to+sql+2000&rnum=10#099a55c7fbed5496
> but when I run it, it gives me alot of errors. Can anyone help me with
> any
> suggestions. Thanks.
> --
> New SQL Server DBA
> --
> New SQL Server DBA|||What do you mean by trying in the password, how do I get the passwords since
they are encrypted? Thanks.
"ChrisR" wrote:
> I would just script them out, type in the passwords, and go on down the road
> personally. Provided you don't have too many SQL Logins.
>
> "Newbie" <Newbie@.discussions.microsoft.com> wrote in message
> news:DA21112C-28CC-482B-851B-129A1761706C@.microsoft.com...
> >I tried the upgrade wizard and I am getting this error:
> > "Unable to connect to the Export Server. Please verify that you are an NT
> > Administrator on that machine"
> >
> > I am an NT Administrator on that box.
> >
> > I also tried the script located
> > http://groups-beta.google.com/group/microsoft.public.sqlserver.security/browse_thread/thread/2eaa09c3d7d7bd1e/099a55c7fbed5496?q=copy+sql+6.5+logins+to+sql+2000&rnum=10#099a55c7fbed5496
> >
> > but when I run it, it gives me alot of errors. Can anyone help me with
> > any
> > suggestions. Thanks.
> > --
> > New SQL Server DBA
> >
> > --
> > New SQL Server DBA
>
>|||Script them out in encrypted form and use that same encrypted for when creating them in SQL2K (check
out the parameters for sp_addlogin). Also, see if the KB article that has sp_help_revlogin (search
for that word) has something you can use in order to facilitate the scripting of your current
logins.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:72B8DCD1-2758-4CFD-899E-120560CD14BA@.microsoft.com...
> What do you mean by trying in the password, how do I get the passwords since
> they are encrypted? Thanks.
> "ChrisR" wrote:
>> I would just script them out, type in the passwords, and go on down the road
>> personally. Provided you don't have too many SQL Logins.
>>
>> "Newbie" <Newbie@.discussions.microsoft.com> wrote in message
>> news:DA21112C-28CC-482B-851B-129A1761706C@.microsoft.com...
>> >I tried the upgrade wizard and I am getting this error:
>> > "Unable to connect to the Export Server. Please verify that you are an NT
>> > Administrator on that machine"
>> >
>> > I am an NT Administrator on that box.
>> >
>> > I also tried the script located
>> > http://groups-beta.google.com/group/microsoft.public.sqlserver.security/browse_thread/thread/2eaa09c3d7d7bd1e/099a55c7fbed5496?q=copy+sql+6.5+logins+to+sql+2000&rnum=10#099a55c7fbed5496
>> >
>> > but when I run it, it gives me alot of errors. Can anyone help me with
>> > any
>> > suggestions. Thanks.
>> > --
>> > New SQL Server DBA
>> >
>> > --
>> > New SQL Server DBA
>>
Can't transfer user logins and password from 6.5 to 2000
I tried the upgrade wizard and I am getting this error:
"Unable to connect to the Export Server. Please verify that you are an NT
Administrator on that machine"
I am an NT Administrator on that box.
I also tried the script located
ead/thread/2eaa09c3d7d7bd1e/099a55c7fbed5496?q=copy+sql+6.5+logins+to+sql+2000&rnu
m=10#099a55c7fbed5496" target="_blank">http://groups-beta.google.com/group...99a55c7fbed5496
but when I run it, it gives me alot of errors. Can anyone help me with any
suggestions. Thanks.
--
New SQL Server DBA
New SQL Server DBAI would just script them out, type in the passwords, and go on down the road
personally. Provided you don't have too many SQL Logins.
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:DA21112C-28CC-482B-851B-129A1761706C@.microsoft.com...
>I tried the upgrade wizard and I am getting this error:
> "Unable to connect to the Export Server. Please verify that you are an NT
> Administrator on that machine"
> I am an NT Administrator on that box.
> I also tried the script located
> hread/thread/2eaa09c3d7d7bd1e/099a55c7fbed5496?q=copy+sql+6.5+logins+to+sql+2000&r
num=10#099a55c7fbed5496" target="_blank">http://groups-beta.google.com/group...99a55c7fbed5496
> but when I run it, it gives me alot of errors. Can anyone help me with
> any
> suggestions. Thanks.
> --
> New SQL Server DBA
> --
> New SQL Server DBA|||What do you mean by trying in the password, how do I get the passwords since
they are encrypted? Thanks.
"ChrisR" wrote:
> I would just script them out, type in the passwords, and go on down the ro
ad
> personally. Provided you don't have too many SQL Logins.
>
> "Newbie" <Newbie@.discussions.microsoft.com> wrote in message
> news:DA21112C-28CC-482B-851B-129A1761706C@.microsoft.com...
>
>|||Script them out in encrypted form and use that same encrypted for when creat
ing them in SQL2K (check
out the parameters for sp_addlogin). Also, see if the KB article that has sp
_help_revlogin (search
for that word) has something you can use in order to facilitate the scriptin
g of your current
logins.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:72B8DCD1-2758-4CFD-899E-120560CD14BA@.microsoft.com...[vbcol=seagreen]
> What do you mean by trying in the password, how do I get the passwords sin
ce
> they are encrypted? Thanks.
> "ChrisR" wrote:
>
"Unable to connect to the Export Server. Please verify that you are an NT
Administrator on that machine"
I am an NT Administrator on that box.
I also tried the script located
ead/thread/2eaa09c3d7d7bd1e/099a55c7fbed5496?q=copy+sql+6.5+logins+to+sql+2000&rnu
m=10#099a55c7fbed5496" target="_blank">http://groups-beta.google.com/group...99a55c7fbed5496
but when I run it, it gives me alot of errors. Can anyone help me with any
suggestions. Thanks.
--
New SQL Server DBA
New SQL Server DBAI would just script them out, type in the passwords, and go on down the road
personally. Provided you don't have too many SQL Logins.
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:DA21112C-28CC-482B-851B-129A1761706C@.microsoft.com...
>I tried the upgrade wizard and I am getting this error:
> "Unable to connect to the Export Server. Please verify that you are an NT
> Administrator on that machine"
> I am an NT Administrator on that box.
> I also tried the script located
> hread/thread/2eaa09c3d7d7bd1e/099a55c7fbed5496?q=copy+sql+6.5+logins+to+sql+2000&r
num=10#099a55c7fbed5496" target="_blank">http://groups-beta.google.com/group...99a55c7fbed5496
> but when I run it, it gives me alot of errors. Can anyone help me with
> any
> suggestions. Thanks.
> --
> New SQL Server DBA
> --
> New SQL Server DBA|||What do you mean by trying in the password, how do I get the passwords since
they are encrypted? Thanks.
"ChrisR" wrote:
> I would just script them out, type in the passwords, and go on down the ro
ad
> personally. Provided you don't have too many SQL Logins.
>
> "Newbie" <Newbie@.discussions.microsoft.com> wrote in message
> news:DA21112C-28CC-482B-851B-129A1761706C@.microsoft.com...
>
>|||Script them out in encrypted form and use that same encrypted for when creat
ing them in SQL2K (check
out the parameters for sp_addlogin). Also, see if the KB article that has sp
_help_revlogin (search
for that word) has something you can use in order to facilitate the scriptin
g of your current
logins.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:72B8DCD1-2758-4CFD-899E-120560CD14BA@.microsoft.com...[vbcol=seagreen]
> What do you mean by trying in the password, how do I get the passwords sin
ce
> they are encrypted? Thanks.
> "ChrisR" wrote:
>
Can't transfer user logins and password from 6.5 to 2000
I tried the upgrade wizard and I am getting this error:
"Unable to connect to the Export Server. Please verify that you are an NT
Administrator on that machine"
I am an NT Administrator on that box.
I also tried the script located
http://groups-beta.google.com/group/...9a55c7fbed5496
but when I run it, it gives me alot of errors. Can anyone help me with any
suggestions. Thanks.
New SQL Server DBA
New SQL Server DBA
I would just script them out, type in the passwords, and go on down the road
personally. Provided you don't have too many SQL Logins.
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:DA21112C-28CC-482B-851B-129A1761706C@.microsoft.com...
>I tried the upgrade wizard and I am getting this error:
> "Unable to connect to the Export Server. Please verify that you are an NT
> Administrator on that machine"
> I am an NT Administrator on that box.
> I also tried the script located
> http://groups-beta.google.com/group/...9a55c7fbed5496
> but when I run it, it gives me alot of errors. Can anyone help me with
> any
> suggestions. Thanks.
> --
> New SQL Server DBA
> --
> New SQL Server DBA
|||What do you mean by trying in the password, how do I get the passwords since
they are encrypted? Thanks.
"ChrisR" wrote:
> I would just script them out, type in the passwords, and go on down the road
> personally. Provided you don't have too many SQL Logins.
>
> "Newbie" <Newbie@.discussions.microsoft.com> wrote in message
> news:DA21112C-28CC-482B-851B-129A1761706C@.microsoft.com...
>
>
|||Script them out in encrypted form and use that same encrypted for when creating them in SQL2K (check
out the parameters for sp_addlogin). Also, see if the KB article that has sp_help_revlogin (search
for that word) has something you can use in order to facilitate the scripting of your current
logins.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:72B8DCD1-2758-4CFD-899E-120560CD14BA@.microsoft.com...[vbcol=seagreen]
> What do you mean by trying in the password, how do I get the passwords since
> they are encrypted? Thanks.
> "ChrisR" wrote:
"Unable to connect to the Export Server. Please verify that you are an NT
Administrator on that machine"
I am an NT Administrator on that box.
I also tried the script located
http://groups-beta.google.com/group/...9a55c7fbed5496
but when I run it, it gives me alot of errors. Can anyone help me with any
suggestions. Thanks.
New SQL Server DBA
New SQL Server DBA
I would just script them out, type in the passwords, and go on down the road
personally. Provided you don't have too many SQL Logins.
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:DA21112C-28CC-482B-851B-129A1761706C@.microsoft.com...
>I tried the upgrade wizard and I am getting this error:
> "Unable to connect to the Export Server. Please verify that you are an NT
> Administrator on that machine"
> I am an NT Administrator on that box.
> I also tried the script located
> http://groups-beta.google.com/group/...9a55c7fbed5496
> but when I run it, it gives me alot of errors. Can anyone help me with
> any
> suggestions. Thanks.
> --
> New SQL Server DBA
> --
> New SQL Server DBA
|||What do you mean by trying in the password, how do I get the passwords since
they are encrypted? Thanks.
"ChrisR" wrote:
> I would just script them out, type in the passwords, and go on down the road
> personally. Provided you don't have too many SQL Logins.
>
> "Newbie" <Newbie@.discussions.microsoft.com> wrote in message
> news:DA21112C-28CC-482B-851B-129A1761706C@.microsoft.com...
>
>
|||Script them out in encrypted form and use that same encrypted for when creating them in SQL2K (check
out the parameters for sp_addlogin). Also, see if the KB article that has sp_help_revlogin (search
for that word) has something you can use in order to facilitate the scripting of your current
logins.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:72B8DCD1-2758-4CFD-899E-120560CD14BA@.microsoft.com...[vbcol=seagreen]
> What do you mean by trying in the password, how do I get the passwords since
> they are encrypted? Thanks.
> "ChrisR" wrote:
Subscribe to:
Posts (Atom)