There's an old application running on sql 6.5 with windows 2000 server.
Some new applications running on another server (sql 2000 sp4, windows
2003 server sp1) need to connect to the sql 6.5 by Data Transformation
Service.
It was fine. However, there was an accidential reboot today. After
that, the scheduled DTS package couldn't run. From the job history it
shows that one of the steps in the package failed. The step was to draw
data from sql 6.5.
I tried to create an ODBC connection by MS OLE Data provider but still
failed. However, I could do that in other machines running Win XP or
Win server 2003 (without any sp installed).
I also tried the same action with other Win Server 2003 sp1 or sp2 and
all failed.
Does it mean that Win server 2003 sp 1 or above doesn't support sql 6.5
any more?
Re: MSSQL_CONNECT problem ...connecting to a SQL 2000 instance. ... I've tried leaving the port out, tried using server IP address, all to ... I've copied the "ntwdblib.dll" from my SQL 2000 box to my PHP ... Double check if the user/password you provide are listed in the Database, and that you allow SQLSERVER AUTHENTICATION (instead of the default is NT WIndows domain thingy) ... (php.general)
Re: Sql Server 2005 Dev. Ed. on Windows Server 2003 ... Check out this KB which is about transferring Logins: http://support.microsoft.com/kb/246133 ... Also, since this is running on a newly installed Windows Server 2003, is ... them from your older SQL Server instance to the newer one. ... (microsoft.public.sqlserver.setup)
Re: New Windows Infrastructure ... vendor's application runs on windows with an SQL database and I will also need a web server for a separate module which will allow our customers to access account data online. ... I would think that if the app runs on windows, I do not need the citrix server. ... It makes sense to have separate DCs though, because let's say you want to upgrade your Active Directory in two weeks time, with separate DCs it's easy, but if you've got a bunch of apps installed it could be a nightmare. ... (microsoft.public.win2000.setup_deployment)
How can I avoid using SQL Authentication with the Office Web Parts? ... We have a machine running Windows 2003 Server, IIS 6, and Windows SharePoint ... We are using Office Web Parts on several Web ... Part pages to display data retrieved from a SQL Server (SQL 2000 SP3 running ... (microsoft.public.sharepoint.portalserver.development)
How can I avoid using SQL Authentication with the Office Web Parts? ... We have a machine running Windows 2003 Server, IIS 6, and Windows SharePoint ... We are using Office Web Parts on several Web ... Part pages to display data retrieved from a SQL Server (SQL 2000 SP3 running ... (microsoft.public.office.developer.web.components)
