Showing posts with label win2k3. Show all posts
Showing posts with label win2k3. Show all posts

Wednesday, March 21, 2012

Installed, but can't ping 1433

Any and all help is appreciated as project deadline is approaching...

Background:
- Two servers, 1 running WinXP with all updates and 1 running Win2K3 Standard with all updates.
- Both have SQL Express 2005 June CTP installed
- Both have Visual Studio 2005 Express installed.
- Installation finished w/o any errors.
- Services are running (browser and database)
- TCP/IP and named pipes are enabled

Issue:
Can't ping 127.0.0.1:1433.
OSQL times out without being able to establish a connection
Windows Firewall is OFF.

Seems to be a connectivity issue, but I'm a newbie and can't figure out why I can't talk to the database.

As I said, any and all help is appreciated. Thanks to all in advance.

PM

Due to the length of time since this issue was posted, I'm marking it as resolved. If you're still in need of help, please respond here.

Paul

Installed, but can't ping 1433

Any and all help is appreciated as project deadline is approaching...

Background:
- Two servers, 1 running WinXP with all updates and 1 running Win2K3 Standard with all updates.
- Both have SQL Express 2005 June CTP installed
- Both have Visual Studio 2005 Express installed.
- Installation finished w/o any errors.
- Services are running (browser and database)
- TCP/IP and named pipes are enabled

Issue:
Can't ping 127.0.0.1:1433.
OSQL times out without being able to establish a connection
Windows Firewall is OFF.

Seems to be a connectivity issue, but I'm a newbie and can't figure out why I can't talk to the database.

As I said, any and all help is appreciated. Thanks to all in advance.

PM

Due to the length of time since this issue was posted, I'm marking it as resolved. If you're still in need of help, please respond here.

Paul

sql

Monday, March 19, 2012

Installation woes

