Capturing ISS Log data

I am quite new to Reporting Services and need some help figuring out why i can't correctly capture the referrrer information in the IIS Logs.

As far as i know when you run the data extraction tool provided with RS it copies the logs into the staging db, from there it then copies all the data into the WSSFact table in the actual db.

I thought that if i entered a URL into the referrer table that when it populates the WSSFact table it would check to see if the referrer URL matches any of the entries in the referrer table and if so enter its id, otherwise enter the id for No referrer.

This seems to work fine for all existing entires in the referrer table but it ignores the new one i have added. Does anyone know if there is something else that i have to do or check?It sounds like you are using IIS tools. I am not aware of the WSSFact table and such. Can you provide a link to the tools you are using?|||

I am using the data extraction tool provided with Reporting Services. The problem is you can't see what this tool does, therefore its difficult to trace the process of how it reads the logs and places the information in the database.

Like i said i am pretty sure it places the log information into a staging database and then from there into the actual one used by to generate the reports.

What i need to know is why it keeps showing as not having any referrer information in the database when you can clearly see there is info in the logs.

Sorry if i wasn't clear the first time.

Can't upgrade evaluation to retail

Hi,
I bought retail SQL server from CDW. I just realized my evaluation period
was overed from application logs. I followed the instructions
http://support.microsoft.com/default...b;en-us;281574 ; during the
installation, I select "upgrade, remove, ...." and following the
instructions and somehow "Upgrade your existing installation" is gray out.
Do you have to upgrade to retail before evalution is over? Any tips and
information will be appreicated.
Thank you in advance,
Johnny Chow
Johnny,
Just a thought...what edition are you trying to upgrade to? Valid upgrade?
Might try running:
SELECT SERVERPROPERTY('EDITION'), SERVERPROPERTY('ENGINEEDITION')
to get more information. Also, make sure your OS supports the version of
SQL Server being used.
HTH
Jerry
"Johnny Chow" <jchow10@.gmail.com> wrote in message
news:Odvjv320FHA.1564@.tk2msftngp13.phx.gbl...
> Hi,
> I bought retail SQL server from CDW. I just realized my evaluation period
> was overed from application logs. I followed the instructions
> http://support.microsoft.com/default...b;en-us;281574 ; during
> the installation, I select "upgrade, remove, ...." and following the
> instructions and somehow "Upgrade your existing installation" is gray out.
> Do you have to upgrade to retail before evalution is over? Any tips and
> information will be appreicated.
> Thank you in advance,
> Johnny Chow
>
|||Hi,
I am not DB administrator. Forgive me, if I ask dumb question. I really
like to find out the version that I was running. What command do I use to
get into SQL prompt? MSSQL serverice is not start due to eval expiration
and can I use still able to get into sql prompt and make query?
Thank you in advance,
Johnny Chow
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:%23B%23OS$20FHA.464@.TK2MSFTNGP15.phx.gbl...
> Johnny,
> Just a thought...what edition are you trying to upgrade to? Valid
> upgrade? Might try running:
> SELECT SERVERPROPERTY('EDITION'), SERVERPROPERTY('ENGINEEDITION')
> to get more information. Also, make sure your OS supports the version of
> SQL Server being used.
> HTH
> Jerry
> "Johnny Chow" <jchow10@.gmail.com> wrote in message
> news:Odvjv320FHA.1564@.tk2msftngp13.phx.gbl...
>
|||I've got exactly the same problem on my end. I have SQL Server 2000
Enterprise Evaluation installed and expired and am trying to apply the SQL
Server 2000 Enterprise Retail version.
The option to Upgrade an Existing installation is greyed out just as
described. Any suggestions?
"Johnny Chow" wrote:

> Hi,
> I am not DB administrator. Forgive me, if I ask dumb question. I really
> like to find out the version that I was running. What command do I use to
> get into SQL prompt? MSSQL serverice is not start due to eval expiration
> and can I use still able to get into sql prompt and make query?
> Thank you in advance,
> Johnny Chow
> "Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
> news:%23B%23OS$20FHA.464@.TK2MSFTNGP15.phx.gbl...
>
>

