Hi,
I'm planning to purchase Sql Server2000 St. Edt. and install it on
windows 2000 server machine. I would like to know please if it is
advisable to work on the same machine that host both servers or should
I work on a separate one???
MTIA,
Grawsha
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
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
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 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?
Hi,
I'm developing an application that will access a database, and then send the data to a server either in batch or as each item is updated over GPRS. The database will have a large table, with 20,000 records. Each record is about 150 characters. The data access needs to be as fast as possible. I'm not sure which platform/hardware to use to achieve maximum speed. I have experience with c#, sql server ce. Worked mostly on Windows Mobile 2003, but thinking of moving to WM 5 or 6. My question is what is the best combination of hardware, OS, development environment, and software to use?
thanks
awni
I need some feedback to bolster my position with a client who is planning a platform migration. They are currently running SQL 7.0 SP3 on Windows NT4 and want to upgrade to Windows 2003. First off, SQL 7.0 isn't going to run on Windows 2003, so their first response is "let's buy the licenses and run Win2000 and SQL7 until we're ready to migrate to SQL2000". Ok... licensing cost controls aside, they're investing significant $$ in acquiring the hardware. What's my most compelling argument for moving them to a Win2003/SQL2000 platform now. (Other than the wait for Yukon is likely to be significant ;-) )
Any feedback would be appreciated.
I'd like to integrate SQL CE 3.5 into a platform builder image(using PB 5 targeting CE 5), but I don't see it in the catalog. Is it currently possible to Sysgen an image with 3.5? Can I somehow deploy the files from the .cab files? Sorry if this has been answered before, I searched around a bit but didn't find anything.
View 6 Replies View Relatedhello... my SQL database is being not able to be accessed by application when i run through VS2005 . I created the database in XP sys now brought to a NT systeem..what shd i do ..??? pls help
View 1 Replies View RelatedI am using windows 98 and I want te use SQL server 7.0. I have installed the non-enterprise edition....But it won't work....
The service manager in istalled succesfully and all the other utilities to.
But it still wont work. Is somebody out there who can help me on this.
Tnx
I've got XEON x64 server and after SQL Server 2005 installation found that the platform in property says AMD64 and not INTEL64 as expected.
I was assured by our service provider that AMD64 platform is the correct one as it was compiled for INTEL x64.
Does anybody have an answer to it?
When I try to run the x86 version of SP1 on my development desktop (for tools only), I get an 'Incorrect Platform' error:
Setup cannot update x86 products on this computer
To proceed, run the Service Pack Setup program for the x86 platform.
The filename I downloaded is SQLServer2005SP1-KB913090-x86-ENU.exe
and it successfully installed on my Wk2003 server (dual PIII). My desktop is a single P4 2.8Ghz running WinXP Pro.
brian smith
I am writing applications for barcode readers that send and receive information via wi-fi to a 2003 Server running the full MS SQL Server 2005. The readers are both XP and CE .NET 5.00 based.
The information is time critical so I need to scan a barcode then send that information to the SQL Server and then in turn run a query based upon it which then displays on the reader. I have no problem with the XP devices as I can link via ODBC to the SQL Server. These work perfectly.
I can also run a program on a XP desktop using Remote Desktop on the CE device which again works fine.
The CE .NET 5.00 readers are a problem as I cannot use OBDC or OLE DB owing to the platform.
Is there any method available where I can query the SQL Server directly without using some kind of third party product like ViaDB from Odyssey Software? I cannot use replication owing to the time constaints.
Any suggestions or gentle prods would be appreciated.
Norman
Hello:
Our company needs to (restore/migrate) our Alpha Nt4sp4 sql 6.5sp5a databases to an Intel hardware platform. For the time being the new intel server will be runing Nt4sp4 sql 6.5 sp5a. I understand that if we were to upgrade to sql 7 we would be able to restore the databases without any problems. However upgrading to sql 7 is not an option right now. I have tried to restore a backup from the alpha to an intel based machine, and it fails because the processor types are different.
I have already search technet, but found nothing, except upgrade to sql 7.
I am hoping someone out there could point me in the right direction.
Thank inadvance for your help, I appreciate it very much.
Cindy
How can i connect to the MS SQL server ruuning on Windows NT from a SOLARIS machine.?
Is there any client software available for this?
please please help?
For the last couple of days i've been trying to transfer a SQL6.5 database from an Alpha platform to an Intel one.
At one point i loaded SQL7 on the Intel platform and tried to perform an upgrade (using the wizard), across the network - but it just did not want to play.
Using Veritas Backup Exec, with SQL6.5 on both machines, i've tried doing a backup of the database on the Alpha platform and then restore to the Intel Platform, but this fails stating that the processors are incompatible
Am i trying something that is impossible?
If anyone could point me in the right direction i'd be truely grateful.
Sharpy
Does anyone know why the Extended Stored Procedure API (formerly Open Data Services) headers and libraries (e.g. srv.h, srvdbtyp.h, opends60.lib) are not in the new Platform SDK?
Older versions of the Platform SDK had these tools included, but I installed the new Platform SDK and they're not included. Is there another SDK that I need to download and install now?
I have to move our dedicated Sql 2000 transactional distributor to a new and faster machine. Great! Can someone give me or point me to a cookbook of the best way to do this? This has to be done quickly so I would like to script it and have it ready ahead of time. I am not a replication guru so I am a bit nervous . . . I have looked at the scripts output by EM, but I am sure there are some assumptions . .
Thanks
Hi
I have been successfully executing a series of IS packages from C# using the following syntax
Microsoft.SqlServer.Dts.Runtime.Package package;
package = app.LoadPackage(ISPackagePath + @"myPackage.dtsx", null);
package.ImportConfigurationFile(ISPackagePath + @"MyConfiguration.dtsConfig");
result = package.Execute();
package.Dispose();
My client has just moved their SQL boxes to a 64bit platform and this process no longer runs.
Now im also running some packages in a SQL Agent job on the SQL box and im aware of the issue of an SSIS job step defaulting to using the 64bit version of DTExec.exe. Ive updated those job steps to be operating system (cmdExec) type steps calling the 32bit version of DTExec.exe, and everything is fine there.
Is there anyway to force the Microsoft.SqlServer.Dts.Runtime.Package object in my C# code to use the 32bit version of DTEexec.exe? This code is running on the same 64bit SQL server box as the SQL agent job. Or will Microsoft.SqlServer.Dts.Runtime.Package object always default to using the 64 bit version if it is executed on a 64bit box ?
I would just call sp_start_job from C# and implement the IS packages in another job but unfortunatly my code cannot be given correct permissions to see the SQL agent jobs.
Any ideas?
Thanks
I need to connect to Express edition of sql server installed on my machine, from perl (solaris platform). How should the connection string containing server, port, database etc look like ??
Dear all,
How do i call an application, which is reside in another unix platform in my flow of execution.
I'll need to call this application after my data extraction is successfully run.
Thanks for the helps in advance.
Thanks & Best Regards,
PassionOrienter
While SQL Server installed into our clustered environment with no significant problems Service Pack 2 will not install with the Error "Unable to install Windows Installer MSP file" during the update to the Database Services.
Subsequently, Integration Services, Native Client and Backwards Compatibilty also fail to upgrade due to suspended installs.
Searching for this returns a number of articles none of which match what we are seeing, including:-
http://support.microsoft.com/kb/918357 indicates this is a problem with the Setup Support Files.
This is not the case and the Setup Support files are updated. Also the permissions are correct on the folder and files mentioned,
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=448685&SiteID=1 also point to a problem when installing the Setup Support Files. Our install gets past this but fails on the database engine then sets up a chain of suspended installs.
Other finds indicate there may be another msi running, again this is not the case and the server has been failed over and rebooted a number of times.
At the moment we are sitting at RTM having rebuilt the machine completely but would like to move forward onto SP2. Has anyone come across this and provide any further information or resolution?
We have successfully deployed SP2 onto a number of other servers cover both clustered and non clustered, 32 bit and X64 installations with no problems and now wondering if the problem is Itanium edition specific.
extract from the install log from the failed install. The logs mentioned in this log do not exist post install, in fact the Hotfix folder is not there.
Prerequisites Check & Status
SQLSupport: Passed
**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
Setup Support Files ENU 9.00.1399.06 IA64
Database Services (MSSQLSERVER) ENU RTM 2005.090.1399.00 IA64 ENTERPRISE
Integration Services ENU RTM 9.00.1399.00 IA64 ENTERPRISE
SQL Server Native Client ENU 9.00.1399.06 IA64
Client Components ENU RTM 9.00.1399.06 IA64 ENTERPRISE
MSXML 6.0 Parser ENU 6.00.3883.8 IA64
SQLXML4 ENU 9.00.1399.06 IA64
Backward Compatibility ENU 8.05.1054 IA64
Microsoft SQL Server VSS Writer ENU 9.00.1399.06 IA64
**********************************************************************************
Products Disqualified & Reason
Product Reason
**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID
**********************************************************************************
Product Installation Status
Product : Setup Support Files
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_SqlSupport.msi.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log
Error Number : 1601
Error Description : Unable to install Windows Installer MSP file
----------------------------------------------------------------------------------
Product : Integration Services
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixDTS9_Hotfix_KB921896_sqlrun_dts.msp.log
Error Number : 1601
Error Description : MSP Error: 1704 An installation for Microsoft SQL Server 2005 (64-bit) is currently suspended. You must undo the changes made by that installation to continue. Do you want to undo those changes?
I have a query of the kind brains of this group.Is it possible to access a microsoft sqlserver database (for select, insert,update, delete, and for miscellaneous administrative actions such as tableand index creation and deletion) remotely from a compiled C program (and/or,from Perl) running on a NON microsoft platform, such as Sun's Solaris and/orLinux?What toolset(s) could be used (on the UNIX/Linux end) for such a purpose?Would it require a corresponding special toolset to be installed on theWindows server end as well? (I'd prefer not to have to do that ifpossible.)If you are not now rolling on the floor laughing at the "heresy" of such anotion, thanks in advance.DanJoin Bytes! (replace 'glowing' with 'lucent')
View 1 Replies View RelatedHi all,We're looking at a vendor who uses the InterSystems Cache DatabasePlatform, but our IT department has zero experience with this system.This software package will have a pivotal and mission critical roll inour organization, so I'd like some comments on what others think ofthis database platform.Mainly I'm curious how easy/difficult it is to query a Cache Database,and does it use standard SQL calls like Oracle and MS SQL? What aboutODBC connections into the database from Crystal, MS Access, and OLAPtools? Any other caviets (backup, maintenance, etc)?Thanks in advance for any suggestions or comments Cache.Sam
View 4 Replies View RelatedWe have build configuration setup for each environment that we automatically deploy to (DEV, UA, PROD 1, PROD 2, etc.) We've recently come across a scenario where one environment will now be running a different version of SQL Server than the others.
Is it possible to tie the Target Platform version to a configuration. Such that one configuration could target 2012 while another targets 2014?
How is cross platform recognition triggered in the process?
View 2 Replies View Related