Showing posts with label web. Show all posts
Showing posts with label web. Show all posts

Friday, March 30, 2012

Install RS with SSL handled in firewall

Hi,

We are trying to install RS in an unusual environment. The Web server's SSL and public IP address are installed in the firewall. The communications between Web server and other servers such as database server are not encrypted; all the servers have no public IP addresses.

My question is if RS can be installed and if it will work properly. Any other advice?

Thanks

Yes - we call this SSL Offloading.

With SQL Server 2005 Reporting Services, things should just work with the exception of the following:

1) Report Builder - it requires a direct connection to the report server to download and to function.

2) Links in Emails - we use the URLRoot property in the rsreportserver.config file to form the URL for the link. You'll need to set the property to your external IP Address or the external hostname, and remember to use the https protocol designatiion.

3) Drill-through links in Exported reports (PDF, Excel, etc.) - again we use the URLRoot property in the rsreportserve.config file to form the URL for the link. See comment above.

4) SharePoint V2 web parts - need a direct connection to the report server to view reports.

With SQL Server 2000 Reporting Services, this is supported starting with SP2. The instructions for setting this up are in the SP2 readme file. One note I should add, is that it is required for the router to translate URLs.

-Lukasz


This posting is provided "AS IS" with no warranties, and confers no rights.

sql

Install RS - Separate DB from Web

I am trying to install reporting services on a web server, which will connect
to an existing instance of the RS Sql Server backend on another machine.
This backend server already has SP2 installed - so when I install RS on the
web server machine and try to point to the existing backend during
installation, it tells me that it is not compatible.
What would be the correct steps to take in order to install on a web server
and connect to an existing RS backend DB? Any relevant articles will help...
Enjoy!
mikeFirst, are you implementing a web farm?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Michael R" <MichaelR@.discussions.microsoft.com> wrote in message
news:9F638932-02F0-48DF-8EF9-A54EF42AF0FA@.microsoft.com...
>I am trying to install reporting services on a web server, which will
>connect
> to an existing instance of the RS Sql Server backend on another machine.
> This backend server already has SP2 installed - so when I install RS on
> the
> web server machine and try to point to the existing backend during
> installation, it tells me that it is not compatible.
> What would be the correct steps to take in order to install on a web
> server
> and connect to an existing RS backend DB? Any relevant articles will
> help...
> Enjoy!
> mike|||Not in the sense that I will have multiple ReportServer databases. I will
have a one to one relationship: 1 web server and 1 server with the
ReportServer database.
It was recommended that I do this by the server admins, in order to take the
load off of IIS.
"Bruce L-C [MVP]" wrote:
> First, are you implementing a web farm?
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Michael R" <MichaelR@.discussions.microsoft.com> wrote in message
> news:9F638932-02F0-48DF-8EF9-A54EF42AF0FA@.microsoft.com...
> >I am trying to install reporting services on a web server, which will
> >connect
> > to an existing instance of the RS Sql Server backend on another machine.
> > This backend server already has SP2 installed - so when I install RS on
> > the
> > web server machine and try to point to the existing backend during
> > installation, it tells me that it is not compatible.
> >
> > What would be the correct steps to take in order to install on a web
> > server
> > and connect to an existing RS backend DB? Any relevant articles will
> > help...
> >
> > Enjoy!
> >
> > mike
>
>|||I would try this:
1) install SQL RS on the web server, and during the install, create new
SQL RS database(s) for it to point to / use (doesn't matter where you
put the DB, you'll end up dropping them soon). At the end of the
install, you'll have a new SQL RS web app, pointing to a new SQL RS db.
2) Apply SP1 to the SQL RS instance (web & new database).
3) Apply SP2 to the SQL RS instance (web & new database).
4) Now that you're web app is up to SP2, you can point it to your
original database using the 'rsconfig' command line utility (see SQL RS
Books Online for details of usage & syntax). After using 'rsconfig' to
point your app to the original database, you'll need to run the
'rskeymgmt' command line utility to initialize / activate your Report
Server for use with the original database (allows it to read the
original database) -- see Books Online for details of syntax and usage.
5) Drop the new SQL RS databases that were created in Step #1, since
you're not going to use them, now that your web app is pointing to the
'original' SP2 database.

Install reporting services (not DB) on 2003 Web Edition?

