login error problem


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: login error problem

  1. #1
    Join Date
    Jan 2006
    Posts
    15

    login error problem

    Under this article it warns that you may get an error if you attached your database:

    http://msdn2.microsoft.com/en-us/library/ms189279.aspx
    <start quote>
    Important:
    The installation of these support objects can fail on a database that has been attached or restored from another instance of SQL Server. This may occur when the database owner name (stored in the database) is not a valid login in the instance of SQL Server the database is being attached or restored to.
    Use the following Transact-SQL expression to change the database owner to a valid login in the instance of SQL Server. Then retry the database diagram operation.

    ALTER AUTHORIZATION ON DATABASE::database_name TO valid_login

    <end of quote>

    Which program do I open to change this authorization on database.
    Can someone clue me in how to do this? Or perhaps point me to another forum where they will help me with problems on this?

    Thanks
    Rae

  2. #2
    Join Date
    May 2005
    Location
    UK
    Posts
    278
    Open the sql query analyser and do it, connect to this database and run the t sql statement
    Sri

  3. #3
    Join Date
    Jan 2006
    Posts
    15
    Thank you.
    Is the "sql query analyzer" included as part of the SQL 2005 express?

  4. #4
    Join Date
    May 2005
    Location
    UK
    Posts
    278
    Sorry i didnt realise you are using SQL 2005 , You will have to run the queries on Visual Studio itself dont have it installed on my system , you see the help in VS.Net 2005
    Sri

Similar Threads

  1. Replies: 11
    Last Post: 10-26-2005, 04:37 PM
  2. Replies: 4
    Last Post: 09-02-2005, 08:22 PM
  3. Return to Login page
    By THL in forum ASP.NET
    Replies: 5
    Last Post: 08-31-2005, 10:47 PM
  4. Login problem in SQLServer 7.0
    By Yan in forum Database
    Replies: 1
    Last Post: 10-03-2001, 09:42 AM
  5. Replies: 0
    Last Post: 08-13-2000, 06:14 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center