[dba-SQLServer] [AccessD] Transferring a database to anotherSQL Server

JWColby jwcolby at colbyconsulting.com
Sun Aug 27 12:26:31 CDT 2006


SQL Server 2K 


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 12:23 PM
To: Access Developers discussion and problem solving
Cc: dba-SQLServer
Subject: Re: [dba-SQLServer] [AccessD] Transferring a database to anotherSQL
Server

In addition, SQL 2005 has "remote access" turned off by default. Go into
Configuration Manager and have a look there. My guess is that this is your
problem.

Arthur

----- Original Message ----
From: Jim Lawrence <accessd at shaw.ca>
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Sent: Sunday, August 27, 2006 12:08:30 PM
Subject: Re: [AccessD] Transferring a database to another SQL Server

Hi John:

1. Would you have an IIS server running on both computers?
2. Are both MS SQLs using different ports (1433 default)?
3. The 'guest' account is turned off by default on new installs; would this
be the case on the new computer?
4. Do you have a personal firewall setup on either/both computers that may
be blocking the MS SQL ports?

HTH
Jim  

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of JWColby
Sent: Sunday, August 27, 2006 6:38 AM
To: dba-sqlserver at databaseadvisors.com
Cc: 'Access Developers discussion and problem solving'
Subject: [AccessD] Transferring a database to another SQL Server

I have just finished rebuilding a machine (new motherboard) and need to
transfer a large SQL Server database to that new server.  The two servers
can see each other (shared folders), but ...

I cannot register the other SQL Servers, getting an error "Login failed for
'MachineName\Guest'.  I get this error on either machine when trying to
register the SQL Server on the other machine.  My login user / password is
the same on both machines.  Both databases were installed using "Windows
Authentication" rather than "SQL Server Authentication".

Any ideas?


John W. Colby
Colby Consulting
www.ColbyConsulting.com


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: 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