Forum Replies Created

Viewing 15 posts - 6,856 through 6,870 (of 9,241 total)

  • RE: Creating a 2 Node SQL Server 2008 Virtual Cluster Part 2

    what was the domain name you used when creating the domain on the DC VM?

    what operating system have you used for the Clusterdc and the cluster nodes?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: IN SSRS DEPLOYMENT

    I'm assuming you mean Report Manager URL and Report Web Service URL

    The web service URL is detailed at this link

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: page size in Sql Server

    Ramkumar (LivingForSQLServer) (7/6/2009)


    Guys,

    why Page size in Sql server is 8K? (why not 4K or 16K)

    and can we change default page size?

    Can anyone please clarify my doubt.

    Thanks in advance

    ram

    i'm stabbing in...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Error encountered during creation of databases: CREATE FILE encountered operating system error 5(Access is denied.)

    operating system error 5 is pretty clear. The SQL Server services user does not have access to the file\folder. Please check the NTFS ACLs and post a screenshot. Alternatively, use...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: I want to restart sql server cluster services What precautions should I take?

    providing your group dependencies are set correctly offlining and onlining the group will take all resources up\down as necessary. If you want to offline\restart just the clustered sql server service...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Creating a 2 Node SQL Server 2008 Virtual Cluster Part 1

    😉

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Copy of Production DB into Reporting DB on daily basis

    Log shipping would probably be your best option

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Deploy by using DBA-created databases (SharePoint Server 2010)

    from memory, the farm account will require at least dbcreator and securityadmin when creating content and search databases

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Can we install SSRS on one server, and the corresponding databases on a different server?

    Furthermore, please see my attached WIKI (in .doc format) detailing how to install, patch and configure an SSRS2005 instance 😉

    😎

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: HELP WITH WMI SCRIPTING

    why are you using WMI?

    To identify the virtual network name and the active cluster node name use the following

    For cluster node name

    select serverproperty('ComputerNamePhysicalNetBIOS')

    For virtual network name

    select serverproperty('machinename')

    For instance name

    select...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Can we install SSRS on one server, and the corresponding databases on a different server?

    jpSQLDude (7/19/2011)


    george sibbald (7/19/2011)


    yes

    Thanks! Care to share how?

    open reporting services configuration manager and when setting the SSRS instance details a set of database connection options are there, simply point to...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Creating a 2 Node SQL Server 2008 Virtual Cluster Part 2

    nalinabey (7/19/2011)


    Hi Perry,

    I was trying to set up domain controller and two VM's for this.I have a problem with assiging IP's for these three servers in order to create a...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: How can list all the users of a particular database.

    Joy Smith San (7/19/2011)


    Thanks Perry.

    Will this work for SQL 2000 as well.? If not whats the equivalent.?

    Thanks again.

    No, the following will work for SQL Server 2000.

    select ...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Creating a 2 Node SQL Server 2008 Virtual Cluster Part 1

    Which browser are you using?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Revisited: RAID10 vs RAID1 SQL

    Jeez, we're not still flogging this dead horse are we 😀

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 15 posts - 6,856 through 6,870 (of 9,241 total)