Re: Can't read from database ??
- From: "Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx>
- Date: Wed, 26 Jul 2006 06:45:25 -0400
One of the first things is to ensure you have proper Login to User mapping.
You also may need to worry about some permissions. Have a look at these:
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://msdn2.microsoft.com/en-us/library/ms345408(en-US,SQL.90).aspx Moving
system dbs 2005
http://www.databasejournal.com/features/mssql/article.php/3379901 Moving
system DB's 2000
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://www.support.microsoft.com/?id=221465 Using WITH MOVE in a Restore
http://www.sqlservercentral.com/columnists/cBunch/movingyouruserswiththeirdatabases.asp
Moving Users
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after
a Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
http://www.support.microsoft.com/?id=320125 Moving a Diagram
http://www.support.microsoft.com/?id=274463 Copy DB Wizard issues 2000
http://www.sqlservercentral.com/scripts/contributions/1598.asp Script
Roles and Permissions
--
Andrew J. Kelly SQL MVP
"K-iS" <KiS@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A1A76593-8903-4C6E-8B69-464524359F8D@xxxxxxxxxxxxxxxx
Hi,
one of our customers had a server crash. So I recovered the database from
backup and integrated it successfully into another sql server. I'm able to
connect through DSN file. Tests ok but the application which should work
with
the database seems to have problems to read or connect to the database.
What have I to bear in mind when recovering a database from backup on a
new
server?
Sincerely
mak
.
- Prev by Date: Re: SQL Server does not exist or is denied
- Next by Date: Re: Can't read from database ??
- Previous by thread: SQL Server does not exist or is denied
- Next by thread: Re: Can't read from database ??
- Index(es):
Relevant Pages
|