I am looking to deploy reporting services on two serves, one already running
SQL2000 plus an exisitng IIS Server.
The IIS server is running Windows 2003 Web Edition - is installing the
non-DB components of this edition of windows supported - cannot find the
into in the deployment guide!
Any thanks much appreciated.
Ian.Yes.
--
| From: "Ian Webster" <i.webster@.nos-pam.select.co.uk>
| Subject: Install reporting services (not DB) on 2003 Web Edition?
| Date: Thu, 28 Jul 2005 16:06:47 +0100
| Lines: 12
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
| X-RFC2646: Format=Flowed; Original
| Message-ID: <#Ew1WY4kFHA.1480@.TK2MSFTNGP10.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: 217.206.61.36
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:49125
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| I am looking to deploy reporting services on two serves, one already
running
| SQL2000 plus an exisitng IIS Server.
|
| The IIS server is running Windows 2003 Web Edition - is installing the
| non-DB components of this edition of windows supported - cannot find the
| into in the deployment guide!
|
| Any thanks much appreciated.
|
| Ian.
|
|
||||http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx
This article talks about deployment scenarios.
HTH,
""Brad Syputa - MS"" wrote:
> Yes.
> --
> | From: "Ian Webster" <i.webster@.nos-pam.select.co.uk>
> | Subject: Install reporting services (not DB) on 2003 Web Edition?
> | Date: Thu, 28 Jul 2005 16:06:47 +0100
> | Lines: 12
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
> | X-RFC2646: Format=Flowed; Original
> | Message-ID: <#Ew1WY4kFHA.1480@.TK2MSFTNGP10.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: 217.206.61.36
> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
> | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:49125
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | I am looking to deploy reporting services on two serves, one already
> running
> | SQL2000 plus an exisitng IIS Server.
> |
> | The IIS server is running Windows 2003 Web Edition - is installing the
> | non-DB components of this edition of windows supported - cannot find the
> | into in the deployment guide!
> |
> | Any thanks much appreciated.
> |
> | Ian.
> |
> |
> |
>

Wednesday, March 28, 2012

Install problem

I have been so far unsuccessful in getting Reporting Services
installed on our web server. This server will be used as the
ReportServer. All prerequisites have been installed. I keep getting
the same cryptic error:
Setting Internal Properties
Error code: 267
The suspect activity is in the middle of the log file as shown here.
It appears there is a problem in ReadSkuInfo.
Action start 17:28:24:
SetInstanceProperty.6ED6C379_934D_4B59_816D_25F6911C3538.
<Func Name='RedirectorCAX'>
Function=SetInstanceProperty
<Func Name='SetCAContext'>
<EndFunc Name='SetCAContext' Return='T' GetLastError='203'>
Doing Action: SetInstanceProperty
<Func Name='SetInstanceProperty'>
Using instanced id: MSSQL.1
<Func Name='ReadSkuInfo'>
GetTempFileName failed 267
<EndFunc Name='ReadSkuInfo' Return='267' GetLastError='267'>
<EndFunc Name='SetInstanceProperty' Return='267' GetLastError='267'>
Gathering darwin properties for failure handling.
<Func Name='DisplayErrorDialog'>
<Failure Type='Fatal' Error='267'>
<EndFunc Name='RedirectorCAX' Return='267' GetLastError='487'>
Action ended 17:29:36:
SetInstanceProperty.6ED6C379_934D_4B59_816D_25F6911C3538. Return value
3.
Thanks!
MarkAccording to the log:
GetTempFileName failed 267
Error 267 is 'The directory name is invalid'. Before this call is a call to
GetTempPath. It would seem this function is returning something invalid.
According to the docs:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/fileio/base/gettemppath.asp
The GetTempPath function checks for the existence of environment variables
in the following order and uses the first path found:
1.. The path specified by the TMP environment variable.
2.. The path specified by the TEMP environment variable.
3.. The path specified by the USERPROFILE environment variable.
4.. The Windows directory.
Note that the function does not verify that the path exists.
Can you see if the function is returning something invalid? If so you will
need to fix this problem first.
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"MarkMurphy" <murphy@.murphysw.com> wrote in message
news:e061eb57.0407290935.637d561d@.posting.google.com...
> I have been so far unsuccessful in getting Reporting Services
> installed on our web server. This server will be used as the
> ReportServer. All prerequisites have been installed. I keep getting
> the same cryptic error:
> Setting Internal Properties
> Error code: 267
>
> The suspect activity is in the middle of the log file as shown here.
> It appears there is a problem in ReadSkuInfo.
> Action start 17:28:24:
> SetInstanceProperty.6ED6C379_934D_4B59_816D_25F6911C3538.
> <Func Name='RedirectorCAX'>
> Function=SetInstanceProperty
> <Func Name='SetCAContext'>
> <EndFunc Name='SetCAContext' Return='T' GetLastError='203'>
> Doing Action: SetInstanceProperty
> <Func Name='SetInstanceProperty'>
> Using instanced id: MSSQL.1
> <Func Name='ReadSkuInfo'>
> GetTempFileName failed 267
> <EndFunc Name='ReadSkuInfo' Return='267' GetLastError='267'>
> <EndFunc Name='SetInstanceProperty' Return='267' GetLastError='267'>
> Gathering darwin properties for failure handling.
> <Func Name='DisplayErrorDialog'>
> <Failure Type='Fatal' Error='267'>
> <EndFunc Name='RedirectorCAX' Return='267' GetLastError='487'>
> Action ended 17:29:36:
> SetInstanceProperty.6ED6C379_934D_4B59_816D_25F6911C3538. Return value
> 3.
>
> Thanks!
> Mark|||Thanks Dan,
I was able to get past that error earlier this morning. When I tried
installing it from the console of the web server instead of through
terminal services, it mentioned the temp directory not being correct.
I went to the temp environmental variables and it had F:\temp and
F:\tmp. Well F drive doesn't exist on that server. So I changed it
to C and it got past that error.
Appreciate you getting back.
-Mark