Hello all,
I am attempting to install RS onto the following machine:
Win2k3 Domain Controller
SQL Standard
I have installed RS successfully, however at the end of the installation it
instructs me that it could not be activated.
I run rsactivate without success...
When I type http://ipaddress/reports I recieve an error Http 404 file not
found...
What have I done wrong?
Cheers
AshThis is the MS docs:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsinstall/htm/gs_installingrs_v1_8k82.asp
This may help more
http://weblogs.asp.net/taganov/archive/2004/03/23/94514.aspx
A Google search should also render a whole bunch.
"AshVsAOD" <.> wrote in message
news:OjsXafHZEHA.2016@.TK2MSFTNGP09.phx.gbl...
> Hello all,
> I am attempting to install RS onto the following machine:
> Win2k3 Domain Controller
> SQL Standard
> I have installed RS successfully, however at the end of the installation
it
> instructs me that it could not be activated.
> I run rsactivate without success...
> When I type http://ipaddress/reports I recieve an error Http 404 file not
> found...
> What have I done wrong?
> Cheers
> Ash
>|||I have read and re-read both of these documents, I perhaps should have
specified that in my previous post.
Still it doesn't work.
"Chris Botha" <chris_s_botha@.AT_h.o.t.m.a.i.l.com> wrote in message
news:%23dDwh5IZEHA.3420@.TK2MSFTNGP12.phx.gbl...
> This is the MS docs:
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsinstall/htm/gs_installingrs_v1_8k82.asp
> This may help more
> http://weblogs.asp.net/taganov/archive/2004/03/23/94514.aspx
> A Google search should also render a whole bunch.
> "AshVsAOD" <.> wrote in message
> news:OjsXafHZEHA.2016@.TK2MSFTNGP09.phx.gbl...
> > Hello all,
> >
> > I am attempting to install RS onto the following machine:
> >
> > Win2k3 Domain Controller
> > SQL Standard
> >
> > I have installed RS successfully, however at the end of the installation
> it
> > instructs me that it could not be activated.
> >
> > I run rsactivate without success...
> >
> > When I type http://ipaddress/reports I recieve an error Http 404 file
not
> > found...
> >
> > What have I done wrong?
> >
> > Cheers
> >
> > Ash
> >
> >
>|||You are right, you should get 401 access denied for a security issue.
Here is what I would have attempted with my knowledge.
1. Check that the virtual directory exists in IIS.
2. The default page on the Reports directory is called Home.aspx, ensure it
is there.
From your example try http://ipaddress/reports/Home.aspx
3. Maybe IIS is blocking aspx pages, so put "aaa.htm" and a "aaa.txt" on the
virtual directory, see if you can get to them.
4. Create a test virtual directory, allow anonymous access, and put some
test pages there, txt, htm, aspx and see if you can get to them. Take the
anonymous access off, see what happens.
"AshVsAOD" <.> wrote in message
news:#iFR2CJZEHA.2816@.TK2MSFTNGP11.phx.gbl...
> I have read and re-read both of these documents, I perhaps should have
> specified that in my previous post.
> Still it doesn't work.
> "Chris Botha" <chris_s_botha@.AT_h.o.t.m.a.i.l.com> wrote in message
> news:%23dDwh5IZEHA.3420@.TK2MSFTNGP12.phx.gbl...
> > This is the MS docs:
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsinstall/htm/gs_installingrs_v1_8k82.asp
> >
> > This may help more
> > http://weblogs.asp.net/taganov/archive/2004/03/23/94514.aspx
> >
> > A Google search should also render a whole bunch.
> >
> > "AshVsAOD" <.> wrote in message
> > news:OjsXafHZEHA.2016@.TK2MSFTNGP09.phx.gbl...
> > > Hello all,
> > >
> > > I am attempting to install RS onto the following machine:
> > >
> > > Win2k3 Domain Controller
> > > SQL Standard
> > >
> > > I have installed RS successfully, however at the end of the
installation
> > it
> > > instructs me that it could not be activated.
> > >
> > > I run rsactivate without success...
> > >
> > > When I type http://ipaddress/reports I recieve an error Http 404 file
> not
> > > found...
> > >
> > > What have I done wrong?
> > >
> > > Cheers
> > >
> > > Ash
> > >
> > >
> >
> >
>|||Chris,
1. The virtual directory exists
2. The page is there and is accessable
3. Following the "Instructions" you pointed to in your previous post I
shouldn't need to do anything when installing on a brand new Win2k3 Domain
Controller, however I thought along these lines also before coming up empty.
4. I am running other Web applications fine off the server. CRM for one.
The whole reason I posted here was that I had exhausted all avenues. I
appreciate the time you have put into this.
Any other ideas anyone? I am at a loss here, I have installed RS
successfully many times on Win2k, this is my first experience with Win2k3.
I am leaning towards CRM having something to do with it. I will continue
the search for answers.
Ash
"Chris Botha" <chris_s_botha@.AT_h.o.t.m.a.i.l.com> wrote in message
news:OQRZG$JZEHA.2544@.TK2MSFTNGP10.phx.gbl...
> You are right, you should get 401 access denied for a security issue.
> Here is what I would have attempted with my knowledge.
> 1. Check that the virtual directory exists in IIS.
> 2. The default page on the Reports directory is called Home.aspx, ensure
it
> is there.
> From your example try http://ipaddress/reports/Home.aspx
> 3. Maybe IIS is blocking aspx pages, so put "aaa.htm" and a "aaa.txt" on
the
> virtual directory, see if you can get to them.
> 4. Create a test virtual directory, allow anonymous access, and put some
> test pages there, txt, htm, aspx and see if you can get to them. Take the
> anonymous access off, see what happens.
> "AshVsAOD" <.> wrote in message
> news:#iFR2CJZEHA.2816@.TK2MSFTNGP11.phx.gbl...
> > I have read and re-read both of these documents, I perhaps should have
> > specified that in my previous post.
> >
> > Still it doesn't work.
> > "Chris Botha" <chris_s_botha@.AT_h.o.t.m.a.i.l.com> wrote in message
> > news:%23dDwh5IZEHA.3420@.TK2MSFTNGP12.phx.gbl...
> > > This is the MS docs:
> > >
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsinstall/htm/gs_installingrs_v1_8k82.asp
> > >
> > > This may help more
> > > http://weblogs.asp.net/taganov/archive/2004/03/23/94514.aspx
> > >
> > > A Google search should also render a whole bunch.
> > >
> > > "AshVsAOD" <.> wrote in message
> > > news:OjsXafHZEHA.2016@.TK2MSFTNGP09.phx.gbl...
> > > > Hello all,
> > > >
> > > > I am attempting to install RS onto the following machine:
> > > >
> > > > Win2k3 Domain Controller
> > > > SQL Standard
> > > >
> > > > I have installed RS successfully, however at the end of the
> installation
> > > it
> > > > instructs me that it could not be activated.
> > > >
> > > > I run rsactivate without success...
> > > >
> > > > When I type http://ipaddress/reports I recieve an error Http 404
file
> > not
> > > > found...
> > > >
> > > > What have I done wrong?
> > > >
> > > > Cheers
> > > >
> > > > Ash
> > > >
> > > >
> > >
> > >
> >
> >
>|||hi,
try this... but i prepared this for installing with share
point server..it may be helpful to u ..
***************
To configure a server running share point portal server,
sql server , analysis services and reporting services
Software Requirements:
1. windows 2003 server enterprise edition.
1.1. Configure application server (enable both front page
extensions and asp.net ) to install IIS.
1.2. Install smtp server
1.3. Configure DNS giving appropriate IP address.
2. SQL Server 2000 Enterprise Edition with Analysis
Services (if reqd) and service packs for both SQL server
and Analysis services.
3. Visual Studio .net Enterprise Architecture
4. Share Point Portal Server
Install share point portal server with out
desktop engine if u r using sql server on the same
machine.
while configuring share point portal server it
will ask to remove front page server extensions at the
time of creating a portal. remove the front page server
extensions and then restart the machine and after that
create a portal site.
5. Reporting services
While installing reporting services it will
check the system and gives a warning message that share
point is also installed in the system and we need to
manually configure reporting services.
leave it and go for the next tab.
Specify a domain/user account where ever asked.
unckeck the ssl certification if u dont have
any and check direct to default
website.
Then continue installing.
After installation
1. go to IIS
right click on reports--> properties--
>configuration -->extensions-->edit
and then uncheck if "Verify that the file exists" is
checked.
and then click OK
close IIS.
2. open E:\Inetpub\wwwroot\webconfig file.
2.1. in <http Modules>
include the third line also.
<add name="Session"
type="System.Web.SessionState.SessionStateModule"/>
and change the below line as follows
pages enableSessionState="true" enableViewState="true"
enableViewStateMac="true" validateRequest="false" />
3. In cmd prompt go to
E:\Program Files\Common Files\Microsoft Shared\web server
extensions\60\BIN
type
stsadm -o addpath -url http://localhost/reportserver -type
exclusion
and
stsadm -o addpath -url http://localhost/reports -type
exclusion
4. in cmd prompt go to
E:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer
type
rsactivate -c "rsreportserver.config"
Then restart the machine
ur configuration is complete now.
********************
>--Original Message--
>Chris,
>1. The virtual directory exists
>2. The page is there and is accessable
>3. Following the "Instructions" you pointed to in your
previous post I
>shouldn't need to do anything when installing on a brand
new Win2k3 Domain
>Controller, however I thought along these lines also
before coming up empty.
>4. I am running other Web applications fine off the
server. CRM for one.
>The whole reason I posted here was that I had exhausted
all avenues. I
>appreciate the time you have put into this.
>Any other ideas anyone? I am at a loss here, I have
installed RS
>successfully many times on Win2k, this is my first
experience with Win2k3.
>I am leaning towards CRM having something to do with it.
I will continue
>the search for answers.
>Ash
>"Chris Botha" <chris_s_botha@.AT_h.o.t.m.a.i.l.com> wrote
in message
>news:OQRZG$JZEHA.2544@.TK2MSFTNGP10.phx.gbl...
>> You are right, you should get 401 access denied for a
security issue.
>> Here is what I would have attempted with my knowledge.
>> 1. Check that the virtual directory exists in IIS.
>> 2. The default page on the Reports directory is called
Home.aspx, ensure
>it
>> is there.
>> From your example try
http://ipaddress/reports/Home.aspx
>> 3. Maybe IIS is blocking aspx pages, so put "aaa.htm"
and a "aaa.txt" on
>the
>> virtual directory, see if you can get to them.
>> 4. Create a test virtual directory, allow anonymous
access, and put some
>> test pages there, txt, htm, aspx and see if you can get
to them. Take the
>> anonymous access off, see what happens.
>> "AshVsAOD" <.> wrote in message
>> news:#iFR2CJZEHA.2816@.TK2MSFTNGP11.phx.gbl...
>> > I have read and re-read both of these documents, I
perhaps should have
>> > specified that in my previous post.
>> >
>> > Still it doesn't work.
>> > "Chris Botha" <chris_s_botha@.AT_h.o.t.m.a.i.l.com>
wrote in message
>> > news:%23dDwh5IZEHA.3420@.TK2MSFTNGP12.phx.gbl...
>> > > This is the MS docs:
>> > >
>> >
>http://msdn.microsoft.com/library/default.asp?
url=/library/en-
us/rsinstall/htm/gs_installingrs_v1_8k82.asp
>> > >
>> > > This may help more
>> > >
http://weblogs.asp.net/taganov/archive/2004/03/23/94514.asp
x
>> > >
>> > > A Google search should also render a whole bunch.
>> > >
>> > > "AshVsAOD" <.> wrote in message
>> > > news:OjsXafHZEHA.2016@.TK2MSFTNGP09.phx.gbl...
>> > > > Hello all,
>> > > >
>> > > > I am attempting to install RS onto the following
machine:
>> > > >
>> > > > Win2k3 Domain Controller
>> > > > SQL Standard
>> > > >
>> > > > I have installed RS successfully, however at the
end of the
>> installation
>> > > it
>> > > > instructs me that it could not be activated.
>> > > >
>> > > > I run rsactivate without success...
>> > > >
>> > > > When I type http://ipaddress/reports I recieve an
error Http 404
>file
>> > not
>> > > > found...
>> > > >
>> > > > What have I done wrong?
>> > > >
>> > > > Cheers
>> > > >
>> > > > Ash
>> > > >
>> > > >
>> > >
>> > >
>> >
>> >
>>
>
>.
>

