Could you help to guide me how to configure SQL Server 2008 on a Windows Server 2008 Cluster?
View Complete Post
I am trying to install SqlServer 2005 on windows 2008 cluster with domain controller. Installation fails on the second node while trying to set registry settings for server network libraries. Attached error message and output from error log. Can somebody
suggest any solutions.
TITLE: Microsoft SQL Server 2005 Setup
Failed to set registry settings for server network libraries. The action is SetDefaults. The error is 11004 (The requested name is valid, but no data of the requested type was found.
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_SetServerSSNLDefaults
PerfTime Start: Do_SetServerSSNLDefaults : Fri Sep 24 17:45:31 2010
Setting server network settings for instance name MSSQLSERVER, instance id MSSQL.1
Failed to set registry settings for server network libraries. The action: SetDefaults Error: 11004
Error Code: 0x80072afc (11004)
Windows Error Text: The requested name is valid, but no data of the requested type was found.
Source File Name: sqlca\nlregca.cpp
I came again with couple question on SQL Server 2008 R2 side by side installation in Cluster(Active/passive on Windows 2003 SP2).
1.I have already have SQL Server 2000 SP4 Installation.
2.Can I start Installation(Side by Side) from Passive node ?
3.you want me give New SQL Server Netwrok name (Instance Configuration Screen)?.
4.you want me give New Instance ID name (Instance Configuration Screen)?
5.Can I chose Excixting Clustore resource group or I need to Create New group which is the best ?
Thanks in advance
Please some body help me to find Hot fixes for Windows 2003 SP2 to install SQL Server 2008 R2 In Cluster environment.
Thanks in Advance
I have a single node Windows Server 2008 R2 cluster configured with SQL Server 2008 Enterprise Edition installed as a clustered instance.
I am having an issue where the SQL Server service will only start using TCP/IP when the service account is a member of the local admins group. To get SQL to install I had to add the sql server service account to the local admins group.
I have configured group policy with the permissions required for SQL Server 2008 and this is correctly applied to the node.
Errorlog shows the following...
Error: 26054, Severity: 16, State: 1.
2010-05-05 15:23:41.98 Server Could not find any IP address that this SQL Server instance depends upon. Make sure that the cluster service is running, that the dependency relationship between SQL Server and Network Name resources
is correct, and that the IP addresses on which this SQL Server instance depends are available. Error code: 0x5.
2010-05-05 15:23:41.98 Server Error: 17182, Severity: 16, State: 1.
2010-05-05 15:23:41.98 Server TDSSNIClient initialization failed with error 0x5, status code 0xa. Reason: Unable to initialize the TCP/IP listener. Access is denied.
2010-05-05 15:23:41.98 Server Error: 17182, Severity: 16
Side A (Active) 12 Core processor 192GB RAM
Side B (passive) 4 Core processor 32GB RAM
If side A failed over, would side B be able to cope?
The problem I am posting here is that I was facing nearly 2 weeks around. Any body comes with this stuff please help.
Word Automation in sample ASP.NET(C#) application.
I am using Microsoft.Office.Inetrop.Word Assembly for automation. Here I am reading a XXX.dot template file and fill the contents with dynamic data.
When i am executing my code in localhost:someportnumber the automation is working fine and I could get expected result and when I am hosting in my inetmgr(Windows XP is my OS) it is also working fine.
But the problem is that when I am hosting in my production server(Windows Server 2008 Standard Edition) I am not able to perform automation and results in the following error.
Data: System.Collections.ListDictionaryInternalMessage: Word has encountered a problem.Source: Microsoft Word
The code gets failed in the following line:
ApplicationClass wordApp = new Microsoft.Office.Interop.Word.ApplicationClass();
Document wordDoc = wordApp.Documents.Add(ref oTemplate, ref oFalse, ref oMissing, ref oMissing); // Error in this line
I cannot able to proceed further. Can anybody please help me in solving this issue?
I have been looking everywhere online regarding this, but have not found a clear answer.
I have an ASP.Net app running on Windows Server 2008, it's basically a reporting app using Crystal Reports. I have encountered a roadblock in regards to rendering some pages. When I run the app in Visual Studio(on the same 2008 machine) everything works perfectly. Yet when I publish it and run it live the reports will not display correctly, I get a message saying Failed to render page.
I looked this error up in the Crystal Reports website and the fixes they have there refer to giving the windows "aspnet" user full access rights to certain folders on the machine. I would be happy to do this, however there is no aspnet user in Windows Server 2008.
I installed the server and set its role to be Web Server. I also checked all the options regarding ASP.Net and IIS 6 compatibility. Yet there is no ASPNET username anywhere.
Did I set the server up wrong? or do I have to do something within ASP.Net to create this user and then give it rights?
I had the CSS friendly adapters working great on our old server (windows server 2003 - 32bit) and now we have moved to a 64 bit environment and now I can not get the CSS friendly adapters to work.
We are using SharePoint 2007.
Is there another work thru for 64bit environment.
I notice windows server 2008 has a directory C:\Windows\Microsoft.NET\Framework64 would I be using the browser file in this directory???
I have created a sequential sharepoint workflow in WSP Builder in my Sharepoint Server and Deployed it.
But the workflows says Failed on start and retrying ans stops there forever says couldn't start the workflow.
I repaired .NET Framework 3.5sp1 installed
1. I tried again, in C Prompt: Lodctr "c:\Windows\Microsoft.Net\Framework\v3.0\Windows Workflow Foundation\perfcounters.ini" it says initiation file cannot be found
2 i again tried this C prompt Lodctr /R "c:\Windows\Microsoft.Net\Framework\v3.0\Windows Workflow Foundation\perfcounters.ini"
it says reloaded from the system restored
i am still getting the same error.
When i manually go to my C:\Windows\Microsoft.NET\Framework\v3.0\Windows Workflow Foundation i can see a folder for SQL that's it nothing more than that..
I dont know what is happening i am trying it from 2 days and still no solution.
any ideas would be real great help for me.
My system is 64 bit , Window server 2008, MOSS SP2, Visual Studio 2008 Version 9.0.30729.
.Net Framework 3.5 sp1
and WSP builder the one from Codeplex for 64 bit machines