Install pb w2k3

Hello,
Here is the pb:
I have just installed W2K3 web edition on a new server, on a new HD. There
was no sql server product before.
I can install and uninstall MSDE without any PB.
If i try to install the sql 2k dev edition, then i can choose to install
prerequies or sql 2k itself.
If i click on SQL 2K, then i can only see the white window 'build with
demoshield' during 1sec. the install stops wihout any msg, just as if i did
nothing.
Courtoisement
Pierre-Marie PETIT
pm@.nst.fr
03 20 06 63 94
Courtoisement
Pierre-Marie PETIT
pm@.nst.fr
03 20 06 63 94Only MSDE is available for SQL2K Web Edition, not the "regular" SQL Server.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"pm" <pm@.nst.fr> wrote in message news:41fa4aab$0$18822$8fcfb975@.news.wanadoo.fr...arkred">
> Hello,
> Here is the pb:
> I have just installed W2K3 web edition on a new server, on a new HD. There
> was no sql server product before.
> I can install and uninstall MSDE without any PB.
> If i try to install the sql 2k dev edition, then i can choose to install
> prerequies or sql 2k itself.
> If i click on SQL 2K, then i can only see the white window 'build with
> demoshield' during 1sec. the install stops wihout any msg, just as if i di
d
> nothing.
>
> --
> Courtoisement
> Pierre-Marie PETIT
> pm@.nst.fr
> 03 20 06 63 94
>
> --
> Courtoisement
> Pierre-Marie PETIT
> pm@.nst.fr
> 03 20 06 63 94
>|||Thanks
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> a crit
dans le message de news: %23QXYQiUBFHA.2016@.TK2MSFTNGP15.phx.gbl...
> Only MSDE is available for SQL2K Web Edition, not the "regular" SQL
> Server.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "pm" <pm@.nst.fr> wrote in message
> news:41fa4aab$0$18822$8fcfb975@.news.wanadoo.fr...
>

Install of SQL/MSDE not completing HELP!

I am a new user working in Windows XP, and I already have the Web Matrix installed. I am trying to download and install MSDE but I am never prompted to restart my computer. When I do restart the PC symbol w/ the green arrow appears but when I click the data connection to establish a new database it comes with an error message:

Unable to connect to database server.

SQL Server does not exist or access denied.
Connection Open (Connect()).

I'm sure I'm entering the right user name (sa) and password. Please help!!

LaurenHi Lauren,

This is a common problem, and there are serveral reasons this can happen. Are you using Windows Authentication or Mixed (SQL Server and Windows) Authentication? What does your connection string look like?

Also, did you try searching for "access denied" in this forum? There are a lot of posts on this topic.

Terri

install of Report Designer onto a machine w/just VS 03 & VB.Net

