Forum Replies Created

Viewing 15 posts - 2,641 through 2,655 (of 6,105 total)

  • RE: SQL Server Domains/Workgroups

    First, scrub your post to erase the password. Second, verify the sa account password is what you think it is. With that done, if they're all in the same workgroup...

  • RE: Questions in BOL

    Clustering is a feature of the operating system which allows you to use redundant hardware (more than one server) to provide services. SQL Server's supports failover clustering. What that means...

  • RE: Further questions from Bol

    Check out Chris Kempster's e-books on backup, recovery, and troubleshooting. They are offered free by Quest Software. You can find more information at Chris' site:

    Author: Chris...

  • RE: SQL Server Domains/Workgroups

    Since the machines are in a workgroup, there is no trust between any of the machines. Therefore, Windows accounts cannot be verified. Ensure that the username/password combination you're logging in...

  • RE: Password

    Echoing earlier comments... without modifying sp_password in SQL Server 2000 and earlier, no (which brings the SQL Server into an unsupported configuration). SQL Server 2005 can if it's running on...

  • RE: Login failed for user ''''NT AUTHORITY\ANONYMOUS LOGON''''

    In development, is the SSRS installed on the same server as SQL Server? What about production?

  • RE: Pulling My Hair Out

    Stability depended a lot on apps and hardware (specifically the drivers). Yes, 98 and ME let vendors get away with things they shouldn't have. Hence a lot of the stability...

  • RE: DBAs and System Administrators

    System administrators manage the server the SQL Server runs on and, in smaller organizations, the workstations which the apps run on that connect to the database servers. DBAs manage the...

  • RE: care to give this a crack?

    No. Consider them separate input statements. For instance, if driverid 5 drives cars with carid 7 and 11, you've got two rows in your join table.

    INSERT INTO DriverCar
    (DriverID, CarID)
    VALUES
    (5, 7)
    INSERT...
  • RE: SQL and Windows access rights

    Create Table can be granted without the use of db_ddladmin. The db_ddladmin can modify any object in a database and set a different owner (to include dbo). So if you...

  • RE: User info retrieval

    Please do not cross post. See my reply in Administration at http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=242628.

  • RE: Retrieving user information..

    Unless I'm mistaken, this information isn't stored in the collaboration database. I'm not a Sharepoint or Sharepoint Services expert, so take what I'm about to say with a grain of...

  • RE: care to give this a crack?

    Insert the drivers that make sense. Then insert the cars that make sense. Do a query against both tables and find out what the values are for the driverid and...

  • RE: Windows authentication choosing the wrong access.

    When you do a net user <username> /domain from the command prompt the user shows up in both groups? Are you talking domain accounts/groups or local ones?

  • RE: SA Password back out plan

    Do you have the ability to run a SQL trace? Turn on logon success auditing before making the change? You may not be able to get everyone, but you should...

Viewing 15 posts - 2,641 through 2,655 (of 6,105 total)