Can't upgrade evaluation to retail

Hi,
I bought retail SQL server from CDW. I just realized my evaluation period
was overed from application logs. I followed the instructions
http://support.microsoft.com/defaul...kb;en-us;281574 ; during the
installation, I select "upgrade, remove, ...." and following the
instructions and somehow "Upgrade your existing installation" is gray out.
Do you have to upgrade to retail before evalution is over? Any tips and
information will be appreicated.
Thank you in advance,
Johnny ChowJohnny,
Just a thought...what edition are you trying to upgrade to? Valid upgrade?
Might try running:
SELECT SERVERPROPERTY('EDITION'), SERVERPROPERTY('ENGINEEDITION')
to get more information. Also, make sure your OS supports the version of
SQL Server being used.
HTH
Jerry
"Johnny Chow" <jchow10@.gmail.com> wrote in message
news:Odvjv320FHA.1564@.tk2msftngp13.phx.gbl...
> Hi,
> I bought retail SQL server from CDW. I just realized my evaluation period
> was overed from application logs. I followed the instructions
> http://support.microsoft.com/defaul...kb;en-us;281574 ; during
> the installation, I select "upgrade, remove, ...." and following the
> instructions and somehow "Upgrade your existing installation" is gray out.
> Do you have to upgrade to retail before evalution is over? Any tips and
> information will be appreicated.
> Thank you in advance,
> Johnny Chow
>|||Hi,
I am not DB administrator. Forgive me, if I ask dumb question. I really
like to find out the version that I was running. What command do I use to
get into SQL prompt? MSSQL serverice is not start due to eval expiration
and can I use still able to get into sql prompt and make query?
Thank you in advance,
Johnny Chow
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:%23B%23OS$20FHA.464@.TK2MSFTNGP15.phx.gbl...
> Johnny,
> Just a thought...what edition are you trying to upgrade to? Valid
> upgrade? Might try running:
> SELECT SERVERPROPERTY('EDITION'), SERVERPROPERTY('ENGINEEDITION')
> to get more information. Also, make sure your OS supports the version of
> SQL Server being used.
> HTH
> Jerry
> "Johnny Chow" <jchow10@.gmail.com> wrote in message
> news:Odvjv320FHA.1564@.tk2msftngp13.phx.gbl...
>|||I've got exactly the same problem on my end. I have SQL Server 2000
Enterprise Evaluation installed and expired and am trying to apply the SQL
Server 2000 Enterprise Retail version.
The option to Upgrade an Existing installation is greyed out just as
described. Any suggestions?
"Johnny Chow" wrote:

> Hi,
> I am not DB administrator. Forgive me, if I ask dumb question. I really
> like to find out the version that I was running. What command do I use to
> get into SQL prompt? MSSQL serverice is not start due to eval expiration
> and can I use still able to get into sql prompt and make query?
> Thank you in advance,
> Johnny Chow
> "Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
> news:%23B%23OS$20FHA.464@.TK2MSFTNGP15.phx.gbl...
>
>

Can't upgrade evaluation to retail

