[dba-SQLServer] [AccessD] Transferring a databasetoanotherSQLServer

artful at rogers.com artful at rogers.com
Mon Aug 28 07:40:59 CDT 2006


SQL Server Login is mixed mode, IIRC. It simply means that a Windows login is not enough. In addition, you need a SQL user/password.

Arthur

----- Original Message ----
From: JWColby <jwcolby at colbyconsulting.com>
To: dba-sqlserver at databaseadvisors.com
Sent: Monday, August 28, 2006 8:16:23 AM
Subject: Re: [dba-SQLServer] [AccessD] Transferring a databasetoanotherSQLServer

This is a network in my home office.  Why do I need to turn Simple File
Sharing off, and if I need to do that, how do I replace it's functionality?

With Simple File Sharing OFF my workstations can no longer see each other
and I get "no permission to use" error messages when trying to browse for
shares in Explorer. 

Furthermore, with SFS off, the other machines do not show up when browsing
in EM for other servers.

I seem to remember that I had to set up the databases to use "mixed mode"
login, but that option is not readily available to me anywhere.  The only
two choices on these two machines are straight "windows login" or "SQL
Server" login.  How do I turn on Mixed Mode?


John W. Colby
Colby Consulting
www.ColbyConsulting.com

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Haslett,
Andrew
Sent: Monday, August 28, 2006 3:15 AM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] [AccessD] Transferring a
databasetoanotherSQLServer

Turn *off* simple file sharing. 

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of JWColby
Sent: Monday, 28 August 2006 11:07 AM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] [AccessD] Transferring a database
toanotherSQLServer

>If space on the stick or CD or DVD is really a problem, you could skip 
>or
truncate the Log file.

LOL, I have three files.  One is 150 GIG, the other two are 140 GIG but only
56 GIG actually used.  Unlikely to fit on a memory stick, or a dvd - even
zipped.

But if I can detach them, then just move the entire disks and then reattach
that would be fine.  I really need to get these disks moved to the new
machine anyway.

Which leaves me with the issue of why EM is not able to attach to the
database on the other machine.  This was working in the past.  These are
simple Windows XP Pro boxes, identical username / password on all the boxes.
Workgroup, no domains.  Simple file sharing is working, I can see
directories on the other boxes.  Each machine has a SQL Server running.
Each machine can see its own local database, and I can see the other machine
(it comes up in a list of machines / databases to connect to) but the
connect itself fails with a "can't use guest".  All of them are set up to
use Windows Server authentication.  Why is it trying to use Guest as opposed
to using the current logged in user on the current machine (jwcolby)?

John W. Colby
Colby Consulting
www.ColbyConsulting.com

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of
artful at rogers.com
Sent: Sunday, August 27, 2006 4:45 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] [AccessD] Transferring a database to
anotherSQLServer

In that case, the simplest means is detach the db, copy it to a memory stick
or something, then copy it to the data directory of the new machine, and
finally attach it. This sidesteps the problem of why you cannot see each box
from the other, but one thing at a time. Presumably the most important thing
is to get the db there. Depending on the size of the MDF and LDF files, you
may need to ZIP or RAR them first, then extract them upon arrival. If space
on the stick or CD or DVD is really a problem, you could skip or truncate
the Log file.

hth.
Arthur

----- Original Message ----
From: JWColby <jwcolby at colbyconsulting.com>
To: dba-sqlserver at databaseadvisors.com
Sent: Sunday, August 27, 2006 1:26:31 PM
Subject: Re: [dba-SQLServer] [AccessD] Transferring a database to anotherSQL
Server

SQL Server 2K 


John W. Colby
Colby Consulting
www.ColbyConsulting.com




_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com



IMPORTANT - PLEASE READ *** This email and any files transmitted with it are
confidential and may contain information protected by law from disclosure.
If you have received this message in error, please notify the sender
immediately and delete this email from your system. No warranty is given
that this email or files, if attached to this email, are free from computer
viruses or other defects. They are provided on the basis the user assumes
all responsibility for loss, damage or consequence resulting directly or
indirectly from their use, whether caused by the negligence of the sender or
not.
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com








More information about the dba-SQLServer mailing list