Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2008 > SQL Server 2008
|
SQL Server 2008 General discussion of SQL Server *2008* version only - not related to a specific book.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2008 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 26th, 2010, 09:13 PM
Authorized User
 
Join Date: May 2007
Posts: 73
Thanks: 4
Thanked 0 Times in 0 Posts
Default SQL server mapping User issue

Hi
I m using sql server 2008.

I moved a database from one server to another by performing a backup/restore operation. All the database specific sql logins came with the restore, and all permissions remained intact. however these logins do not exist at the server level on this new server. I manually recreated a logins few days back, now i want to give other databse access to the same login, but am keep getting the error message saying something like the log files doesnot exist.....


Any idea how to solve this?
__________________
Cheers
Sheraz
 
Old May 27th, 2010, 08:41 AM
Authorized User
 
Join Date: May 2007
Posts: 73
Thanks: 4
Thanked 0 Times in 0 Posts
Default

The error message box says:

create failed for user 'abc'

additional information:

-An exception occured while executing a transact-sql statement or batch

- The log for databse 'mydatabse' is not available. check the event log for related error messages. resolve any errors and restart the databse.(microsoft sql server, Error: 9001)
__________________
Cheers
Sheraz





Similar Threads
Thread Thread Starter Forum Replies Last Post
Oracle to SQL Server DataType Mapping maulik33 SQL Language 0 November 1st, 2007 02:48 PM
SQL Server 2000 connectivity issue avixorld ASP.NET 2.0 Professional 8 July 25th, 2007 09:17 AM
SQL Server Mobile 5 issue in VS.NET rodmcleay Visual Studio 2005 0 July 10th, 2006 11:49 PM
Usizing issue Access to SQL Server gvcooper Pro VB 6 0 April 30th, 2006 05:09 AM
Email about mapping issue RaminS Biztalk 2 July 7th, 2003 08:34 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.