MS Sql Server And Windows 2000/XP

Jul 20, 2005

Hi, I have a problem.

I have two computers (clients), one with Windows 2000 and second with
Windows XP. And a third computer (server) with a Windows 2000 and MS Sql
Server 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 one
row: '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 help

Magda

View 2 Replies


ADVERTISEMENT

Moving SQL Servr 2000 From Windows 2K Server To Windows 2K3

Apr 17, 2008



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

View 4 Replies View Related

Vista Business ODBC/DSN To Remote Windows 2000 Server / SQL 2000

Oct 8, 2007

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.

View 8 Replies View Related

SQL Server 2000 Installation Problem On Windows 2000 Professional

Jul 20, 2005

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 Related

Windows 2000 Sp4 && SQL Server 2000 Causes Java Core Dump

Sep 7, 2007

I'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

View 5 Replies View Related

Access 2000 On Windows 2000 Can't Interact With SQL Server 7.0

Mar 13, 2001

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.

View 1 Replies View Related

Sql 2000 Installation On Windows 2000 Advance Server

May 13, 2006

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?



View 2 Replies View Related

SQL Server 2000 Standard On Windows 2000 Advanced Server

Jul 20, 2005

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

SQL Server 2000 On Windows 2000 Pro

Nov 25, 2004

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.

View 7 Replies View Related

SQL 2000 Ent Ed (32-bit) On Windows 2000 Server R2

Nov 26, 2007



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.

View 5 Replies View Related

Configure SQL Server 2000 For More Than 2GB RAM On Windows 2000 Server

Jul 19, 2007

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

View 3 Replies View Related

SQL 6.5 On Windows 2000 Server

Feb 20, 2001

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 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

Can I Install SQL Server 2000 On Windows XP

Mar 18, 2004

I have XP Pro installed on my system,Can I install SQL server 2000 Interprise

View 11 Replies View Related

Windows 2000 Advanced Server On SQL 7.0

May 4, 2000

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

View 6 Replies View Related

SQL Server 6.5 And Windows 2000 Professional

Jun 28, 2000

Currently, 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 Related

Sql Server / Windows 2000 Compatibility

Jul 11, 2002

We 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.

View 1 Replies View Related

LOADING SQL SERVER 2000 WITH WINDOWS ME O.S.

Sep 18, 2001

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.

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

SQL Server 2000 On Windows XP System

Dec 10, 2005

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

View 4 Replies View Related

SQL 2005 On Windows 2000 Server?

Oct 4, 2007

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 3 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

SQL Server 2005 And Windows 2000

Dec 15, 2006

Hi, Is there any know issues upgrading to SQL Server 2005 on Windows 2000 OS. Any help would be appreciated. Thanks.

View 5 Replies View Related

Windows Terminal Server 2000

Jun 26, 2007

Hi,
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?

View 4 Replies View Related

Windows Event Log In SQL Server 2000

Mar 26, 2008

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

Install SQL Server 2000 To Windows XP Pro ?

Feb 13, 2008



Does any one can tell me . how to install SQL server 2000 to Windows XP pro ?

View 1 Replies View Related

Windows Services For SQL Server 2000

Jul 11, 2006

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

View 1 Replies View Related

Can't Connect .Net Application From Windows Server 2003 To Database Server (SQL Server 2000)

Apr 3, 2008

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

Service Pack Available For Sql Server 2000 With Windows XP.

Oct 12, 2006

 How to find out the SP available for sql server 2000 with win xp 

View 8 Replies View Related

SQL Server 7.0 And Windows 2000 Operating System

May 13, 2002

Does SQL Server 7.0 work with the Windows 2000 operating System?
Thanks you for your help.

Regards,
Mark

View 1 Replies View Related

Backup ODBC On Windows 2000 Server?

Jul 6, 2004

howto backup ODBC configure and data on windows 2000 server help me!
thanks.

View 6 Replies View Related

SQL Server 2000 Requiring Windows Authetication

Sep 25, 2004

Hi, I'm having a rough weekend and really need some advice. We've been having some problems with our SQL Server ever since an upgrade to SQL 2K and then were moved by the IT security people to a new domain that is not in a trust relationship with the domain the SQL Server is on. After the move, attempts to log into a CMMS application we use, called Maximo, are failing. The error indicated that the user's domain login isn't trusted with the SQL Server. This is odd, because we use SQL Server Authentication and each user has a different username on the SQL Server and shouldn't care about the domain login, so I don't know why it's even being passed. This application has been working fine on SQL Server 7 for the past 3 years.

Our SQL Server is setup for Mixed Mode (set during installation and verified in Ent Mgr) and the clients are using ODBC to connect with TCP/IP port 1433 (setup with the client configuration in the ODBC properties) using SQL Server Authentication. The problem is that the settings seem to be ignored and it's using Windows Authentication only, which is a major problem. All of the grants are given to the SQL Server user by the Maximo application and all records are tracked by the login, so we can't use Windows Authentication. I am able to add the user's domain login to SQL Server and give it RW rights to the database and the user is able to login, however unable to run reports because the grants are given to the SQL Server login, not the domain login.

I tried removing the server from the domain it was on and making it a stand alone server, which resulted in the following error:

Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

This is telling me that it's ignoring SQL Server Authentication. I've also tried installing Patch 3a on SQL Server and installing MDAC 2.8 on the client.

Please help, I need to get it running by Monday.

Thanks

View 4 Replies View Related

SQL Server Windows 2000 Event Log Configuration

Mar 23, 2004

Hi ,
Do you know what is the registry key / parameter that can be change in order to configure SQL 2000 to report on warning / Error event only ( just dismiss all the information messages)


Thanks,
Eyal

View 1 Replies View Related







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