Monday, March 12, 2012

Installation Problems with Win2K3

I am unable to install Reporting Services on our new Windows 2003
Server.
I have tried several times.
I have given ASPNET administration privileges.
I have tried the install via remote desktop and VNC.
I have tried various systems and local accounts all of which work on
other servers.
After the install I get a warning: Setup could not initialize error,
which said to
manually initialize
When I navigate to
http://localhost/Reports/Pages/Folder.aspx
or http://localhost/Reportserver
I get this error:
An internal error occurred on the report server. See the error log for
more details. (rsInternalError) Get Online Help The system cannot find
the file specified.
I get this warning from the Application Event Log
Event Id: 5603
A provider, ReportingServicesWMI, has been registered in the WMI
namespace, root\Microsoft\SqlServer\ReportingServices\v8, but did not
specify the HostingModel property. This provider will be run using the
LocalSystem account. This account is privileged and the provider may
cause a security violation if it does not correctly impersonate user
requests. Ensure that provider has been reviewed for security behavior
and update the HostingModel property of the provider registration to an
account with the least privileges possible for the required
functionality.
For more information, see Help and Support Center at
Please HelpFixed
It was related to security.
I edited the machine.config file
Updated username under "processmodel" to system. It was originally
machine. I am not sure if this step was necessary.
I also updated the security of the application pool
Go to IIS, Application Pools, DefaultAppPool, Properties, Identity Tab,
Select Predefined = Network Service.
I also updated the windows services to use NT Authority\NetworkService.
I restarted IIS. Then I ran the rsconfig.exe tool because I changed
the account of the windows services.
I also ran the rsactivate with the -r switch.
Everything works now; hope this post helps if someone else has a
similar problem.
daveg.01@.gmail.com wrote:
> I am unable to install Reporting Services on our new Windows 2003
> Server.
> I have tried several times.
> I have given ASPNET administration privileges.
> I have tried the install via remote desktop and VNC.
> I have tried various systems and local accounts all of which work on
> other servers.
> After the install I get a warning: Setup could not initialize error,
> which said to
> manually initialize
> When I navigate to
> http://localhost/Reports/Pages/Folder.aspx
> or http://localhost/Reportserver
>
> I get this error:
> An internal error occurred on the report server. See the error log for
> more details. (rsInternalError) Get Online Help The system cannot find
> the file specified.
>
> I get this warning from the Application Event Log
> Event Id: 5603
> A provider, ReportingServicesWMI, has been registered in the WMI
> namespace, root\Microsoft\SqlServer\ReportingServices\v8, but did not
> specify the HostingModel property. This provider will be run using the
> LocalSystem account. This account is privileged and the provider may
> cause a security violation if it does not correctly impersonate user
> requests. Ensure that provider has been reviewed for security behavior
> and update the HostingModel property of the provider registration to an
> account with the least privileges possible for the required
> functionality.
> For more information, see Help and Support Center at
>
> Please Help

