Memory Configurations For SQL Server 2005 EE X64 With SQL Server 2000 EE X32 On Windows Server EE X64 Server
My server is a dual AMD x64 2.19 GHz with 8 GB RAM running under Windows Server 2003 Enterprise Edition with service pack 1 installed. We have SQL 2000 32-bit Enterprise installed in the default instance. AWE is enabled using Dynamically configured SQL Server memory with 6215 MB minimum memory and 6656 maximum memory settings.
I have now installed, side-by-side, SQL Server 2005 Enterprise Edition in a separate named instance. Everything is running fine but I believe SQL Server2005 could run faster and need to ensure I am giving it plenty of resources. I realize AWE is not needed with SQL Server 2005 and I have seen suggestions to grant the SQL Server account the 'lock pages in memory' rights. This box only runs the SQL 2000 and SQL 2005 server databases and I would like to ensure, if possible, that each is splitting the available memory equally, at least until we can retire SQL Server 2000 next year. Any suggestions?
View Complete Forum Thread with Replies
Related Forum Messages:
SQL Server 2000 + 2005 Working On Same Windows 2003 Server As Seperate Instances
Hi all,I just asked some people to help me out and phone microsoft with thefollowing information, kindly they refused unless we setup a supportcontract with them first, for pre-sales information. (That really doesnot sound like good business sense to me - anyway here is our problem,if anyone could help thanks)."To tell and ask microsoft:We will be setting up a microsoft sql server 2000 instance running on awindows 2003 server.1) We need to check this can run alongside a microsoft 2003 sql server(either workgroup or standard edition), on the same machine. Are thereany .dll clashes if we do this? If there are can we run SQL Server2000, in a virtual machine running windows 2000 professional. (I have alicenced copy we can use for this).2) If we run one instance of 2000, and one of 2003 of the sql servers,can one use the processor licence model, and one use the CAL licencemodel."Thanks for any help, and any idea why they actually force you to usenews groups for pre-sales information?David
View Replies !
Connection Error To The SQL Server 2005 Express On Windows 2000 Server.
Hi, My application use SQL Native Client to connect to the SQL Server 2005 Express database instance. It uses IRowsetFastLoad for bulk insert and IRowset for other accessings. When this application runs at Windows 2000 Server, and there is another running instance of SQL Server 2000 for other service, my program fails to connect the the SS2005 express after running about 40 hours. The error message is 'Initialize datasource error(0x80004005)' The memory usage of SS2005 express is over 600 MB even though I limited the memory usage to 200MB using sp_configure stored procedure. Another programs also fail to running. For example, the ftp client return error message like this, 'No buffer space is supported.' and fails to connect to FTP server. Here is my code. Please check if there are any problems like threading models,MDAC version ect... ------------------------------------------------------------- HRESULT hr = CoInitialize(NULL); if ( S_OK != hr ) { return FALSE; } hr = CoCreateInstance(CLSID_SQLNCLI, NULL, CLSCTX_INPROC_SERVER, IID_IDBInitialize, (void**)&m_pIDBInitialize); if ( S_OK != hr ) { return FALSE; } rgProperty[0].dwPropertyID = DBPROP_INIT_DATASOURCE; rgProperty[0].dwOptions = DBPROPOPTIONS_REQUIRED; // rgProperty[0].dwStatus = ; <-- not required in input or consumer rgProperty[0].colid = DB_NULLID; rgProperty[0].vValue.vt = VT_BSTR; rgProperty[0].vValue.bstrVal= bstrDataSource; rgProperty[1].dwPropertyID = DBPROP_INIT_CATALOG; rgProperty[1].dwOptions = DBPROPOPTIONS_OPTIONAL;//DBPROPOPTIONS_REQUIRED; // rgProperty[1].dwStatus = ; <-- not required in input or consumer rgProperty[1].colid = DB_NULLID; rgProperty[1].vValue.vt = VT_BSTR; rgProperty[1].vValue.bstrVal= bstrCatalog; rgProperty[2].dwPropertyID = DBPROP_AUTH_USERID; rgProperty[2].dwOptions = DBPROPOPTIONS_REQUIRED; // rgProperty[2].dwStatus = ; <-- not required in input or consumer rgProperty[2].colid = DB_NULLID; rgProperty[2].vValue.vt = VT_BSTR; rgProperty[2].vValue.bstrVal= bstrUserID; rgProperty[3].dwPropertyID = DBPROP_AUTH_PASSWORD; rgProperty[3].dwOptions = DBPROPOPTIONS_REQUIRED; // rgProperty[3].dwStatus = ; <-- not required in input or consumer rgProperty[3].colid = DB_NULLID; rgProperty[3].vValue.vt = VT_BSTR; rgProperty[3].vValue.bstrVal= bstrPassword; rgPropertySets[0].rgProperties = rgProperty; rgPropertySets[0].cProperties = cPropertySets; rgPropertySets[0].guidPropertySet = DBPROPSET_DBINIT; hr = m_pIDBProperties->SetProperties(1, rgPropertySets); if ( S_OK != hr ) { return FALSE; } hr = m_pIDBInitialize->Initialize(); if ( S_OK != hr ) { return FALSE; } // Create Session hr = m_pIDBInitialize->QueryInterface(IID_IDBCreateSession,(void**)&m_pIDBCreateSession); if ( S_OK != hr ) { return FALSE; } hr = m_pIDBCreateSession->CreateSession(NULL,IID_IOpenRowset,&m_pIUnkSession); if ( S_OK != hr ) { return FALSE; }
View Replies !
Can't Connect .Net Application From Windows Server 2003 To Database Server (SQL Server 2000)
Hi, I am having a problem connecting my .net applications from the application server to the database server. When I run the application from my windows xp (sp2) box it works fine. When I try to connect via SQL Management Studio to the database server from the application server I get the same error. Here is the error: System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) Here is the Environment: App Server: Windows Server 2003 Standard Edition Inside Company's Firewall/ Network Database Server: Windows Server 2000 Advanced Edition SQL Server 2000 SP4 Remote Connections to the Server is checked Enable Protocols: Named Pipes & TCP/IP TCP/IP Port: 1402 (I don't know why it isn't the default of 1433) The db server is sitting out side the Company's firewall (don't ask me why). I can access it fine from inside the firewall on my XP box but not from windows server 2003. There is a web server outside the our network that also connects to the db server with no problem and that is running Windows Server 2003 Web Edition. I can ping the db server from the app server using the IP address. I tried using the IP address and the port 1402 in my connection string but that didn't work from any machine (XP and Server). I imagine the issue is somehow related to the company's firewall but why would it only block Windows Server 2003 and not XP? What do I tell the network admin to change? Any help would be appreciated. Thanks, Oran
View Replies !
How To Make Use Of 4 GB Memory For SQL Server 2005 Standard + Windows 2003 Stardard
We just upgraded the memory of our database server from 2GB to 4GB. And its OS is windows 2003 standard and sql is 2005 standard edition. According to microsoft(http://msdn2.microsoft.com/en-us/library/ms143685.aspx and http://msdn2.microsoft.com/en-us/library/aa366778.aspx#physical_memory_limits_windows_server_2003), this configuration should allow database use up to 4 GB memory. My question is : Do I need to do anything(such as: adjust the maximum memory in management studio) to let our server be able to consume this extra 2 GB memory? Does this solution http://support.microsoft.com/kb/274750 apply for SQL server 2005?
View Replies !
Not Able To Install SSRS For SQL Server 2000 On Production Machine (Windows 2000 Advanced Server)
Hi, I am not able to install SSRS for SQL Server 2000 on our production server, which is Windows 2000 advanced server and it is giving error messages in the last minute and before completing the set up and the message is displayed in meesage box as "SQL Setup failed to execute a command for Server configuration. The error was: Line 1: Incorrect Syntax error near '[]'. Refer to Server logs and set up logs for detailed error information " Please help on this at the earliest. Appreciate your help in advance.
View Replies !
SQL 2005 On Windows 2000 Server?
We have a financial software package that has been certified for SQL 2005 and Windows 2003 server. Will SQL 2005 run on a Windows 2000 server? I don’t want to build a new server at this time unless I really have too. Thanks, Al
View Replies !
Any Books That Explain How To Setup Windows 2003 Server + SQL Server 2000?
My uncle runs a small networking company and has extra licenses for Windows 2003 Server as well as SQL Server 2000. Since I just graduated from college and have started working as a database programmer (for a different company) I'd like to setup a small server at home to learn more about SQL (as well as networking, but SQL is my primary concern). I know I can setup SQL Server 2000 on my main PC, but I'd still like to set everything up in a server environment. So, what I'm wondering is if any books (or web sites?) exist that walk you through setting up Windows 2003 Server and SQL Server 2000. I've actually set these up before (it's not very complicated) but I'm not sure if I did it the "correct" way. Ideally if any books exist on O'Reilly's Safari Bookshelf that would be even better. Thanks in advance, John
View Replies !
Distributed Transactions Problem With SQL Server 2000 On Windows Server 2003
Hi I'm running SQL Server 2000 on Windows Server 2000, but migrating all databases on SQL Server 2000 to a Server running Windows 2003 The last time I moved everything over to a new Windows 2000 server some of my SQL statements wouldn't work - and returned the following error message: 'The operation could not be performed because the OLE DB provider 'MSDAORA' was unable to begin a distributed transaction' I was able to cure this by following advice from Microsoft.com. I changed Registry settings as follows: [HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSDTCMTxOCI ] "OracleXaLib"="oraclient9.dll" "OracleSqlLib"="orasql9.dll" "OracleOciLib"="oci.dll" I'm now migrating my SQL Server 2000 to a large server running Windows Server 2003 5.2., and the fix doesn't seem to work. If I run code in QA as below, it returns the error message above: select Field1,Field2, dbo.fn_findpt(Code,Groupid)as Func_Field into #Test from Mytable where Tcode is not null and Team ='Alpha' dbo.fn_findpt is a function which pulls data from an Oracle database using MSDAORA - and has worked fine for ages on the old Windows 2000 server. I have also tried the process below kindly sent to me by Balmukund Lakhani – my comments follow: Looks like you are getting hit by MSDTC default security settings for Windows 2003. Anyway, lets try below. a. Click Start, and then click Run. b. In the Run dialog box, type dcomcnfg.exe, and then click OK. c. In the Component Services window, expand Component Services, expand Computers, and then expand My Computer. d. Right-click My Computer, and then click Properties. e. In the My Computer Properties dialog box, click Security Configuration on the MSDTC tab. f. In the Security Configuration dialog box, click to select the Network DTC Access check box. g. To allow the distributed transaction to run on this computer from a remote computer, click to select the Allow Inbound check box. h. To allow the distributed transaction to run on a remote computer from this computer, click to select the Allow Outbound check box. i. Under the Transaction Manager Communication group, click to select the No Authentication Required option. j. In the Security Configuration dialog box, click OK. k. In the My Computer Properties dialog box, click OK. My Reply: I went through your outlined procedure. All was checked as you described: 'Allow Inbound' checked 'Allow Outbound' checked ('Allow Remote Clients' checked?? 'Allow Remote Administration' checked?? not sure about the above 2) However, I found that the 'No Authentication Required Option' wasn't selected so that is now selected. It prompted to restart MsTDC, which I did. Unfortunately, when I run code in QA, I get the same message. So the situation remains: I can link to the Oracle Server fine on the new Windows 2003 server. It's just distributed tranactions which I can't do. If anybody has a cure for this, I'd be really grateful – I’m getting pretty desperate. Thanks Paul
View Replies !
Windows 2003 Server SP2 To Be Applied On SQL Server 2000 Standard Edition SP3
We got SQL Server 2000 Standard Edition SP3 running on Windows 2003 Standard Edition server. Now, we would like to apply windows 2003 SP2 to the Operating System. We are concerned that whether windows 2003 SP2 is compatible with SQL server 2000 (SP3)? I was looking at the application compatibility chart for Windows 2003 SP2.Among them Microsoft SQL Server Standard (2000) was listed but with no Service pack details. And also does Standard means standard edition there? My Question - Is windows 2003 server SP2 compatible with SQL Server 2000 (SP3) Standard Edition? And what if I plan to apply SP4 to Sql Server ? Please help. Thanks
View Replies !
Upgrade - Server 2000/sql Server 2000 To Server 2003/ Sql Server 2005
I am converting about 50 databases from Windows 2000 and from SQL Server 2000 to a totally new 4 processor Server 2003 with SQL SErver 2005. I used the Database Copy Wizard in SS2005 to do the transfer and I used the object method. After making sure the databases were big enough to hold the new Masterdatabase everything went well... except none of the stored procedures from any of the 50 databases copied from SQL Server 2000 to SQL Server 2005. What did I do wrong? And how do i fix it. Also, even though I changed the default database, the wizard did not reflect the new SAN location for the Data and Log files. I had to do each one manually.
View Replies !
SQL EXPRESS Reporting Server (Access Denied - Windows 2000 Server Domain Controller)
Subject problem has me quite vexed. I am receiving the following error when attempting to access reporting services... to sum things up real nice and tidy- I get three login prompts - then the access denied response. It is almost as if it is unable to authenticate the user... anyway... here's the actual error response, I'd really appreciate any input/insight/resolution. Server Error in '/Reports' Application. Access to the path 'C:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesReportManagerin' is denied. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.UnauthorizedAccessException: Access to the path 'C:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesReportManagerin' is denied. ASP.NET is not authorized to access the requested resource. Consider granting access rights to the resource to the ASP.NET request identity. ASP.NET has a base process identity (typically {MACHINE}ASPNET on IIS 5 or Network Service on IIS 6) that is used if the application is not impersonating. If the application is impersonating via <identity impersonate="true"/>, the identity will be the anonymous user (typically IUSR_MACHINENAME) or the authenticated request user. To grant ASP.NET access to a file, right-click the file in Explorer, choose "Properties" and select the Security tab. Click "Add" to add the appropriate user or group. Highlight the ASP.NET account, and check the boxes for the desired access. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [UnauthorizedAccessException: Access to the path 'C:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesReportManagerin' is denied.] System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) +2014163 System.IO.Directory.InternalGetFileDirectoryNames(String path, String userPathOriginal, String searchPattern, Boolean includeFiles, Boolean includeDirs, SearchOption searchOption) +1817 System.IO.Directory.GetDirectories(String path, String searchPattern, SearchOption searchOption) +36 Microsoft.ReportingServices.Diagnostics.Localization.GetInstalledCultures() +112 Microsoft.ReportingServices.Diagnostics.Localization..cctor() +66 [TypeInitializationException: The type initializer for 'Microsoft.ReportingServices.Diagnostics.Localization' threw an exception.] Microsoft.ReportingServices.Diagnostics.Localization.SetCultureFromPriorityList(String[] localeList) +0 Microsoft.ReportingServices.UI.GlobalApp.Application_BeginRequest(Object sender, EventArgs e) +157 System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64 Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210
View Replies !
SQL Server 2000 Databases To SQL Server 2005? Enterprise Manager And Management Stuio At The Same Server?
When I proposed start to use SQL Server 2005 for new VS 2005 web sites, one of my co-workers responded that we will update the old SQL Server 2000 databases to SQL Server 2005 when we are ready to use 2005 SQL Server. Questions: 1. Any expected problems to upgrade old 2000 databases to new 2005 SQL Server? 2. I have installed both 2005/Management Studio Express and 2000/Enterprise Manager in my PC. Any expected problems when running both 2000 and 2005 SQL Server at the same database server? 3. What is the best configuration for running SQL Server 2005 when we have old 2000 databases? Upgade or not upgrade? TIA, Jeffrey
View Replies !
SQL Server 2005 Connectivity From Windows 2000
We have an OLD vbscript process that is running on a Windows 2000 box. The box has Sql Server 7.0 on it (not sure if relevant). The process used to hit a Sql Server 2000 database, but that database was recently migrated to 2005 (on different server). Now the connection string obviously no longer works, and we can't even add a DSN to 2005 (does not recognize new server). The machine pings the new SQL server without any problem, but cannot connect for data access. I assume there should be some driver that I can install to fix this, but have yet to find one on the web. Does anyone have a recommended download to remedy this? Thanks in advance.
View Replies !
Problem Occurs When Migrating A SQL Server 2000 Database To A SQL Server 2005 Server
When I try to migrate a database on a SQL Server 2000 server to a SQL Server 2005 server with the Copy Database Wizard of the SQL Server Management Studio, I'm confronted with the following problem; Performing operation... - Add log for package (Success) - Add task for transferring database objects (Success) - Create package (Success) - Start SQL Server Agent Job (Success) - Execute SQL Server Agent Job (Error) Messages * The job failed. Check the event log on the destination server for details. (Copy Database Wizard) When I take a look at 'Event viewer' on the SQL 2005 server, the following error is displayed; InnerException-->An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) I already enabled the MSSQLSERVER network configuration protocols (TCP/IP and Named Pipes ). How do I solve this problem?
View Replies !
SQL Server 2000 Problem In Windows 2003 Server
Hello ALL I have configured a website on a windows 2003 server, while its database is residing on a remote server with sqlserver 2000 database. In the connection string, I use the server IP address for the remote SQL server, and when the website is browsed, i get an error something similar to the one below: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) If I test the same website on windows XP, it will connect to the remote server without a problem. Can Anyone please give me a tip about the windows operating system, what should I do to over come this? Thanks in advance regards, Mykhan
View Replies !
SQL Server Setup Failed On Windows 2000 Server SP4
Hi, When I tried to install Sql server 2005 enterprise edition on Windows 2000 SP4 , it gave an error message asking to install a newer version of windows installer . So I installed the windows installer 3.1. V2, (WindowsInstaller-KB893803-v2-x86) which comes in the redistribution package with sql server 2005 installation. After that when I tried to install SQL server 2005 again, it gave me the following error when installing Microsoft SQL Native Client. "Errors occured during the installation: Error 1619 installing Microsoft Native Client. This installation package could not be opened. Verify that the package exists and that you can access it, or contact the application vendor to verify that this is a valid Windows Installer package." Is this error due to the windows installer that I installed? Please Help. Thanks in advance.
View Replies !
Reporting Services 2005 On Windows 2000 Server
Hi, I successfully got SQL 2005 Express with reporting services running under VISTA. Developed some reports in the VISTA environment. However, my target system is a Windows 2000 server. We installed SQL 2005 w/reporting services onto the Windows 2000 server. SQL2005 Database is up and running. Reporting Services are running, IIS RRS virtual directories are built, RRS databases are built. I can do everything except deploy reports from Business Intelligent Studio. I can preview reports, just cannot deploy. The Reporting Services indicate 1 failure in its configuration; the Web Service Identity. It is loaded with <server>ASPNET. I cannot get rid of this error. I assume this is the problem. After digging around I found that Windows 2000 does not have an ASPNET user, it uses the IWAM user instead. Reporting services did not run at all till I changed the rs config file and put the IWAM user in as <WebServiceAccount>. Does anyone have Reporting services 2005 running on Windows 2000 server? Anyone know how to fix the Web Service Identity error I am getting? Thanks
View Replies !
SQL Server 2005 Not Starting At Boot, Windows 2000
Please feel free to redirect me if this has been previously addressed. I've read through the FAQ post and searched the forums, and as yet haven't found anything relevant on Google so I'm hoping you folks can help. I am using SQL Server 2005 Express Edition on a fully patched Windows 2000 Server, and for some reason the database just will not start up when the machine starts or reboots. The service starts fine if I go start it by hand though. This is obnoxious because it prevents me from running fully automated updates to the box since that reboots it at least once a week on "patch Tuesday". Here are what my related services and their startup types look like: SQL Server (MSSQLSERVER) Automatic SQL Server Active Directory Helper Disabled SQL Server Browser Disabled SQL Server VSS Writer Manual This is a production machine so I'd prefer not to run any services I don't have to. All this database needs to do is sit there and get hit by a local Cold Fusion instance that talks to it by TCP/IP. Any administration on it I tend to do locally with Management Studio Express by remotely logging into the server on it's internal IP. The really weird thing is, I have these services configured exactly the same on development environments I've created in Windows XP and Windows 2003 Server Standard Edition. This seems to be specific to Windows 2000 Server, and I just can't figure it out... Any advice much appreciated!
View Replies !
SQL Server 2005 Installation Problems With SQL Server Express && SQL Server 2000
Hi Guys, I have had SQL Server Express and Sql Server Management Studio Express installed on my machine for some time and recently tried to install a trial of SQL Server 2005 as well. (Yes, I'm migrating from Visual Studio Express to Visual Studio Professional, just as in tended!) Everything went fine except that nothing seemed to be installed. I searched in all the obvious places - both on the Start/Programs menu and on the hard-drive: nothing. A check under Add/Remove Programs showed that Sql Server 2005 Express was installed, but called SQL Server 2005. So after a number of retries in which the install program kept saying that there was nothing to install, I selected every option under Advanced in the intall process. This resulted in stuff being installed and I now have SQL Server 2005 running on my machine, but no SQL Server Manager icon. My questions are: Where can I find the SQL Server Manager executeable? Has anyone installed SQL Server Express, SQL Server Mangement Studio Express, SQL Server 2005 and SQL Server Management Studio on a single machine successfully? If so, what order did you install them in? (I'm planning on uninstalling everything SXQL Server related and starting again.) Thanks very much for your help. Regards Gary
View Replies !
Problem Accessing A SQL Server 2000 Linked Server From SQL Server 2005
Hi I have created a linked server from SQL Server 2005 (SP 1) to SQL Service 2000 (SP 4) with a sql server login that is available on both servers but with different passwords and permissions. I am getting the following error while accessing the linked server in management studio based on the scenario given below ; ------ Error Message Starts OLE DB provider "SQLNCLI" for linked server "(SQL Server 2000 instance name)" returned message "Communication link failure". Msg 10054, Level 16, State 1, Line 0 TCP Provider: An existing connection was forcibly closed by the remote host. Msg 18456, Level 14, State 1, Line 0 Login failed for user 'abc'. ------ Error Message Ends Consider login name is abc. Now this login abc has sysadmin rights on sql server 2005. The same login abc has only db_datareader rights on sql server 2000 on just one database and is not associated with any fixed server role. I have configured the linked server using the following options; 1. I have tried impersonating login from SQL Server 2005 to SQL Server 2000 . 2. I have also tried specifying remote login / password option. Anyone having any idea, would be of great help. Regards, Salman Shehbaz.
View Replies !
No SQL Server Report Subscriptions Run After SQL Server 2005 Upgrade From SQL Server 2000
Hello, We had a running instance of SQL Server 2000 SP4 with SQL Server 2000 Reporting Services (SP2 I think) that had several working e-mail report subscriptions. Since the upgrade to SQL Server 2005 with SP1 the subscriptions simply do not run...no errors in the logs under "C:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesLogFiles". All of the SQL Server 2005 services are running as LocalSystem except for Integration Services and Reporting Services, which are both running as Network Service. The only place I find any errors at all is in the SQL Server Agent logs...there are a couple of jobs that are Report Server related...they both point to some kind of logon problem...'EXECUTE AS LOGIN' failed for the requested login 'NT AUTHORITYNETWORK SERVICE'. The step failed. What what do I need to do in order to get the unattended subscriptions running again? Thanks in advance, Dwight
View Replies !
Cannot Install SQL Server 2005 On A Windows 2003 Cluster In Virtual Server 2005
I am trying to install SQL 2005 in a 2-node virtual Windows 2003 cluster. I set the cluster up through Virtual Server 2005 with 2 virtual nodes and one virtual domain. The nodes can connect to each other as well as the physical machine. When I try to install a fresh copy of SQL 2005 on my cluster, I get an error every time. The error stops the installation while checking system configuration after installing prerequisites. The log file entry is as follows: ******************************************* Setup Consistency Check Report for Machine: --SERVERNAME-- ******************************************* Article: WMI Service Requirement, Result: CheckPassed Article: MSXML Requirement, Result: CheckPassed Article: Operating System Minimum Level Requirement, Result: CheckPassed Article: Operating System Service Pack Level Requirement, Result: CheckPassed Article: SQL Compatibility With Operating System, Result: CheckPassed Article: Minimum Hardware Requirement, Result: CheckPassed Article: IIS Feature Requirement, Result: Warning Description: IIS is not installed, therefore Report Server feature will be disabled Action: Install IIS in order for Report Server feature to be enabled Article: Pending Reboot Requirement, Result: CheckPassed Article: Performance Monitor Counter Requirement, Result: CheckPassed Article: Default Installation Path Permission Requirement, Result: CheckPassed Article: Internet Explorer Requirement, Result: CheckPassed Article: Check COM+ Catalogue, Result: CheckPassed Article: ASP.Net Registration Requirement, Result: CheckPassed Article: Minimum MDAC Version Requirement, Result: CheckPassed <Func Name='PerformDetections'> 1 Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlsval.dll Version:2005.90.1399.0 Error: Action "InvokeSqlSetupDllAction" threw an exception during execution. Error information reported during run: Source File Name: datastorecachedpropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:49 2005 Function Name: CachedPropertyCollection::findProperty Source Line Number: 130 ---------------------------------------------------------- Failed to find property "ComputerList" {"SqlComputers", "", ""} in cache Source File Name: datastoreclusterinfocollector.cpp Compiler Timestamp: Fri Sep 16 13:20:12 2005 Function Name: ClusterInfoCollector::collectClusterVSInfo Source Line Number: 883 ---------------------------------------------------------- Failed to detect VS info due to datastore exception. Source File Name: datastoreclustergroupsproperties.cpp Compiler Timestamp: Fri Jul 29 01:13:49 2005 Function Name: ClusterGroupScope.SharedDisks Source Line Number: 56 ---------------------------------------------------------- Failed to find a cluster group that owned shared disk: J: WinException : 2 Error Code: 0x80070002 (2) Windows Error Text: The system cannot find the file specified. Source File Name: datastoreclustergroupsproperties.cpp Compiler Timestamp: Fri Jul 29 01:13:49 2005 Function Name: ClusterGroupScope.SharedDisks Source Line Number: 56
View Replies !
Problem Installing SQL Server 2005 Express, In Windows 2000
I have downloaded SQL Server 2005 express from microsoft's site and tried to install in windows 2000 service pack 4 but having an unexpected error. The screenshot and log file is attached. Please suggest. The error log is as shown: Microsoft SQL Server 2005 Setup beginning at Fri May 05 21:36:51 2006 Process ID : 1008 e:469a4a9ba4bfdc9d2db501289fb676setup.exe Version: 2005.90.2047.0 Running: LoadResourcesAction at: 2006/4/5 21:34:50 Complete: LoadResourcesAction at: 2006/4/5 21:34:50, returned true Running: ParseBootstrapOptionsAction at: 2006/4/5 21:34:50 Loaded DLL:e:469a4a9ba4bfdc9d2db501289fb676xmlrw.dll Version:2.0.3609.0 Complete: ParseBootstrapOptionsAction at: 2006/4/5 21:36:51, returned false Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run: Could not parse command line due to datastore exception. Source File Name: utillibpersisthelpers.cpp Compiler Timestamp: Wed Oct 26 16:38:20 2005 Function Name: writeEncryptedString Source Line Number: 124 ---------------------------------------------------------- writeEncryptedString() failed Source File Name: utillibpersisthelpers.cpp Compiler Timestamp: Wed Oct 26 16:38:20 2005 Function Name: writeEncryptedString Source Line Number: 123 ---------------------------------------------------------- Error Code: 0x800706b5 (1717) Windows Error Text: The interface is unknown. Source File Name: cryptohelpercryptsameusersamemachine.cpp Compiler Timestamp: Wed Oct 26 16:37:25 2005 Function Name: sqls::CryptSameUserSameMachine::ProtectData Source Line Number: 50 1717 Could not skip Component update due to datastore exception. Source File Name: datastorecachedpropertycollection.cpp Compiler Timestamp: Wed Oct 26 16:37:20 2005 Function Name: CachedPropertyCollection::findProperty Source Line Number: 130 ---------------------------------------------------------- Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "1008"} in cache Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Wed Oct 26 16:37:21 2005 Function Name: SetupBootstrapOptionsScope.InstallMediaPath Source Line Number: 44 ---------------------------------------------------------- No collector registered for scope: "SetupBootstrapOptionsScope" Running: ValidateWinNTAction at: 2006/4/5 21:36:51 Complete: ValidateWinNTAction at: 2006/4/5 21:36:51, returned true Running: ValidateMinOSAction at: 2006/4/5 21:36:51 Complete: ValidateMinOSAction at: 2006/4/5 21:36:51, returned true Running: PerformSCCAction at: 2006/4/5 21:36:51 Complete: PerformSCCAction at: 2006/4/5 21:36:51, returned true Running: ActivateLoggingAction at: 2006/4/5 21:36:51 Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run: Datastore exception while trying to write logging properties. Source File Name: datastorecachedpropertycollection.cpp Compiler Timestamp: Wed Oct 26 16:37:20 2005 Function Name: CachedPropertyCollection::findProperty Source Line Number: 130 ---------------------------------------------------------- Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Wed Oct 26 16:37:21 2005 Function Name: SetupStateScope.primaryLogFiles Source Line Number: 44 ---------------------------------------------------------- No collector registered for scope: "SetupStateScope" 02AFCFC0Unable to proceed with setup, there was a command line parsing error. : 2 Error Code: 0x80070002 (2) Windows Error Text: The system cannot find the file specified. Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Wed Oct 26 16:37:21 2005 Function Name: SetupBootstrapOptionsScope.InstallMediaPath Source Line Number: 44 Class not registered. Failed to create CAB file due to datastore exception Source File Name: datastorecachedpropertycollection.cpp Compiler Timestamp: Wed Oct 26 16:37:20 2005 Function Name: CachedPropertyCollection::findProperty Source Line Number: 130 ---------------------------------------------------------- Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "1008"} in cache Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Wed Oct 26 16:37:21 2005 Function Name: SetupBootstrapOptionsScope.HostSetup Source Line Number: 44 ---------------------------------------------------------- No collector registered for scope: "SetupBootstrapOptionsScope" Message pump returning: 2
View Replies !
Problem Installing SQL Server 2005 Enterprise Edition On Windows Server 2003 Box
While attempting to install SQL Server 2005 Enterprise Edition on a Windows Server 2003 box, it is failing as follows... Microsoft SQL Server 2005 Setup beginning at Thu Sep 20 11:11:35 2007 Process ID : 5440 E:setup.exe Version: 2005.90.1399.0 Running: LoadResourcesAction at: 2007/8/20 11:11:35 Complete: LoadResourcesAction at: 2007/8/20 11:11:35, returned true Running: ParseBootstrapOptionsAction at: 2007/8/20 11:11:35 Loaded DLL:E:xmlrw.dll Version:2.0.3604.0 Complete: ParseBootstrapOptionsAction at: 2007/8/20 11:11:35, returned false Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run: Could not parse command line due to datastore exception. Source File Name: utillibpersisthelpers.cpp Compiler Timestamp: Fri Jul 29 01:13:55 2005 Function Name: writeEncryptedString Source Line Number: 124 ---------------------------------------------------------- writeEncryptedString() failed Source File Name: utillibpersisthelpers.cpp Compiler Timestamp: Fri Jul 29 01:13:55 2005 Function Name: writeEncryptedString Source Line Number: 123 ---------------------------------------------------------- Error Code: 0x80070002 (2) Windows Error Text: The system cannot find the file specified. Source File Name: cryptohelpercryptsameusersamemachine.cpp Compiler Timestamp: Mon Jun 13 14:30:00 2005 Function Name: sqls::CryptSameUserSameMachine:rotectData Source Line Number: 50 2 Could not skip Component update due to datastore exception. Source File Name: datastorecachedpropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:49 2005 Function Name: CachedPropertyCollection::findProperty Source Line Number: 130 ---------------------------------------------------------- Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "5440"} in cache Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:50 2005 Function Name: SetupBootstrapOptionsScope.InstallMediaPath Source Line Number: 44 ---------------------------------------------------------- No collector registered for scope: "SetupBootstrapOptionsScope" Running: ValidateWinNTAction at: 2007/8/20 11:11:35 Complete: ValidateWinNTAction at: 2007/8/20 11:11:35, returned true Running: ValidateMinOSAction at: 2007/8/20 11:11:35 Complete: ValidateMinOSAction at: 2007/8/20 11:11:35, returned true Running: PerformSCCAction at: 2007/8/20 11:11:35 Complete: PerformSCCAction at: 2007/8/20 11:11:35, returned true Running: ActivateLoggingAction at: 2007/8/20 11:11:35 Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run: Datastore exception while trying to write logging properties. Source File Name: datastorecachedpropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:49 2005 Function Name: CachedPropertyCollection::findProperty Source Line Number: 130 ---------------------------------------------------------- Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:50 2005 Function Name: SetupStateScope.primaryLogFiles Source Line Number: 44 ---------------------------------------------------------- No collector registered for scope: "SetupStateScope" 00CFCFC8Unable to proceed with setup, there was a command line parsing error. : 2 Error Code: 0x80070002 (2) Windows Error Text: The system cannot find the file specified. Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:50 2005 Function Name: SetupBootstrapOptionsScope.InstallMediaPath Source Line Number: 44 Failed to create CAB file due to datastore exception Source File Name: datastorecachedpropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:49 2005 Function Name: CachedPropertyCollection::findProperty Source Line Number: 130 ---------------------------------------------------------- Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "5440"} in cache Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:50 2005 Function Name: SetupBootstrapOptionsScope.HostSetup Source Line Number: 44 ---------------------------------------------------------- No collector registered for scope: "SetupBootstrapOptionsScope" Message pump returning: 2 Any ideas? Thanks in advance.
View Replies !
Server Switched To Windows Auth Only After SQL Server 2005 SP2a And KB933508 Upgrade
Last night I upgraded one of our development machines to SQL Server 2005 SP2a + KB933508. The server I did this on had 2 instances of SQL Server installed. After the upgrade, one of the instances was left in Windows Authentication mode instead of Mixed Mode. Looking at the logs I can determine that it was the SP2a upgrade that did it. There was a brief time interval between the two where logins were logged as failed in the SQL Log. Have any of you ever ran into this?
View Replies !
Windows Server 2008 Enterprise && SQL Server 2005 Express Reporting Services
Does anyone know how to properly install SQL server 2005 express reporting services on windows server 2008. Whenever i try to access the report manager I get an error "Cannot access the remote server" even though the report server is on the local machine. I only have the web server role installed on the server. Im still quite a newbie at managing servers so please keep it as simple as possible. Thanks Matthew
View Replies !
SQL Server Reporting Services 2005 Service Would Not Start On Windows Server 2003
SQL Server Reporting Services 2005 Service would not Start on windows server 2003. Working great till yesterday and no changes were made to config file. Here is the error in Event log Event Type: Error Event Source: SQL Server Report Service Event Category: None Event ID: 0 Date: 12/13/2007 Time: 8:25:59 AM User: N/A Computer: XXXXXXXXXXX Description: Service cannot be started. Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information. at Microsoft.ReportingServices.Library.ServiceAppDomainController.Start(Boolean firstTime) at Microsoft.ReportingServices.NTService.ReportService.OnStart(String[] args) at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state) For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. Here is i found in log files ReportingServicesService!resourceutilities!4!12/13/2007-08:25:59:: i INFO: Running on 0 physical processors, 1 logical processors ReportingServicesService!servicecontroller!4!12/13/2007-08:25:59:: e ERROR: Exception caught loading and setting code permissions policy level: System.Security.XmlSyntaxException: Invalid syntax on line 158. at System.Security.Util.Parser.GetRequiredSizes(TokenizerStream stream, Int32& index) at System.Security.Util.Parser.ParseContents() at System.Security.Util.Parser..ctor(Tokenizer t) at System.Security.SecurityManager.LoadPolicyLevelFromStringHelper(String str, String path, PolicyLevelType type) at System.Security.SecurityManager.LoadPolicyLevelFromString(String str, PolicyLevelType type) at Microsoft.ReportingServices.Library.ServiceController.SetAppDomainPolicy() ReportingServicesService!servicecontroller!4!12/13/2007-08:25:59:: e ERROR: Error Starting Service: System.Security.XmlSyntaxException: Invalid syntax on line 158. at System.Security.Util.Parser.GetRequiredSizes(TokenizerStream stream, Int32& index) at System.Security.Util.Parser.ParseContents() at System.Security.Util.Parser..ctor(Tokenizer t) at System.Security.SecurityManager.LoadPolicyLevelFromStringHelper(String str, String path, PolicyLevelType type) at System.Security.SecurityManager.LoadPolicyLevelFromString(String str, PolicyLevelType type) at Microsoft.ReportingServices.Library.ServiceController.SetAppDomainPolicy() at Microsoft.ReportingServices.Library.ServiceController.StartService(Boolean firstStart)
View Replies !
How Do I Connect Client Machines To SQL Server 2005 Installed On A Windows 2003 Server
I am new to SQL server 2005 Windows 2003 Server and all client PCs are all on the same network. I installed SQL 2005 std version on windows server 2003 and created a database and tables in it. I have two users, who want to connect to SQL server 2005 from their PCs (they have windows XP): These are two things that I need to facilitate: 1) They want to be able to write queries using Query Designer and run from their PCs. 2) I created an MS Access database on my PC, I want to use Access database as a front end to the SQL server database. I will create queries, forms in Access DB, and I want to be able to get the data from SQL server Database to do this. I guess I can use ODBC to connect to tables in SQL server database. 3) I want to connect SQL server to Oracle database, and run oracle stored procedures. I want to load the results of oracle stored procedures into SQL server database tables. I guess I will use IIS for this. Any suggestions are appreciated, especially with item number 1.
View Replies !
Distributed Transaction Does Not Work With SQL Server 2005 On Windows Server 2003
Hi,I'm having problems trying to put triggers working between SQL Server 2005 connected by linked servers.I'm using two SqlServer 2005 both running on Windows Server 2003 Standard Edition SP1.Both doesn't belongs to a Domain. They are configured in they own workgroup. Microsoft SQL Server Management Studio 9.00.2047.00Microsoft Analysis Services Client Tools 2005.090.2047.00Microsoft Data Access Components (MDAC) 2000.086.1830.00 (srv03_sp1_rtm.050324-1447)Microsoft MSXML 2.6 3.0 5.0 6.0 Microsoft Internet Explorer 6.0.3790.1830Microsoft .NET Framework 2.0.50727.42Operating System 5.2.3790MSDTC version 5.2.3790.1830 What I checked on both servers: - Service "Remote Procedure Call" is running using the account "NT AUTHORITYNetworkService"; - On Component Services -> Computer -> My Computer Properties -> tab MSDTC -> Security Configuration all box are checked. On the Transaction Manager Communication the chosen is "No Authentication is Required". - On Local Computer Policy -> Administrative Templates -> System -> Remote Procedure Call the "Restriction for Unauthenticated RPC clients" is enabled and the restriction to apply is "None". - Windows Firewall is disabled - Registry key is set to HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSDTCTurnOffRpcSecurity is set to "1" Schema on server [myServer2]: USE [myDB]GOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[myTable]( [code] [varchar](5) NOT NULL, [name] [varchar](10) NULL,PRIMARY KEY CLUSTERED ( [code] ASC)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFF SQLStatement run on server [myServer1] begin distributed transactioninsert into [myServer2].myDB.dbo.myTable values ('ACD','LX')commit transaction The error message: OLE DB provider "SQLNCLI" for linked server "myServer2" returned message "No transaction is active.".Msg 7391, Level 16, State 2, Line 2The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "myServer2" was unable to begin a distributed transaction. Some one can help me find the problem?Thank you in advanceJoao
View Replies !
Problems Connecting To SQL Server 2005 SP2 On Windows Server 2008 (both 64bit)
Hi All, After I installed sql server 2005 64bit standard edition on Windows Server Enterprise 2008 64bit, I cannot connect to the sql instance using the sql management studio on the same machine! I verified that: service is running, in surface area configuration: remote connections to local and remote are enabled, for TCP/IP and named pipes. ran the command netstat -avn| findstr 49279 to make sure that the server is listening. firewall is off, but this does not matter since I'm connecting locally to local instance I'm using domain controller account to login to sql server / also tried the sa account. what else can be wrong? thanks.
View Replies !
Installed SQL Server 2005 In Existing Windows 2003 Domain Server
I would like to ask if it is advisable to install SQL Server 2005 in the existing Windows 2003 Domain Server? Currently our Windows 2003 standard sp2 server has managing multiple server roles which is the File Server, Domain Controller (Active Directory) and DNS Server. Now my co-I.T. installed an SQL Server 2005 in our primary domain server. Here's the problem, a client domain computers(workstation) we are having problem when we log-in, it is very slow when i login. it seems the setting of the AD or DNS was affected or maybe the services. I don't know if SQL Server 2005 are having issues or conflicts into AD, DNS or services.Can somebody give me some advice to this matters. Thanks, razorbex
View Replies !
SQL Server 2005 Express With Reporting Services On Windows Server 2008 X64
I am attempting to install SQL Server 2005 Express with Reporting Services on a fresh install of Windows Server 2008 x64 Standard Edition. Following the installation, the /reports virtual directory does not exist and the configuration option in Reporting Services Configuration for that virtual directory is disabled. I have found numerous articles related to installing Reporting Services on Windows Server 2008, and on x64 Windows, but none on x64 Windows Server 2008. Here is the background: Prior to starting the installation I ran the following two commands in order to get all of the prerequisites installed: ServerManagerCmd -install NET-Framework-Core call start /w %SYSTEMDRIVE%windowssystem32pkgmgr /l:log.etw /iu:IIS-WebServerRole;IIS-WebServer;IIS-CommonHttpFeatures;IIS-StaticContent;IIS-DefaultDocument;IIS-DirectoryBrowsing;IIS-HttpErrors;IIS-HttpRedirect;IIS-ApplicationDevelopment;IIS-ASPNET;IIS-NetFxExtensibility;IIS-ASP;IIS-CGI;IIS-ISAPIExtensions;IIS-ISAPIFilter;IIS-ServerSideIncludes;IIS-HealthAndDiagnostics;IIS-HttpLogging;IIS-LoggingLibraries;IIS-RequestMonitor;IIS-HttpTracing;IIS-CustomLogging;IIS-ODBCLogging;IIS-Security;IIS-BasicAuthentication;IIS-WindowsAuthentication;IIS-DigestAuthentication;IIS-ClientCertificateMappingAuthentication;IIS-IISCertificateMappingAuthentication;IIS-URLAuthorization;IIS-RequestFiltering;IIS-IPSecurity;IIS-Performance;IIS-HttpCompressionStatic;IIS-HttpCompressionDynamic;IIS-WebServerManagementTools;IIS-ManagementConsole;IIS-ManagementScriptingTools;IIS-ManagementService;IIS-IIS6ManagementCompatibility;IIS-Metabase;IIS-WMICompatibility;IIS-LegacyScripts;IIS-LegacySnapIn;IIS-FTPPublishingService;IIS-FTPServer;IIS-FTPManagement;WAS-WindowsActivationService;WAS-ProcessModel;WAS-NetFxEnvironment;WAS-ConfigurationAPI I then attempted to run the setup (SQLEXPR_ADV.EXE) but received the following warning: "64-bit ASP .Net is Registered. Required 32-bit ASP .Net to install Microsoft Reporting Service 2005 (32.bit)" The following command solved this problem (as seen on http://msdn2.microsoft.com/en-us/library/ms143293.aspx): cscript %SystemDrive%inetpubAdminScriptsadsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 1 I then attempted to run setup again and this time failed during the final installation, complaining about sqlncli_x64.msi missing. The excellent forum post at http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=3025706&SiteID=17 got me past this problem. In a nutshell, the installer installs the wrong version of the SQL Native Client and you must manually install the 64-bit version of the SQL Native Client after starting the SQL Express installer. Finally, everything installed correctly but as mentioned in the beginning of this post the Reports virtual directory does not exist and the configuration options related to the virtual directory are disabled in Reporting Services Configuration. The ReportServer virtual directory is available and functions correctly. Any procedures available from somebody who has done this? Am I better off just installing the Standard version of SQL 2005 instead of Express?
View Replies !
|
TRACKER
