I am creating a new sql server 2000 machine and was wondering how to get the users and passwords from the sql6.5 box over onto the new machine. I know for sql 6.5 there is a stored proc sp_TransferPasswords that I have used but it will not script over cleanly to the sql 2000 box.
Hi, WE are moving one of our applications to oracle from sql server.For this migration is there any way I can move passwords from sql server syslogins table to oracle or extract the passwords. thanks in advance Mohan
Does anyone have a script or tip on how to move passwords associated with logins. I am consolidating two 6.5s into one and want to maintain the passwords associated with the logins. Any hints?
There are set of logins in sql server some are NT authentication and some are sql server authentication. How can i retrieve the passwords for both these logins.
I am a systems analyst and work with an app that runs against 2 SQL Server DBs. Though I have some familiarity with SQL Server and SQL, I am not a DBA.
The app executable is tied to a Windows service. When we install the app, we run a process that builds 2 dbs to include: Tables, indexes, stored procedures, views and user accounts. SQL Server is set up for mixed mode authentication.
Normally, the dbs run off the local db user accounts which are tied to local logins with the same names. We have a client that wants to remove our standard logins so that they can run on only a Windows login. I know I should be able to tie the db users to a Windows login. And I can do the same for the service.
But I am at a loss as to how to get this done. How do you associate db users with a Windows login? When I have tried sp_change_users_login I get an error that the Windows login does not exist. (Though I have added the Windows account to the DB.)
I have versions of sp_hexadecimal and sp_help_revlogin I used with SQL 2000 to transfer logins. Will they work with SQL 2005 as-is? Might I need updated versions?
I€™m using express edition of SQL server 2005. 9.00.1399.06 (Intel X86)
I need to transfer all SQL logins and passwords from one server to another.
The script at http://support.microsoft.com/kb/246133 (designed for sqlserver 7.0 and 2000) This script references a system table (master..syslogins) that may not exits in sqlserver 2005. I get the following error:
EXEC master..sp_help_revlogin
Msg 208, Level 16, State 1, Procedure sp_help_revlogin, Line 12 Invalid object name 'master..sysxlogins'.
Would SMO be something to try for transfering logins and passwords?
I need to transfer the logins and passwords from my prod server to my DR server. I've seen a number of articles about how to transfer logins; but, I'm not finding anything on how to transfer both logins and their passwords. SQL server R2008 R2
I am trying to move users from a SQL 6.5 database to a SQL 2000 database and would like to keep their passwords intact. We used to move them from 6.5 to 6.5 by bcping in the passwords from master..syslogins into a temp table and then inserting them into the new server. SQL 2000 won't allow us to do that. Does anyone konw another way or know how to make this method work?
What is the best procedure to move database logins between servers ? DTS logins over? Should i move the logins first then the user databases or is it the other way around ?
On one of our development ,and production, databases, I have been, through Enterprise Manager for Mssql 6.5, uisng the managerlogin facility to map each login toa specific group for a specfic database via right clickin on the group for the login and changing it. This s being doe for moving a login for public to a read-only group.
I have done this for about 40 users. Users are being added quite often now. This is obviously a labor-intensive and time-consuming manner of doing things.
!) Does any one have a script to change the associaed group for each login in a particular database? If not, how could I built a script from the system tables?
2) Does any one have a script which would tell me, and generate output on, which users have which permissions on the tables in a database and what group are they associated with?
Thanks. Any information you can provide will be greatly appreciated.
On one of our development ,and production, databases, I have been, through Enterprise Manager for Mssql 6.5, uisng the managerlogin facility to map each login toa specific group for a specfic database via right clickin on the group for the login and changing it. This s being doe for moving a login for public to a read-only group.
I have done this for about 40 users. Users are being added quite often now. This is obviously a labor-intensive and time-consuming manner of doing things.
!) Does any one have a script to change the associaed group for each login in a particular database? If not, how could I built a script from the system tables?
2) Does any one have a script which would tell me, and generate output on, which users have which permissions on the tables in a database and what group are they associated with?
Thanks. Any information you can provide will be greatly appreciated.
Historically, many of us have used bulk copy to move selected contents of syslogins from one server to another so that the logins stayed in sync for things such as replication, log shipping, etc.
In SQL 2005, I have no access to passwords (this is proper from a security perspective) so I can't generate a file with bulk copy. I also can't update sys.server_principals, so it doesn't really matter that I can't export the passwords.
So what is the SQL 2005 solution? Suppose I decide to mirror my database. How do I get the logins that are users of that database over to the mirror server? Scripting the logins won't work because it generates a random password. sp_change_users_login requires me to provide a password but then I would have to know each login's current password or give them each a new password. This is viable with 2 users; it is not viable with 2000!
I know that Copy Database Wizard will move the logins with the passwords intact, but it will assign new SIDs to SQL Server authentication logins. That's fine as long as it is a one-time move but not if I am maintaining a warm standby.
This problem has been one of the most frequent problems posted on newsgroups, etc. in the past. But we have had solutions. I fear that we do not have one in SQL 2005.
ok, first, I know... I forgot to run a backup of the master database, and I forgot to run a script to caputure logins. Not that that is out of the way... I need to recreate the logins under the Securities tab below the databases. All the company databases have the user names and passwords assigned to them, but they are not able to login, because they are not able to authenticate to the SQL server first.
Is there a script that someone has that will copy the company database security info for the users and recreate them in the SQL security tab?
I know that I can rebuild them manually, but I need to delete them first in the application software, then delete them from the databases, and then recreate them in the application software... and as simple as that sounds... it is a slow moving process.
I would move a Database to another server. I try to use DTS but I have problems with this process because DB have big tables, I think. I try to use DETACH and ATTACH procedures but logins doesn't export. And more, in new server there are already logins from another DBs.
What's the best way to solve this problem? Please, help Thanks
I trying to get the moving total (juts as moving average). It always sum up the current record plus previous two records as well and grouped by EmpId.For example, attaching a image of excel calculation.
I have to create some type of an sp that will force users to change their passwords every 30 days. It sounds like I should be able to create a simple table with the login and the password expiration date. Then, I should create some type of function to check the expiration, get the new password and run sp_password. Has anyone done this before? Where would this table be created? In Master? Would that also be where I should create this sp? Should this be an xp?
I'm fairly light on creating sp's. Can anyone suggest a starting point for me or give any suggestions? I would appreciate any help. Thanks! Toni E.
Does some one know of a way to use windows passwords in sql w/o having to enter them in? Like a program or sql statement? As of now, we are having to enter them in ourselves , and would like to make our jobs easier....Thanks!!
I have SQL Server 2000 and in one of the databases we store the Application passwords as a Clear text. we would like to encrypt these passwords so that we will pass the auditing.
Can some one please suggest a good way to encrypt these passwords.
I have a pgp file requiring a password that is emailed to me. Is it possible to set up a DTS package that will open the file (using the password), and insert the data into a table, file, etc. TB