Installation Problems - sqlspars.dll

I'm trying to install Reporting Services onto a Win2k3 SBS from the MSDN CD
pack and cannot get past the initial Setup application.
Looking in the event log, I see the following error:
Faulting application SETUP.EXE, version 2000.80.743.0, faulting module
sqlspars.dll, version 2000.80.743.0, fault address 0x00059cf8.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
I just install the app onto a different SBS last week without any issues. I
just updated the machine with the latest Hotfixes from Windows Update.
Any info or troubleshooting suggestions would be appreciated.For those who are interested, a solution was found...
Article #840219 - connecting to SQL Server running on Win2k3
"Kevin D" <kevin@.threeriverstech.com> wrote in message
news:%23l$g442TFHA.584@.TK2MSFTNGP15.phx.gbl...
> I'm trying to install Reporting Services onto a Win2k3 SBS from the MSDN
CD
> pack and cannot get past the initial Setup application.
> Looking in the event log, I see the following error:
> Faulting application SETUP.EXE, version 2000.80.743.0, faulting module
> sqlspars.dll, version 2000.80.743.0, fault address 0x00059cf8.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
> I just install the app onto a different SBS last week without any issues.
I
> just updated the machine with the latest Hotfixes from Windows Update.
> Any info or troubleshooting suggestions would be appreciated.
>