Viewing 15 posts - 6,766 through 6,780 (of 9,253 total)
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...
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...
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!
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?
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...
August 24, 2011 at 11:11 am
where did you get the SSL certificate for the site, is it self generated?
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...
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...
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...
August 24, 2011 at 8:53 am
Minaz Amin (8/23/2011)
Generally standby ( using mirroring or Log shipping ) will be in read only mode.
A mirror database will only be read mode if you use database snapshots and...
August 24, 2011 at 12:51 am
Lowell (8/23/2011)
August 23, 2011 at 9:27 am
It's consistent, i'll give it that. It's the same in SQL Server 2008 R2 management studio 😀
August 23, 2011 at 6:39 am
i see what is confusing the OP now
go into the shrink file dialog and select the log file and release ununsed space, then script action to new query window. It...
August 23, 2011 at 6:10 am
GilaMonster (8/23/2011)
p.s. TruncateOnly on shrink is ignored for log files. It's only a valid option for data files (see BoL)
good catch Gail i totally missed that bit 🙂
August 23, 2011 at 6:04 am
Viewing 15 posts - 6,766 through 6,780 (of 9,253 total)