Forum Replies Created

Viewing 15 posts - 2,641 through 2,655 (of 6,104 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...

    K. Brian Kelley
    @kbriankelley

  • 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...

    K. Brian Kelley
    @kbriankelley

  • 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...

    K. Brian Kelley
    @kbriankelley

  • 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...

    K. Brian Kelley
    @kbriankelley

  • 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...

    K. Brian Kelley
    @kbriankelley

  • 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?

    K. Brian Kelley
    @kbriankelley

  • 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...

    K. Brian Kelley
    @kbriankelley

  • 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...

    K. Brian Kelley
    @kbriankelley

  • 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...

    K. Brian Kelley
    @kbriankelley

  • 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...

    K. Brian Kelley
    @kbriankelley

  • 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.

    K. Brian Kelley
    @kbriankelley

  • 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...

    K. Brian Kelley
    @kbriankelley

  • 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...

    K. Brian Kelley
    @kbriankelley

  • 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?

    K. Brian Kelley
    @kbriankelley

  • 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...

    K. Brian Kelley
    @kbriankelley

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