"server could not be found" problem

hi all,
i downloaded the msde 2000 release A and a graphic tool . i named the
instance as "MSSQLSERVER". installation was success ful. i gave the directory
in the set up parameter to my local drive "C:\vinoth". Installation
automatically creadted a folder named "C:\vinothMSSQL". inside contains the
binn and data files.
when i ry to connect thru the graphic tool in gave server name
"MSSQLSERVER"
user name "sa" , pass word "sa". but it says server not found.i saw
the services in control panel . the MSSQLSERVER is running.
please help to resolve this issue
thanks
vinoth
hi,
vinoth wrote:
> hi all,
> i downloaded the msde 2000 release A and a graphic tool . i
> named the instance as "MSSQLSERVER". installation was success ful. i
> gave the directory in the set up parameter to my local drive
> "C:\vinoth". Installation automatically creadted a folder named
> "C:\vinothMSSQL". inside contains the binn and data files.
> when i ry to connect thru the graphic tool in gave server name
> "MSSQLSERVER"
> user name "sa" , pass word "sa". but it says server not
> found.i saw the services in control panel . the MSSQLSERVER is
> running.
>
please do not open all these threads for the same question...
instead of providing the "MSSQLSERVER" name (which only is the name of the
service) provide the server name (=ComputerName or ComputerName\InstanceName
for named instances)
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

"Not associated with a trusted SQL Server connection"

Hello,
Having some trouble here with a CRM installation, and I think there is
something wrong with our SQL Server, since we got the exact same issue with
another application.
Anyhow, we got a SQL Server 2000 SP4. Right now we are running databases for
Microsoft Navision 4.0 and a .NET webshop, and it works fine. Installed a new
server the otherday (Windows Server 2003 SP1) for Microosoft CRM, and want
the CRM-databases on our current SQL Server.
During installation we get the following error:
=====================
Microsoft CRM 3.0 Server Setup
Activating SQL Server Reporting Services failed.
Setup failed to validate specified Reporting Services Report Server
http://CRM1/ReportServer. Error: The report server cannot open a connection
to the report server database. A connection to the database is required for
all requests and processing.
=====================
I press "Ignore" just to finish the installation, and it continues. After
that, when trying to connect to http://crm1 to access the system (from the
CRM1 server), it just gives the following .NET-error:
=========================
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
=========================
Been Googleing and testing alot of stuff, but can't find the solution. I am
not that great on SQL Server, so we got a few other people to look at it, but
it just doesn't work.
Anyone know what to do, I'm clueless...
Problem solved.
On the SQL Server, in "local security policy" --> "access this computer from
the network" was only "domain/domain users" specified. I added CRM1 (the
server), and it started to work.
"joup" wrote:

> Hello,
> Having some trouble here with a CRM installation, and I think there is
> something wrong with our SQL Server, since we got the exact same issue with
> another application.
> Anyhow, we got a SQL Server 2000 SP4. Right now we are running databases for
> Microsoft Navision 4.0 and a .NET webshop, and it works fine. Installed a new
> server the otherday (Windows Server 2003 SP1) for Microosoft CRM, and want
> the CRM-databases on our current SQL Server.
> During installation we get the following error:
> =====================
> Microsoft CRM 3.0 Server Setup
> --
> Activating SQL Server Reporting Services failed.
> Setup failed to validate specified Reporting Services Report Server
> http://CRM1/ReportServer. Error: The report server cannot open a connection
> to the report server database. A connection to the database is required for
> all requests and processing.
> =====================
> I press "Ignore" just to finish the installation, and it continues. After
> that, when trying to connect to http://crm1 to access the system (from the
> CRM1 server), it just gives the following .NET-error:
> =========================
> Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection.
> =========================
> Been Googleing and testing alot of stuff, but can't find the solution. I am
> not that great on SQL Server, so we got a few other people to look at it, but
> it just doesn't work.
> Anyone know what to do, I'm clueless...

"Not associated with a trusted SQL Server connection"