Hi,
I bought retail SQL server from CDW. I just realized my evaluation period
was overed from application logs. I followed the instructions
http://support.microsoft.com/default.aspx?scid=kb;en-us;281574 ; during the
installation, I select "upgrade, remove, ...." and following the
instructions and somehow "Upgrade your existing installation" is gray out.
Do you have to upgrade to retail before evalution is over? Any tips and
information will be appreicated.
Thank you in advance,
Johnny ChowJohnny,
Just a thought...what edition are you trying to upgrade to? Valid upgrade?
Might try running:
SELECT SERVERPROPERTY('EDITION'), SERVERPROPERTY('ENGINEEDITION')
to get more information. Also, make sure your OS supports the version of
SQL Server being used.
HTH
Jerry
"Johnny Chow" <jchow10@.gmail.com> wrote in message
news:Odvjv320FHA.1564@.tk2msftngp13.phx.gbl...
> Hi,
> I bought retail SQL server from CDW. I just realized my evaluation period
> was overed from application logs. I followed the instructions
> http://support.microsoft.com/default.aspx?scid=kb;en-us;281574 ; during
> the installation, I select "upgrade, remove, ...." and following the
> instructions and somehow "Upgrade your existing installation" is gray out.
> Do you have to upgrade to retail before evalution is over? Any tips and
> information will be appreicated.
> Thank you in advance,
> Johnny Chow
>|||Hi,
I am not DB administrator. Forgive me, if I ask dumb question. I really
like to find out the version that I was running. What command do I use to
get into SQL prompt? MSSQL serverice is not start due to eval expiration
and can I use still able to get into sql prompt and make query?
Thank you in advance,
Johnny Chow
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:%23B%23OS$20FHA.464@.TK2MSFTNGP15.phx.gbl...
> Johnny,
> Just a thought...what edition are you trying to upgrade to? Valid
> upgrade? Might try running:
> SELECT SERVERPROPERTY('EDITION'), SERVERPROPERTY('ENGINEEDITION')
> to get more information. Also, make sure your OS supports the version of
> SQL Server being used.
> HTH
> Jerry
> "Johnny Chow" <jchow10@.gmail.com> wrote in message
> news:Odvjv320FHA.1564@.tk2msftngp13.phx.gbl...
>> Hi,
>> I bought retail SQL server from CDW. I just realized my evaluation
>> period was overed from application logs. I followed the instructions
>> http://support.microsoft.com/default.aspx?scid=kb;en-us;281574 ; during
>> the installation, I select "upgrade, remove, ...." and following the
>> instructions and somehow "Upgrade your existing installation" is gray
>> out. Do you have to upgrade to retail before evalution is over? Any tips
>> and information will be appreicated.
>> Thank you in advance,
>> Johnny Chow
>|||I've got exactly the same problem on my end. I have SQL Server 2000
Enterprise Evaluation installed and expired and am trying to apply the SQL
Server 2000 Enterprise Retail version.
The option to Upgrade an Existing installation is greyed out just as
described. Any suggestions?
"Johnny Chow" wrote:
> Hi,
> I am not DB administrator. Forgive me, if I ask dumb question. I really
> like to find out the version that I was running. What command do I use to
> get into SQL prompt? MSSQL serverice is not start due to eval expiration
> and can I use still able to get into sql prompt and make query?
> Thank you in advance,
> Johnny Chow
> "Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
> news:%23B%23OS$20FHA.464@.TK2MSFTNGP15.phx.gbl...
> > Johnny,
> >
> > Just a thought...what edition are you trying to upgrade to? Valid
> > upgrade? Might try running:
> >
> > SELECT SERVERPROPERTY('EDITION'), SERVERPROPERTY('ENGINEEDITION')
> >
> > to get more information. Also, make sure your OS supports the version of
> > SQL Server being used.
> >
> > HTH
> >
> > Jerry
> > "Johnny Chow" <jchow10@.gmail.com> wrote in message
> > news:Odvjv320FHA.1564@.tk2msftngp13.phx.gbl...
> >> Hi,
> >> I bought retail SQL server from CDW. I just realized my evaluation
> >> period was overed from application logs. I followed the instructions
> >> http://support.microsoft.com/default.aspx?scid=kb;en-us;281574 ; during
> >> the installation, I select "upgrade, remove, ...." and following the
> >> instructions and somehow "Upgrade your existing installation" is gray
> >> out. Do you have to upgrade to retail before evalution is over? Any tips
> >> and information will be appreicated.
> >>
> >> Thank you in advance,
> >>
> >> Johnny Chow
> >>
> >
> >
>
>