Error when connecting to sql 2000

I am trying to connect to a sql 2k database using a Microsoft Application block. I get the following error. It is saying about 2005, I verified that SQL 2K is running on the server.

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

Any help will be appreciated.

Hi,

1. Verify the firewall have open the port of SQL 2K,

2. the Service pack versión I have some problems with versions under sp4

greetings.

|||

Hi jijo_robert,

That's a common issue. If you perform a search through google for the error message you are getting, you will find many valuable solutions.

The first thing for you to do is to check your connection string, make sure you have used the correct server name, database name , authentication mode,,.etc

If you still cannot figure it out, open up your query analyzer and connect to your database manually, see if you can login this way(there is a possibility that there maybe some problem in the server side)

Hope my suggestion helps

|||I could connect using sql query analyzer. I can also connect during design time (Gridview --> SQLDatasource --> and see the records with a connection string) but when I run it it gives this error.|||Make sure that you don't have any other program using the database other than Visual Web Developer if that is what u're using, or having the connection open. What mostly cause this kind of problem is when you have your database open in the database explorer of your VWD or VS.Hope this works.Please give me the appropriate make if this works for this is my first post on the forums|||

No other program is using SQL server databsae

Error trying to install reporting services

I have verified that iwam_computer is enabled and in sync.
error mesage -
Internet Information Services 5.0 (IIS) or later is either not installed, or
it is configured in a way that is incompatible with a Reporting Services
installation.
log -
Microsoft SQL Server 2000 Reporting Services Setup beginning at Mon Jan 24
09:22:42 2005
<Func Name='UpdateComponents'>
SCU_SetupMgr::InitComponents()
<Func Name='WindowsInstallerComp::Init'>
<Func Name='WindowsInstallerComp::IsRequired'>
<Func Name='DotNetFxComp::Init'>
<Func Name='DotNetFxComp::IsRequired'>
<EndFunc Name='DotNetFxComp::IsRequired' Return='F' GetLastError='0'>
SCU_SetupMgr::svc() state=SS_INIT_DONE, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:414}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
<Func Name='SqlSetupFilesComp::Install'>
<Func Name='BootstrapPackageLogic'>
<Func Name='InstallBootstrapPackage'>
/I "E:\SQLRSEVAL\Setup\bootmsi.dat" REBOOT="ReallySuppress"
ADDLOCAL="BootstrapFiles,WatsonFiles,ParsFiles1033,HelpFiles1028,HelpFiles1031,HelpFiles1033,HelpFiles1036,HelpFiles1040,HelpFiles1041,HelpFiles1042,HelpFiles2052,HelpFiles3082,WatsonFiles1033" /qn
<EndFunc Name='InstallBootstrapPackage' Return='0' GetLastError='183'>
<EndFunc Name='BootstrapPackageLogic' Return='0' GetLastError='183'>
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
ScuProgressDlg::SetupFinished()
ScuProgressDlg::DialogProc() installation done... waiting for setup mgr
SCU_SetupMgr::svc() finished. SetupMgr: state=FINISHED, cancel_state=0,
is_done=1, ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:420}
<EndFunc Name='UpdateComponents' Return='0' GetLastError='183'>
<Func Name='DwLaunchMsiExec'>
<Func Name='PerformDetections'>
0
<EndFunc Name='PerformDetections' Return='0' GetLastError='0'>
Machine = ISOVDEVWAC8, Article = IIS, Result = 0 (0x0)
<Prerequisite Name="IsVS71Installed" Checked="Registry"
Item="HKLM\SOFTWARE\Microsoft\VisualStudio\7.1" Found="Can not open key"
Expected="No error" Result="Fail" />
Machine = ISOVDEVWAC8, Article = VSNET, Result = 60351 (0xebbf)
Machine = ISOVDEVWAC8, Article = ASPNET, Result = 0 (0x0)
Machine = ISOVDEVWAC8, Article = MDAC, Result = 0 (0x0)
Machine = ISOVDEVWAC8, Article = DTC, Result = 0 (0x0)
Machine = ISOVDEVWAC8, Article = SERVEROS, Result = 0 (0x0)
Machine = ISOVDEVWAC8, Article = SHAREPOINT, Result = 0 (0x0)
Machine = ISOVDEVWAC8, Article = AUTHZ, Result = 0 (0x0)
<Prerequisite Name="AreRSAccountsValidInstalled" Checked="User accounts"
Item="IWAM_machineName" Found="Not exist or not enable" Expected="Exist and
enabled" Result="Fail" />
Machine = ISOVDEVWAC8, Article = RSACCOUNTS, Result = 60357 (0xebc5)
**************
ISOVDEVWAC8
**************
Report Designer component requirement
<B>Explanation:</B> Visual Studio .NET 2003 is not installed.
<B>Action:</B> Install Visual Studio .NET 2003, and then rerun Setup to
install Report Designer. Or, continue Setup to complete the installation
without Report Designer.
Report Server component requirement
<B>Explanation:</B> Internet Information Services 5.0 (IIS) or later is
either not installed, or it is configured in a way that is incompatible with
a Reporting Services installation.
<B>Action:</B> To install the Report Server and Report Manager components,
you must first install Internet Information Services 5.0 (IIS) or later, and
then verify that the Web server configuration requirements are compatible
with Setup. Check the Setup documentation for more information about Web
server configuration requirements.
Report size = 1050
<Func Name='FSetupLogging'>
<Func Name='CreateSetupLogCabs'>
Creating Setup Logs Cab "C:\Program Files\Microsoft SQL Server\80\RS Setup
Bootstrap\LOG\RSStp_.cab"seems error comes from these line
> <Func Name='InstallBootstrapPackage'
> /I "E:\SQLRSEVAL\Setup\bootmsi.dat" REBOOT="ReallySuppress"
ADDLOCAL="BootstrapFiles,WatsonFiles,ParsFiles1033,HelpFiles1028,HelpFiles1031,HelpFiles1033,HelpFiles1036,HelpFiles1040,HelpFiles1041,HelpFiles1042,HelpFiles2052,HelpFiles3082,WatsonFiles1033
/q
> <EndFunc Name='InstallBootstrapPackage' Return='0
GetLastError='183'
> <EndFunc Name='BootstrapPackageLogic' Return='0
GetLastError='183'
>
Did you find how to solve it ? i got the same problem..
Thank|||o
in my case i used to install it with the command line options wher
some errors are but if you used the response file it's the same
For example do not use REINSTALL=All; it just failed, us
REINSTALLMODE=omus or amus (omus works
Also RS_BooksOnline_EN is not a valid entry even you see it everywher
on Ms Docs (bull...
use RS_BooksOnline and not RS_BooksOnline_EN
Hope it will hav helped yo