Hello,
Having some trouble here with a CRM installation, and I think there is
something wrong with our SQL Server, since we got the exact same issue with
another application.
Anyhow, we got a SQL Server 2000 SP4. Right now we are running databases for
Microsoft Navision 4.0 and a .NET webshop, and it works fine. Installed a ne
w
server the otherday (Windows Server 2003 SP1) for Microosoft CRM, and want
the CRM-databases on our current SQL Server.
During installation we get the following error:
=====================
Microsoft CRM 3.0 Server Setup
--
Activating SQL Server Reporting Services failed.
Setup failed to validate specified Reporting Services Report Server
http://CRM1/ReportServer. Error: The report server cannot open a connection
to the report server database. A connection to the database is required for
all requests and processing.
=====================
I press "Ignore" just to finish the installation, and it continues. After
that, when trying to connect to http://crm1 to access the system (from the
CRM1 server), it just gives the following .NET-error:
=========================
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
=========================
Been Googleing and testing alot of stuff, but can't find the solution. I am
not that great on SQL Server, so we got a few other people to look at it, bu
t
it just doesn't work.
Anyone know what to do, I'm clueless...Problem solved.
On the SQL Server, in "local security policy" --> "access this computer from
the network" was only "domain/domain users" specified. I added CRM1 (the
server), and it started to work.
"joup" wrote:

> Hello,
> Having some trouble here with a CRM installation, and I think there is
> something wrong with our SQL Server, since we got the exact same issue wit
h
> another application.
> Anyhow, we got a SQL Server 2000 SP4. Right now we are running databases f
or
> Microsoft Navision 4.0 and a .NET webshop, and it works fine. Installed a
new
> server the otherday (Windows Server 2003 SP1) for Microosoft CRM, and want
> the CRM-databases on our current SQL Server.
> During installation we get the following error:
> =====================
> Microsoft CRM 3.0 Server Setup
> --
> Activating SQL Server Reporting Services failed.
> Setup failed to validate specified Reporting Services Report Server
> http://CRM1/ReportServer. Error: The report server cannot open a connectio
n
> to the report server database. A connection to the database is required fo
r
> all requests and processing.
> =====================
> I press "Ignore" just to finish the installation, and it continues. After
> that, when trying to connect to http://crm1 to access the system (from the
> CRM1 server), it just gives the following .NET-error:
> =========================
> Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection.
> =========================
> Been Googleing and testing alot of stuff, but can't find the solution. I a
m
> not that great on SQL Server, so we got a few other people to look at it,
but
> it just doesn't work.
> Anyone know what to do, I'm clueless...

"Error!" msg during "setup support files" installation

