Forum Replies Created

Viewing 15 posts - 7,906 through 7,920 (of 9,241 total)

  • RE: Best practice when moving data from old storage to the new one

    pavleesseck (6/2/2010)


    I will try this solution on my simulating SQL cluster in VMware Infrastructure 3 first. 🙂

    good man, was gonna be my next suggestion 😉

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

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

  • RE: Sqlserver Report server's HTTP 500 Internal Server Error

    NazerMohamed (6/2/2010)


    Good that I at least found out that SSRS 2008 does not require IIS. I was thinking it still uses IIS as SQL 2005.

    My installation of SSRS is in...

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

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

  • RE: Best practice when moving data from old storage to the new one

    presumably you are currently presenting these over iSCSI?

    You would need agreed downtime for your cluster there's no getting away from that.

    I would create the new LUNS and attach them...

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

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

  • RE: Sqlserver Report server's HTTP 500 Internal Server Error

    Hi

    couple of questions.

    is IIS installed\configured on this server (do you have any websites)?

    Are you using a service account for the SSRS service?

    Can you post some screenshots for web service URL...

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

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

  • RE: SQL SERVER 2005 Restore Backup database

    is the backup they have sent you definitely a full backup? Post the results of the following query

    restore headeronly from disk = 'drive:\path\backupfilename.bak'

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

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

  • RE: SQL 2008 Clustering on a VMWare Environment

    CavyPrincess (6/1/2010)


    I've installed SQL Server Clustering, but not Windows Clustering using VMWare

    Hi Cindy

    glad you found it useful. Remember that clustering is totally separate to SQL Server. SQL Server merely makes...

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

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

  • RE: 890219 - Cluster IP Address gets a barrier

    Bingo, you got it. 😉

    Well done!

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

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

  • RE: Need to run the Statement to attain the list of users in SQL 2008

    you may want to try posting in the correct forum in future 😉

    The database table you need to query is sys.database_principals, this script should help!

    use yourdb

    select 'Login name : '...

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

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

  • RE: Delete Vs Truncate

    Jeff Moden (5/27/2010)


    Just don't throw the book at me. 😛

    No give him a taste of his own medicine and throw a few pork chops instead 😀 :laugh:

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

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

  • RE: Instance not selectable when trying to remove node from a cluster

    when you get the error

    are you creating a failover cluster instance or adding a node to a failover cluster instance

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

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

  • RE: SQL 2008 Clustering on a VMWare Environment

    Hi

    Check my tutorial at the following link for installing a SQL Server 2008 clustered instance under VMWare Server 2.0!

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

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

  • RE: Instance not selectable when trying to remove node from a cluster

    which version of SQL Server are you attempting to cluster?

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

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

  • RE: 2008 failover clustering, failover unsuccessful when NIC disabled or network disconnected

    Windows 2003 or Windows 2008 cluster?

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

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

  • RE: LOGIN ,USER & ROLE PERMISSIONS

    then group them and create roles for each group of users

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

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

  • RE: LOGIN ,USER & ROLE PERMISSIONS

    so are you saying that each of the 100 users needs entirely different permissions?

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

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

Viewing 15 posts - 7,906 through 7,920 (of 9,241 total)