sqlserver database suspect

Ask a Question related to ASP.NET Security, Design and Development.

  1. #1

    Default sqlserver database suspect

    Hello,
    I am using xp.and my user was deleted. I create new user.But now my database
    seem suspect.How can I get back my database

    Thanks..


    Selen Guest

  2. Similar Questions and Discussions

    1. Flash & SQLServer
      Hi How can I connect to sql server directly? Is there any way?
    2. [Macromedia][SQLServer JDBC Driver][SQLServer]Internal
      I'm running an export process which takes data and dumps it to a text file. The query used to build it can contain large amounts of information in...
    3. Flash MX 2004 and SQLServer Database
      Hi All, I have Windows 2000 and IIS 5.0 and Flash MX 2004 PRO I would like to access my sqlserver from action script or using Flash Data...
    4. printing from ASP/IIS/sqlserver
      hello all. i want to create an output document from an ASP page. i would like to read data from a database AND based on a login, route the...
    5. suspect on sp execution order
      Hello, friends: If I have a SP with TSQL code as EXEC sp1 EXEC sp2 EXEC sp3 .... where sp1, sp2, sp3 are several stored procedures, am I...
  3. #2

    Default sqlserver database suspect

    Users are not represented by names inside either Active
    Directory or in your case the local Security Accounts
    Manager (SAM). Everything is represented by a unique
    GUID. When you deleted your account, you really deleted
    it forever unless you backed up your system settings
    using backup. To solve your SQL Server problem though,
    login to your machine as Administrator or an
    Administrator equivalent user and change the settings for
    the SQL Server database Services to logon using your new
    account. They are going to be pointing unfortunately to
    some GUID which used to be your account. There are at
    least three services from SQL Server: SQLServerAgent,
    MSSQLServer and the Distributed Transaction Coordinator.
    Access the services by going to Start -> Control Panel ->
    Administrative Tools -> Services. Look through the list,
    click on the service names and modify the logon tab.
    >-----Original Message-----
    >Hello,
    >I am using xp.and my user was deleted. I create new
    user.But now my database
    >seem suspect.How can I get back my database
    >
    >Thanks..
    >
    >
    >.
    >
    Keith Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139