Windows 2003 Server. Asp.Net 1.1. Sql Server 2000 Sp3a.
"Error!" msg during "setup support files" installation.
Unable to install Reporting Services. Found a couple of users experiencing
the same problem, but no solution :( Any ideas?
/ChrisFirst, check the error log in Event Viewer and see if you can find any
EventID number for your error. That can pinpoint what the error really is.
If it's error 25619, then check if the DTC service is running? Go check in
services.msc for "Distributed Transaction Coordinator".
Even if it says "started", it might not be. I've had some troubles with
installing RS, and the DTC was the culprit.
It's been discussed in this thread:
http://groups.google.com/groups?hl=en&lr=&threadm=89FD4D17-1F6A-4BCF-A15E-CF098C5A68D7%40microsoft.com&rnum=1
In this thread, Pitroda asks about a password for Network Service. Just
leave the password blank, at least that worked for me.
Kaisa M. Lindahl
"Chris Leaf" <ChrisLeaf@.discussions.microsoft.com> wrote in message
news:E6F567CB-08C9-4B49-8544-9DB32826CC09@.microsoft.com...
> Windows 2003 Server. Asp.Net 1.1. Sql Server 2000 Sp3a.
> "Error!" msg during "setup support files" installation.
> Unable to install Reporting Services. Found a couple of users experiencing
> the same problem, but no solution :( Any ideas?
> /Chris|||Event log says:
"Product: Microsoft SQL Server 2000 Reporting Services Enterprise Edition --
Please install SQL Server by running setup.exe."
and
"Product: Microsoft SQL Server 2000 Reporting Services Enterprise Edition --
Installation failed."
install log ends with:
<Func Name='SqlSetupFilesComp::Install'>
<Func Name='BootstrapPackageLogic'>
<Func Name='InstallBootstrapPackage'>
/I "D:\Setup\bootmsi.dat" REBOOT="ReallySuppress"
ADDLOCAL="BootstrapFiles,WatsonFiles,ParsFiles1033,HelpFiles1028,HelpFiles1031,HelpFiles1033,HelpFiles1036,HelpFiles1040,HelpFiles1041,HelpFiles1042,HelpFiles2052,HelpFiles3082,WatsonFiles1033" /qn
<EndFunc Name='InstallBootstrapPackage' Return='1603' GetLastError='183'>
<EndFunc Name='BootstrapPackageLogic' Return='1603' GetLastError='183'>
SqlSetupFilesComp BootstrapPackageLogic() failed : (1603)
{n:\rosetta\dev\src\everettsetup\sqlcu\dll\customcomps.cpp:565}
SCU_SetupMgr::svc() caught exception: SqlSetupFilesComp
BootstrapPackageLogic() failed : (1603)
{n:\rosetta\dev\src\everettsetup\sqlcu\dll\customcomps.cpp:565}. SetupMgr:
state=ERROR, cancel_state=0, is_done=0, ActionRequired=1, NeedReboot=0,
custom_props={AutoStart=true
HandleReboots=false
ModuleDir=D:
QuietMode=false
Unattended=false
WorkDir=D:
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:428}
ScuProgressDlg::SetupFinished()
ScuProgressDlg::DialogProc() installation done... waiting for setup mgr
<EndFunc Name='UpdateComponents' Return='1602' GetLastError='0'>
DTC is running..
Thanks for your response.
"Kaisa M. Lindahl" wrote:
> First, check the error log in Event Viewer and see if you can find any
> EventID number for your error. That can pinpoint what the error really is.
> If it's error 25619, then check if the DTC service is running? Go check in
> services.msc for "Distributed Transaction Coordinator".
> Even if it says "started", it might not be. I've had some troubles with
> installing RS, and the DTC was the culprit.
> It's been discussed in this thread:
> http://groups.google.com/groups?hl=en&lr=&threadm=89FD4D17-1F6A-4BCF-A15E-CF098C5A68D7%40microsoft.com&rnum=1
> In this thread, Pitroda asks about a password for Network Service. Just
> leave the password blank, at least that worked for me.
> Kaisa M. Lindahl
> "Chris Leaf" <ChrisLeaf@.discussions.microsoft.com> wrote in message
> news:E6F567CB-08C9-4B49-8544-9DB32826CC09@.microsoft.com...
> > Windows 2003 Server. Asp.Net 1.1. Sql Server 2000 Sp3a.
> >
> > "Error!" msg during "setup support files" installation.
> > Unable to install Reporting Services. Found a couple of users experiencing
> > the same problem, but no solution :( Any ideas?
> >
> > /Chris
>
>

"...could not load DCOM"

Hello.
I have the same problem.
Version is
Microsoft SQL Server 2000 - 8.00.2039 - Service Pack 4 installed.
Before installation SP4 I had error "Unexpected NULL value returned for
column '[OpenXML].OutSourcedPartCount' from the OLE DB provider
'OpenXML'. This column cannot be NULL." when I didn't specified values
(no XML branches) for columns with default values.
Any ideas?
Zevakov Andrew
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message184753.htmlI can add that in event viewer I have such entries after calling my
stored proc :
Source: MSSQLSERVER
"Failed to Initialize COM (CoInitializeEx returned 80010119)"
"Heterogeneous Queries and Remote RPC will be disabled."
Zevakov Andrew
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message184753.html