Help with Sql Cache Dependency

Hello all.. i'm having a major issue with my Sql Express 2005 database :(

I'm using wicked code sitemap to allows for a sitemap to be stored in a database.. it uses sql cache dependency to invalidated the cache bla bla

Problem:

After i update a record / add new record the database generates a SqlQueryNotificationStoredProcedure

But it never gets executed. I've done tests on the code it's calling everything accordingly so i'm assuming the problem lies in a configuration setting of the database

done alot of searching around the net and i've found this

GRANT SUBSCRIBE QUERY NOTIFICATIONS TO username

i'm using Windows Authentication how do i run this and will this solve the problem

Thank you in advance

Chris

Any ideas anyone?|||

Well I've found something out..

The sitemap provided from wicked code only invalidates the cache when a new item has been inserted.. from what i can tell anyway

So updates are not displayed.. to get around this problem i've disallowed updates to the sitemap.. i could of writen a stored procedure to delete and recreate the entry however.

If you try deleting and recreating be careful of the ordering if you have set the ID to auto increment.

Happy Coding :D

All the above isWRONG.. i thought it was updating because of visual studios virutal webserver type of thing.. read below post for the correct answer..

Chris

|||

For all those ppl out there strugling with the Wicked Code Sitemap I have some new findings....

Please post thanks if i've helped anyone so i know weather it's worth updating these answers lol..

first of all

1. SQL EXPRESS 2005 DOES NOT SUPPORT QUERY NOTIFICATIONS, so site map will not update on database changes!!!