Hi:
I recently got Reporting Services and am trying to install it. Microsoft's
web site says:
Additional Software Required to Use Specific Features in Reporting Services
a.. Microsoft Visual Studio® .NET 2003 (any edition) or the standard edition
of Visual Basic® .NET, Visual C#® .NET, Visual C++® .NET Standard, or Visual
J#® .NET to use Report Designer. Report Designer can be installed on the
same computer as Report Server components or on a separate computer.
I have the SQL Server on one box, I put most of Reporting Services on
another box (our web server), and I'm trying to put the Report Designer on
my machine.
I have VS 03, with just VB.net, installed on my machine now. It was a
discount version, and didn't have db access wizards, nor any other
languages. It's been ok because I just used System.Data.SqlClient and
System.Data.SqlTypes, etc, to specify my db access, and manually coded the
interfaces and was able to connect fine.
So I'm trying to install Reporting Services - and just the Report designer,
onto my machine so I can author a report or two without writing raw XML.
When I run the install CD I get all sorts of errors IIS not installed, etc,
etc.Where can I get some specific, applicable instructions on doing this
install ?
ThanksI think your problem is that you are trying to install the server and the
client tools. When you install just the client tools you should not be
getting any errors about IIS (IIS is not required for the development
environment).
Bruce L-C
"steve" <steve@.earthlink.net> wrote in message
news:uufO0khiEHA.632@.TK2MSFTNGP12.phx.gbl...
> Hi:
> I recently got Reporting Services and am trying to install it. Microsoft's
> web site says:
> Additional Software Required to Use Specific Features in Reporting
Services
> a.. Microsoft Visual Studio® .NET 2003 (any edition) or the standard
edition
> of Visual Basic® .NET, Visual C#® .NET, Visual C++® .NET Standard, or
Visual
> J#® .NET to use Report Designer. Report Designer can be installed on the
> same computer as Report Server components or on a separate computer.
> I have the SQL Server on one box, I put most of Reporting Services on
> another box (our web server), and I'm trying to put the Report Designer on
> my machine.
> I have VS 03, with just VB.net, installed on my machine now. It was a
> discount version, and didn't have db access wizards, nor any other
> languages. It's been ok because I just used System.Data.SqlClient and
> System.Data.SqlTypes, etc, to specify my db access, and manually coded the
> interfaces and was able to connect fine.
> So I'm trying to install Reporting Services - and just the Report
designer,
> onto my machine so I can author a report or two without writing raw XML.
> When I run the install CD I get all sorts of errors IIS not installed,
etc,
> etc.Where can I get some specific, applicable instructions on doing this
> install ?
> Thanks
>
>sql

Wednesday, March 21, 2012

install error on web server (windows 2003 web edition/iis6)

During the web server install, I used the network service account to run the
report server.
My Error: setup could not initialize the report server. you must manually
initialize the report server before using it for the 1st time. see reporting
services setup doc.
My environment:
sql server = dbs
web server = report server
client = designer
Do I need to run the rsactivate utility on the web server? How is this done?
Is this correct syntax in the command prompt?
rsconfig -m \\<webserver> -u<administrator> -p<password>
Or, if I am logged onto the web server directly; is this the correct way to
activate the report server?
rsconfig -c"C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\RSReportServer.config"
Thanks,When I tried to pull up the site on my client, I got:
reporting services error
the report server installation is not initialized. check the doc for more
info. (rsreportservernotactivated) get help:
http://www.microsoft.com/products/ee/transform.aspx?EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsReportServerNotActivated&ProdName=Microsoft+SQL+Server+Reporting+Services&ProdVer=8.00
As a result of the error, I restarted the web server and typed in the
address for the reportserver and got prompted to login. I could not use the
servername, but the ipaddress 192.168.0.4/reportserver
It let me in after logging in and displayed the ms sql server reporting
services v 8.
Does this mean that it is working?
---
"wills" wrote:
> During the web server install, I used the network service account to run the
> report server.
> My Error: setup could not initialize the report server. you must manually
> initialize the report server before using it for the 1st time. see reporting
> services setup doc.
> My environment:
> sql server = dbs
> web server = report server
> client = designer
> Do I need to run the rsactivate utility on the web server? How is this done?
> Is this correct syntax in the command prompt?
> rsconfig -m \\<webserver> -u<administrator> -p<password>
>
> Or, if I am logged onto the web server directly; is this the correct way to
> activate the report server?
> rsconfig -c"C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer\RSReportServer.config"
> Thanks,
>|||I tried to test the report manager, 192.168.0.4/reports
I got the following: 192.168.0.4/reports/pages/folder.aspx
Error
The request failed with http status 400. Bad Request.
Home
Does this mean that it is working?
"wills" wrote:
> When I tried to pull up the site on my client, I got:
> reporting services error
> the report server installation is not initialized. check the doc for more
> info. (rsreportservernotactivated) get help:
> http://www.microsoft.com/products/ee/transform.aspx?EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsReportServerNotActivated&ProdName=Microsoft+SQL+Server+Reporting+Services&ProdVer=8.00
>
> As a result of the error, I restarted the web server and typed in the
> address for the reportserver and got prompted to login. I could not use the
> servername, but the ipaddress 192.168.0.4/reportserver
> It let me in after logging in and displayed the ms sql server reporting
> services v 8.
> Does this mean that it is working?
>
> ---
> "wills" wrote:
> > During the web server install, I used the network service account to run the
> > report server.
> >
> > My Error: setup could not initialize the report server. you must manually
> > initialize the report server before using it for the 1st time. see reporting
> > services setup doc.
> >
> > My environment:
> > sql server = dbs
> > web server = report server
> > client = designer
> >
> > Do I need to run the rsactivate utility on the web server? How is this done?
> > Is this correct syntax in the command prompt?
> >
> > rsconfig -m \\<webserver> -u<administrator> -p<password>
> >
> >
> > Or, if I am logged onto the web server directly; is this the correct way to
> > activate the report server?
> >
> > rsconfig -c"C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> > Services\ReportServer\RSReportServer.config"
> >
> > Thanks,
> >
> >

