Viewing 15 posts - 6,751 through 6,765 (of 9,241 total)
Dj463 (8/24/2011)
No the server is not a part of windows cluster.
so how do you plan to install a clustered instance of SQL Server if the server is not part of...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 24, 2011 at 3:02 pm
yes, use a database role and grant users access to the role
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 24, 2011 at 3:00 pm
flora M (8/24/2011)
Thanks for all the responses. I'll look for an option to do this from a stored procedure.
why??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 24, 2011 at 2:55 pm
Snitz forum is a good way of creating an issues forum\tracker
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 24, 2011 at 2:52 pm
in truth, to SSRS, they are system databases. They hold metadata and temporary storage (sort of like a TEMPDB) used by the reporting services instance(s)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 24, 2011 at 2:42 pm
flora M (8/24/2011)
[font="Courier New"]CREATE VIEW...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 24, 2011 at 2:38 pm
ok the certificate is or at least should be bound to the fully qualified computername which you have changed. Self certs do also seem to be an issue i have...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 24, 2011 at 12:35 pm
This will work
exec sp_configure 'show advanced options', '1'
reconfigure with override
exec sp_configure 'xp_cmdshell', '1'
reconfigure with override
set nocount on
create table #services(stext varchar(128))
insert into #services
exec xp_cmdshell "net start"
If (select * from #services where...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 24, 2011 at 11:37 am
ananda.murugesan (8/24/2011)
How to re-assign new IPAddress-2 in SQL server 2008.
change the IP address on the server network connections centre and restart the sql server instance. Dont touch anything else!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 24, 2011 at 11:20 am
is there a firewall between the 2 endpoints?
can the client machine resolve the server name or even ping it?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 24, 2011 at 11:13 am
you also need to remove the passive node from the possible owners list on the cluster resources in case Murphy's law tries to fail over to that node during the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 24, 2011 at 11:11 am
where did you get the SSL certificate for the site, is it self generated?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 24, 2011 at 11:07 am
patch the passive node first, remove the node from the possible owners list on the cluster resources. Install the SP. Add the node back to possible owners list afterwards.
Once done...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 24, 2011 at 11:01 am
Jinu43 (8/16/2011)
configured security( i already configured security)
Sorry for the delay replying. I believe you may already have an endpoint configured on the mirror instance that is different to what you...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 24, 2011 at 10:56 am
shew (8/24/2011)
Does anyone on this forum have experience with building a Windows Server 2008 Failover Cluster on cheap hardware at home?
Follow my 3 part guide on this site starting at...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 24, 2011 at 8:53 am
Viewing 15 posts - 6,751 through 6,765 (of 9,241 total)