Friday, March 30, 2012
Help!. Images not Displaying
i have made a report and inserted some company logo in the report header ,,,
from the image wizard i selected Embeded type ,, But when i run the port in
asp.net by calling its webservice ,,,images are not shown.
Plz help me to solve this problem
ThanksHi Malik,
Please look at following link. "_" in the machine name may be the
culprit. Use the IP instead of machine name. Also replace machine name in
report server and report manager config files with machine IP address.
http://groups.google.com.pk/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/dc1fcfec0c41ec70/23425c9cbdabb2a1?q=%22reporting+services%22+%2B+%22images%22&rnum=1&hl=en#23425c9cbdabb2a1
"Malik Asif Joyia" wrote:
> Hello
> i have made a report and inserted some company logo in the report header ,,,
> from the image wizard i selected Embeded type ,, But when i run the port in
> asp.net by calling its webservice ,,,images are not shown.
> Plz help me to solve this problem
> Thanks
>
>sql
Friday, March 23, 2012
HELP! Reset dbo login id password, cannot get company website up
Under Enterprise Manager there is a Security group, underneath here is a login. The person reset the password here on the login id that is the DBO for our website's database. Underneath the database in Enterprise Manager the dbo uses this login id. Where else does the password need to get reset in order for that login id to access the database? We cannot set it back to the previous password because it is unknown.
When we go to our website we get the following error:
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect
Please try the following:
Enable Robust Exception Information to provide greater detail about the source of errors. In the Administrator, click Debugging & Logging > Debugging Settings, and select the Robust Exception Information option.
Check the ColdFusion documentation to verify that you are using the correct syntax.
Search the Knowledge Base to find a solution to your problem.
Browser Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)Also- when trying to login to SQL Query Analyzer using the login id that was changed under security it doesn't work with the new password. This is where I'm assuming the problem is (different password for login id vs. dbo).
SQL Server authentication- login id and password method.|||You have a bigger problem than I'd care to tackle with only support via a web site. You really need professional help on problems like this, it will be far cheaper in the long run than trying to work it out this way once you figure in your own time into the equation.
When you change the password using SQL Enterprise Manager, it will change the password. If you change it there, then can't log in using Query Analyzer, then you almost certainly mis-typed the password in one place or the other.
The error being reported doesn't have anything to do with the password. That error message is telling you that the "client" machine (probably your web server) can't "see" your SQL Server machine. My first guess would be due to a configuration issue with Windows Firewall, but that is only a guess.
You have more than one problem. The problems are complex, and can interfere with one another in "interesting" ways. You really need professional help with this!
-PatP|||We got it figured out. It was on the cold fusion side where the password needed to be changed.
Monday, March 19, 2012
Help! How to clustering SQL Server 2000 without Shared Disk?
our company is going to setup ms sql server cluster for fault tolerance,
budget has to be kept minimum.
actaully, i was told that sql clustering (includes shared DB data sync)
can be done over a dedicated tcp/ip connection instead of using shared disk
array connected to the same scsi bus of 2 machines, however i could not even
configure cluster service on win2k server as there is no shared disk.
futhermore, i heard windows 2003 server can do it with no shared disk,
butr it can't be used for this purpose because of license issue.
i would to know if there is a way to cluster sql server nodes without a
shared disk array on windows 2000 adv/dc server + ms sql 2000 enterprise.
all advices are welcomed to reach chun_wail@.hotmail.com
thank you very much,
Will Law (hong kong)"wailaw" <chun_wail@.hotmail.com> wrote in message
news:bi7mdl$lpa1@.imsp212.netvigator.com...
> hi all,
> our company is going to setup ms sql server cluster for fault
tolerance,
> budget has to be kept minimum.
> actaully, i was told that sql clustering (includes shared DB data
sync)
> can be done over a dedicated tcp/ip connection instead of using shared
disk
> array connected to the same scsi bus of 2 machines, however i could not
even
> configure cluster service on win2k server as there is no shared disk.
> futhermore, i heard windows 2003 server can do it with no shared disk,
> butr it can't be used for this purpose because of license issue.
> i would to know if there is a way to cluster sql server nodes without
a
> shared disk array on windows 2000 adv/dc server + ms sql 2000 enterprise.
> all advices are welcomed to reach chun_wail@.hotmail.com
>
> thank you very much,
> Will Law (hong kong)
(Removed irrelevant newsgroups from the reply)
SQL Server clustering depends on the Windows clustering service, so you have
no way to avoid the shared disk requirement - clustering is managed by the
OS, not by SQL Server. However, from what you say, I suspect you may be
thinking of replication, which is a totally different concept. Replication
allows you to keep data in sync between databases on different servers, but
it doesn't provide the failover support that clustering has.
I suggest you read the Books Online overviews on both clustering and
replication and see which suits your needs best. Log shipping might be
another option if a warm standby server is good enough for your purposes.
But if you really need high availability, you can't do it without a decent
budget and resources, so make sure you know exactly what the business
requirements are before you choose a solution.
Simon
Monday, February 27, 2012
help!
01/01 ABS 2000
10/01 KB 1500
02/03 ABS 4000
02/04 LB 3000
04/05 KB 3000
05/06 LB 7000
i need help to write a SQL statement which can output companies with a total amount over 5000 for the period 01/01 to 05/06.try this
select company, sum(amount)
from table
where (the conditions you like)
group by company
having sum(amount) > 5000|||Select
Company,
Sum(Amount) as CompanyTotal
From
Table
Where
(CompanyTotal > 5000)
AND
( Date > 01/01
and
Date < 05/06)
Group by
Company|||Please note that 'Having sum(amount) > x' is not equal to 'where amount > x'. Having is a post group function while where is a pre function.