Can Install MS SQLServer2000 On Win2k Profestional?
Aug 13, 2004I only can install client-side of SQLServer2000 on Win2kProfestional
But i need to set up server-side, so can i?
I only can install client-side of SQLServer2000 on Win2kProfestional
But i need to set up server-side, so can i?
Hello all,
There are have 2 nodes.Both on cluster and on a test_domain.Test domain is a active directory domain.
Node_A & node_B has C and D drives.D drive will have programs.
There is one common drive E - where data will go.
Now,I have to install SQL2000 on it.Can anyone tell me in layman's way how to install it.Do I have to have D drive in shared mode?When I give remote connection what should I give here?
Win 2000 clustered was installed by a NT expert and is working fine.
I am assuming drive_D will hold the SQl programs.
I tried one article posted here from Sqlserver preformance side but nothing worked.
Does it matter as both the nodes are on a Active Directory?
Any hint may help.
thanks!
hi... i need help.
i tried to install sql server 2000 on my laptop (WinXP os) and when i reach the form where im supposed to click "Install Database Server", the next form after clicking "Install Database Server" wont show, and there are no error messages. I tried everything i could but it didnt work. My last choice is to format my computer - but i dont want to do that.
there are two processes running on the background that has SQL in its name - SETUPSQL.EXE and SQLSTP.EXE. I think this shows that the setup is still running.
i need help asap please, and i dont want to format my computer...
thanks in advance!
In the past I've used MSDE with Visual Studio.NET 2003. I'm going to start studying for an MCP in SQL Server 2000 so I'll probably get SQL Server 2000 Developer Edition. Will I be able to install this on my PC if it already has MSDE installed, or will I need to remove MSDE, etc? If there are any other things I need to be aware of please let me know.
Also should I stick with SQL Server 2000 while studying for the exam, or would I probably be able to use SQL Server 2005 with a book that uses SQL Server 2000? I don't know how different they are.
Hi,
iam having vs2005 installed on my machine and i also installed sqlserver2005 dev edition on my machine...Now iam devloping a Window Appplication in which I need to populate a grid from Sqlserver2000 (dev edition) which installed on remote (i.e another network)....when i try to run my application it gives me a error tht "Unable to connect to sqlserver2005".actaully i specified in my connection string to connect to Sqlserver2000 on the remote machine.
I feel to know how to enable remote connection on Sqlserver 2000.So tht i can access this sqlserver2000 from another machine
With regards
Mahender
Hi All Can I install sqlserver2000 as a desktop version in win2k professional ?
Please Help
Starting with Win2k you are not suppossed to have to install MDAC, as it comes with the OS. What about when I install SQL7 and it automatically installs MDAC. Do I have to reinstall MDAC in this case?
View 2 Replies View RelatedI have heard that when installing Win2K sp2 and SQL 2000 sp2 they should be done in a certain order. Does anyone know anything about this?
Thanks!
JJ
Does anyone know the 'trick' in getting sqlmail (sqlserver 7.0) to work with Outlook 2000 on a windows 2000 server machine. I've setup a mail profile on Outlook, but it is not listed in the dropdown menu in the sqlmail properties.
Outlook communicates with my smtp/pop3 mail server - no problem. I can't get sqlmail to interface with outlook. Basically it is telling me that it cannot find ANY profiles on the server.
My shop is thinking of migrating from NT4 to Win2K. Is anyone running SQL7 on Windows 2000 (which edition?)? How's you're experience been? Anyone hear any anecdotes of particular things that don't work (well)?
Thanks for your input.
does anyone know where I can get the admin pack for win2k. thanks
View 1 Replies View RelatedI am planning to upgrade our SQL Server 2000 box from Win NT to Windows 2000. Have anyone done the same thing and has encounter problems? Thank you.
View 2 Replies View RelatedI am new to MSDE and want to deploy it in my company (because it is free).However, when I install it in a W2K professional machine, there is a messagebox saying that a "strong SA password is required". How can I solve theproblem?Arthur Cheung(The MSDE engine was downloaded from the microsoft sql server web page)
View 1 Replies View RelatedHi,I am new to Win2k and SQL server and need to back up everything each night.I used the supplied NT backup utility to schedule a backup but this missedsome files that were open or in use.I am more used to Unix/Informix where I could backup everything whether itwas in use or not.How or what would you recommend I use to do my backups?Thanks.
View 2 Replies View RelatedHiya!
I'm having a problem installing SQL Server 7 Enterprise Edition (no service pack)on a Windows 2000 Server SP 2 machine (256 MB RAM,40 GB drive) off an original MSDN CD. Only the client components get installed. This is the output from the SQLStp.log file:
15:19:51 Begin Setup
15:19:51 7.00.623
15:19:51 Mode=Normal
15:19:51 ModeType=NORMAL
15:19:51 ValueFTS returned: 1
15:19:51 ValuePID returned: 1
15:19:51 ValueLic returned: 1
15:19:51 GetDefinitionEx returned: 0, Extended: 0xf000000
15:19:51 System: Windows NT Server
15:19:51 SQL Server ProductType: Enterprise Edition [0x3]
15:19:51 Begin Action: SetupInitialize
15:19:51 End Action SetupInitialize
15:19:52 Fixed install: 0
15:19:52 Begin Action: CheckRequirements
15:19:52 Platform ID: 0xf0000000
15:19:52 Version: 5.0.2195
15:19:52 Processor Architecture: x86 (Pentium)
15:19:52 File Version - C:NTSRVRSystem32shdocvw.dll: 5.0.3315.2879
15:19:52 ComputerName: SERVER-5IQ8359Z
15:19:52 User Name: Administrator
15:19:52 IsAllAccessAllowed returned: 1
15:19:52 C:NTSRVRTEMP\_ISTMP44.DIRscm.exe -Silent 1 -Action 6 -Timeout 5000 -Service MSSQLServer
15:19:57 Process Exit Code: (0)
15:19:57 OS Language: 0x409
15:19:57 End Action CheckRequirements
15:19:57 Begin Action: Detection
15:19:57 End Action Detection
15:19:57 Begin Action: ODBCLocked
15:19:57 End Action ODBCLocked
15:19:57 This combination of Package and Operating System allows a client install only.
15:19:59 The Enterprise Edition server component cannot be installed on Windows NT Server using this CD. Only client components will be available for installation.
15:19:59 Reading SoftwareMicrosoftWindowsCurrentVersionCommonFilesD ir ...
15:19:59 CommonFilesDir=C:Program FilesCommon Files
15:19:59 Windows Directory=C:NTSRVR15:19:59 Begin Action: ShowDialogs
15:19:59 Begin Action: DialogShowSdWelcome
15:20:00 End Action DialogShowSdWelcome
15:20:00 Begin Action: DialogShowSdLicense
15:20:01 End Action DialogShowSdLicense
15:20:01 Begin Action: DialogShowSdRegisterUserEx
15:20:06 End Action DialogShowSdRegisterUserEx
15:20:06 Begin Action: DialogShowCdKey
15:20:06 End Action DialogShowCdKey
15:20:06 Begin Action: DialogShowPID
15:20:06 End Action DialogShowPID
15:20:06 Begin Action: DialogShowSdSetupType
15:20:10 [SetupTypeSQL]
15:20:10 szDir=C:MSSQL7
15:20:10 Result=303
15:20:10 szDataDir=C:MSSQL7
15:20:10 End Action DialogShowSdSetupType
15:20:10 Begin Action: DialogShowSdComponentMult
15:20:10 basesys=0, baseinst=0,basedata=0
15:20:19 SQL program folder: C:MSSQL7
15:20:19 SQL data folder: C:MSSQL7
15:20:19 Windows system folder: C:NTSRVRSystem3215:20:19 Prog req: 46703, Data req: 0, Sys req: 24971
15:20:19 Prog avail: 2147483, Data avail: 2147483, Sys avail: 2147483
15:20:19 Prog req vs. avail, 71674, 2147483
15:20:19 Data req vs. avail, 0, 2147483
15:20:19 Sys req vs. avail, 24971, 2147483
15:20:19 DisplaySystemPreReq
15:20:19 [SQLComponentMult]
15:20:19 Component=
15:20:19 Result=1
15:20:19 End Action DialogShowSdComponentMult
15:20:19 Begin Action: DialogShowSdStartCopy
15:20:38 End Action DialogShowSdStartCopy
15:20:38 Begin Action: DlgCPLLicense
15:20:38 End Action DlgCPLLicense
15:20:38 End Action ShowDialogs
15:20:38 Begin Action ProcessBeforeDataMove:
15:20:38 DeinstallStart returned (C:MSSQL7): -1
15:20:38 DeinstallStart returned (C:MSSQL7): 0
15:20:38 End Action ProcessBeforeDataMove:
15:20:38 Begin Action ProcessComponentSelection:
15:20:38 End Action ProcessComponentSelection
15:20:38 Begin Action LogSelectedComponents:
15:20:38 MgtTool
15:20:38 MgtToolSEM
15:20:38 MgtToolSEMHTML
15:20:38 MgtToolSEMMSD98
15:20:38 MgtToolSEMMSD98SYS
15:20:38 MgtToolSEMMSD98Res
15:20:38 MgtToolSEMMSD98Hlp
15:20:38 MgtToolSEMHelp
15:20:38 MgtToolSEMSEMSys
15:20:38 MgtToolSEMRes1033
15:20:38 MgtToolSEMResIntl
15:20:38 MgtToolSEMMSD98RsI
15:20:38 MgtToolProfiler
15:20:38 MgtToolProfilerHelp
15:20:38 MgtToolProfilerRes1033
15:20:38 MgtToolProfilerResIntl
15:20:38 MgtToolQryanlz
15:20:38 MgtToolQryanlzHelp
15:20:38 MgtToolQryanlzRes1033
15:20:38 MgtToolQryanlzResIntl
15:20:38 MgtToolDTCCLi
15:20:38 MgtToolWzcnflct
15:20:38 MgtToolWzcnflctWzcnsys
15:20:38 MgtToolWzcnflctWzcnHlp
15:20:38 MgtToolUtilSys
15:20:38 MgtToolUtilBinn
15:20:38 Connect
15:20:38 ConnectConnSys
15:20:38 ConnectConn9x
15:20:38 ConnectConnNT
15:20:38 Books
15:20:38 BooksBookso
15:20:38 DevTools
15:20:38 DevToolsHeaders and Libraries
15:20:38 DevToolsHeaders and LibrariesInclude
15:20:38 DevToolsHeaders and LibrariesLibx86
15:20:38 DevToolsHeaders and LibrariesLibAlpha
15:20:38 DevToolsHeaders and LibrariesESQLC
15:20:38 DevToolsMDAC SDK
15:20:38 DevToolsVDI
15:20:38 DevToolsVDIInc
15:20:38 DevToolsVDISamples
15:20:38 DevToolsDbg Int
15:20:38 DevToolsDbg IntDbg Int Common
15:20:38 DevToolsDbg IntEXE
15:20:38 Samples
15:20:38 SamplesADO
15:20:38 SamplesDBLIB
15:20:38 SamplesDTS
15:20:38 SamplesESQLC
15:20:38 SamplesMSDTC
15:20:38 SamplesODBC
15:20:38 SamplesODS
15:20:38 SamplesOLEAut
15:20:38 SamplesRepl
15:20:38 SamplesSQLDMO
15:20:38 SamplesSQLNS
15:20:38 Core
15:20:38 CoreSys
15:20:38 ODBC
15:20:38 OLEDB
15:20:38 Repostry
15:20:38 RepstSys
15:20:38 CoreMisc
15:20:38 Monarch
15:20:38 Jet
15:20:38 NetCore
15:20:38 NetExt
15:20:38 SFExt
15:20:38 ReplExt
15:20:38 Core1033
15:20:38 CoreIntl
15:20:38 CrMi1033
15:20:38 CrMiIntl
15:20:38 Monr1033
15:20:38 MonrIntl
15:20:38 SFEx1033
15:20:38 SFExIntl
15:20:38 RpEx1033
15:20:38 RpExIntl
15:20:38 SysCore
15:20:38 VOLEDB
15:20:38 VODBC
15:20:38 MiscCore
15:20:38 MCHlp
15:20:38 MC1033
15:20:38 MCIntl
15:20:38 CnctBinn
15:20:38 CrRepCom
15:20:38 {E07FDDC8-5A21-11d2-9DAD-00C04F79D434}
15:20:38 {E07FDDBF-5A21-11d2-9DAD-00C04F79D434}
15:20:38 End Action LogSelectedComponents
15:20:38 Begin Action MoveFileData:
15:21:11 End Action MoveFileData
15:21:11 Begin Action ProcessAfterDataMove:
15:21:11 DeinstallSetReference (C:MSSQL7sqlservr.exe) returned: 0
15:21:11 End Action ProcessAfterDataMove
15:21:11 Begin Action InstallPkgs:
15:21:11 Setup is installing Microsoft Management Console (MMC) ...
15:21:11 D:x86Otherinstmmc.exe /Q
15:21:35 Process Exit Code: (0)
15:21:35 Setup is installing HTML Help ...
15:21:36 HTML Help installer exit code: 0
15:21:36 End Action InstallPkgs
15:21:36 Path successfully updated.
15:21:36 %SystemRoot%system32;%SystemRoot%;%SystemRoot%syst em32WBEM;C:Program FilesSymantecpcAnywhere;C:MSSQL7BINN
15:21:36 Begin Action SelfRegister
15:23:39 Return code: 0
15:23:39 End Action SelfRegister
15:23:39 Begin Action SetupRegistry:
15:23:39 End Action SetupRegistry
15:23:39 Begin Action PostSetupRegistry:
15:23:39 C:MSSQL7BINNdcomscm.exe /RegServer
15:23:39 Process Exit Code: (0)
15:23:39 C:PROGRA~1COMMON~1MICROS~1SQLDEB~1sqldbreg.exe -RegServer
15:23:39 Process Exit Code: (-2147312566) Error loading type library/DLL.
15:23:40 C:PROGRA~1COMMON~1MICROS~1DATABA~1wzcnflct.exe /RegServer
15:23:40 Process Exit Code: (0)
15:23:40 End Action PostSetupRegistry
15:23:40 Begin Action SetupFolders:
15:23:40 Microsoft SQL Server 7.0 Folder refreshed.
15:23:40 End Action SetupFolders
15:23:40 Action CleanUpInstall:
15:23:40 Uninstall command: C:NTSRVRIsUninst.exe -fC:MSSQL7Uninst.isu -c"C:MSSQL7sqlsun.dll" -msql70.mif
15:23:40 SetTracking: {E07FDDA8-5A21-11d2-9DAD-00C04F79D434}
15:23:40 SetTracking: {E07FDDA9-5A21-11d2-9DAD-00C04F79D434}
15:23:40 SetTracking: {E07FDDAA-5A21-11d2-9DAD-00C04F79D434}
15:23:40 SetTracking: {E07FDDAB-5A21-11d2-9DAD-00C04F79D434}
15:23:40 SetTracking: {E07FDDAC-5A21-11d2-9DAD-00C04F79D434}
15:23:40 SetTracking: {E07FDDAD-5A21-11d2-9DAD-00C04F79D434}
15:23:40 SetTracking: {E07FDDAF-5A21-11d2-9DAD-00C04F79D434}
15:23:40 SetTracking: {E07FDDB0-5A21-11d2-9DAD-00C04F79D434}
15:23:40 SetTracking: {E07FDDB1-5A21-11d2-9DAD-00C04F79D434}
15:23:40 SetTracking: {E07FDDB2-5A21-11d2-9DAD-00C04F79D434}
15:23:40 SetTracking: {E07FDDB3-5A21-11d2-9DAD-00C04F79D434}
15:23:40 SetTracking: {E07FDDB4-5A21-11d2-9DAD-00C04F79D434}
15:23:40 SetTracking: {E07FDDB5-5A21-11d2-9DAD-00C04F79D434}
15:23:40 SetTracking: {E07FDDB6-5A21-11d2-9DAD-00C04F79D434}
15:23:40 SetTracking: {E07FDDB7-5A21-11d2-9DAD-00C04F79D434}
15:23:40 SetTracking: {E07FDDB8-5A21-11d2-9DAD-00C04F79D434}
15:23:40 SetTracking: {E07FDDB9-5A21-11d2-9DAD-00C04F79D434}
15:23:40 SetTracking: {E07FDDBA-5A21-11d2-9DAD-00C04F79D434}
15:23:40 SetTracking: {E07FDDBB-5A21-11d2-9DAD-00C04F79D434}
15:23:40 SetTracking: {E07FDDBB-5A21-11d2-9DAD-00C04F79D434}
15:23:40 SetTracking: {E07FDDBD-5A21-11d2-9DAD-00C04F79D434}
15:23:40 SetTracking: {E07FDDC8-5A21-11d2-9DAD-00C04F79D434}
15:23:40 SetTracking: {E07FDDBF-5A21-11d2-9DAD-00C04F79D434}
15:23:40 Installation Succeeded
Thanks,
Sarah
Ok I'm am going through a rather painful experience of installing Reporting Services on:
Windows 2000 SP4
MDAC 2.8
.Net Framework 2.0
IIS 5.0
SQL Server 2005 Developer
I have installed RS 2005 on Windows 2003, and seen it installed on XP no problems. However this is a nightmare.
RS goes ahead and installs - note that there is no Network/Local service option on the service accounts just Local system or the domain account option. I have tried using the Local system and tried using the NT AUTHORITY/SYSTEM.
After the installation I go to the Reporting Services Configuration Tool, where I have crosses on:
- Server Status
- Report Server Virtual Directory
- Report Manager Virtual Directory
- Web Service Identity
- Database Setup
I- nitialization
So I go to report server/manager and click on "New.." on each to create the virtual directories and check "apply default settings" and click "Apply", all goes well
Web Service Identity I cannot change so I go to:
C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServer
sreportserver.config
and change the web service account to:
<WebServiceAccount><<MACHINE NAME>>ASPNET</WebServiceAccount>
When I restart the reporting services service I no longer see a warning in the reporting services log file about the WebServiceAccount
I go back to the Reporting Services Config Tool, where I have crosses on the following:
Web Service Identity
Database Setup
Initialization
The Web Service Identity stays greyed out...
I go to Database Setup:
connect to the server
select the reportingserver database
leave it set as service credentials
Click "Apply"
and I get the most vague of all error messages:
"There was a failure applying your change
A virtual directory must first be created before performing this operation"
What virtual directory, where???
I look in the log files..nothing. I look in the event viewer...and...nothing.
I look on here...
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=628231&SiteID=1
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1682492&SiteID=1
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=493194&SiteID=1
Either unanswered or there is the one answer but it is not relevant in this case.
Can someone please provide some advice before I lose my sanity?
Thanks in advance
I have been asked to install Sql 7 on a Win2K server. I am looking for White papers, articles, postings etc which identify potential issues or known issues. I have looked through MSDN, Win2K, Microsoft Sql7 and TechNet for specifics. Any suggestions?
Thank you,
Troy
Hi,
I recently migrated our database from Access to SQL Server 2005. All the WinXP users can connect to the new SQL2005 database. But all the Win2K machines fail to log on. To diagnose the problem, I tried to connect from a Wind2K machine using an .udl file. The connection failed because "a provider failed to initialize".
The SQL2005 server is residing on a WinXP machine. Users log on via SQL Server authentication layer using a dedicated login that only has read/write privileges to one specific database.
Does anyone know a solution? Thanks in adance.
Regards,
Vladislav
error msg in summary.txt
Microsoft SQL Server 2005 9.00.1399.06
==============================
OS Version : Microsoft Windows 2000 Server Service Pack 4 (Build 2195)
Time : Wed Feb 14 03:31:27 2007
LDINTSQL1 : There was an unexpected failure during the setup wizard. You may review the setup logs and/or click the help button for more information.
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
Time : Wed Feb 14 03:39:30 2007
List of log files:
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_LDINTSQL1_Core.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_LDINTSQL1_Datastore.xml
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_LDINTSQL1_.NET Framework 2.0.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSummary.txt
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_LDINTSQL1_.NET Framework 2.0 LangPack.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_LDINTSQL1_.NET Framework Upgrade Advisor.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_LDINTSQL1_.NET Framework Upgrade Advisor LangPack.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_LDINTSQL1_.NET Framework Windows Installer.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_LDINTSQL1_.NET Framework Windows Installer LangPack.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_LDINTSQL1_SNAC.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_LDINTSQL1_Support.log
error msg in C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_LDINTSQL1_Core.log
Microsoft SQL Server 2005 Setup beginning at Wed Feb 14 03:31:27 2007
Process ID : 2176
\ldnas1msdn versionsServer ApplicationsSQL Server 2005 stdServerssetup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2007/1/14 3:31:27
Complete: LoadResourcesAction at: 2007/1/14 3:31:27, returned true
Running: ParseBootstrapOptionsAction at: 2007/1/14 3:31:27
Loaded DLL:\ldnas1msdn versionsServer ApplicationsSQL Server 2005 stdServersxmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2007/1/14 3:31:27, returned true
Running: ValidateWinNTAction at: 2007/1/14 3:31:27
Complete: ValidateWinNTAction at: 2007/1/14 3:31:27, returned true
Running: ValidateMinOSAction at: 2007/1/14 3:31:27
Complete: ValidateMinOSAction at: 2007/1/14 3:31:27, returned true
Running: PerformSCCAction at: 2007/1/14 3:31:27
Complete: PerformSCCAction at: 2007/1/14 3:31:27, returned true
Running: ActivateLoggingAction at: 2007/1/14 3:31:27
Complete: ActivateLoggingAction at: 2007/1/14 3:31:27, returned true
Delay load of action "DetectPatchedBootstrapAction" returned nothing. No action will occur as a result.
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__2176" returned false.
Running: PerformSCCAction2 at: 2007/1/14 3:31:27
Loaded DLL:C:WINNTsystem32msi.dll Version:3.1.4000.2435
Loaded DLL:C:WINNTsystem32msi.dll Version:3.1.4000.2435
Complete: PerformSCCAction2 at: 2007/1/14 3:31:27, returned true
Running: PerformDotNetCheck at: 2007/1/14 3:31:27
Complete: PerformDotNetCheck at: 2007/1/14 3:31:27, returned true
Running: ComponentUpdateAction at: 2007/1/14 3:31:27
Complete: ComponentUpdateAction at: 2007/1/14 3:31:54, returned true
Delay load of action "DetectLocalBootstrapAction" returned nothing. No action will occur as a result.
Action "LaunchLocalBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchLocalBootstrap__2176" returned false.
Running: PerformDotNetCheck2 at: 2007/1/14 3:31:54
Complete: PerformDotNetCheck2 at: 2007/1/14 3:31:54, returned true
Running: InvokeSqlSetupDllAction at: 2007/1/14 3:31:54
Error: Action "InvokeSqlSetupDllAction" threw an exception during execution.
Failed to determine path to bootstrap files : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
Source File Name: setupsqlsetupactions.cpp
Compiler Timestamp: Thu Sep 1 22:23:04 2005
Function Name: sqls::InvokeSqlSetupDllAction::perform
Source Line Number: 1663
any ideas?
thanks
I've got SQL 2000 set up on a cluster running Windows 2000 Advanced Server (w/SP1).
Setup for Failover Clustering appeared to succeed normally on both nodes.
The SQL 2000 server logs show:
2001-01-11 10:02:57.82 server SuperSocket Info: Bind failed on TCP port 1433.
2001-01-11 10:02:57.85 server SQL server listening on Shared Memory, Named Pipes.
2001-01-11 10:02:57.85 server SQL Server is ready for client connections
I've checked to see if something else is using port 1433 (unlikely) and don't see anything.
The physical node that SQL 2000 is currently on has no other cluster resources assigned to it.
Any ideas?
Hi
Today I have task to move all UDB's including matser,msdb form Windows 2000 server to Windows 2003 Advacned Server with 64bit(8 Hours Down time)
Present Plan
1.Install same Version of SQL Server in Destination Server
2.Take all Databases Backup
2.Move DTS,JOB and Scripts with same location
3.Stop both servers SQL Server's
4.Deattch all Databses and Move to Destination Server
5.Place all Databases(Same Loaction i.e Soruce Server master DB is C:<folders>.. Place in Destination Server C:<folder>..)
6.Start the Databse Servers(Destination)
7.Port the Apllication and Test.
Note:for our project we are using windows users,so that no problem with Orphan users.
Please some body Advice me, or suggest me
..it is ok
Hi, I have a little question regarding
SQLServer2000 vs ADO of Visual Basic 6
In a code snipplet a have something like:
Conn1.BeginTrans
Set rec_tmp = Conn1.Execute("SELECT * FROM IDENTIFICATIONS;")
Conn1.Execute "DELETE FROM CARS WHERE CAR_ID = 8;"
.
.
.
Conn1.CommitTrans
and whe VB tries to execute the line with the
DELETE sentence the Err object says something like:
"cannot create a new connection because you are in
distributed or manual transaction mode"
However, if I remove the line that executes the sentence
SELECT * FROM IDENTIFICATIONS the error never shows up.
Seems like I canīt execute a SELECT before a DELETE/UPDATE
even if I execute the SELECT in some other table.
Iīve tried changing the IsolationLevel, Mode and Cursor
Location properties and the error always occurs.
Furthermore, I tried putting the SELECT out of the
transaction and the error continues showing up.
Why does this occurs? Is there a way to solve it?
NOTE: I need forcely to execute that SELECT before the DELETE.
Thanks for the time
Roland
Hi, I have a little question regarding
SQLServer2000 vs ADO of Visual Basic 6
In a code snipplet a have something like:
Conn1.BeginTrans
Set rec_tmp = Conn1.Execute("SELECT * FROM IDENTIFICATIONS;")
Conn1.Execute "DELETE FROM CARS WHERE CAR_ID = 8;"
.
.
.
Conn1.CommitTrans
and whe VB tries to execute the line with the
DELETE sentence the Err object says something like:
"cannot create a new connection because you are in
distributed or manual transaction mode"
However, if I remove the line that executes the sentence
SELECT * FROM IDENTIFICATIONS the error never shows up.
Seems like I canīt execute a SELECT before a DELETE/UPDATE
even if I execute the SELECT in some other table.
Iīve tried changing the IsolationLevel, Mode and Cursor
Location properties and the error always occurs.
Furthermore, I tried putting the SELECT out of the
transaction and the error continues showing up.
Why does this occurs? Is there a way to solve it?
NOTE: I need forcely to execute that SELECT before the DELETE.
Thanks for the time
Roland
date(m/dd/yyyy)9/18/2006 In this above table i want to select only the month in this format Sep 2006 . How to do that ?
View 1 Replies View RelatedHello everyone,My project (asp.net and sqlserver2000) is working fine in my intranet. But sometime, it cannot connect to sqlserver, it shows "SQLServer does not exists or access denied". If I restart my dbserver and webserver, then it again works fine.Please give me a solution.
View 1 Replies View RelatedHi,
I have created the below procedure in SQL SERVER 2005.
But when I copy out the same in SQL SERVER 2000. I get an error at the underlined place. It says
Line 32: Incorrect syntax near '('.
ALTER procedure [dbo].[VTELcardvalidation1]
@CardValue1 int,
@CardValue2 int,
@CardValue3 int,@Result nvarchar(50)output
as
begin
declare @CrdPinNo varchar(100)
declare @CrdNo nvarchar(100)declare @count int
declare @inc int
declare @concat nvarchar(200)create table #temptable(crno nvarchar(50),pno nvarchar(50))
--First Card
--Change here
select @count=count(cardno) from vendorcardvalidation where cardvalue=1500 and flag=0if (@count)>@CardValue1
begin
declare cur1 cursor forselect top(@CardValue1) pin,cardno from vendorcardvalidation where cardvalue=1500 and flag=0 order by cardno
open cur1fetch next from cur1 into @CrdPinNo,@CrdNo
while(@@fetch_status=0)
beginupdate vendorcardvalidation set flag=1 where cardno=@CrdNo
insert into #temptable values(1500,@CrdPinNo)fetch next from cur1 into @CrdPinNo,@CrdNo
endclose cur1
deallocate cur1
set @Result='Success'end
else
begin
set @Result='Failure'
end
select * from #temptable
drop table #temptable
end
It seems the the word 'top' will not be supported in sqlserver 2000. What should I do?
Regards
cmrhema
Sir,i am running .net1.1 on my system with sqlserver as my database.I am devaloping an e-trading project in ASP.NET with VB.net.My problem is that,I am not getting the correct syntax to query the database with SELECT(with WHERE clause)in vb.net.Please help me.
View 1 Replies View RelatedHi,
I would like to create groups in SQLServer2000.Do i need to do this by roles or can i create groups for each database.I read some where that there where
no groups for SQLServer7.0. Is this option available for the latest versions.
Any help will be appreciated.
Thanks in Advance.
Ran.
I turned the Audit ALL option on SQLServer instance "security" tab and restarted the SQLServer but do not see any information logged in SQLServer Logs though I tried to access databases and logged in a couple of times through Query Analyzer. Why is that no logging happened and how can I get this fixed?
Any help is appreciated.
Vinnie
Hai
I wrote a sp in sqlserver2000 and sp consists of 1 input parameter of type datetime and everything is working fine but if i pass the argument of invalid date format it is giving error.Is there any way to handle errors in sps and even if i give invalid format it should not raise errors.Pls reply as early as possible.
Thanks
Aruna
More of a SQL Server problem than a ASP one but hope you can help me :)
Im tryin to do my first data based application using ASP.net and silly me I forgot to add users when I created then database so now Visual Studio can't access it.
Can someone tell me the syntax to add/create a user to MSSQL database so I can then grant them privelidges to the tables.
thanks very much
Tom
hi all,
my problem is failure in the connection to SQLserver2000 remotly( to city a) by enterprise manager or query analyzer via windows authentication ( this error appears "login failed for (domain/user)" ),while no problems happened in the connection when i would to connect to other servers at other locations(to cities b,c) via windows authentication.
note that i can access to (city a)server via sql server authentication , but i want to access to this server(city a) via windows authenication as the other locations because this authentication mode is policy of our system, and note also that persons in city b can access to all servers (city a,c) via windows authenication .
regards,
Hi,
If access database has an extension of .mdb then what is sqlserver2000 file extension?