Hello
when I installed SQL6.5 on a server with Win2000 I received a message saying that SQL6.5 could "not be installed on this version of Windows."
Can someone please tell me what the story is here.
Regards
De Waal
Anyone running sql7 on a win 2000 box? Running advanced server? Any problems? suggestions? hints?
Thanks,
David
Hi,
I am about to make the transition from Win98 and Access 97 to Win2000 and SQl 7.0.
I was hoping for some basic/strategic advice on how to make the transition as painless as possible.
I have already installed Win2000 and SQL 7 and they seem to be coexisting. But, is there anything I should know or famialarize myself with straigth away to hit the ground running... Many Thanks >>
Jason
Cape Town, South Africa
Running SQL Server 7 Enterprise edition SP1 on NT 4.0 server and installed it on 2 Toshiba laptops 1) running Windows 2000 Professional Beta 3, 2) Windows 2000 Professional RC2.
Neither one can login to the NT 4.0 domain (Odessa) which is the PDC- get error message that domain not found. Can login to local copy and then map a drive to the domain and utilize all functions etc. as both users have administrative privileges on the NT 4.0 server.
Because of this we can't (and we have had 3 different MS tech support people working with us) can't get either a push or pull subscription from the Odessa SQLServer databases to either one of the laptops. Continually getting OS error 5, Access denied.
We have 4 other laptops running Win98 getting pull subscriptions with no problems.
Any suggestions greatly appreciated,
Larry
Hi,I'm planning to purchase Sql Server2000 St. Edt. and install it onwindows 2000 server machine. I would like to know please if it isadvisable to work on the same machine that host both servers or shouldI work on a separate one???MTIA,Grawsha
View 1 Replies View RelatedHi Everybody,
I am looking for help on how to proceed. I have only 1 drive that has Win 2000 Prof o/s. I am installing SQL 7. Should I install to the same partition or create a new one for SQL, and are they compatable. I know Win 2k o/s post dates SQL 7. Would SQL 2000 be better? or Win98SE w/SQL 7? The main reason I ask is that I don't want to lose any of the stuff that's on the Win 2k o/s already. Any advice is greatly appreciated. Thanks ! Phil
When I installed SQL Server 7.0 on Windows 2000 Server, I got "File Protection Error" saying Windows 2000 system files are being updated by other version.... to restore the Windows 2000 files insert CD.
The same error I received when i tried to install SP3 of SQL Server 7.0, is there any compatibility issues? I canceled the above error and the Server works well after installation.
Please HELP..!!!
I have a SQL Server 2005 in use locally. I'm trying to connect a remote location. Using WinXP Pro, I can connect just fine. However, when I try the same connect string on a Win2000 or WinXP Home computer, I cannot connect.
All these computers are plugged into the same network (hub even).
I've updated all the computers to MDAC 2.8.
To connect, I open the ODBC Administrator in Windows, enter my SQL Server IP and instance name: xx.xx.xx.xxabc, change the network library to TCP/IP and enter my username and password.
This works great on the WinXP Pro machines.
This is the error I get on the other machines:
[Microsoft][OBBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen(Connect()).
[Microsoft][OBBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not found.
Any help would be appreciated.
Hello,I am installing SAP R/3 on Win2000/SQL Server. There is a CD with theSQL Server RDBMS, as well as another one with SP 3A (Both are fromSAP). According to the SAP installation manual, after installing thoseI have to install 'QMF' for SQL Server. It indicates to checkMicrosoft's documentation on installing QMF on SQL Server. I searchedMicrosoft's Website, but I did not find any information on QMF.Any ideas on the procedure involved, where it is documented, etc..would be greatly appreciated.Thanks,SAP BASIS Consultant
View 1 Replies View RelatedI am interested if anyone can point me to "best practices" regarding thelevel of administrative authority a SQL Server database administrator shouldhave. Alternatively, I'd be interested hearing what level of authority onthe server you/your SQL Admin has. I have been told that in order to dotheir job, a database admin needs full admin authority on the operatingsystem in a Microsoft environment, but I find that hard to believe.Thanks.
View 1 Replies View RelatedI have my SQL7 server running on NT4 server. Currently the transaction log backups are on the same server but I want to back these up to a Win2000
server in another building. When creating a Backup Device in Enterprise Manager on the NT server it cannot see the drive but not the folder I have created on the Win2000 server, even though I have shared this folder out and set the permissions. Any help would be appreciated.. Thanks
When upgrading servicepack for SQL Server 7 in a Windows 2000 cluster, do I need to uncluster the servers before installing SP?
Install on Node 1 first?
The database devices was showing a negative number size, so i expanded the database which has cleared this problem, however, now when users try to input a form(each form is allocated a unique reference number) for this database the reference number has reset and is starting off at 1 instead of following on from the previous form number before this problem occurred.
View 1 Replies View RelatedI created a DTS task to transfer data from a SQL7.0 table to a SQL6.5 table. This trasfer is really slow.
The transfer the other way is amazingly fast.
Any ideas ??
Thank you in advance.
Can my Access 97 db's connect to both a SQL 6.5 and 7.0 without a problem.
has anybody tried this?
Hi all :
Does the upgrade wizard in 7.0 help me upgrade ALL the database objects in SQL 6.5 (including stored procedures, triggers) to 7.0? Has anyone encountered any problems?
Rnathan
Hello All,
Does anyone know if stored functions can be written for sql similar to stored procedures? And if theey
can, what language?
Thanks
I am attempting to connect to my SQL 6.5 Server through IPX. We currently have a WindowsNT network setup with a Novell Server v3.12 running as a file and login server. When I setup IPX/SPX as a network protocal to use, and then set it in the client configuration , I get a specific error.
"Cannot Connect To SQL Server : Login Failed"
Maybe I am missing a step in my setup somewhere. Has anyone encountered this with using IPX? It connects perfectly using named pipes, but only see this error when I try to use IPX. All help is appreciated. Thank You.
Michael Mroz
Libera, Inc.
Jamestown, NY
Can SQL6.5 and SQL7.0 live on the same NT4.0 server?
View 2 Replies View RelatedI just started as a junior dba and I'm monitoring a SQL6.5 database and I need some help with a certain issue, as to what I should be looking for.
Recently, the program we use to retrieve data from the database has been freezing up on everyone. What I did was just kill some user's processes from Enterprise Manager which seems to work. But we never had this problem before. And since everyone has been closing their programs prematurely, the error log contains many errors like this:
Error: 1608, Severity: 21, State: 2
A network error was encountered while sending data to the front end.
Error: 17824, Severity: 10, State: 0
Unable to write to ListenOn Connection pipesqlquery.....
We have a dedicated server for this database and there's about 20 requests to the database at any given time.
If anybody can tell me what to do, I would greatly appreciate it. Thank you.
Does anyone know of any issues that need to be considered when installing NT sp4.
Since doing so we are getting unexpected database behaviour
thanks in advance
Can you restore a SQL6.5 backup to a Sql2000sp3 ?
View 7 Replies View RelatedHi all
I would like to know - we are currently running SQL6.0 on NT4 servers. We have 2 x 3rd party programs that runs on the servers, making use of the databases. We don't forsee any changes in the near future.
Question: will it be wise to upgrade to SQL7 anyways, or can we keep the status quo as is ???
Rgds
De Waal
I installed SQL 7 on a new computer and imported DB from another SQL 6.5.
Tables were imported but index and SPs were not.
I had to script those objects and run it on SQL 7.
Any shortcut to import all objects directly?
Again I was importing not upgrading.
Hi all,
I receive the following error message every time I run this script:
INSERT INTO archive_temp (mrn, folder, name)
SELECT a.mrn, a.encounter, a.name
FROM his..active a, cabinet..cabinet c
WHERE imnet like 'images3%'
ORDER BY a.mrn, a.encounter
GO
After 10 minutes I get this ERROR MESSG: Can't allocate space for object
'-1443' in database 'tempdb' b/c the 'system' segment is full. If you
ran out of space in Syslogs, dump the transaction log. Otherwise use
'Alter database" or sp_extendsegment to increase the size of segment.
So far, i've updated the tempdb log segment from 100 mb to 500 mb
shared with data. I don't understand why I am still getting this error.
When I look at Performance Monitor, the log for tempdb is not peaked at
all!
can anyone help?
Thanks
Chris
I need to transfer databases from one server to the other.
(They are identical sort order/char set/...) but as I did
all passwords were set to NULL....How can I use the
generated scripts to transfer without losing them ?
(Have about 300 users...) Thank you for your help !!
I Completely new to SQL, can anyone give me a URL to find this information.?
Thanks
Can it be done?
View 2 Replies View RelatedHi!
I just have one short question.
Is there a way to change the sort order in SQL 6.5 short of re-installing
the whole database?
If there is, how do I go about it?
TIA
Johan
i've a sql server 6 and sql server 7 located in 2 different domain.
how could i migrate the database from my sql 6 to sql 7?
I`m planning on installing sql7 beta on my desktop. Currently I have sql6.5 client tools installed on my desktop for performing DBA tasks against our test and prod. sql6.5 servers. Does anyone know if installing sql7 will conflict with my sql6.5 client tools or cause any other problems?
Thanks
In SQL 6.5, you could Transfer (through a menu item in Enterprise Mgr) all or parts of a database to another server. It was the perfect 'copy' mechanism. What happened to it?
Thanks,
Judith
Hi
Is it possible to add jobs into the SQL schedule by means of a SQL script. We have 1000 remote servers to update and don't really want to do it manually.
Any help appreciated.
Ian