2. took me hours to find that out stupid me should read up on sql express before introducing it.. :(

3. to fix the updating problem add the following procedure to the SqlSiteMapProvider

publicvoid Refresh()

{

Clear();

_nodes.Clear();

_root =null;

}

personally i just refresh the sitemap on every page request in my master page... this isn't the best way.. only did it because the site doesn't get much traffic and it was easy bad bad bad programmer chris.. lol.. you should only refresh the sitemap on database changes..

please help my mate get more hitswww.drakesterling.com that will display the sitemap too.. i had to do alot of modifications to the CSS adapters to get it working properly any questions on what's shown here i'm happy to answer..

Happy programming all

From Chris

sql

Help with SQL 2005 Client Tools

I installed SQL 2005 Express and 2005 Express Tools on a PC. The user now wants SQL 2005 Client Tools. When I uninstall 2005 Express Tools and try to install 2005 Client Tools I get an upgrade error. It says that I've got a newer version of online books already installed and won't let me finish the install.

I'v uninstalled everything relating to MS SQL and tried cleaning some of the registry entries, but can't seem to get it to work. Anybody have any ideas as to what to do?

Did you uninstall Books Online?

(I assume that the client has properly licensed SQL Servers (non Express Edition) -otherwise only SQL Server Express Client Tools would be in license...)

|||

Have you restarted the machine after uninstalling, as few of the .DLLs will be in use.

Also see whether any related SQL client programs or directories are still in place on that machine.

If its XP try to use restore point, it may help. I tried that way earlier.

BTW what was the exact error you are getting?

|||

Sorry I haven't responded sooner.

Yes, I did uninstall Books Online.

|||

I did restart the machine and deleted any SQL programs and/or directories on the system. This is server 2000 system and does not have the restore point feature.

I will post the exact error code tomorrow.

|||

Double check in Control Panel -> Add/Remove Programs to see if there are any SQL2K5 components left behind. Also, the exact installer error will help.

Cheers,

Dan

|||Hey guys thanks for all your help, but I ran out of time and ended up just re-imaging the drive. It was actually a virtual server, so it was easy to redo!

Help with SQL 2005 Client Tools

I installed SQL 2005 Express and 2005 Express Tools on a PC. The user now wants SQL 2005 Client Tools. When I uninstall 2005 Express Tools and try to install 2005 Client Tools I get an upgrade error. It says that I've got a newer version of online books already installed and won't let me finish the install.

I'v uninstalled everything relating to MS SQL and tried cleaning some of the registry entries, but can't seem to get it to work. Anybody have any ideas as to what to do?

Did you uninstall Books Online?

(I assume that the client has properly licensed SQL Servers (non Express Edition) -otherwise only SQL Server Express Client Tools would be in license...)

|||

Have you restarted the machine after uninstalling, as few of the .DLLs will be in use.

Also see whether any related SQL client programs or directories are still in place on that machine.

If its XP try to use restore point, it may help. I tried that way earlier.

BTW what was the exact error you are getting?

|||

Sorry I haven't responded sooner.

Yes, I did uninstall Books Online.

|||

I did restart the machine and deleted any SQL programs and/or directories on the system. This is server 2000 system and does not have the restore point feature.

I will post the exact error code tomorrow.

|||

Double check in Control Panel -> Add/Remove Programs to see if there are any SQL2K5 components left behind. Also, the exact installer error will help.

Cheers,

Dan

|||Hey guys thanks for all your help, but I ran out of time and ended up just re-imaging the drive. It was actually a virtual server, so it was easy to redo!sql

Help with reporting services

Ok, here's the deal.

I'm just learning sql express and I'm trying to get my reporting

services worked out. I have everything installed and I have managed to

connect to the report server at http://<computername>/Reports

my problem is I can only connect to this page when I am at the machine

where the sql database, reporting database, etc... I cannot log on to

this site from any other computer no my network? Does any one know why

?

I have also tried installing on a different machine and I get an error "Server Error in /ReportServer application..... failed to access IIS metabase.
IIS is installed on this machine.

Thanks!!!

As long as you are inserting the correct computer name in your URL string, I don't see why it shouldn't connect. Obviously you wouldn't want to use http://localhost/Reports to connect from a client machine. Are both the server and client under the same domain?

What happens when you try http://<computername>/reportserver ?

|||I've tried using the computer name when trying to connect from a client machine and I get the same result. Both machines are on the same domain but using different user accounts. Would that matter?|||

Jamaz wrote:

I've tried using the computer name when trying to connect from a client machine and I get the same result. Both machines are on the same domain but using different user accounts. Would that matter?

No that wouldn't matter.

What happens when you try http://<computername>/reportserver from a client machine where computername is the name of the computer with SQL server?

|||

GregSQL wrote:

Jamaz wrote:

I've tried using the computer name when trying to connect from a client machine and I get the same result. Both machines are on the same domain but using different user accounts. Would that matter?

No that wouldn't matter.

What happens when you try http://<computername>/reportserver from a client machine where computername is the name of the computer with SQL server?

That's the only way I had tried it. Should I be making computer name the name of the computer I happen to be on ? I didn't think that was the way it worked ?|||No, it should be the name of the computer on which SQL server resides. What is the error message you are getting?|||

Server Error in '/Reports' Application.

---

Failed to access IIS metabase.

I uninstalled SQL on the first machine i was trying it on ... and have now installed SQL on a new machine and I have run through the set up the same way I did before and I am getting this error now. I get this error when trying to connect from the server machine .. and when I try to connect from a client machine I get a page not found error in the browser

|||

Oh I see. I thought it was working on the server.

Check this forum: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=116989&SiteID=1

help with reporting services

I installed sql express with advanced services on a local network computer named 'Tester'. For service accounts I used 'network service' and 'mixed mode' for authentication. I would like to publish database reports using reporting services. when i open a web browser on the machine with sql express and type in the url: http://localhost/reports or http://localhost/reportserver the web pages work fine. but when i go to a different machine thats on the same network and use the url: http://Tester/reports or http://Tester/reportserver the web page is not found. how do i get users on the network to be able to view the virtual report server directories on the Tester computer? Help would be greatly appreciated.

Hi,

did you check your IIS configuration of your localhost (Tester)?

Is there an alias for your network computer - "Tester", DNS?

Have you put in a Hostheadername by IP?

What about a ping`?

Have you test http://172.../reports ?

CU

tosc

|||i can ping 'Tester' fine, i've tried http://<ip of host>/reports. IIS is configured for integrated windows autentication. I tried setting authentication to allow anonymous access but that didnt work either.|||

Hi John,

by installation, have you check "Use SSL..." checkbox in the installation wizard?

CU

tosc

|||

are you referring to the install of IIS? I dont recall, should I try to reinstall IIS?

Thanks,

John

|||

Hi John,

NO, i'm referring to Installing and Configuring SQL Server Reporting Services!

Have yopu check "Use SSL..." checkbox in the installation wizard?

CU

tosc

|||

Hi John,

Unless you changed it manually, Reporting Services is given an instance name just like the database service. Try adding "$SQLEXPRESS" (without quotes) to the end of your URL. Needless to say, if you installed to a different instance name, use that inplace of SQLEXPRESS.

Mike

|||I've tried all the url's and none of them work. Does IIS have to be configured in a particular way? also do I need to add permissions to my report server database? I would think that anyone on the intranet who knows the host computer name can put in the url and view the reportserver web page. Im not getting prompted for a login, my web browser just says the page cannot be displayed, that makes me think that it is network problem and not a configuration problem on the local machine.|||

I have had similar troubles. I have a report server configured on a computer on the network. I've installed SQL Express 2005 and the toolkits to get hold of RS. The computer is running IIS 5 and is connected using MMC. Reports can be generated, deployed, and viewed using a browser and URL from this machine quite happily.

However, when I try to access the report server from a different computer on the network I also get a

Internet Explorer cannot display the webpage

message.

I have tried:

http://rs_name/reports

http://rs_name.network.local/reports

http://rs_name/reports$sqlexpress

I can ping the machines from eachother successfully and I have made profiles from within Report Manager for each user on these machines. Is this a Express thing? SURELY, you must be able to access these reports across a Windows network.

Many thanks.

Leslie

|||

You sould ask this question in the Report Services forum to get a better answer. (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=82&SiteID=1)

Mike

|||

OK. I'll ask them over there. Thank you very much, and apoligies for being in the wrong place.

L

help with reporting services

I installed sql express with advanced services on a local network computer named 'Tester'. For service accounts I used 'network service' and 'mixed mode' for authentication. I would like to publish database reports using reporting services. when i open a web browser on the machine with sql express and type in the url: http://localhost/reports or http://localhost/reportserver the web pages work fine. but when i go to a different machine thats on the same network and use the url: http://Tester/reports or http://Tester/reportserver the web page is not found. how do i get users on the network to be able to view the virtual report server directories on the Tester computer? Help would be greatly appreciated.

Hi,

did you check your IIS configuration of your localhost (Tester)?

Is there an alias for your network computer - "Tester", DNS?

Have you put in a Hostheadername by IP?

What about a ping`?

Have you test http://172.../reports ?

CU

tosc

|||i can ping 'Tester' fine, i've tried http://<ip of host>/reports. IIS is configured for integrated windows autentication. I tried setting authentication to allow anonymous access but that didnt work either.|||

Hi John,

by installation, have you check "Use SSL..." checkbox in the installation wizard?

CU

tosc

|||

are you referring to the install of IIS? I dont recall, should I try to reinstall IIS?

Thanks,

John

|||

Hi John,

NO, i'm referring to Installing and Configuring SQL Server Reporting Services!

Have yopu check "Use SSL..." checkbox in the installation wizard?

CU

tosc

|||

Hi John,

Unless you changed it manually, Reporting Services is given an instance name just like the database service. Try adding "$SQLEXPRESS" (without quotes) to the end of your URL. Needless to say, if you installed to a different instance name, use that inplace of SQLEXPRESS.

Mike

|||I've tried all the url's and none of them work. Does IIS have to be configured in a particular way? also do I need to add permissions to my report server database? I would think that anyone on the intranet who knows the host computer name can put in the url and view the reportserver web page. Im not getting prompted for a login, my web browser just says the page cannot be displayed, that makes me think that it is network problem and not a configuration problem on the local machine.|||

I have had similar troubles. I have a report server configured on a computer on the network. I've installed SQL Express 2005 and the toolkits to get hold of RS. The computer is running IIS 5 and is connected using MMC. Reports can be generated, deployed, and viewed using a browser and URL from this machine quite happily.

However, when I try to access the report server from a different computer on the network I also get a

Internet Explorer cannot display the webpage

message.

I have tried:

http://rs_name/reports

http://rs_name.network.local/reports

http://rs_name/reports$sqlexpress

I can ping the machines from eachother successfully and I have made profiles from within Report Manager for each user on these machines. Is this a Express thing? SURELY, you must be able to access these reports across a Windows network.

Many thanks.

Leslie

|||

You sould ask this question in the Report Services forum to get a better answer. (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=82&SiteID=1)

Mike

|||

OK. I'll ask them over there. Thank you very much, and apoligies for being in the wrong place.

L

Help with query -SQL Express and ASP.net

I am having trouble with the below query. This is attached to a SQLDataAdapter which in turn is connected to a grid view.

@.pram5 is a dropdownlist
all other perameters such as @.nw in the big OR statement are check boxes.

My tables look similar to this:

Company TblComodity TblRegion

PK CompanyID PK CommodityID PK RegionID
CompanyName FK CompanyID FK CompanyID
CommodityName North
South, East, etc

What I would am trying to do is have a user slect a commodity which is a distinct value from the comodity table. Then select by tick boxes locations, then in the grid view companies with possible locations and commoditys appear. My problem is even when I select a commodity and leave all tick boxes blank (false) the records still display - like its only filltering on commodity name. Can anyone help ? I can provide more info if needed

Here is my query:

SELECT TblCompany.CompanyID, TblCompany.CompanyName, TblRegion.NorthWest, TblRegion.NorthEast, TblRegion.SouthEast, TblRegion.SouthWest,
TblRegion.Scotland, TblRegion.Wales, TblRegion.Midlands, TblRegion.UKNational, TblRegion.EuropOotherThanUK, TblComodity.ComName
FROM TblCompany INNER JOIN
TblRegion ON TblCompany.CompanyID = TblRegion.CompanyID INNER JOIN
TblComodity ON TblCompany.CompanyID = TblComodity.CompanyID AND TblComodity.ComName = @.pram5
WHERE (TblRegion.NorthWest = @.nw) OR
(TblRegion.NorthEast = @.NE) OR
(TblRegion.SouthEast = @.se) OR
(TblRegion.SouthWest = @.sw) OR
(TblRegion.Scotland = @.scot) OR
(TblRegion.Wales = @.wal) OR
(TblRegion.Midlands = @.mid) OR
(TblRegion.EuropOotherThanUK = @.EU) AND (TblRegion.UKNational = @.UKN)More info needed: Are the ticks mapped to the appropiate parameters like @.sw ? What do you pass if the ticks are not selected ? Probably Null ? because of doing an OR, you will get all values which habe in one of the filtered columns the value null then.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de