Installation configuration

I am new to SRS, so bear with me. Can I install SRS on my existing SQL box;
install SRM on my existing web box on a different site; and install VS.NET
with report designer on my desktop?It's just depened only on software and hardware yours PC configuration. There
is not other depenedences. Ofcourse You can instal SRS on your SQL box and
SRM on your web box. VS.NET you can have everywhere you want.
J
"Dwayne" wrote:
> I am new to SRS, so bear with me. Can I install SRS on my existing SQL box;
> install SRM on my existing web box on a different site; and install VS.NET
> with report designer on my desktop?

Monday, March 19, 2012

Installation - need help

During installation I get warning ASP.NET is not registered with your Web
Server.
I am running Windows XP Pro and ASP.NET is running on the web server. I
checked few times to make sure that root is running 1.1 version of ASP.NET
( have other versions on my machine also 1.0 and 2.0)
So after I ignored the warning (since I can't do about it anything anyway )
I installed the Reporting Services
From VS.NET I am trying to create new project for Reporting services and I
get "There is an error in XML document (0,0)"
So what's now'
I would appreciate the help. I need it get it running ASAP
Thanks,
Shimon.Reporting Services is not compatible with the 2.0 version of the .NET
framework. I would delete the later version.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Shimon Sim" <estshim@.att.net> wrote in message
news:%23WUd1ofcEHA.4092@.TK2MSFTNGP11.phx.gbl...
> During installation I get warning ASP.NET is not registered with your Web
> Server.
> I am running Windows XP Pro and ASP.NET is running on the web server. I
> checked few times to make sure that root is running 1.1 version of ASP.NET
> ( have other versions on my machine also 1.0 and 2.0)
> So after I ignored the warning (since I can't do about it anything
> anyway )
> I installed the Reporting Services
> From VS.NET I am trying to create new project for Reporting services and I
> get "There is an error in XML document (0,0)"
> So what's now'
> I would appreciate the help. I need it get it running ASAP
> Thanks,
> Shimon.
>|||I uninstalled .NET 2.0 and installation went through but I still get this
message from VS.NET 2003 when I am trying to create new project "There is an
error in XML document (0,0)"
Thanks,
Shimon.
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:OB25LThcEHA.3040@.TK2MSFTNGP10.phx.gbl...
> Reporting Services is not compatible with the 2.0 version of the .NET
> framework. I would delete the later version.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Shimon Sim" <estshim@.att.net> wrote in message
> news:%23WUd1ofcEHA.4092@.TK2MSFTNGP11.phx.gbl...
> > During installation I get warning ASP.NET is not registered with your
Web
> > Server.
> > I am running Windows XP Pro and ASP.NET is running on the web server. I
> > checked few times to make sure that root is running 1.1 version of
ASP.NET
> > ( have other versions on my machine also 1.0 and 2.0)
> >
> > So after I ignored the warning (since I can't do about it anything
> > anyway )
> > I installed the Reporting Services
> >
> > From VS.NET I am trying to create new project for Reporting services and
I
> > get "There is an error in XML document (0,0)"
> >
> > So what's now'
> > I would appreciate the help. I need it get it running ASAP
> > Thanks,
> > Shimon.
> >
> >
>|||I don't know if anybody will find it interesting but uninstalling TestRunner
solves the problems.
Thanks,
Shimon.
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:OB25LThcEHA.3040@.TK2MSFTNGP10.phx.gbl...
> Reporting Services is not compatible with the 2.0 version of the .NET
> framework. I would delete the later version.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Shimon Sim" <estshim@.att.net> wrote in message
> news:%23WUd1ofcEHA.4092@.TK2MSFTNGP11.phx.gbl...
> > During installation I get warning ASP.NET is not registered with your
Web
> > Server.
> > I am running Windows XP Pro and ASP.NET is running on the web server. I
> > checked few times to make sure that root is running 1.1 version of
ASP.NET
> > ( have other versions on my machine also 1.0 and 2.0)
> >
> > So after I ignored the warning (since I can't do about it anything
> > anyway )
> > I installed the Reporting Services
> >
> > From VS.NET I am trying to create new project for Reporting services and
I
> > get "There is an error in XML document (0,0)"
> >
> > So what's now'
> > I would appreciate the help. I need it get it running ASAP
> > Thanks,
> > Shimon.
> >
> >
>

Wednesday, March 7, 2012

inserting video from sql into embedded media

Hi i have a video file path stored in my sql database and i have an embedded media player in my web page, how can i load up a different video file into the embedded media player based on movie id or movie name, this is the code i have written so far but im unsure if im in the right direction, thanks

sorry this is the code

<

formid="form1"runat="server"><palign="center"><OBJECTID="Player"

CLASSID

="CLSID:6BF52A52-394A-11d3-B153-00C04F79FAA6"

VIEWASTEXT

><PARAMname="autoStart"value="True"><PARAMname="URL"value="<%# Eval("MovieFile") %>"><PARAMname="rate"value="1"><PARAMname="balance"value="0"><PARAMname="enabled"value="true"><PARAMname="enabledContextMenu"value="true"><PARAMname="fullScreen"value="false"><PARAMname="playCount"value="1"><PARAMname="volume"value="100">

</

OBJECT></p>

|||

Hi Peter,

Naturally, you can pass the value from database to the url attribute of the object. And about the usage of ActiveX controls from Internet Explorer, you may refer the following kb article:

http://support.microsoft.com/kb/555687

If this does not help you,pls feel free to mark the post as Not Answered and reply.

Thanks.

Friday, February 24, 2012

Inserting to SQL DB from a form using parameters

I have a web form for new members to fill out and save their info in a SQL database to be retrieved later. There will be like 20 elements in the form mostly textboxes. Is there a good example of how to read all the elements and have them INSERTed in a SQL Database? I imagine parameters and a SP would be the way to go. So if someone could provide me with some sample code or a good link.

Thanks in advance,Here's a sample calling a stored procedure with parameters and with a variety of data types.


SqlCommand cm= new SqlCommand();
cm.Connection= Connection;
cm.CommandType= CommandType.StoredProcedure;
cm.CommandText= "StoredProcedureName";
SqlParameter sp1 = cm.Parameters.Add( new SqlParameter("@.Field1",SqlDbType.Int,4)); sp1.Value = salesID;
SqlParameter sp2 = cm.Parameters.Add( new SqlParameter("@.Field2",SqlDbType.Int, 4)); sp2.Value = someIntValue;
SqlParameter sp3 = cm.Parameters.Add( new SqlParameter("@.Field3",SqlDbType.Money, 8));sp3.Value = someDoubleValue;
SqlParameter sp4 = cm.Parameters.Add( new SqlParameter("@.Field4",SqlDbType.Float, 8 )); sp4.Value = anotherDoubleValue;
SqlParameter sp5 = cm.Parameters.Add( new SqlParameter("@.Field5",SqlDbType.DateTime, 8)); sp5.Value = someDateTimeValue
Connection.Open();
cm.ExecuteNonQuery();
Connection.Close();

Inserting special characters

Hi
I have a web page where users insert some comments into a text area. users
are able to insert any character into this area. When they submit the
character ' and " causes problems. How can i allow these characters to be
inserted into the database( sql server 2000)?
I am using Java server page to process and insert the comments to the
database.
thanksHi,
Not quite sure what you are trying exactly. Just try using NVARCHAR data
type and see if it helps.
Thanks
Hari
SQL Server MVP
"panda" <panda@.discussions.microsoft.com> wrote in message
news:CF0A3B21-D97F-44C6-800B-88B3B54E501C@.microsoft.com...
> Hi
> I have a web page where users insert some comments into a text area. users
> are able to insert any character into this area. When they submit the
> character ' and " causes problems. How can i allow these characters to be
> inserted into the database( sql server 2000)?
> I am using Java server page to process and insert the comments to the
> database.
> thanks|||This would be less of a problem if you were using stored procedures. Since
you are probably sending query strings from the web page to the SQL Server,
you may be very vulnerable to SQL Injection attacks. (Write to me off line
and I will give you more information about your vulnerability.)
For the single quote, if you must store them, have the application double
(two single quotes) them before sending to SQL Server. The double quote
shouldn't be a problem -please confirm how you are experiencing the problem.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"panda" <panda@.discussions.microsoft.com> wrote in message
news:CF0A3B21-D97F-44C6-800B-88B3B54E501C@.microsoft.com...
> Hi
> I have a web page where users insert some comments into a text area. users
> are able to insert any character into this area. When they submit the
> character ' and " causes problems. How can i allow these characters to be
> inserted into the database( sql server 2000)?
> I am using Java server page to process and insert the comments to the
> database.
> thanks|||HI,
I am trying to insert a ' charcerter. However the SQL syntax for inserting
nvarchar or strings use the ' character to determine the begining and the
end.
How do i go about inserting a ' character into the database?
"Hari Prasad" wrote:
> Hi,
> Not quite sure what you are trying exactly. Just try using NVARCHAR data
> type and see if it helps.
> Thanks
> Hari
> SQL Server MVP
> "panda" <panda@.discussions.microsoft.com> wrote in message
> news:CF0A3B21-D97F-44C6-800B-88B3B54E501C@.microsoft.com...
> > Hi
> >
> > I have a web page where users insert some comments into a text area. users
> > are able to insert any character into this area. When they submit the
> > character ' and " causes problems. How can i allow these characters to be
> > inserted into the database( sql server 2000)?
> >
> > I am using Java server page to process and insert the comments to the
> > database.
> >
> > thanks
>
>|||This is a multi-part message in MIME format.
--=_NextPart_000_05F8_01C6C63E.8066A380
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable
Use two of them, for example:
CREATE TABLE #MyTable
( RowID int IDENTITY
, MyStringValue varchar(100)
)
INSERT INTO #MyTable VALUES ('"This isn''t so obvious, is it?", said =Bill O''Shea to Terrance O''Donald.')
SELECT MyStringValue FROM #MyTable
DROP TABLE #MyTable
Hope that this helps...
-- Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience. Most experience comes from bad judgment. - Anonymous
"panda" <panda@.discussions.microsoft.com> wrote in message =news:26E49E21-4F45-4F5E-ABD2-BD5E5D8771C4@.microsoft.com...
> HI,
> > I am trying to insert a ' charcerter. However the SQL syntax for =inserting > nvarchar or strings use the ' character to determine the begining and =the > end. > > How do i go about inserting a ' character into the database?
> > "Hari Prasad" wrote:
> >> Hi,
>> >> Not quite sure what you are trying exactly. Just try using NVARCHAR =data >> type and see if it helps.
>> >> Thanks
>> Hari
>> SQL Server MVP
>> >> "panda" <panda@.discussions.microsoft.com> wrote in message >> news:CF0A3B21-D97F-44C6-800B-88B3B54E501C@.microsoft.com...
>> > Hi
>> >
>> > I have a web page where users insert some comments into a text =area. users
>> > are able to insert any character into this area. When they submit =the
>> > character ' and " causes problems. How can i allow these characters =to be
>> > inserted into the database( sql server 2000)?
>> >
>> > I am using Java server page to process and insert the comments to =the
>> > database.
>> >
>> > thanks >> >> --=_NextPart_000_05F8_01C6C63E.8066A380
Content-Type: text/html;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable
=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

Use two of them, for =example:
CREATE TABLE =#MyTable ( =RowID int IDENTITY , MyStringValue varchar(100) )
INSERT INTO #MyTable VALUES ('"This isn''t so obvious, is it?", =said Bill O''Shea to Terrance O''Donald.')
SELECT MyStringValue FROM #MyTable
DROP TABLE #MyTable
Hope that this helps...
-- Arnie Rowland, =Ph.D.Westwood Consulting, Inc
Most good judgment comes from =experience. Most experience comes from bad judgment. - Anonymous
"panda" wrote in message news:26E49E21-4F45-4F5E-ABD2-BD5E5D8771C4@.microsoft.com...> =HI,> > I am trying to insert a ' charcerter. However the SQL syntax =for inserting > nvarchar or strings use the ' character to determine =the begining and the > end. > > How do i go about =inserting a ' character into the database?> > "Hari Prasad" =wrote:> > Hi,> > Not quite sure what you are =trying exactly. Just try using NVARCHAR data > type and see if it helps.> > Thanks> Hari> SQL =Server MVP> > "panda" wrote in message > news:CF0A3B21-D97F-44C6-800B-88B3B54E501C@.microsoft.com...> > Hi> =>> > I have a web page where users insert some comments into a text area. users> > are able to insert any character into this area. =When they submit the> > character ' and " causes problems. How =can i allow these characters to be> > inserted into the =database( sql server 2000)?> >> > I am using Java server =page to process and insert the comments to the> > =database.> >> > thanks > > >

--=_NextPart_000_05F8_01C6C63E.8066A380--

Inserting special characters

Hi
I have a web page where users insert some comments into a text area. users
are able to insert any character into this area. When they submit the
character ' and " causes problems. How can i allow these characters to be
inserted into the database( sql server 2000)?
I am using Java server page to process and insert the comments to the
database.
thanksHi,
Not quite sure what you are trying exactly. Just try using NVARCHAR data
type and see if it helps.
Thanks
Hari
SQL Server MVP
"panda" <panda@.discussions.microsoft.com> wrote in message
news:CF0A3B21-D97F-44C6-800B-88B3B54E501C@.microsoft.com...
> Hi
> I have a web page where users insert some comments into a text area. users
> are able to insert any character into this area. When they submit the
> character ' and " causes problems. How can i allow these characters to be
> inserted into the database( sql server 2000)?
> I am using Java server page to process and insert the comments to the
> database.
> thanks|||This would be less of a problem if you were using stored procedures. Since
you are probably sending query strings from the web page to the SQL Server,
you may be very vulnerable to SQL Injection attacks. (Write to me off line
and I will give you more information about your vulnerability.)
For the single quote, if you must store them, have the application double
(two single quotes) them before sending to SQL Server. The double quote
shouldn't be a problem -please confirm how you are experiencing the problem.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"panda" <panda@.discussions.microsoft.com> wrote in message
news:CF0A3B21-D97F-44C6-800B-88B3B54E501C@.microsoft.com...
> Hi
> I have a web page where users insert some comments into a text area. users
> are able to insert any character into this area. When they submit the
> character ' and " causes problems. How can i allow these characters to be
> inserted into the database( sql server 2000)?
> I am using Java server page to process and insert the comments to the
> database.
> thanks|||HI,
I am trying to insert a ' charcerter. However the SQL syntax for inserting
nvarchar or strings use the ' character to determine the begining and the
end.
How do i go about inserting a ' character into the database?
"Hari Prasad" wrote:

> Hi,
> Not quite sure what you are trying exactly. Just try using NVARCHAR data
> type and see if it helps.
> Thanks
> Hari
> SQL Server MVP
> "panda" <panda@.discussions.microsoft.com> wrote in message
> news:CF0A3B21-D97F-44C6-800B-88B3B54E501C@.microsoft.com...
>
>|||Use two of them, for example:
CREATE TABLE #MyTable
( RowID int IDENTITY
, MyStringValue varchar(100)
)
INSERT INTO #MyTable VALUES ('"This isn''t so obvious, is it?", said Bill O'
'Shea to Terrance O''Donald.')
SELECT MyStringValue
FROM #MyTable
DROP TABLE #MyTable
Hope that this helps...
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"panda" <panda@.discussions.microsoft.com> wrote in message news:26E49E21-4F45-4F5E-ABD2-BD5E
5D8771C4@.microsoft.com...[vbcol=seagreen]
> HI,
>
> I am trying to insert a ' charcerter. However the SQL syntax for inserting
> nvarchar or strings use the ' character to determine the begining and the
> end.
>
> How do i go about inserting a ' character into the database?
>
> "Hari Prasad" wrote:
>

Sunday, February 19, 2012

INSERTING or UPDATING automatically

i am using visual web developer 2005 and SQL Express 2005 with VB as the code behind

i have a button and in the button click event i have written codes to INSERT to a database table - it has one primary key

so when i click the button, if there is already a row with primary key fields value as 10 and if i try to INSERT with the same value in the primary key field there will occur primary key constraint

so , if i try to INSERT with the already existing primary key fields value, instead of INSERTing it should be UPDATEd without generating any error

please help me

In ur SQl procedure

Include


If exists (select [PrimaryKeyColumn] from UrTable where PrimarKey = @.PrimaryKey)

Update ...

else

Insert ...

Like this u get to check for existing key , if exists it will execute an update else an insert

Hope that helps u