Re: Permission to restore databases and access them without being

"Charles Wang [MSFT]" (changliw@xxxxxxxxxxxxxxxxxxxx) writes:
The RESTORE seemed failed, right? However it was not true. The database
was actually restored even with this error message. The problem was that
the current user could not be created in the newly restored database.
However you can manually assign the permissions with a sysadmin account.
There were no data loss based on my observation.

Later I decided that I could have use for that database on that server,
so I restored it as sa. And got no error message that it was already
there.

I should add that I ran this test on SQL 2000, as that was the server
version Lena asked about.

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

.

Relevant Pages

  • Re: SQL Adaptor - Timeout
    ... Anyway there is not many methods to throttling: ... SQL send port trying to repeat the SP several times then suspend the ... Server stored procedures using SQL Server Adaptor. ... The adapter "SQL" raised an error message. ...
    (microsoft.public.biztalk.general)
  • Re: SQL Timeout Error
    ... "Robert Lakinski" wrote: ... but you can access data in Sql server via MS ... I don't know why I got the error message. ...
    (microsoft.public.sqlserver.server)
  • Re: update query ODBC--call failed
    ... Google results from searching for your error message, ... on the local server SQL database. ... reporting the error rather than the "ODbc Driver For SQL Server" ...
    (microsoft.public.access.queries)
  • Re: Problem upgrading Microsoft Office Accounting Professional from 2008 to 2009 using SQL Express 2
    ... The file that is attached to the "Open a Company" command is a text document that appears to just contain the connection string for the selected company. ... Server Express Edition locally, but cannot connect remotely, and if the SQL Server Express Edition is listening on Named Pipes, then I suspect a firewall issue on the computer that is running SQL Server Express Edition. ... Since the problem appears to involve some sort of interaction between Microsoft Office Accounting Professionaland SQL Express 2008 hopefully someone in this forum will understand the error message I'm receiving and can suggest some possible solutions for me to try. ...
    (microsoft.public.sqlserver.connect)
  • RE: SQL Server 2000 desktop MSDE + Internet Explorer 7 = Cant con
    ... cannot open SQL Enterprise Manager. ... From the error message, it seems to be related to SSL and certifcate. ... Edit the registry on the SQL Server machine and make the following ...
    (microsoft.public.sqlserver.connect)