Windows 2003 Memory Question

Mar 10, 2004

Hi all, new to the forum.

I am in the process of building a 3+1 Win2k3 cluster with SQL 2000. Once I got through all the funky install issues, everything is running great. In fact, working with the new cluster services has been such a breath of fresh air compared even to Win2K. The SAN abilities of W2K3 with on the fly drive additions and such are just awesome.

Anyway, the issue I am seeing has to do with memory. The boxes all have 8gb. First thing I noticed was Win2K3 seems to automatically enable the /PAE option. It's not in the boot.ini but the server "knows" it is using AWE support, which is fine. What confuses me is if I give SQL (awe enabled) a fixed 7.5gb of RAM to play with, it seems to actually use it, without the 3gb option or any regard for the OS. I was able to push it to 7.9gb leaving the OS about 50mb and it allowed it, or at least it looks like it allows it. Target and total memory counters for SQL Memory show it using the full 7.9gb, but taskmgr shows SQL using 80mb. I seem to remember reading that this is normal somewhere; taskmgr can't accurate display memory use. The available physical memory in taskmgr does reflect that all physical ram is in use.

Adding the PAE and 3GB options to the boot.ini appears to have made no impact. Almost like they were already there anyway?

Can anyone explain Win2k3 and SQL 2000 memory stuff to me? I feel dumb right now.

Thanks!

View 4 Replies


ADVERTISEMENT

4 GB Memory For SQL 2005 Std + Windows 2003 Std

Jul 31, 2007

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 1 Replies View Related

SQL 2000 On Windows 2003 Memory Limits

Mar 11, 2004

Can anyone confirm that SQL 2000 Standard Edition is still limited to 2GB of memory utilization on Windows 2003 Server?

In addition, anyone have suggestions for deploying SQL 2000 on Windows 2003?

TIA

View 1 Replies View Related

Memory Setting In SQL 2005 In Windows 2003

May 4, 2007

We have a SQL 2005 installed in Windows 2003 64 bit system, which has 16 CPU and 32GB RAM, but the performance is poor. SQL server is AWE enable and the sql start account with "Lock Pages In Memory". I checked the task manager and it looks that the SQL server used only about 300 MB memory. Here is what I found:

http://blogs.msdn.com/psssql/archive/2006/11/28/sql-server-becomes-sluggish-or-appears-to-stall-on-64-bit-installations.aspx?CommentPosted=true#commentmessage

What I need to do?



Thanks



View 5 Replies View Related

Memory Sizing For A SQL 2000 Cluster - Windows 2003 Enterprise SP1

Oct 4, 2007



I am looking for some recommendations for memory sizing and options for a SQL 2000 Cluster. This is a two node cluster built on Windows 2003 ENT SP1 (x86). Both the nodes have the following hardware:

- 4 x Dual Core AMD Processors
- 16 GB Memory
- EMC Shared Disk

We are running six SQL 2000 instances and don't expect each of these instances to use more than 1.7 GB of memory. All these instances are going to support BizTalk 2004 Databases. I already have /PAE enabled on the nodes. I am looking for the following answers:

- Do I need to enable AWE on all the instances even if the instances ? Currently, we don't have that enabled and we have seen some issues regarding excessive paging even when there is physical memory available. The DBAs think that we don't need to enable AWE. I am bit confused on this one.

- We normally run 3 instances on each node and would like size the cluster in such a way that it can take six instances in case of a node failure

Any input will be highly appreciated.

View 4 Replies View Related

Setting Memory Values For SQL 2005 Standard (32 Bit) On Windows 2003 Server 64 Bit.

Aug 3, 2007

Hi,

I am testing SQL 2005 Standard (32 bit) on a Windows 2003 Server 64 bit with 8GB of RAM? Should I enable the AWP Setting or not and should I change the maximum server memory (currently saying 2GB)?

Thanks!
Tom

View 1 Replies View Related

Connection Problem To Sql 2000 On Windows 2003 From Windows 95

Jul 20, 2005

Hi all,I have a Windows 2003 server, which is also a terminal server forapplication, with sql 2000 installed. My company has developed anapplication that uses SQL 2000 as its database. The application is aclient/server one. In each client computer there's a link to theapplication on the server. There is no problem with Windows 98,Windows 2000 pro, Windows xp pro clients, but the windows 95 onescannot log in to the database. The log of the application shows thefollowing error:connection error -2147467259. Cannot open database requested in login'database name'. Login fails.Till a week ago the application was running on a Windows 2000 serverwith SQL 2000 install and the W95 clients had no problem connecting tothe database, so my guess is the error has something to do withWindows 2003 server, but what'causing the error?I tried to install a newer version of MDAC (MDAC 2.5, the last versionof MDAC you can install on W95)but with no success. By the way W95clients have no problem accessing shared folder on the Windows 2003server.Any idea?ThanksMarino

