Viewing 15 posts - 7,216 through 7,230 (of 9,253 total)
Brandie Tarvin (3/29/2011)
DTC is on the first active node with an instance. But just in case, what are these issues you are referring to so I can research them?
This first...
March 29, 2011 at 12:19 pm
there are known issues if the clustered DTC resource is not active on the same node as the clustered sql server instance. Windows 2008 clusters allow mulitple clustered DTC applications,...
March 29, 2011 at 10:00 am
do you have any SQL Server 2008 policies in force that may be disabling it after enabling
March 29, 2011 at 9:50 am
sqldba_icon (3/29/2011)
Thanks. I am not sure what you meant with your second comment "instance will go down is node is lost" wouldnt the sql engine failover to other node ?
Database...
March 29, 2011 at 9:42 am
create table structure only using
select * into <newtable> from <oldtable> where 0 = 1
will not create any keys, etc though only table definition
March 29, 2011 at 5:34 am
IMHO log shipping is probably your easiest option here and built in to SQL Server, it's also fairly easy to manage. User disconnections should be minimal if you get the...
March 29, 2011 at 5:29 am
sqldba_icon (3/28/2011)
March 29, 2011 at 5:09 am
Shanlyva
have you checked the event logs for the cluster operations to see if there is anyhting obvious there. Are you sure the new disks are not part of an existing...
March 29, 2011 at 5:04 am
you could do, but the script above supplies a lot more detail
March 29, 2011 at 5:00 am
invaliddba (3/28/2011)
An instance and a sql server are not the same though.
Microsoft refer to each instance as an instance of SQL Server 😉
They are one of the same
March 29, 2011 at 4:59 am
ok so you have a TCP alias setup as SQL03 which points to SQL03,1433 or SQL03\SQL03 does this make sense?
Open sql server configuration manager and go to SQL Native Client...
March 28, 2011 at 3:36 pm
check the following registry key and post the values
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo
Also check this for the port number in use by the instance
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.x\MSSQLServer\SuperSocketNetLib\Tcp\IPAll
March 28, 2011 at 2:48 pm
paulnamroud (3/28/2011)
Thank you PerryI give it a right to the user name SQLServerMSSQLUser$xxx and now It works fine!
That looks like one of the local groups created during the SQL...
March 28, 2011 at 1:54 pm
Windows 2003 or 2008 cluster?
What does this return
SELECT SERVERPROPERTY('Servername')
March 28, 2011 at 1:42 pm
Kenneth
what does the following return when executed against the instance
SELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS') AS ComputerName,
CASE (SELECT SERVERPROPERTY('ISCLUSTERED'))
WHEN 1 THEN 'VirtualName = ' + CAST(SERVERPROPERTY('MachineName') AS NVARCHAR(25))
WHEN 0 THEN 'Not Clustered'
END AS VirtualNetworkName,
ISNULL(SERVERPROPERTY('Instancename'),...
March 28, 2011 at 12:42 pm
Viewing 15 posts - 7,216 through 7,230 (of 9,253 total)