We have a couple of vendor applications that create standard accounts.
These accounts have the same format as our domain accounts. For
example, my Windows account would be <domain>\<user_name>. The SQL
standard account would be <user_name>.
What we would like to do is change the login process to validate
against active directory either prior to or instead of checking the
SQL password. Everything else could remain the same.
This would be on SQL 2000 or SQL 2005. Any suggestions or other
insight would be appreciated.RogerT (roger.tompkins@.gmail.com) writes:
> We have a couple of vendor applications that create standard accounts.
> These accounts have the same format as our domain accounts. For
> example, my Windows account would be <domain>\<user_name>. The SQL
> standard account would be <user_name>.
> What we would like to do is change the login process to validate
> against active directory either prior to or instead of checking the
> SQL password. Everything else could remain the same.
> This would be on SQL 2000 or SQL 2005. Any suggestions or other
> insight would be appreciated.
I'm not really sure what you mean here. SQL Server provides to
means of authentication: SQL authentication and Windows authentication.
It sounds from your description that the vendor accounts are for
SQL authentication. But you cannot change a login from being an SQL
login, to be a Windows login. These two types of logins are competely
unconnected.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx
Showing posts with label format. Show all posts
Showing posts with label format. Show all posts
Monday, March 12, 2012
Friday, March 9, 2012
Login and User Problems
This is a multi-part message in MIME format.
--=_NextPart_000_0015_01C3DBB8.722998E0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Sorry but i think i was not clear enough..
I have a SQL Server 7.0 Desktop installed in my computer. When i = restore a back up
from a SQL SERVER 7.0 Standart it, restore all tables from the database = but not logins.
When I create the logins in the Standart Edition, I created it one for = each user and sing it
by database default my database.
this users appear in the tree view, in the Database User folder. When i restore the database all there are not users, asingned in the = database...
only, Roles and, in this ones, a Public one, that contain all users that = i created.
I can't delete this users, and i can't create a new one with the same = name, because an Error
come's up..
Error 15023: User or role 'REMI'alredy esists in the current database
now i don't know what to do..
any help it will be apreciated..
Remi
--=_NextPart_000_0015_01C3DBB8.722998E0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Sorry but i think i was not clear enough..
I have a SQL Server 7.0 Desktop = installed in my computer. When i restore a back up
from a SQL SERVER 7.0 Standart it, = restore all tables from the database but not logins.
When I create the logins in the = Standart Edition, I created it one for each user and sing it
by database default my = database.
this users appear in the tree view, in = the Database User folder.
When i restore the database all there = are not users, asingned in the database...
only, Roles and, in this ones, a Public = one, that contain all users that i created.
I can't delete this users, and i can't = create a new one with the same name, because an Error
come's up..
Error 15023: User or role 'REMI'alredy = esists in the current database
now i don't know what to = do..
any help it will be = apreciated..
Remi
--=_NextPart_000_0015_01C3DBB8.722998E0--I am not sure if I understand everything, but let me try. Logins are in
master database, so it is normal they are not restored with a user database.
You can script them on the source and implement the script on the
destination server. I guess we are talking about SQL logins. You cn map them
to db users with sp_change_users_login system SP - check it in Books OnLine.
HTH,
--
Dejan Sarka, SQL Server MVP
Please reply only to the newsgroups.|||Thank you that resolve the problem...
Remi
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> escribió
en el mensaje news:e3MIR0$2DHA.3196@.TK2MSFTNGP11.phx.gbl...
> I am not sure if I understand everything, but let me try. Logins are in
> master database, so it is normal they are not restored with a user
database.
> You can script them on the source and implement the script on the
> destination server. I guess we are talking about SQL logins. You cn map
them
> to db users with sp_change_users_login system SP - check it in Books
OnLine.
> HTH,
> --
> Dejan Sarka, SQL Server MVP
> Please reply only to the newsgroups.
>
--=_NextPart_000_0015_01C3DBB8.722998E0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Sorry but i think i was not clear enough..
I have a SQL Server 7.0 Desktop installed in my computer. When i = restore a back up
from a SQL SERVER 7.0 Standart it, restore all tables from the database = but not logins.
When I create the logins in the Standart Edition, I created it one for = each user and sing it
by database default my database.
this users appear in the tree view, in the Database User folder. When i restore the database all there are not users, asingned in the = database...
only, Roles and, in this ones, a Public one, that contain all users that = i created.
I can't delete this users, and i can't create a new one with the same = name, because an Error
come's up..
Error 15023: User or role 'REMI'alredy esists in the current database
now i don't know what to do..
any help it will be apreciated..
Remi
--=_NextPart_000_0015_01C3DBB8.722998E0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Sorry but i think i was not clear enough..
I have a SQL Server 7.0 Desktop = installed in my computer. When i restore a back up
from a SQL SERVER 7.0 Standart it, = restore all tables from the database but not logins.
When I create the logins in the = Standart Edition, I created it one for each user and sing it
by database default my = database.
this users appear in the tree view, in = the Database User folder.
When i restore the database all there = are not users, asingned in the database...
only, Roles and, in this ones, a Public = one, that contain all users that i created.
I can't delete this users, and i can't = create a new one with the same name, because an Error
come's up..
Error 15023: User or role 'REMI'alredy = esists in the current database
now i don't know what to = do..
any help it will be = apreciated..
Remi
--=_NextPart_000_0015_01C3DBB8.722998E0--I am not sure if I understand everything, but let me try. Logins are in
master database, so it is normal they are not restored with a user database.
You can script them on the source and implement the script on the
destination server. I guess we are talking about SQL logins. You cn map them
to db users with sp_change_users_login system SP - check it in Books OnLine.
HTH,
--
Dejan Sarka, SQL Server MVP
Please reply only to the newsgroups.|||Thank you that resolve the problem...
Remi
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> escribió
en el mensaje news:e3MIR0$2DHA.3196@.TK2MSFTNGP11.phx.gbl...
> I am not sure if I understand everything, but let me try. Logins are in
> master database, so it is normal they are not restored with a user
database.
> You can script them on the source and implement the script on the
> destination server. I guess we are talking about SQL logins. You cn map
them
> to db users with sp_change_users_login system SP - check it in Books
OnLine.
> HTH,
> --
> Dejan Sarka, SQL Server MVP
> Please reply only to the newsgroups.
>
Friday, February 24, 2012
Logic in format?
Hello,
This might be a simple questions for you guys.
Can you put logic withing the format of each cell; for example if i have a
number column and i want all numbers > 0 to be red and numbers<=0 to be blue.
Can this be done?
Thanks.Click on your field and go to properties box Go to properties box. Find color
property and and in the drop down box select <expression>. Use an IIF clause
in place of black. IE:
=IIF(Fields!fieldname.value <= 0,"Blue","Red")
"Ash" wrote:
> Hello,
> This might be a simple questions for you guys.
> Can you put logic withing the format of each cell; for example if i have a
> number column and i want all numbers > 0 to be red and numbers<=0 to be blue.
> Can this be done?
> Thanks.|||Actually you can code for most of the field properties. If your report is
going to be printed and you only have a black laser, changing the font to
bold makes it stand out. I had this issue come up earlier today.|||Do you do that in the one click report builder (that you can launch from the
web) or from within the VS2005 editor?
because i tried it from the report builder and when i right click a field i
get 'Format', 'Edit Formula' and 'Delete' only.
I think i'm missing somthing..
"William" wrote:
> Actually you can code for most of the field properties. If your report is
> going to be printed and you only have a black laser, changing the font to
> bold makes it stand out. I had this issue come up earlier today.|||I was describing the process in RS designing in the MSDE designer within VS
.Net 2003. I know there is a Report Builder in 2005, but I have not tried
it yet.
This might be a simple questions for you guys.
Can you put logic withing the format of each cell; for example if i have a
number column and i want all numbers > 0 to be red and numbers<=0 to be blue.
Can this be done?
Thanks.Click on your field and go to properties box Go to properties box. Find color
property and and in the drop down box select <expression>. Use an IIF clause
in place of black. IE:
=IIF(Fields!fieldname.value <= 0,"Blue","Red")
"Ash" wrote:
> Hello,
> This might be a simple questions for you guys.
> Can you put logic withing the format of each cell; for example if i have a
> number column and i want all numbers > 0 to be red and numbers<=0 to be blue.
> Can this be done?
> Thanks.|||Actually you can code for most of the field properties. If your report is
going to be printed and you only have a black laser, changing the font to
bold makes it stand out. I had this issue come up earlier today.|||Do you do that in the one click report builder (that you can launch from the
web) or from within the VS2005 editor?
because i tried it from the report builder and when i right click a field i
get 'Format', 'Edit Formula' and 'Delete' only.
I think i'm missing somthing..
"William" wrote:
> Actually you can code for most of the field properties. If your report is
> going to be printed and you only have a black laser, changing the font to
> bold makes it stand out. I had this issue come up earlier today.|||I was describing the process in RS designing in the MSDE designer within VS
.Net 2003. I know there is a Report Builder in 2005, but I have not tried
it yet.
Subscribe to:
Posts (Atom)