We are testing our SQL 7.0 server on Windows 2000 Advanced Server.
We are getting some bottlenecks on stored procedures.
Has any one out there used this set up and if so what kind of problems have you seen?
Thanks,
Dianne
What is the limitation of memory that SQL Server 2000 Standard can usewhen running on a Windows 2000 Advanced Server platform?
View 1 Replies View Related
When I try to install SQL Server 2005 Expess SP2 with Advanced Services on a clean Windows XP system that has had Service Pack 3 applied I get the error "Setup is missing prerequisites: - MSXML6" when it starts to install SQL Server Management Studio Express. This is despite the fact that earlier in the installation is says it installed MSXML6, and my understanding is that MSXML6 is part of Windows XP Service Pack 3 anyway.
The SQL Express installation stops installing components at this point. The database server itself does seem to be operational.
Is there anything I can do to work around this? I would like our customers to be able to install and use Management Studio Express.
Here is the relevant snippet from SQLSetup0006_LUDQAVMXPEN_SSMSEE_1.log
Action start 8:03:54: AppSearch.
MSI (s) (CC:98) [08:03:54:078]: PROPERTY CHANGE: Adding INSTALLSQLSHAREDDIR property. Its value is 'C:Program FilesMicrosoft SQL Server'.
MSI (s) (CC:98) [08:03:54:078]: PROPERTY CHANGE: Adding UI_INSTALLSQLSHAREDDIR property. Its value is 'C:Program FilesMicrosoft SQL Server'.
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerSSMSEECurrentVersion 3: 2
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: IniLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: DrLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSXML60Setup 3: 2
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: IniLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: DrLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:078]: PROPERTY CHANGE: Adding SNACPRESENT property. Its value is '{11111111-1111-1111-1111-111111111111},{B0F9497C-52B4-4686-8E73-74D866BBDF59},{58D379F7-62BC-4748-8237-FE071ECE797C}'.
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerASOLEDB9MSIRefCount 3: 2
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: IniLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: DrLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerADOMDMSIRefCount 3: 2
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: IniLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: DrLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerXMOMSIRefCount 3: 2
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: IniLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: DrLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server90ToolsShell 3: 2
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: IniLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: DrLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:093]: PROPERTY CHANGE: Adding DW20PATH_X86.8D56D6B0_25DE_4471_A64F_717FC5AB6330 property. Its value is 'C:PROGRA~1COMMON~1MICROS~1DWDW20.EXE'.
MSI (s) (CC:98) [08:03:54:093]: Note: 1: 2262 2: IniLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:093]: Note: 1: 2262 2: DrLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:093]: Note: 1: 1402 2: HKEY_LOCAL_MACHINECLSID{31411198-a502-11d2-bbca-00c04f8ec294}InprocServer32 3: 2
MSI (s) (CC:98) [08:03:54:093]: Note: 1: 2262 2: IniLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:093]: Note: 1: 2262 2: DrLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:093]: Note: 1: 1402 2: HKEY_LOCAL_MACHINECLSID{31411198-a502-11d2-bbca-00c04f8ec294}InprocServer32 3: 2
MSI (s) (CC:98) [08:03:54:093]: Note: 1: 2262 2: IniLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:093]: Note: 1: 2262 2: DrLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:093]: Doing action: CA_URTVersionCmd.3643236F_FC70_11D3_A536_0090278A1BB8
Action ended 8:03:54: AppSearch. Return value 1.
MSI (s) (CC:98) [08:03:54:093]: PROPERTY CHANGE: Adding URTVersion property. Its value is 'v2.0.50727'.
Action start 8:03:54: CA_URTVersionCmd.3643236F_FC70_11D3_A536_0090278A1BB8.
MSI (s) (CC:98) [08:03:54:093]: Skipping action: CA_SSMSAlreadyInstalled (condition is false)
MSI (s) (CC:98) [08:03:54:093]: Doing action: MISSINGMSXML6.6D658EB9_E2B8_429A_92C4_84337700878E
Action ended 8:03:54: CA_URTVersionCmd.3643236F_FC70_11D3_A536_0090278A1BB8. Return value 1.
MSI (s) (CC:98) [08:03:54:093]: PROPERTY CHANGE: Adding MISSINGREDISTPREREQS property. Its value is '
- MSXML6'.
Action start 8:03:54: MISSINGMSXML6.6D658EB9_E2B8_429A_92C4_84337700878E.
MSI (s) (CC:98) [08:03:54:093]: Skipping action: MISSINGSNAC.6D658EB9_E2B8_429A_92C4_84337700878E (condition is false)
MSI (s) (CC:98) [08:03:54:093]: Skipping action: MISSINGPTS9.6D658EB9_E2B8_429A_92C4_84337700878E (condition is false)
MSI (s) (CC:98) [08:03:54:093]: Skipping action: MISSINGADOMD9.6D658EB9_E2B8_429A_92C4_84337700878E (condition is false)
MSI (s) (CC:98) [08:03:54:093]: Skipping action: MISSINGXMO.6D658EB9_E2B8_429A_92C4_84337700878E (condition is false)
MSI (s) (CC:98) [08:03:54:093]: Doing action: MISSINGPREREQERROR.6D658EB9_E2B8_429A_92C4_84337700878E
Action ended 8:03:54: MISSINGMSXML6.6D658EB9_E2B8_429A_92C4_84337700878E. Return value 1.
MSI (s) (CC:98) [08:03:54:109]: PROPERTY CHANGE: Adding MISSINGREDISTPREREQERROR property. Its value is 'Setup is missing prerequisites:
- MSXML6
Go to http://go.microsoft.com/fwlink/?LinkId=54583'.
Action start 8:03:54: MISSINGPREREQERROR.6D658EB9_E2B8_429A_92C4_84337700878E.
MSI (s) (CC:98) [08:03:54:109]: Doing action: CA_ErrorMissingPreReqs
Action ended 8:03:54: MISSINGPREREQERROR.6D658EB9_E2B8_429A_92C4_84337700878E. Return value 1.
Action start 8:03:54: CA_ErrorMissingPreReqs.
MSI (s) (CC:98) [08:23:30:937]: Product: Microsoft SQL Server Management Studio Express -- Setup is missing prerequisites:
- MSXML6
Go to http://go.microsoft.com/fwlink/?LinkId=54583
Setup is missing prerequisites:
- MSXML6
Go to http://go.microsoft.com/fwlink/?LinkId=54583
Action ended 8:23:30: CA_ErrorMissingPreReqs. Return value 3.
Action ended 8:23:30: INSTALL. Return value 3.
Going to the mentioned link offers me a download of MSXML6, among other things....
Thanks,
---
Barry Roskuski barry.roskuski@esko.com
EskoArtwork
Ludlow, MA
I originally posted this on the SQL Server Setup and Upgrade forum, but then I found this forum and though it might be more appropriate...
When I try to install SQL Server 2005 Expess SP2 with Advanced Services on a clean Windows XP system that has had Service Pack 3 applied I get the error "Setup is missing prerequisites: - MSXML6" when it starts to install SQL Server Management Studio Express. This is despite the fact that earlier in the installation is says it installed MSXML6, and my understanding is that MSXML6 is part of Windows XP Service Pack 3 anyway.
The SQL Express installation stops installing components at this point. The database server itself does seem to be operational.
Is there anything I can do to work around this? I would like our customers to be able to install and use Management Studio Express.
Here is the relevant snippet from SQLSetup0006_LUDQAVMXPEN_SSMSEE_1.log
Action start 8:03:54: AppSearch.
MSI (s) (CC:98) [08:03:54:078]: PROPERTY CHANGE: Adding INSTALLSQLSHAREDDIR property. Its value is 'C:Program FilesMicrosoft SQL Server'.
MSI (s) (CC:98) [08:03:54:078]: PROPERTY CHANGE: Adding UI_INSTALLSQLSHAREDDIR property. Its value is 'C:Program FilesMicrosoft SQL Server'.
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerSSMSEECurrentVersion 3: 2
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: IniLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: DrLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSXML60Setup 3: 2
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: IniLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: DrLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:078]: PROPERTY CHANGE: Adding SNACPRESENT property. Its value is '{11111111-1111-1111-1111-111111111111},{B0F9497C-52B4-4686-8E73-74D866BBDF59},{58D379F7-62BC-4748-8237-FE071ECE797C}'.
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerASOLEDB9MSIRefCount 3: 2
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: IniLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: DrLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerADOMDMSIRefCount 3: 2
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: IniLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: DrLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerXMOMSIRefCount 3: 2
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: IniLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: DrLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server90ToolsShell 3: 2
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: IniLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:078]: Note: 1: 2262 2: DrLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:093]: PROPERTY CHANGE: Adding DW20PATH_X86.8D56D6B0_25DE_4471_A64F_717FC5AB6330 property. Its value is 'C:PROGRA~1COMMON~1MICROS~1DWDW20.EXE'.
MSI (s) (CC:98) [08:03:54:093]: Note: 1: 2262 2: IniLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:093]: Note: 1: 2262 2: DrLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:093]: Note: 1: 1402 2: HKEY_LOCAL_MACHINECLSID{31411198-a502-11d2-bbca-00c04f8ec294}InprocServer32 3: 2
MSI (s) (CC:98) [08:03:54:093]: Note: 1: 2262 2: IniLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:093]: Note: 1: 2262 2: DrLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:093]: Note: 1: 1402 2: HKEY_LOCAL_MACHINECLSID{31411198-a502-11d2-bbca-00c04f8ec294}InprocServer32 3: 2
MSI (s) (CC:98) [08:03:54:093]: Note: 1: 2262 2: IniLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:093]: Note: 1: 2262 2: DrLocator 3: -2147287038
MSI (s) (CC:98) [08:03:54:093]: Doing action: CA_URTVersionCmd.3643236F_FC70_11D3_A536_0090278A1BB8
Action ended 8:03:54: AppSearch. Return value 1.
MSI (s) (CC:98) [08:03:54:093]: PROPERTY CHANGE: Adding URTVersion property. Its value is 'v2.0.50727'.
Action start 8:03:54: CA_URTVersionCmd.3643236F_FC70_11D3_A536_0090278A1BB8.
MSI (s) (CC:98) [08:03:54:093]: Skipping action: CA_SSMSAlreadyInstalled (condition is false)
MSI (s) (CC:98) [08:03:54:093]: Doing action: MISSINGMSXML6.6D658EB9_E2B8_429A_92C4_84337700878E
Action ended 8:03:54: CA_URTVersionCmd.3643236F_FC70_11D3_A536_0090278A1BB8. Return value 1.
MSI (s) (CC:98) [08:03:54:093]: PROPERTY CHANGE: Adding MISSINGREDISTPREREQS property. Its value is '
- MSXML6'.
Action start 8:03:54: MISSINGMSXML6.6D658EB9_E2B8_429A_92C4_84337700878E.
MSI (s) (CC:98) [08:03:54:093]: Skipping action: MISSINGSNAC.6D658EB9_E2B8_429A_92C4_84337700878E (condition is false)
MSI (s) (CC:98) [08:03:54:093]: Skipping action: MISSINGPTS9.6D658EB9_E2B8_429A_92C4_84337700878E (condition is false)
MSI (s) (CC:98) [08:03:54:093]: Skipping action: MISSINGADOMD9.6D658EB9_E2B8_429A_92C4_84337700878E (condition is false)
MSI (s) (CC:98) [08:03:54:093]: Skipping action: MISSINGXMO.6D658EB9_E2B8_429A_92C4_84337700878E (condition is false)
MSI (s) (CC:98) [08:03:54:093]: Doing action: MISSINGPREREQERROR.6D658EB9_E2B8_429A_92C4_84337700878E
Action ended 8:03:54: MISSINGMSXML6.6D658EB9_E2B8_429A_92C4_84337700878E. Return value 1.
MSI (s) (CC:98) [08:03:54:109]: PROPERTY CHANGE: Adding MISSINGREDISTPREREQERROR property. Its value is 'Setup is missing prerequisites:
- MSXML6
Go to http://go.microsoft.com/fwlink/?LinkId=54583'.
Action start 8:03:54: MISSINGPREREQERROR.6D658EB9_E2B8_429A_92C4_84337700878E.
MSI (s) (CC:98) [08:03:54:109]: Doing action: CA_ErrorMissingPreReqs
Action ended 8:03:54: MISSINGPREREQERROR.6D658EB9_E2B8_429A_92C4_84337700878E. Return value 1.
Action start 8:03:54: CA_ErrorMissingPreReqs.
MSI (s) (CC:98) [08:23:30:937]: Product: Microsoft SQL Server Management Studio Express -- Setup is missing prerequisites:
- MSXML6
Go to http://go.microsoft.com/fwlink/?LinkId=54583
Setup is missing prerequisites:
- MSXML6
Go to http://go.microsoft.com/fwlink/?LinkId=54583
Action ended 8:23:30: CA_ErrorMissingPreReqs. Return value 3.
Action ended 8:23:30: INSTALL. Return value 3.
Going to the mentioned link offers me a download of MSXML6, among other things....
Thanks,
---
Barry Roskuski barry.roskuski@esko.com
EskoArtwork
Ludlow, MA
Does any one come across any difficulty in the following migration?
OS: Wondows Server 2K
DB: SQL Server 2K Standard Edition
Migrating to
OS: Wondows Server 2K3
DB: SQL Server 2K Standard Edition
Thank you,
Gish
Could anyone inform me how much the conventional memory SQL7 Enterprise on Advanced Server 2000 can have?
The SQL is on an active/active cluster. Currently each runs at 2GB of memory, with available memory for failover. I am planning to add another 2GB to each SQL node. Is this possible? Are there any configurations I need to do? Do I need to set AWE enabled? and How much?
Your help is greatly appreciate.
Jim
SQL Sever 2012, I have a table where I store data related with a Log, the columns of the table are three, IDTable, DateLog and CountLog, the column CountLog is a cumulative value, each new rows can increment this value, my query will receive two parameters related with the Date, @dateFrom and @dateTo, with this information is necesary to get the diff between two months, for example:
CREATE TABLE MyTable
(
IDTable INT IDENTITY NOT NULL,
DateLog DATE NOT NULL,
CountLog INT NOT NULL
)
[code]....
In this case I need to apply a filter with the Dates:
@dateFrom ='2014-01-01',
@dateTo ='2014-04-28'
But according with this filter I need to limit the results only for this period between the date, but I need that the first month (January 2014) take the information of the max value from previous month even not included in the filter, in this case the results will be the next:
Id MonthYear Diff
1 Jan2014 5
2 Feb2014 3
3 March2014 0
4 April2014 5
With the results, for the first mont (January) is, according to the range of times, January is the lower limit,the last cumulative value of CountLog before the first month of the range was 2 (December 2013), the max value of the CountLog for this first month was 7, the diff is 7-2 equal to 5 , in the case of the next month (February) the max value of the CountLog was 10, the diff is 10 - 7 equal to 3 and this way.
[URL]
Is there some special settings, permissions, or special choices I have to make when install SQL Express SP1 Advanced on Vista Beta 2 to allow me to restore DBs?
I have a user, which is the user during Vista Beta 2 install that it created as 'Administrator' account.
With this user, I have righ-clicked and Run As Administrator the SQL Express SP1 Advanced install..
All my attempts as an Administrator or with this user to restore a DB, results in a DB that the user can't connect to and run a simple select on. I either flat out can't restore the DB, or if I can somehow through lots of messing around get the DB restored, I then get a SQL permissions on object error from SQL Server Express on a simple select.
I don't know what I'm doing wrong, does anyone have any experience with this and any pointers on where I could be getting hung-up?
Hi,
Just upgraded some development desktops to Vista Business. However we need
to still connect to some older remote windows 2000/SQL 2000 servers.
Trying to setup an ODBC system DSN on our Vista Business local desktop we get the
following errors -
-START ERROR WINDOW-
Connection Failed:
SQLState: '01000'
SQL Server Error: 772
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen
(SECDoClientHandshake()0.
Connection failed:
SQLState: '08001'
SQL Server Error: 18
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SSL Security Error
-END ERROR WINDOW-
Any help greatly appreciated as this is stopping us from making
database/table connections etc. We've checked the firewall setup and all is well there.
PS - we can still connect fine using XP or windows 2000 desktops and their
local DSNs.
Hello,I received the error message below when i'm trying to install SQLServer 2000 standard edition into a Windows 2000 Professionaleworkstation.Error :Microsoft SQL server 2000 Standard Edition server components is notsupported on this operating system. Only client components will beavailable for installation.Any request modification ?Best regards,Thanks
View 1 Replies View RelatedI've just started getting this EXCEPTION_ACCESS_VIOLATION (0xc0000005) on machines using Windows 2000 sp4 connecting to SQLServer. This is crashing JVMs (multiple Sun versions and BEA also) in the Java VM frame (outside our code). This has just started recently - perhaps with the last set of patches? Has anyone else seen this or know what I could do to get more information? Could this be related to updates to named pipes?
Thanks!
-Brian Temple
We have a SQL Server 7.0 system in NT 4.0 environment. We upgraded our users to Access 2000 and started to work with this. Now we installed a new
server which is Windows 2000 based and the domain is different from
the SQL servers domain. We then installed Access 2000 on Windows 2000
to use with terminal server. But I noticed that there was a problem
with the program. I then looked at the program which was written on Access 2000 and saw that the tables and views can't be seen. The program runs but
I can't see the views and tables. Another thing is access disconects from SQL Server when I want to see the tables. So what can be the problem.
In one part there is an Access 2000 on Windows 2000 server. On the other part SQL Server 7.0 on Windows NT 4.0. And Access can't see the tables in SQL server.
I am trying to install microsoft sql server 2000 enterprise edition on a windows 2000 advance server. I keep getting error message
A previous program installation created pending file operations on the installation machine. You must restart the computer before running . I have restarted machine and no change.
What does error message mean and what is solution?
Dear Friends
Can I install SQL Server 2000 on Windows 2000 Professional, I have tried but message was "this platform is not supported" and only client components will be installed after installing, I was unable to create any database.
Please help me.
Can SQL Server 2000 Enterprise Edition (32-bit) be installed on a Windows 2003 Server R2 SP2 64-bit clustered system?
I have the Windows Cluster fully patched, but when I try to install SQL server 2000 Ent Ed (32-bit) from the directory 'd:englishsql2000entx86setupsetupsql.exe' it hangs after I enter the virtual server IP.
NB. I have successfully installed SQL 2000 Ent Ed (32-bit) on a clustered Windows 2003 Server (NOT R2)
Any help or pointers would be greatly appriciated.
Hi,
I've a SQL Server 2000 (SP4) installed on Windows 2000 Server.
The system has 4GB RAM.
SQL Server not using more than 2GB RAM even I set the following.
AWE enabled.
Max server Memory (MB) : 3GB
SQLService account is enabled for "Lock Pages in Memory"
Can you please help what I'm missing here?
Thanks in advance.
Regards,
Mkarumuru
Do I understand correctly that an upgrade from 6.5 to 7.0 is mandatory when moving from NT 4 to Windows 2000?
View 1 Replies View RelatedHi, I have a problem.I have two computers (clients), one with Windows 2000 and second withWindows XP. And a third computer (server) with a Windows 2000 and MS SqlServer 2000.I have a TABLE with two rows: 'row' and 'row ' (space).And SQL: 'select * from TABLE where row = 'row'If I run this SQL on computer with Windows 2000 it works ok (return only onerow: 'row').If I run this SQL on computer with Windows XP it works really strange(return two rows: 'row' and 'row ' ) - it can't see this spaces.Is there differences between MS Sql Server on W2000 and WXP?Thanks for the helpMagda
View 2 Replies View RelatedHi 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 RelatedI have XP Pro installed on my system,Can I install SQL server 2000 Interprise
View 11 Replies View RelatedCurrently, I have the client side of SQL Server 6.5 (Enteprise Manager, Security Manager, Books Online, etc.) installed and running under Windows NT 4.0 Workstation. When I attempt to install the same package under Windows 2000 Professional I get the following message - This program does not run correctly on this version of windows. To continue, click Run Program. Has anyone sucessfully installed this under Windows 2000 Professional? Are there any patches or service packs to apply? Thanks.
View 1 Replies View RelatedWe are going to upgrade to windows 2000 in the near future.
We currently use sql server 6.5.
Can anyone tell me if SQL 6.5 will run on windows 2000?
Also will SQL server v7 run on windows 2000 or do I need to upgrade to SQL 2000?
Many thanks.
WHEN I TRY TO LOAD THE SQL 2000 SERVER I GET THE FOLLOWING ERROR:
MICROSOFT SQL SERVER 2000 DEVELOPER EDITION SERVER COMPONENT IS NOT SUPPORTED ON THIS OPERATING SYSTEM. ONLY CLIENT COMPONENTS WILL BE AVAILABLE FOR INSTALLATION.
AT THE PRESENT I AM RUNNING WINDOWS ME AS THE OPERATING SYSTEM. THIS VERSION OF SQL SERVER 2000 WAS BOUGHT FROM MICROSOFT A COUPLE OF MONTHS AGO. THIS IS MY FIST TIME TRYING TO INSTALL IT.
THANKS FOR YOUR COMMENTS AND SUGGESTIONS.
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
Hi,
I was wondering how to install SQL Server 2000 on a windows xp system as I have seen it on one of my friend's PC and I was also able to do it 5 years ago... lol
Just don't remember it. I know it's perfectly compatible with Windows 2000 server and above. I was just looking for a hack on this...
Hope someone can answer.... thanks in advance!
:D :D :D
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
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 RelatedHi, Is there any know issues upgrading to SQL Server 2005 on Windows 2000 OS. Any help would be appreciated. Thanks.
View 5 Replies View RelatedHi,
I currently have a Compaq ProLiant DL360 server running with Windows Terminal Server 2000. I want to switch to a Dell server, but the old server contains 5 terminal users. How can I switch the license to the Dell server?
How to verify whether windows event log is enable in MSSQL 2000 or not through SQL Client (or sql query)
View 9 Replies View Related
Does any one can tell me . how to install SQL server 2000 to Windows XP pro ?
For a SQL Server 2000 machine that performs no other function than being a database server with no web services, reporting services, or analysis services, I'm wondering if there is any documentation on what services would typically be running and, more importantly, which ones could be stopped.
For example, I'm looking at a server and I see services such as Computer Browser and Microsoft Search. I don't see why either of these services are necessary for this machine.
Thank you
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