asp.net

When I attempt to install sql reporting services enterprise, i receive the
following:
"System Check results--asp.net is not installed or is not registered with
your web server".
I review services and iisadmin is there and running as is also asp.net state
services which I had started to run automatically. Microsoft .net framework
1.1 is confirmed installed in the add/remove programs.
Anyone come across this before?
thanksDid you by any chance remove the default website? RS needs the default
website to be able to install.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"tom frost" <tomfrost@.discussions.microsoft.com> wrote in message
news:3ABC1970-87A4-47D2-8CFC-11A613861F72@.microsoft.com...
> When I attempt to install sql reporting services enterprise, i receive the
> following:
> "System Check results--asp.net is not installed or is not registered with
> your web server".
> I review services and iisadmin is there and running as is also asp.net
state
> services which I had started to run automatically. Microsoft .net
framework
> 1.1 is confirmed installed in the add/remove programs.
> Anyone come across this before?
> thanks
>|||Run this from a command prompt:
%SYSTEMROOT%\Microsoft.NET\Framework\v1.1.4322\aspnet_regiis.exe -i
This will install ASP.NET.
On a side note, you may want to turn off the ASP.NET State Service as this
is used for servers that act as session state servers for ASP.NET
applications that are configured to maintain session state out of process.
So this service is probably just using resources for nothing.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:ui3TDyx$EHA.2880@.TK2MSFTNGP14.phx.gbl...
> Did you by any chance remove the default website? RS needs the default
> website to be able to install.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "tom frost" <tomfrost@.discussions.microsoft.com> wrote in message
> news:3ABC1970-87A4-47D2-8CFC-11A613861F72@.microsoft.com...
> > When I attempt to install sql reporting services enterprise, i receive
the
> > following:
> > "System Check results--asp.net is not installed or is not registered
with
> > your web server".
> >
> > I review services and iisadmin is there and running as is also asp.net
> state
> > services which I had started to run automatically. Microsoft .net
> framework
> > 1.1 is confirmed installed in the add/remove programs.
> >
> > Anyone come across this before?
> >
> > thanks
> >
> >
>|||Your error happens when, for example, ASP.NET is installed and IIS isn't on
the machine or IIS is installed later. The aspnet_regiis.exe utility with
the -i parameter installs the correct IIS script maps so IIS associates
asp.net requests with the desired version of the framework. (Each framework
version has it's own aspnet_regiis.exe utility).
You should also be able to MSDN search that message and you will get more
information on the aspnet_regiis tool.
Adrian M.
"tom frost" <tomfrost@.discussions.microsoft.com> wrote in message
news:3ABC1970-87A4-47D2-8CFC-11A613861F72@.microsoft.com...
> When I attempt to install sql reporting services enterprise, i receive the
> following:
> "System Check results--asp.net is not installed or is not registered with
> your web server".
> I review services and iisadmin is there and running as is also asp.net
> state
> services which I had started to run automatically. Microsoft .net
> framework
> 1.1 is confirmed installed in the add/remove programs.
> Anyone come across this before?
> thanks
>

AS/400 Access Client destroys SQL Server 2000 DTS

Until this morning I had a fully functional SQL Server 2000 Enterprise manager with DTS capability. There is a requirement to have data pulled from an AS/400 machine into the SQL Server 2000 environment for reporting reasons. To do this we needed the AS/400 ODBC drivers.
I was given a CD which matches the OS on the 400 box that being; V4R5M0, i.e. Version 4 Rev 5, (4.5).
Well, when trying to use the DTC which up untill that moment worked perfectly I got the following message upon initiation of the Data Transformation Services Wizard;

The title is:
DTS Import/Export Wizard Error: CoCreateInstance
The very helpful message is;
Error in the DLL

Which DLL is a mystery, and I can't get DTS to recover.

If I go ahead I can define a connection but when I hit "next>" it just sits there. Basically it's FUBAR'd.

I've uninstalled the lousy IBM Client that trashed DTS, and I've uninstalled, and re-installed SQL Server 2000 about 3 times now but to no avail. I still cannot initiate DTC. The other wizards and Tools Database, Management, Replication all work fine.

Any ideas ?
Thanks
Jeremy GreavesOuch!

Since no one else has posted a reply yet, I suggest you cross post to http://communities.microsoft.com/newsgroups/default.asp?icp=SQL&slcid=us in the DTS forum.

Also not much help, but just in case it helps a little, you can find a list of DTS dll's at http://www.sqldts.com/main.asp?nav=1,6,225,0

John

Arithmetic overflow error for data type smallint, value = 46080

Hello friends, in this moments I have a problem with my Ms Sql server 2000,
at the enterprise manager I can't see the databases, a message error
"Arithmetic overflow error for data type smallint, value = 46080" appears,
but the server is seems to be still working, what it is?
Regards,
Jess R.
Hi
You may want to run SQL profiler to see what is being run by Enterprise
manager.
It could be similar (but not necessarily the same thing as!) to
http://support.microsoft.com/default...b;en-us;234028
Also check the version of SQL Server http://www.aspfaq.com/show.asp?id=2160.
John
"Jesus Brito" wrote:

> Hello friends, in this moments I have a problem with my Ms Sql server 2000,
> at the enterprise manager I can't see the databases, a message error
> "Arithmetic overflow error for data type smallint, value = 46080" appears,
> but the server is seems to be still working, what it is?
> Regards,
> Jesús R.
>
>

Arithmetic overflow error for data type smallint, value = 46080

Hello friends, in this moments I have a problem with my Ms Sql server 2000,
at the enterprise manager I can't see the databases, a message error
"Arithmetic overflow error for data type smallint, value = 46080" appears,
but the server is seems to be still working, what it is?
Regards,
Jess R.Hi
You may want to run SQL profiler to see what is being run by Enterprise
manager.
It could be similar (but not necessarily the same thing as!) to
http://support.microsoft.com/defaul...kb;en-us;234028
Also check the version of SQL Server http://www.aspfaq.com/show.asp?id=2160.
John
"Jesus Brito" wrote:

> Hello friends, in this moments I have a problem with my Ms Sql server 2000
,
> at the enterprise manager I can't see the databases, a message error
> "Arithmetic overflow error for data type smallint, value = 46080" appears,
> but the server is seems to be still working, what it is?
> Regards,
> Jesús R.
>
>

Arithmetic overflow error for data type smallint, value = 46080

Hello friends, in this moments I have a problem with my Ms Sql server 2000,
at the enterprise manager I can't see the databases, a message error
"Arithmetic overflow error for data type smallint, value = 46080" appears,
but the server is seems to be still working, what it is?
Regards,
Jesús R.Hi
You may want to run SQL profiler to see what is being run by Enterprise
manager.
It could be similar (but not necessarily the same thing as!) to
http://support.microsoft.com/default.aspx?scid=kb;en-us;234028
Also check the version of SQL Server http://www.aspfaq.com/show.asp?id=2160.
John
"Jesus Brito" wrote:
> Hello friends, in this moments I have a problem with my Ms Sql server 2000,
> at the enterprise manager I can't see the databases, a message error
> "Arithmetic overflow error for data type smallint, value = 46080" appears,
> but the server is seems to be still working, what it is?
> Regards,
> Jesús R.
>
>

are we running Enterprise or Standard

How can I tell if we're running the Enterprise or Standard or Developer
version of SQL Server 2000?
Thanks,
DanHi,
Execute the below command from query analyzer:-
select @.@.version
(In the final line it say "Personal Edition on Windows NT" -- incase of
personal edition)
In sql 2000, you can execute the below command as well:-
Select serverproperty('edition')
Thanks
Hari
MCDBA
"Dan" <ddonahue@.archermalmo.com> wrote in message
news:eZfzgtOOEHA.2976@.TK2MSFTNGP10.phx.gbl...
> How can I tell if we're running the Enterprise or Standard or Developer
> version of SQL Server 2000?
> Thanks,
> Dan
>|||Try:
SELECT @.@.VERSION
or
SELECT SERVERPROPERTY('Edition')
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Dan" <ddonahue@.archermalmo.com> wrote in message
news:eZfzgtOOEHA.2976@.TK2MSFTNGP10.phx.gbl...
> How can I tell if we're running the Enterprise or Standard or Developer
> version of SQL Server 2000?
> Thanks,
> Dan
>|||Thanks Dan and Hari. The serverproperty is just the right thing. Using
@.@.version produces a line so long I have a hard time finding the end of it.
Dan
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:ukVzsvOOEHA.2952@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Execute the below command from query analyzer:-
> select @.@.version
>
> (In the final line it say "Personal Edition on Windows NT" -- incase of
> personal edition)
> In sql 2000, you can execute the below command as well:-
> Select serverproperty('edition')
>
> Thanks
> Hari
> MCDBA
> "Dan" <ddonahue@.archermalmo.com> wrote in message
> news:eZfzgtOOEHA.2976@.TK2MSFTNGP10.phx.gbl...
> > How can I tell if we're running the Enterprise or Standard or Developer
> > version of SQL Server 2000?
> >
> > Thanks,
> >
> > Dan
> >
> >
>

are we running Enterprise or Standard

How can I tell if we're running the Enterprise or Standard or Developer
version of SQL Server 2000?
Thanks,
Dan
Hi,
Execute the below command from query analyzer:-
select @.@.version
(In the final line it say "Personal Edition on Windows NT" -- incase of
personal edition)
In sql 2000, you can execute the below command as well:-
Select serverproperty('edition')
Thanks
Hari
MCDBA
"Dan" <ddonahue@.archermalmo.com> wrote in message
news:eZfzgtOOEHA.2976@.TK2MSFTNGP10.phx.gbl...
> How can I tell if we're running the Enterprise or Standard or Developer
> version of SQL Server 2000?
> Thanks,
> Dan
>
|||Try:
SELECT @.@.VERSION
or
SELECT SERVERPROPERTY('Edition')
Hope this helps.
Dan Guzman
SQL Server MVP
"Dan" <ddonahue@.archermalmo.com> wrote in message
news:eZfzgtOOEHA.2976@.TK2MSFTNGP10.phx.gbl...
> How can I tell if we're running the Enterprise or Standard or Developer
> version of SQL Server 2000?
> Thanks,
> Dan
>
|||Thanks Dan and Hari. The serverproperty is just the right thing. Using
@.@.version produces a line so long I have a hard time finding the end of it.
Dan
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:ukVzsvOOEHA.2952@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Execute the below command from query analyzer:-
> select @.@.version
>
> (In the final line it say "Personal Edition on Windows NT" -- incase of
> personal edition)
> In sql 2000, you can execute the below command as well:-
> Select serverproperty('edition')
>
> Thanks
> Hari
> MCDBA
> "Dan" <ddonahue@.archermalmo.com> wrote in message
> news:eZfzgtOOEHA.2976@.TK2MSFTNGP10.phx.gbl...
>

are we running Enterprise or Standard

How can I tell if we're running the Enterprise or Standard or Developer
version of SQL Server 2000?
Thanks,
DanHi,
Execute the below command from query analyzer:-
select @.@.version
(In the final line it say "Personal Edition on Windows NT" -- incase of
personal edition)
In sql 2000, you can execute the below command as well:-
Select serverproperty('edition')
Thanks
Hari
MCDBA
"Dan" <ddonahue@.archermalmo.com> wrote in message
news:eZfzgtOOEHA.2976@.TK2MSFTNGP10.phx.gbl...
> How can I tell if we're running the Enterprise or Standard or Developer
> version of SQL Server 2000?
> Thanks,
> Dan
>|||Try:
SELECT @.@.VERSION
or
SELECT SERVERPROPERTY('Edition')
Hope this helps.
Dan Guzman
SQL Server MVP
"Dan" <ddonahue@.archermalmo.com> wrote in message
news:eZfzgtOOEHA.2976@.TK2MSFTNGP10.phx.gbl...
> How can I tell if we're running the Enterprise or Standard or Developer
> version of SQL Server 2000?
> Thanks,
> Dan
>|||Thanks Dan and Hari. The serverproperty is just the right thing. Using
@.@.version produces a line so long I have a hard time finding the end of it.
Dan
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:ukVzsvOOEHA.2952@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Execute the below command from query analyzer:-
> select @.@.version
>
> (In the final line it say "Personal Edition on Windows NT" -- incase of
> personal edition)
> In sql 2000, you can execute the below command as well:-
> Select serverproperty('edition')
>
> Thanks
> Hari
> MCDBA
> "Dan" <ddonahue@.archermalmo.com> wrote in message
> news:eZfzgtOOEHA.2976@.TK2MSFTNGP10.phx.gbl...
>

Are text pages deleted when a column is converted to varchar

When I change a column from text to varchar using the
design view of a table within Enterprise Manager the
varchar value (less than 8000 characters) appears in the
column but does SQL Server automatically delete the text
values from their pages?

If not are they removed by routine reindex/defrag or
should I create a new table, import from the text as
varchar and drop the old table to make sure the pages
storing the original text version of the values are
deleted?
..morriszone@.hotmail.com (Steve Morris) wrote in message news:<757b6d8f.0404080820.7956cf62@.posting.google.com>...
> When I change a column from text to varchar using the
> design view of a table within Enterprise Manager the
> varchar value (less than 8000 characters) appears in the
> column but does SQL Server automatically delete the text
> values from their pages?
> If not are they removed by routine reindex/defrag or
> should I create a new table, import from the text as
> varchar and drop the old table to make sure the pages
> storing the original text version of the values are
> deleted?
> .

just try:

select * into your_table_bak from your_table

and then try your alter table statment with no risk of dataloss!
alter table *your_table_bak* :-)

if you dont like to read 8000 charakter to find out wether some data
is loss or not try the function
"getsize"

hth