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
ADVERTISEMENT
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
Apr 22, 2006
Good Day,
I have an application that is being developed on Visual Studio 2005 (VB) and SQL Express. The application is set up to use the SQL Express on the development computer, and if an Internet or CD install is built, it installs SQL Express as expected. The question is, when it is time to deploy and put the SQL Express database on the 2003 server, how should the install on the server be done and how should we set the database path to the server?
Thanks,
Dave
View 1 Replies
View Related
Aug 14, 2006
Hi All,
I need a hand here, referring to this knowledge base on Microsoft (http://support.microsoft.com/default.aspx?scid=kb;en-us;Q283811) i applied this knowledge base, and it worked, the MSSQL and SQLSERVERAGENT have run under local non admin account.
But after i installed SP1, MSSQL service is ok, but SQLSERVERAGENT wont run. The warning message is : "Some service run and then stop if they have no work to do."
Is there any way i can install SP1 but in the same time run SQLSERVERAGENT under local non admin account?
Your assistance will be much appreciated
thank you very much in advance.
Felix Adhitya
View 4 Replies
View Related
Nov 24, 2004
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 4 Replies
View Related
Aug 17, 2006
Hello Experts,
I have been unable to install SQL Express 2005 Server on my Windows 2003 Server (with SP2 installed). I keep getting an error message saying that Microsoft Windows Installer 3.1 is not installed.
Click here for image
So, I downloaded Microsoft Windows Installer 3.1 v2 (WindowsInstaller-KB893803-v2-x86.exe) but whenever I try to install it I get an error message saying that "the Service Pack version of this system is newer than the update you are applying" and that there is no need to install the update and it stops there.
Click here for image
Is there a workaround to this? How can I get Microsoft Windows Installer 3.1 installed? I tried going to the Windows Update site, I already have everything installed and I even started the Windows Installer service manually. Has anyone else experienced this?
How can I get SQL Server 2005 Express installed if not how can I install SQL Server 2000 on tihs machine? The only reason I am trying to install SQL Server 2005 is because wanted to try it so I uninstalled SQL Server 2000 now I can no longer install SQL Server 2000 again because it won't let me because of the SP2 patch.
Help! :(
View 1 Replies
View Related
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
Dec 28, 2003
I can not install SQl 2000 on my new win 2003 server.
It says: setup failed to configure the server.
What should I do?
This is my Sqlstp.log file
01:51:11 Begin Setup
01:51:11 8.00.194
01:51:11 Mode = Normal
01:51:11 ModeType = NORMAL
01:51:11 GetDefinitionEx returned: 0, Extended: 0x0
01:51:11 ValueFTS returned: 1
01:51:11 ValuePID returned: 1
01:51:11 ValueLic returned: 1
01:51:11 System: Windows NT Terminal Server
01:51:11 SQL Server ProductType: Standard Edition [0x2]
01:51:11 Begin Action: SetupInitialize
01:51:11 End Action SetupInitialize
01:51:11 Begin Action: SetupInstall
01:51:11 Reading SoftwareMicrosoftWindowsCurrentVersionCommonFi
lesDir ...
01:51:11 CommonFilesDir=C:Program FilesCommon Files
01:51:11 Windows Directory=C:WINDOWS
01:51:11 Program Files=C:Program Files
01:51:11 TEMPDIR=C:WINDOWSTEMP
01:51:11 Begin Action: SetupInstall
01:51:11 digpid size : 256
01:51:11 digpid size : 164
01:51:11 Begin Action: CheckFixedRequirements
01:51:11 Platform ID: 0xf00
01:51:11 Version: 5.2.3790
01:51:11 File Version - C:WINDOWSsystem32shdocvw.dll: 6.0.3790.94
01:51:11 End Action: CheckFixedRequirements
01:51:11 Begin Action: ShowDialogs
01:51:11 Initial Dialog Mask: 0x183000f7, Disable Back=0x1
01:51:11 Begin Action ShowDialogsHlpr: 0x1
01:51:11 Begin Action: DialogShowSdWelcome
01:51:12 End Action DialogShowSdWelcome
01:51:12 Dialog 0x1 returned: 1
01:51:12 End Action ShowDialogsHlpr
01:51:12 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
01:51:12 Begin Action ShowDialogsHlpr: 0x2
01:51:12 Begin Action: DialogShowSdMachineName
01:51:14 ShowDlgMachine returned: 1
01:51:14 Name = ETOUCHHOST, Type = 0x1
01:51:14 Begin Action: CheckRequirements
01:51:14 Processor Architecture: x86 (Pentium)
01:51:14 ComputerName: ETOUCHHOST
01:51:14 User Name: Administrator
01:51:14 IsAllAccessAllowed returned: 1
01:51:14 OS Language: 0xc09
01:51:14 End Action CheckRequirements
01:51:14 This combination of Package and Operating System allows a full product install.
01:51:14 CreateSetupTopology(ETOUCHHOST), Handle : 0x1134168, returned : 0
01:51:14 CreateSetupTopology returned : 0, Handle : 0x1134168
01:51:14 Topology Type : 1, Return Value : 0
01:51:14 ST_GetPhysicalNode returned : 0, PNHandle : 0x11341b8
01:51:14 PN_EnumerateEx returned : 0
01:51:14 PN_GetSQLStates returned : 0, SqlStates : 0x0
01:51:14 PN_StartScan [0x11341b8] returned : 0
01:51:14 PN_GetNext [0x11341b8] returned : 18, Handle: [0x0]
01:51:14 No more items in enumeration.
01:51:14 ReleaseSetupTopology
01:51:14 Named instance limit: 100, quota: 0
01:51:14 End Action DialogShowSdMachineName
01:51:14 begin ShowDialogsUpdateMask
01:51:14 nFullMask = 0x183000f7, nCurrent = 0x2, nDirection = 0
01:51:14 Updated Dialog Mask: 0xbf00037, Disable Back = 0x1
01:51:14 Dialog 0x2 returned: 0
01:51:14 End Action ShowDialogsHlpr
01:51:14 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
01:51:14 Begin Action ShowDialogsHlpr: 0x4
01:51:14 Begin Action: DialogShowSdInstallMode
01:51:15 ShowDlgInstallMode returned: 1
01:51:15 InstallMode : 0x1
01:51:15 End Action DialogShowSdInstallMode
01:51:15 begin ShowDialogsUpdateMask
01:51:15 nFullMask = 0xbf00037, nCurrent = 0x4, nDirection = 1
01:51:15 Updated Dialog Mask: 0x1bf40037, Disable Back = 0x1
01:51:15 Dialog 0x4 returned: 1
01:51:15 End Action ShowDialogsHlpr
01:51:15 ShowDialogsGetDialog returned: nCurrent=0x10,index=4
01:51:15 Begin Action ShowDialogsHlpr: 0x10
01:51:15 Begin Action: DialogShowSdRegisterUserEx
01:51:24 End Action DialogShowSdRegisterUserEx
01:51:24 Dialog 0x10 returned: 1
01:51:24 End Action ShowDialogsHlpr
01:51:24 ShowDialogsGetDialog returned: nCurrent=0x20,index=5
01:51:24 Begin Action ShowDialogsHlpr: 0x20
01:51:24 Begin Action: DialogShowSdLicense
01:51:27 End Action DialogShowSdLicense
01:51:27 Dialog 0x20 returned: 1
01:51:27 End Action ShowDialogsHlpr
01:51:27 ShowDialogsGetDialog returned: nCurrent=0x40000,index=18
01:51:27 Begin Action ShowDialogsHlpr: 0x40000
01:51:27 Begin Action: DialogShowSdCliSvr
01:51:27 DisplaySystemPreReq
01:51:28 ShowDlgClientServerSelect returned: 1
01:51:28 Type : 0x2
01:51:28 End Action DialogShowSdCliSvr
01:51:28 begin ShowDialogsUpdateMask
01:51:28 nFullMask = 0x1bf40037, nCurrent = 0x40000, nDirection = 1
01:51:28 Updated Dialog Mask: 0x1bfc0037, Disable Back = 0x1
01:51:28 Dialog 0x40000 returned: 1
01:51:28 End Action ShowDialogsHlpr
01:51:28 ShowDialogsGetDialog returned: nCurrent=0x80000,index=19
01:51:28 Begin Action ShowDialogsHlpr: 0x80000
01:51:28 Begin Action: DialogShowSdInstanceName
01:51:28 Begin Action: ShowDlgInstanceName
01:51:29 End Action: ShowDlgInstanceName
01:51:29 ShowDlgInstanceName returned : 1
01:51:29 InstanceName : MSSQLSERVER
01:51:29 CreateSetupTopology(ETOUCHHOST), Handle : 0x1134730, returned : 0
01:51:29 CreateSetupTopology returned : 0, Handle : 0x1134730
01:51:29 Topology Type : 1, Return Value : 0
01:51:29 ST_GetPhysicalNode returned : 0, PNHandle : 0x11341b8
01:51:29 PN_EnumerateEx returned : 0
01:51:29 PN_GetSQLStates returned : 0, SqlStates : 0x0
01:51:29 PN_StartScan [0x11341b8] returned : 0
01:51:29 PN_GetNext [0x11341b8] returned : 18, Handle: [0x0]
01:51:29 No more items in enumeration.
01:51:29 ReleaseSetupTopology
01:51:29 End Action DialogShowSdInstanceName
01:51:29 begin ShowDialogsUpdateMask
01:51:29 nFullMask = 0x1bfc0037, nCurrent = 0x80000, nDirection = 1
01:51:29 Updated Dialog Mask: 0x1bfc0037, Disable Back = 0x1
01:51:29 Dialog 0x80000 returned: 1
01:51:29 End Action ShowDialogsHlpr
01:51:29 ShowDialogsGetDialog returned: nCurrent=0x100000,index=20
01:51:29 Begin Action ShowDialogsHlpr: 0x100000
01:51:29 Begin Action: DialogShowSdSetupType
01:51:29 Begin Action: Setup Type
01:51:31 SQL program folder: C:Program FilesMicrosoft SQL Server
01:51:31 SQL data folder: C:Program FilesMicrosoft SQL Server
01:51:31 Windows system folder: C:WINDOWSsystem32
01:51:31 Prog req: 38205, Data req: 34432, Sys req: 182917
01:51:31 Prog avail: 73899760, Data avail: 73899760, Sys avail: 73899760
01:51:31 Prog req vs. avail, 255554, 73899760
01:51:31 Data req vs. avail, 34432, 73899760
01:51:31 Sys req vs. avail, 217349, 73899760
01:51:31 DisplaySystemPreReq
01:51:31 [SetupTypeSQL]
01:51:31 szDir = C:Program FilesMicrosoft SQL Server
01:51:31 szDir = %PROGRAMFILES%Microsoft SQL Server
01:51:31 Result = 301
01:51:31 szDataDir = C:Program FilesMicrosoft SQL Server
01:51:31 szDataDir = %PROGRAMFILES%Microsoft SQL Server
01:51:31 End Action: Setup Type
01:51:31 Setup Type: Typical (301)
01:51:31 End Action DialogShowSdSetupType
01:51:31 begin ShowDialogsUpdateMask
01:51:31 nFullMask = 0x1bfc0037, nCurrent = 0x100000, nDirection = 301
01:51:31 Updated Dialog Mask: 0x1bdc0037, Disable Back = 0x1
01:51:31 Dialog 0x100000 returned: 301
01:51:31 End Action ShowDialogsHlpr
01:51:31 ShowDialogsGetDialog returned: nCurrent=0x400000,index=22
01:51:31 Begin Action ShowDialogsHlpr: 0x400000
01:51:31 Begin Action: DlgServices
01:51:36 ShowDlgServices returned: 1
01:51:36 [DlgServices]
01:51:36 Local-Domain = 3855
01:51:36 AutoStart = 15
01:51:36 Result = 1
01:51:36 End Action DlgServices
01:51:36 begin ShowDialogsUpdateMask
01:51:36 nFullMask = 0x1bdc0037, nCurrent = 0x400000, nDirection = 1
01:51:36 Updated Dialog Mask: 0x1bdc0037, Disable Back = 0x1
01:51:36 Dialog 0x400000 returned: 1
01:51:36 End Action ShowDialogsHlpr
01:51:36 ShowDialogsGetDialog returned: nCurrent=0x800000,index=23
01:51:36 Begin Action ShowDialogsHlpr: 0x800000
01:51:36 Begin Action: DlgSQLSecurity
01:51:38 ShowDlgSQLSecurity returned: 1
01:51:38 LoginMode = 1,szPwd
01:51:38 End Action DlgSQLSecurity
01:51:38 begin ShowDialogsUpdateMask
01:51:38 nFullMask = 0x1bdc0037, nCurrent = 0x800000, nDirection = 1
01:51:38 Updated Dialog Mask: 0x1bdc0037, Disable Back = 0x1
01:51:38 Dialog 0x800000 returned: 1
01:51:38 End Action ShowDialogsHlpr
01:51:38 ShowDialogsGetDialog returned:
View 11 Replies
View Related
May 15, 2007
I have installed a licensed copy of Windows Small Business Server 2003 R2 and was attempting to configure the bundled sql server. The indicator icon in the system tray isn't green (the service hasn't been started). When I right click it and select 'Open SQL Server Service Manager', both Server and Services are blank and the refresh button does nothing. How do I coax this bad boy to start so that I can configure it?
TIA, Jim
View 4 Replies
View Related
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
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
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
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
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
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
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
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
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
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
Apr 20, 2006
Hello, everyone
I try to set up Sharepoint Portal Server 2003 in SQL Server 2005 database (on Windows 2003 Server R2). But It cannot create new portal site... the Error message told about "cannot access instance..." (in fact that I input the correct instance, user, and password)...??? I wanna know that How to setup it...
Setapong
View 1 Replies
View Related
Nov 21, 2007
I would like the Backup SQL user A can backup and restore DATABASE_a, what access right I need to grant to him. Although he can backup the database_a to the c:Program Files.....Database_a.BAK but he cannot restore it with some message said ''not enough security privieges..
Please quote some example right assigment so that I can replicate to our environment
Many Thanks...
View 6 Replies
View Related
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
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
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
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
View Related
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
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
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
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
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
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
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
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