View 1 Replies View Related

MSSQL For 64-Bit OS (Windows 2003 64-Bit)

May 28, 2003

Is there anyway We could install a MSSQL server 2000 32-Bit in the Windows 2003 Server 64-Bit? Or Any Solution? Or is there any Evaluation Copy we could get from microsoft of 64-bit MSSQL Server? Please help i am lost in 64-Bit MSSQL. Coz my company recently upgraded to 64-bit Windows 2003 sit on a Itatium 2

View 6 Replies View Related

MSDE Windows 2003

Oct 3, 2005

Hi,

Got a problem with network access for MSDE on Win2003 SBS. I have tried all the usual stuff (SVRNETCN, firewall check) to get windows to open the port for network access, but I am having no luck.

Thought it maybe something to do with win2003 "increased" security.. so check the IPSec policy but nothing looks like it is assigned, plus I could also be checking the wrong policy.

As you can probably tell I know only little bits about server, policies and everything that goes with it (I normally work with the lovely pre setup database) but guess its time I should learn.

So with my small and probably dangerous knowledge can someone please let me know if I am looking in the right area for allowing port 1433 to open for MSDE? If I am how to I edit the policy to allow something to run accross the network?

Basic Server Stats

O/S: Windows 2003 Small Business Server Standard (all updates +sp)
NIC: One gigabit (know win2003 recommends 2)
Hardware: Hugly over the minimum spec!!

MSDE: 3* instances (2 pre installed - SBSMonitoring, SharePoint and 1 user defined that needs sharing)

Thanks so much for any help, background information on group policies and alike would be nice to know as well, but don't worry too much about that!

View 1 Replies View Related

Windows 2003 Server

Jan 23, 2008

Hello, pls Some of my factory guys can log on the same user name at the same time, so I want a situation where a user name may be able to log on, one at a time. Whoever that is reading this, note this is not a misplacement, this is the fact that I don't have means of solving it, I am also of opinion that some have full knowledge of windows 2003 server

View 1 Replies View Related

Windows 2003 Server

Apr 22, 2004

I have SQL 2k on a W2003 Server.
I have SP3 installed.
My problem is that i cant connect to the server via telnet:

"C:>telnet localhost 1433
Connecting to localhost...Could not open connection to the host, on port 1433: Connect failed."

I try telnet 127.0.0.1 also.
In the Server Network Utility TCP/IP is ENABLED and the port number is 1433.

Who can help me?
(Sorry for my english)

View 2 Replies View Related

SQl With Windows Server 2003 SBS R2

Nov 25, 2006

We have purchased Windows 2003 Small Business Edition Premium.

Our company uses Analysis Manager / Analysis Services and also MDX functions. However Release2 only appears to have SQL 2005 Workgroup edition with it and these features do not seem to be present.

Does anybody know how I upgrade to get these functions? I don’t know if these functions can be downloaded or whether we have to upgrade by purchasing SQL Server Standard 2005 edition outright?

Thanks, Stephen.

View 1 Replies View Related

Sql 2000 With Windows 2003

Jul 23, 2005

When windows 2003 server is not log on to the domain, SQL worksfine.(workgroup) Everyone can connect to SQL. When everyone is on thedomain, nothing can connect remotely to SQL.

View 1 Replies View Related

Windows 2003 Server And ASP

Jul 23, 2005

Hi,I am unable to connect to a database in my SQL 2000 Server installed ona Windows 2003 Server machine from an asp page. It gives the thefollowing error:Microsoft OLE DB Provider for SQL Server (0x80004005)Login failed for user 'sa'. Reason: Not associated with a trusted SQLServer connection.I also sometimes get:MSDataShape (0x80004005)Data provider could not be initialized.I can connect with the same connection string and parameters from avisual basic 6 application.I can also connect the web client with the same DB in SQL 2000 runningon Windows 2000/XP.The authentication mode is mixed.I believe it is something to do with security. Please advise me on whatto do. It is very urgent.

View 11 Replies View Related

Sql2k With Windows 2003 SBS

Jul 20, 2005

I uninstalled the SQL and trying to install back and getting this error:SETUP FAIL TO CONFIGURE THE SERVER. REFER TO THE SERVER LOGS ANDC:WINDOWSSQLSTP.LOGI ;looked at sqlstp.log and there are some errors and all are SSL SECURITYERROR.H ow to fix it ?Thanks

View 1 Replies View Related

Reg Windows Svr Ent 2003 R2 English MVL

Mar 30, 2007

Hi,



I have purchased windows Srv Ent 2003 R2 English MVL license is it 32 bit or 64 bit? will it run on HP DL580 G4/(1) Dual-Core 64-bit Intel® Xeon„˘ 7110M Processor (2.60 GHz, 95 Watts, 800MHz FSB) ?



Pls reply urgently.



Thanks

View 4 Replies View Related

SQL 7.0 On Windows 2003 Server

Oct 19, 2006

Hi,

I have a client requiring SQL 7.0 installed on Windows 2003 Server Std. Just wondering if its supported and possible to install SQL 97 on Windows 2003 servers.

Thanks

View 1 Replies View Related

SQL Server 2005 Workgroup Edition In SBS 2003 R2 Max Memory Question

Feb 11, 2007

We have only a small busines and haven't got too much experience with servers and now have a proliant server coming in with SBS 2003 R2 Premium with the 4 GB max memory that SBS 2003 can handle according to the specs.

We weren't planning on using the SQL 2005 worlgroup edition up till now, but now we might. According to the specs of SQL server 2005 workgroup edition however, it has a max RAM of 3GB!

Is this going to be a problem and should we keep using our previous DB, or can we migrate toward SQL server with the 4 GB of RAM?

View 2 Replies View Related

SQL 2000 Authentication From Windows 2003

Jul 27, 2006

I'm working on deploying an ASP.NET 2.0 app onto a Windows 2003 server and I'm having trouble with SQL 2000 authentication. When I run my app from my development box running IIS 5.1 I have no problems. In order to get it to work on my this machine, I had set the account for anonymous access to run under an ASPNETDOMAIN account and configured my SQL database to allow this account.On the Windows 2003 box with IIS 6.0, I've done the same thing with anonymous access for the web app, and also created an application pool that the app runs under and have set the application pool to run under the same account. It appears the app is looking for a local SQL 2005 instance (which doesn't exist). Why would it do this and what do I need to change for this to work?Error: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: SQL Network Interfaces, error: 26
- Error Locating Server/Instance Specified)Stack Trace:[SqlException (0x80131904): 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +735043 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188 System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup) +820 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +130 System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) +27 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +47 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 System.Web.Management.SqlServices.GetSqlConnection(String server, String user, String password, Boolean trusted, String connectionString) +68

View 2 Replies View Related

Server 2000 And Windows 2003

Oct 26, 2004

Hello y'all,
I have to do a new install of SERVER 2000 using WINDOWS 2003 . Has anyone done this. If so, what are the steps. Should I expect any problems ? Any help appreciated.
Thanx

View 1 Replies View Related

MSDE2000A + Windows 2003 Server

Jan 15, 2004

I have been searching the net and haven't found anything that has worked so far for resolving this issue, hopefully someone on here can provide some insight?

I did a fresh install of a Windows 2003 Standard Edition server (as part of a workgroup, not a domain..the server is only temporary for testing) and installed MSDE 2000A (the version that contains all current service packs). I can use the MSDE server locally on the server without any issue...however when I try to connect to MSDE with a workstation, it tells me that Access is denied or the Server does not exist.

The ICF is disabled, and all passowrds being entered have been checked, however I still can not connect to the sql server. Does anyone have any ideas on this or run into this problem before?

View 2 Replies View Related

Windows Server 2003 Freezes

Mar 7, 2008

Set up - windows server 2003 - SQL server 2000 + tools installed

Not sure why its happening but recently when running some scripts onto one of the databases held on the server windows crashes.

I say crashes - it is non responsive but the mouse cursor can be moved.

these scripts are not being run from the server but from one of many machines on our companies network.

Any suggestions would be great

View 1 Replies View Related

SQL Server 2000 And Windows 2003 SBS

Jul 23, 2005

I have XP workstations and windows 2003 SBS. I setup an ODBC for anapplication (tried both User and System DSN), but after a few usage, I getthe following error:Connection failed:SQLState: 'HY000'SQL Server Error: 0[Microsoft][ODBC SQL Server Driver]Cannot generate SSPI context.Any ideas? Is this a bug?--Thank youPlease post only

View 3 Replies View Related

MSDE2000A + Windows 2003 Server

Jul 20, 2005

I have been searching the net and haven't found anything that hasworked so far for resolving this issue, hopefully someone on here canprovide some insight?I did a fresh install of a Windows 2003 Standard Edition server (aspart of a workgroup, not a domain..the server is only temporary fortesting) and installed MSDE 2000A (the version that contains allcurrent service packs). I can use the MSDE server locally on theserver without any issue...however when I try to connect to MSDE witha workstation, it tells me that Access is denied or the Server doesnot exist.The ICF is disabled, and all passowrds being entered have beenchecked, however I still can not connect to the sql server. Doesanyone have any ideas on this or run into this problem before?

View 1 Replies View Related

MS SQL 2000 And Windows 2003 Cluster

Jul 20, 2005

I installed MS SQL 2000 on a Windows 2003 server cluster (no servicepacks). Both nodes are online and both domain controllers are online.I tried to install SP3 and got the following error:--------------Logon Account could not be validated.No authority could be contacted for authentication.---------------I installed SQL SP 2 and did not get the error but I do get it everytime I try to install SP3.Does anybody have an idea that might help resolve the problem.

View 2 Replies View Related

NFS Between Unix And Windows Server 2003 R2

Jan 18, 2008

I have a windows server 2003 R2 sharing a filesystem using NFS. I have created a group and passwd file and mapped the ids' to the unix login ids' . I', able to mount but when I try to cd to the directory I get "NFS access failed for server testsrvr: RPC: Authentication error". On the win2k3 server I'm getting an event error "There was a mapping failure". I have the Admin id on the win2k3 server mapped to the unix root login .

View 1 Replies View Related

MS SQL 2005 + Windows Server 2003 SP2

Jul 13, 2007

At first I thought it was just me, but has anyone else noticed that SQL 2005 suffers a performance hit when you install Windows Server 2003 SP2?



Since SP2, memory and hard drive usage has gone through the roof on a number of servers I use. It may just be coincidence... but it seems unlikely.

View 6 Replies View Related

Windows 2003 SP2 Is NOT A Supported OS For SQL 2005 SP2???

Apr 5, 2007

Maybe this is just an oversight in the documentation? Here it is for all to see on the download page for SQL 2005 SP2:

http://tinyurl.com/35nunk

Note the supported operating systems:

Windows 2000 Service Pack 4; Windows Server 2003 Service Pack 1; Windows Vista; Windows XP Service Pack 2

NO mention of Windows 2003 Service Pack 2, but Windows 2003 Service Pack 1 is specifically mentioned.

Any ideas on this one? Thanks!

Chris

View 4 Replies View Related

Windows Server 2003 Query

Nov 12, 2006

I am following the MCTS Self-Paced Training Kit for Exam 70-431 (implementation and maintenance of sql server 2005) and one of the prerequisites is that I have Microsoft Windows Server 2003 running on my computer on an NTFS file system (NTFS) partition. Now am I right in thinking Windows Server 2003 is an operating system. If it is can I install it alongside XP Professional which I am currently running. I am currently afraid to go ahead with the installation as I am worried it will overwrite XP, which would be disastrous as I have a great deal of data on it.

Thanks

vik

View 4 Replies View Related

How To Run Two Sql Servers On One Windows Server 2003

Nov 13, 2007

I have a problem i have been working on moving sql2000 databases to 2005.
I have two servers running on one machine.
Is there a way to make my 2005 server a default server

I want to make 2005 a default server instead of 2000.
Because in my connection string from the applications i connect to server using external ip & it's connecting to 2000 instead of 2005.

How can i solve this problem

let me know
thanks

View 7 Replies View Related

Setup New User On Windows 2003

Jun 21, 2007

Hi,



Is it possible to create a new user into Windows 2003 users table (not Sql) through a sql 2005 query ?



I ask this because I forgot the admin password of the Windows 2003 server and this is in a remote location, so I though, since I have the admin password of SQL 2005 server, maybe it could help me to log onto Windows 2003 and reset windows admin password.



Any help would be eternally appreciated



Regards.



George

View 4 Replies View Related

SQL Server, Windows 2003, And ASP Problem

Apr 2, 2007

I have SQL Server 2000 running on Windows 2003 Server. I have Windows 2000 Server running IIS. I am trying to connect my asp running on 2000 to my SQL Server running on 2003, but I run into the problem when I have to machines connecting to the database. The first machine works, but the second machine comes up with the page is not found. When the first machine is done with getting the data, I am able to refresh on the second machine and it works. Some reason it is only allowing one connection at a time on the same database. Any help would be greatly appreciated. Thanks

View 2 Replies View Related

Mail Setup On Windows Server 2003 ?

May 6, 2005

Wondering if there is a different way to setup mail because of Windows Server 2003 instead of Windows Server 2000? The server I'm being asked to get mail working on will have an exchange email account and I'm not familiar with setting this up. On my 2000 machine I had to use Outlook 2000 with option for Corporate or Workgroup an a POP email account. Any help is appreciated.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved