BCP IN SYSLOGINS - SQL 7

Jul 25, 2000

In a recent Disaster Recovery TEST, I successfully recovered some SQL Server 6.5 databases by re-installing SQL Server, applying the SP5a, restoring the application database, and then BCPing IN the syslogins. Everything went normal, as I have done this many times.

I had one SQL 7 to recover. I used the same procedures, however, the BCP in did not work. I ended up getting a Dr. Watson message (not sure if it was related to the BCP or not). Luckily I had the Logins scripted and was able to apply them as follows:
USE master
go
EXEC sp_addlogin 'user1',
0x21312144332c534025532f3a442d5e4c,
@defdb = 'DBNAME',
@deflanguage = 'us_english',
@sid = 0xf8ddfa809a05d411a56600508ba705cb,
@encryptopt = 'skip_encryption'
go

This seemed to work, and luckily there weren't many users in this database.

How do you get the syslogins in for SQL 7?

Thanks,
Carl

View 5 Replies


ADVERTISEMENT

Migrating Syslogins

Apr 6, 2001

We are looking to migrate an entire server with several databases which collectively contain every user in the company. Obviously, I would prefer to directly migrate the logins without having to make everyone reset their own passwords. Anyone know of a way to do this?

I tried dts'ing the syslogins table but it fails due to password collumn being read only.

View 5 Replies View Related

Syslogins In 6.5 - Urgent Question

Jul 18, 2001

hi,
I created a new 6.5 sql server. I brought all the logins from the old
server. I bcp out the syslogins from the old server and bcp into the new
server. There were no errors from the bcp in. Somehow, I still can't
login to the new server using the same password from the old server.
Why?
how can I fix it?

thanks

View 3 Replies View Related

Bcp Syslogins SQL65->SQL7

Mar 23, 2000

my problem is : I want to export syslogins from database SQL6.5 to syslogins SQL7.0.
I use BCP (command : mssqlBCP master..syslogins out d:empsyslogins.dat -c -Sservername -Usa -P -ed:emplogins.err)
It runs well.
AFTER to export to SQL7 database :
(command : mssql7BCP master..syslogins in d:empsyslogins.dat -c -SNEWservername -Usa -P -ed:emplogins.err)
I always have DR WATSON.
If someone has encountered this problem and solved it.
Your help will be strongly appreciate.
Patrick

View 1 Replies View Related

Replicate Syslogins & Sysusers

Oct 22, 1999

Is it possible to have a two way replication of the Logins and Users between two servers? What we have is two SQL 7.0 servers, for an CRM package. They use the CRM replication program to move data back and forth. However, we need to keep the logins and passwords between the two machines ther same. Any thoughts on how to do this?

View 1 Replies View Related

SQL Server 20000 Syslogins

Aug 24, 2000

Just installed SQL Server 2000 Beta 2. I have a procedure that selects the suid from the syslogins table from a SQL 7.0 version that is now saying that column is not valid.
All the documentation I can find still refers to that being a valid column.
Any suggestions?

View 1 Replies View Related

Logins In Master..syslogins

Jun 21, 2001

How can you manually update the syslogins table in SQL 2000? It keeps giving me the following error:

Server: Msg 4406, Level 16, State 2, Line 1
Update or insert of view or function 'master..syslogins' failed because it contains a derived or constant field.

I used to be able to do it in 6.5.

View 3 Replies View Related

Query On Syslogins Table

Aug 17, 2004

Pls help me out with this query as

select * from master..syslogins WHERE hasaccess = 1

as it is both giving me record where hasaccess = 0 and 1

brgds

View 5 Replies View Related

Syslogins, Database Logins Script.

Dec 15, 2004

Does anyone have a script already which pulls all the logins and what databases they have public/dbo access to? I'm looking for something more than just pulling syslogins/users and their default dbname, I need a list of all the databases they have dbo access to.

Thanks, Jim

View 5 Replies View Related

Setting Permissions On Master.dbo.syslogins

Jul 23, 2005

I've got a tool that accesses syslogins to pick up some information.When I run the tool, I get the error message that sasys that my logindoes not have sufficient permissions to read syslogins. If I run undermy admin ID, everything is fine. HOWEVER, the intention is that thistool will be used by non-DBA staff members so we have a generic idcreated to run this tool specifically (non-DBA account).OK, so I go to Enterprise Manager and open up the master database, goto syslogins and add my non-DBA id to the permissions list as havingSELECT access, and click on EXECUTE.BOOM! No sign of my permissions being set.Am I missing something? If so, what do I need to do to set permissionsagainst this view?

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved