Remote Web Report timing out

I've got an internal Reporting Server and I can access the reports directly
there with no problem.
I can generate a report with the WinForm without a problem as well.
What I'm trying to do is to use a second, public web server that has an ASPX
page containing the reportviewer control that connects to the internal web
server so we can implment the seucurity system used by the rest of the web
site.
I can open the report, which has an input parameter without a problem. When
I enter a parameter and attempt to generate the report, it connects to the
Report Server without a problem but then sits there, spinning the little
green arrow until it times out.
With profiler turned on I can see the exact same set of data calls being
made when the report is run on the report server, in the WinForm and in the
WebForm, the only difference being that it appears the WebForm never gets the
data back.
Any ideas?
--
Josef
http://www.reluctantdba.comOn Sep 13, 9:54 am, Josef Finsel
<JosefFin...@.discussions.microsoft.com> wrote:
> I've got an internal Reporting Server and I can access the reports directly
> there with no problem.
> I can generate a report with the WinForm without a problem as well.
> What I'm trying to do is to use a second, public web server that has an ASPX
> page containing the reportviewer control that connects to the internal web
> server so we can implment the seucurity system used by the rest of the web
> site.
> I can open the report, which has an input parameter without a problem. When
> I enter a parameter and attempt to generate the report, it connects to the
> Report Server without a problem but then sits there, spinning the little
> green arrow until it times out.
> With profiler turned on I can see the exact same set of data calls being
> made when the report is run on the report server, in the WinForm and in the
> WebForm, the only difference being that it appears the WebForm never gets the
> data back.
> Any ideas?
> --
> Josefhttp://www.reluctantdba.com
Normally hitting the web server will be slower if it is on another
machine/server. Also, communicating through IIS and a network takes
extra time. The only suggestion I have is to tune the query/stored
procedure that sources the report via the Database Engine Tuning
Advisor. This might give you a little performance improvement. Hope
this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Those are all good and valid points but it turns out that it was actually a
permissions issue.
I got it resolved and it works fine.
Thanks
--
Josef
http://www.reluctantdba.com
"EMartinez" wrote:
> On Sep 13, 9:54 am, Josef Finsel
> <JosefFin...@.discussions.microsoft.com> wrote:
> > I've got an internal Reporting Server and I can access the reports directly
> > there with no problem.
> >
> > I can generate a report with the WinForm without a problem as well.
> >
> > What I'm trying to do is to use a second, public web server that has an ASPX
> > page containing the reportviewer control that connects to the internal web
> > server so we can implment the seucurity system used by the rest of the web
> > site.
> >
> > I can open the report, which has an input parameter without a problem. When
> > I enter a parameter and attempt to generate the report, it connects to the
> > Report Server without a problem but then sits there, spinning the little
> > green arrow until it times out.
> >
> > With profiler turned on I can see the exact same set of data calls being
> > made when the report is run on the report server, in the WinForm and in the
> > WebForm, the only difference being that it appears the WebForm never gets the
> > data back.
> >
> > Any ideas?
> > --
> > Josefhttp://www.reluctantdba.com
>
> Normally hitting the web server will be slower if it is on another
> machine/server. Also, communicating through IIS and a network takes
> extra time. The only suggestion I have is to tune the query/stored
> procedure that sources the report via the Database Engine Tuning
> Advisor. This might give you a little performance improvement. Hope
> this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||On Sep 14, 4:02 pm, Josef Finsel
<JosefFin...@.discussions.microsoft.com> wrote:
> Those are all good and valid points but it turns out that it was actually a
> permissions issue.
> I got it resolved and it works fine.
> Thanks
> --
> Josefhttp://www.reluctantdba.com
> "EMartinez" wrote:
> > On Sep 13, 9:54 am, Josef Finsel
> > <JosefFin...@.discussions.microsoft.com> wrote:
> > > I've got an internal Reporting Server and I can access the reports directly
> > > there with no problem.
> > > I can generate a report with the WinForm without a problem as well.
> > > What I'm trying to do is to use a second, public web server that has an ASPX
> > > page containing the reportviewer control that connects to the internal web
> > > server so we can implment the seucurity system used by the rest of the web
> > > site.
> > > I can open the report, which has an input parameter without a problem. When
> > > I enter a parameter and attempt to generate the report, it connects to the
> > > Report Server without a problem but then sits there, spinning the little
> > > green arrow until it times out.
> > > With profiler turned on I can see the exact same set of data calls being
> > > made when the report is run on the report server, in the WinForm and in the
> > > WebForm, the only difference being that it appears the WebForm never gets the
> > > data back.
> > > Any ideas?
> > > --
> > > Josefhttp://www.reluctantdba.com
> > Normally hitting the web server will be slower if it is on another
> > machine/server. Also, communicating through IIS and a network takes
> > extra time. The only suggestion I have is to tune the query/stored
> > procedure that sources the report via the Database Engine Tuning
> > Advisor. This might give you a little performance improvement. Hope
> > this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
Glad you resolved the issue. Let me know if I can be of further
assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

Remote SQL Server login failed for ASPNET user

This is a common problem, but none of the methods I read about in the other
posts have worked. What is a sure-fire way to get my web application to sto
p
using the ASPNET user for SQL Server authentication? I am trying to connect
to a Server on my LAN with a specified username and password. The error I
get is "Login failed for user '<computer name>\ASPNET'. I tried a standard
connection string and then one that Visual Studio generated when I dragged
the connection to a form:
"Server=<servername>;User ID=<userid>;Password=<password>Initial Catalog=<db
name>"
"workstation id=<my computer name>;packet size=4096;user
id=<user>;password=<password>;data source=<sql server name>;persist security
info=False;initial catalog=<db name>"
I have also tried putting in "Trusted_Connection=false". Also I saw
something about impersonation in the web.config, which i tried but it would
not compile.
The login works fine from inside the Visual Studio IDE and also through
Enterprise Manager.
Thanks for your help
SteveIn my experience this happens when you have the following conditions true...
1. You're using a connection string that's using Integrated Windows
authentication
2. Your web server is configured for anonymous access only
3. <identity impersonate="true" /> is set in your web config (system.web
section)
If your connection string uses a sql login:
User ID=<user>;password=<pwd>;Initial Catalog=<database>;Data Source=<server
>
You should never get this error if your using a SQL login, you're telling
the connection with what credentials to use to connect to the database, why
would it not use what you specified...? I'd double check the connection
string in the config file... You have to have "Integrated Security=True"
specified in your connect string otherwise you would not be attempting to
authenticate to the database using a windows account.
"Steve P" wrote:

> This is a common problem, but none of the methods I read about in the othe
r
> posts have worked. What is a sure-fire way to get my web application to s
top
> using the ASPNET user for SQL Server authentication? I am trying to conne
ct
> to a Server on my LAN with a specified username and password. The error I
> get is "Login failed for user '<computer name>\ASPNET'. I tried a standar
d
> connection string and then one that Visual Studio generated when I dragged
> the connection to a form:
> "Server=<servername>;User ID=<userid>;Password=<password>Initial Catalog=<
db
> name>"
> "workstation id=<my computer name>;packet size=4096;user
> id=<user>;password=<password>;data source=<sql server name>;persist securi
ty
> info=False;initial catalog=<db name>"
> I have also tried putting in "Trusted_Connection=false". Also I saw
> something about impersonation in the web.config, which i tried but it woul
d
> not compile.
> The login works fine from inside the Visual Studio IDE and also through
> Enterprise Manager.
> Thanks for your help
> Steve|||Thank you for responding, Alien2_51. I'll just go down your list:
1) I have made sure that my connection string does not include Integrated
Security=true"
2) I'm not sure about this. I'm just serving out the pages my my computer
(localhost). If I right-click on the default web site and go to directory
security, then to Edit anonymous access, the items that are checked are
"anonymous access", "allow IIS to control password", and "Integrated Windows
authentication". The user name in this dialog box is set to "IUSR_<my
computer name>". If I try to uncheck "integrated windows authentication", I
have to log in when I run the page and then the page won't even display.
3) In my machine.config file, impersonate="false". In the web.config of the
application, the value is not set.
Finally, I don't use the connection string that is in the web.config file
(sqlConnectionString="data source=127.0.0.1;Trusted_Connection=yes") I'm not
sure why it's in there; I just put the connection string in global.asax as a
n
application variable. I have also tried just hard-coding the connection
string into the code. I tried commenting out the connection string in
web.config to no avail.
Anyone please let me know if you have any other suggestions; your help is
certainly appreciated.
Thanks,
Steve
"Alien2_51" wrote:
> In my experience this happens when you have the following conditions true.
.
> 1. You're using a connection string that's using Integrated Windows
> authentication
> 2. Your web server is configured for anonymous access only
> 3. <identity impersonate="true" /> is set in your web config (system.w
eb
> section)
> If your connection string uses a sql login:
> User ID=<user>;password=<pwd>;Initial Catalog=<database>;Data Source=<serv
er>
> You should never get this error if your using a SQL login, you're telling
> the connection with what credentials to use to connect to the database, wh
y
> would it not use what you specified...? I'd double check the connection
> string in the config file... You have to have "Integrated Security=True"
> specified in your connect string otherwise you would not be attempting to
> authenticate to the database using a windows account.
>
>
>
> "Steve P" wrote:
>|||Figured out my problem...though the error message is misleading. Apparently
asp.net won't let you have 2 connections open at the same time (one to local
database and one to remote). I removed the local connection to test it and
it worked. Does anyone know how to have 2 simultaneous connections open? I
can use a dataset but the potential problem there is the amount of memory it
could use...
Thanks, Steve
"Steve P" wrote:

> This is a common problem, but none of the methods I read about in the othe
r
> posts have worked. What is a sure-fire way to get my web application to s
top
> using the ASPNET user for SQL Server authentication? I am trying to conne
ct
> to a Server on my LAN with a specified username and password. The error I
> get is "Login failed for user '<computer name>\ASPNET'. I tried a standar
d
> connection string and then one that Visual Studio generated when I dragged
> the connection to a form:
> "Server=<servername>;User ID=<userid>;Password=<password>Initial Catalog=<
db
> name>"
> "workstation id=<my computer name>;packet size=4096;user
> id=<user>;password=<password>;data source=<sql server name>;persist securi
ty
> info=False;initial catalog=<db name>"
> I have also tried putting in "Trusted_Connection=false". Also I saw
> something about impersonation in the web.config, which i tried but it woul
d
> not compile.
> The login works fine from inside the Visual Studio IDE and also through
> Enterprise Manager.
> Thanks for your help
> Steve|||Please disregard my last post. The error originated not from the remote
connection but from the local connection.
"Steve P" wrote:
> Figured out my problem...though the error message is misleading. Apparent
ly
> asp.net won't let you have 2 connections open at the same time (one to loc
al
> database and one to remote). I removed the local connection to test it an
d
> it worked. Does anyone know how to have 2 simultaneous connections open?
I
> can use a dataset but the potential problem there is the amount of memory
it
> could use...
> Thanks, Steve
> "Steve P" wrote:
>sql

Remote SQL Server Access

I'm using SQL Server to store session state. The Sql Server is on the local network but not on the web server. I use impersonation and use account credentials for the ASPNET worker process:

<identity impersonate="true" userName="domain\user" password="pass"/
I'm able to access all resources and execute all pages without any problem.

When an object is added to session state I recieve the following error:

"Cannot open database requested in login 'ASPState'. Login fails. Login failed for user 'domain\username. "

Here is my web.config entry for using sql server (with modified connection string of course):

<sessionState mode="SQLServer" cookieless="false" timeout="30" stateConnectionString="Data Source=xxx.xxx.x.xx,1433;Network Library=DBMSSOCN;Initial Catalog=ASPState;Integrated Security=SSPI" /
I've checked and given the user i'm impersonating the ability to do everything. I've granted access on all necessary files, added them to the DB and made the user a db_owner of the ASPState table. I can log in to a machine as the user, then access sql server using the windows authentication. I granted 'act as part of the operating system', 'access this computer from a network', 'log on as a service', 'log on as a batch job' on both the remote computer hosting sql server and the web server.

The strange thing is i installed the asp session state tables on my development machine, using the same configuration file to run everything, and was able to add an object to session state without any problem. But when i specify the remote server, i'm denied.

Anybody have an idea?Have you tried switched back from integrated and supplying the said user details in the connection string? Not suggesting that as a solution but just wondering if that works.

Remote server backups to local drive?

Is there any way to backup a remote SQL Server that is on a hosted account
to a local drive? We have a web hosted account that has a SQL Server that
we do not have full admin rights on. We would like to be able to do backups
and restores to our local development server if possible.ML
Can you copy .BAK file to your local server by using XCOPY utility?
"ML" <schooner@.accesswave.ca> wrote in message
news:eVHVJOlpFHA.1416@.TK2MSFTNGP09.phx.gbl...
> Is there any way to backup a remote SQL Server that is on a hosted account
> to a local drive? We have a web hosted account that has a SQL Server that
> we do not have full admin rights on. We would like to be able to do
> backups and restores to our local development server if possible.
>|||No, I do not have direct access to perform a backup or copy the bak files.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%232N%23LUlpFHA.1464@.TK2MSFTNGP14.phx.gbl...
> ML
> Can you copy .BAK file to your local server by using XCOPY utility?
>
>
> "ML" <schooner@.accesswave.ca> wrote in message
> news:eVHVJOlpFHA.1416@.TK2MSFTNGP09.phx.gbl...
>> Is there any way to backup a remote SQL Server that is on a hosted
>> account to a local drive? We have a web hosted account that has a SQL
>> Server that we do not have full admin rights on. We would like to be
>> able to do backups and restores to our local development server if
>> possible.
>|||Ok, so maybe someone who has permissions at remote server can backup
database and put in FTP directory for example where you can copy .BAK file
Also , check out WEB Admin SQL tool provided by Microsoft.
"ML" <schooner@.accesswave.ca> wrote in message
news:%23UWcrYlpFHA.3516@.TK2MSFTNGP15.phx.gbl...
> No, I do not have direct access to perform a backup or copy the bak files.
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%232N%23LUlpFHA.1464@.TK2MSFTNGP14.phx.gbl...
>> ML
>> Can you copy .BAK file to your local server by using XCOPY utility?
>>
>>
>> "ML" <schooner@.accesswave.ca> wrote in message
>> news:eVHVJOlpFHA.1416@.TK2MSFTNGP09.phx.gbl...
>> Is there any way to backup a remote SQL Server that is on a hosted
>> account to a local drive? We have a web hosted account that has a SQL
>> Server that we do not have full admin rights on. We would like to be
>> able to do backups and restores to our local development server if
>> possible.
>>
>|||I am looking for a solution that avoids having to have someone on the
hosting end be involved, possibly a DTS package or similar.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uefMEilpFHA.3536@.TK2MSFTNGP15.phx.gbl...
> Ok, so maybe someone who has permissions at remote server can backup
> database and put in FTP directory for example where you can copy .BAK file
> Also , check out WEB Admin SQL tool provided by Microsoft.
>
> "ML" <schooner@.accesswave.ca> wrote in message
> news:%23UWcrYlpFHA.3516@.TK2MSFTNGP15.phx.gbl...
>> No, I do not have direct access to perform a backup or copy the bak
>> files.
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:%232N%23LUlpFHA.1464@.TK2MSFTNGP14.phx.gbl...
>> ML
>> Can you copy .BAK file to your local server by using XCOPY utility?
>>
>>
>> "ML" <schooner@.accesswave.ca> wrote in message
>> news:eVHVJOlpFHA.1416@.TK2MSFTNGP09.phx.gbl...
>> Is there any way to backup a remote SQL Server that is on a hosted
>> account to a local drive? We have a web hosted account that has a SQL
>> Server that we do not have full admin rights on. We would like to be
>> able to do backups and restores to our local development server if
>> possible.
>>
>>
>|||You have just answered your own question. You need platform access to a
file share to retrieve a backup file. DTS will copy a file for you, but it
uses the same windows network file mechanism that copy and xcopy use. You
can use a SQL to SQL transfer to copy database elements, but you will need
direct outside access to the SQL Service. Somehow, I doubt the hosting
company will be any more likely to grant that than they will to give
platform access.
I would say your best bet is to havethem make a backup and place it where
you can retrieve it via FTP.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"ML" <schooner@.accesswave.ca> wrote in message
news:%23UWcrYlpFHA.3516@.TK2MSFTNGP15.phx.gbl...
> No, I do not have direct access to perform a backup or copy the bak files.
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%232N%23LUlpFHA.1464@.TK2MSFTNGP14.phx.gbl...
>> ML
>> Can you copy .BAK file to your local server by using XCOPY utility?
>>
>>
>> "ML" <schooner@.accesswave.ca> wrote in message
>> news:eVHVJOlpFHA.1416@.TK2MSFTNGP09.phx.gbl...
>> Is there any way to backup a remote SQL Server that is on a hosted
>> account to a local drive? We have a web hosted account that has a SQL
>> Server that we do not have full admin rights on. We would like to be
>> able to do backups and restores to our local development server if
>> possible.
>>
>|||I have full dbo access in terms of being able to run a DTS package, etc. I
just do not have rights to backup to a drive that is accessible from our
account.
That is why I ask if there is someway to handle it other than the normal
backup/restore.
Yes the host will do full backups and restores for us on request but would
like to have means where we can do a similar task as needed.
"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:%23fpzF1npFHA.3004@.TK2MSFTNGP15.phx.gbl...
> You have just answered your own question. You need platform access to a
> file share to retrieve a backup file. DTS will copy a file for you, but
> it uses the same windows network file mechanism that copy and xcopy use.
> You can use a SQL to SQL transfer to copy database elements, but you will
> need direct outside access to the SQL Service. Somehow, I doubt the
> hosting company will be any more likely to grant that than they will to
> give platform access.
> I would say your best bet is to havethem make a backup and place it where
> you can retrieve it via FTP.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "ML" <schooner@.accesswave.ca> wrote in message
> news:%23UWcrYlpFHA.3516@.TK2MSFTNGP15.phx.gbl...
>> No, I do not have direct access to perform a backup or copy the bak
>> files.
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:%232N%23LUlpFHA.1464@.TK2MSFTNGP14.phx.gbl...
>> ML
>> Can you copy .BAK file to your local server by using XCOPY utility?
>>
>>
>> "ML" <schooner@.accesswave.ca> wrote in message
>> news:eVHVJOlpFHA.1416@.TK2MSFTNGP09.phx.gbl...
>> Is there any way to backup a remote SQL Server that is on a hosted
>> account to a local drive? We have a web hosted account that has a SQL
>> Server that we do not have full admin rights on. We would like to be
>> able to do backups and restores to our local development server if
>> possible.
>>
>>
>|||ML (schooner@.accesswave.ca) writes:
> I have full dbo access in terms of being able to run a DTS package, etc.
> I just do not have rights to backup to a drive that is accessible from
> our account.
> That is why I ask if there is someway to handle it other than the normal
> backup/restore.
You can backup to a network drive, but I doubt that your local disks are
visible from the SQL Server machine. (And if they are, that would mean that
you need to open those drives for access, so that anyone customer of the
web host, can dump things on your disk space.)
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

Remote server backups to local drive?

Is there any way to backup a remote SQL Server that is on a hosted account
to a local drive? We have a web hosted account that has a SQL Server that
we do not have full admin rights on. We would like to be able to do backups
and restores to our local development server if possible.ML
Can you copy .BAK file to your local server by using XCOPY utility?
"ML" <schooner@.accesswave.ca> wrote in message
news:eVHVJOlpFHA.1416@.TK2MSFTNGP09.phx.gbl...
> Is there any way to backup a remote SQL Server that is on a hosted account
> to a local drive? We have a web hosted account that has a SQL Server that
> we do not have full admin rights on. We would like to be able to do
> backups and restores to our local development server if possible.
>|||No, I do not have direct access to perform a backup or copy the bak files.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%232N%23LUlpFHA.1464@.TK2MSFTNGP14.phx.gbl...
> ML
> Can you copy .BAK file to your local server by using XCOPY utility?
>
>
> "ML" <schooner@.accesswave.ca> wrote in message
> news:eVHVJOlpFHA.1416@.TK2MSFTNGP09.phx.gbl...
>|||Ok, so maybe someone who has permissions at remote server can backup
database and put in FTP directory for example where you can copy .BAK file
Also , check out WEB Admin SQL tool provided by Microsoft.
"ML" <schooner@.accesswave.ca> wrote in message
news:%23UWcrYlpFHA.3516@.TK2MSFTNGP15.phx.gbl...
> No, I do not have direct access to perform a backup or copy the bak files.
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%232N%23LUlpFHA.1464@.TK2MSFTNGP14.phx.gbl...
>|||I am looking for a solution that avoids having to have someone on the
hosting end be involved, possibly a DTS package or similar.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uefMEilpFHA.3536@.TK2MSFTNGP15.phx.gbl...
> Ok, so maybe someone who has permissions at remote server can backup
> database and put in FTP directory for example where you can copy .BAK file
> Also , check out WEB Admin SQL tool provided by Microsoft.
>
> "ML" <schooner@.accesswave.ca> wrote in message
> news:%23UWcrYlpFHA.3516@.TK2MSFTNGP15.phx.gbl...
>|||You have just answered your own question. You need platform access to a
file share to retrieve a backup file. DTS will copy a file for you, but it
uses the same windows network file mechanism that copy and xcopy use. You
can use a SQL to SQL transfer to copy database elements, but you will need
direct outside access to the SQL Service. Somehow, I doubt the hosting
company will be any more likely to grant that than they will to give
platform access.
I would say your best bet is to havethem make a backup and place it where
you can retrieve it via FTP.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"ML" <schooner@.accesswave.ca> wrote in message
news:%23UWcrYlpFHA.3516@.TK2MSFTNGP15.phx.gbl...
> No, I do not have direct access to perform a backup or copy the bak files.
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%232N%23LUlpFHA.1464@.TK2MSFTNGP14.phx.gbl...
>|||I have full dbo access in terms of being able to run a DTS package, etc. I
just do not have rights to backup to a drive that is accessible from our
account.
That is why I ask if there is someway to handle it other than the normal
backup/restore.
Yes the host will do full backups and restores for us on request but would
like to have means where we can do a similar task as needed.
"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:%23fpzF1npFHA.3004@.TK2MSFTNGP15.phx.gbl...
> You have just answered your own question. You need platform access to a
> file share to retrieve a backup file. DTS will copy a file for you, but
> it uses the same windows network file mechanism that copy and xcopy use.
> You can use a SQL to SQL transfer to copy database elements, but you will
> need direct outside access to the SQL Service. Somehow, I doubt the
> hosting company will be any more likely to grant that than they will to
> give platform access.
> I would say your best bet is to havethem make a backup and place it where
> you can retrieve it via FTP.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "ML" <schooner@.accesswave.ca> wrote in message
> news:%23UWcrYlpFHA.3516@.TK2MSFTNGP15.phx.gbl...
>|||ML (schooner@.accesswave.ca) writes:
> I have full dbo access in terms of being able to run a DTS package, etc.
> I just do not have rights to backup to a drive that is accessible from
> our account.
> That is why I ask if there is someway to handle it other than the normal
> backup/restore.
You can backup to a network drive, but I doubt that your local disks are
visible from the SQL Server machine. (And if they are, that would mean that
you need to open those drives for access, so that anyone customer of the
web host, can dump things on your disk space.)
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Remote server backups to local drive?

Is there any way to backup a remote SQL Server that is on a hosted account
to a local drive? We have a web hosted account that has a SQL Server that
we do not have full admin rights on. We would like to be able to do backups
and restores to our local development server if possible.
ML
Can you copy .BAK file to your local server by using XCOPY utility?
"ML" <schooner@.accesswave.ca> wrote in message
news:eVHVJOlpFHA.1416@.TK2MSFTNGP09.phx.gbl...
> Is there any way to backup a remote SQL Server that is on a hosted account
> to a local drive? We have a web hosted account that has a SQL Server that
> we do not have full admin rights on. We would like to be able to do
> backups and restores to our local development server if possible.
>
|||No, I do not have direct access to perform a backup or copy the bak files.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%232N%23LUlpFHA.1464@.TK2MSFTNGP14.phx.gbl...
> ML
> Can you copy .BAK file to your local server by using XCOPY utility?
>
>
> "ML" <schooner@.accesswave.ca> wrote in message
> news:eVHVJOlpFHA.1416@.TK2MSFTNGP09.phx.gbl...
>
|||Ok, so maybe someone who has permissions at remote server can backup
database and put in FTP directory for example where you can copy .BAK file
Also , check out WEB Admin SQL tool provided by Microsoft.
"ML" <schooner@.accesswave.ca> wrote in message
news:%23UWcrYlpFHA.3516@.TK2MSFTNGP15.phx.gbl...
> No, I do not have direct access to perform a backup or copy the bak files.
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%232N%23LUlpFHA.1464@.TK2MSFTNGP14.phx.gbl...
>
|||I am looking for a solution that avoids having to have someone on the
hosting end be involved, possibly a DTS package or similar.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uefMEilpFHA.3536@.TK2MSFTNGP15.phx.gbl...
> Ok, so maybe someone who has permissions at remote server can backup
> database and put in FTP directory for example where you can copy .BAK file
> Also , check out WEB Admin SQL tool provided by Microsoft.
>
> "ML" <schooner@.accesswave.ca> wrote in message
> news:%23UWcrYlpFHA.3516@.TK2MSFTNGP15.phx.gbl...
>
|||You have just answered your own question. You need platform access to a
file share to retrieve a backup file. DTS will copy a file for you, but it
uses the same windows network file mechanism that copy and xcopy use. You
can use a SQL to SQL transfer to copy database elements, but you will need
direct outside access to the SQL Service. Somehow, I doubt the hosting
company will be any more likely to grant that than they will to give
platform access.
I would say your best bet is to havethem make a backup and place it where
you can retrieve it via FTP.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"ML" <schooner@.accesswave.ca> wrote in message
news:%23UWcrYlpFHA.3516@.TK2MSFTNGP15.phx.gbl...
> No, I do not have direct access to perform a backup or copy the bak files.
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%232N%23LUlpFHA.1464@.TK2MSFTNGP14.phx.gbl...
>
|||I have full dbo access in terms of being able to run a DTS package, etc. I
just do not have rights to backup to a drive that is accessible from our
account.
That is why I ask if there is someway to handle it other than the normal
backup/restore.
Yes the host will do full backups and restores for us on request but would
like to have means where we can do a similar task as needed.
"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:%23fpzF1npFHA.3004@.TK2MSFTNGP15.phx.gbl...
> You have just answered your own question. You need platform access to a
> file share to retrieve a backup file. DTS will copy a file for you, but
> it uses the same windows network file mechanism that copy and xcopy use.
> You can use a SQL to SQL transfer to copy database elements, but you will
> need direct outside access to the SQL Service. Somehow, I doubt the
> hosting company will be any more likely to grant that than they will to
> give platform access.
> I would say your best bet is to havethem make a backup and place it where
> you can retrieve it via FTP.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "ML" <schooner@.accesswave.ca> wrote in message
> news:%23UWcrYlpFHA.3516@.TK2MSFTNGP15.phx.gbl...
>
|||ML (schooner@.accesswave.ca) writes:
> I have full dbo access in terms of being able to run a DTS package, etc.
> I just do not have rights to backup to a drive that is accessible from
> our account.
> That is why I ask if there is someway to handle it other than the normal
> backup/restore.
You can backup to a network drive, but I doubt that your local disks are
visible from the SQL Server machine. (And if they are, that would mean that
you need to open those drives for access, so that anyone customer of the
web host, can dump things on your disk space.)
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

Remote Reporting Server

Can you have SQL 2005 reporting services installed on a front end web server
without a local SQL engine (i.e. the reports DB is on a remote engine).
Reporting is running and working on the remote back end server which has the
engine as well.
If this is so, can the back end server be SQL 2005 Enterprise SQL 64 bit,
and the front end web server be SQL 2005 Enterprise SQL 32 bitOn Feb 11, 2:06 pm, "John Hiebert" <johndhieb...@.hotmail.com> wrote:
> Can you have SQL 2005 reporting services installed on a front end web server
> without a local SQL engine (i.e. the reports DB is on a remote engine).
> Reporting is running and working on the remote back end server which has the
> engine as well.
> If this is so, can the back end server be SQL 2005 Enterprise SQL 64 bit,
> and the front end web server be SQL 2005 Enterprise SQL 32 bit
As long as your Report Manager and virtual directories for SSRS are on
the front-end server and the back-end server includes the ReportServer
and ReportServerTempDB databases, you should be fine with varying
editions of SQL Server. Of course, your SQL Server license for SSRS is
required in the location of your ReportServer and ReportServerTempDB
databases. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||We have a similar situation but we want SSRS to run on an internal web
server. So teh user has access only to the fron-end web server, and upon a
report request, he'll be forwarded to the internal server for report
processing. The question is how to configure the front-end IIS to run the
reports on the back end IIS.
Thanks,
Gilgamesh
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:0946c772-2790-4993-ba61-b6cad04b4a79@.y5g2000hsf.googlegroups.com...
> On Feb 11, 2:06 pm, "John Hiebert" <johndhieb...@.hotmail.com> wrote:
>> Can you have SQL 2005 reporting services installed on a front end web
>> server
>> without a local SQL engine (i.e. the reports DB is on a remote engine).
>> Reporting is running and working on the remote back end server which has
>> the
>> engine as well.
>> If this is so, can the back end server be SQL 2005 Enterprise SQL 64 bit,
>> and the front end web server be SQL 2005 Enterprise SQL 32 bit
>
> As long as your Report Manager and virtual directories for SSRS are on
> the front-end server and the back-end server includes the ReportServer
> and ReportServerTempDB databases, you should be fine with varying
> editions of SQL Server. Of course, your SQL Server license for SSRS is
> required in the location of your ReportServer and ReportServerTempDB
> databases. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant|||On Feb 13, 6:56 pm, "Gilgamesh" <Gilgamesh4E...@.aol.com> wrote:
> We have a similar situation but we want SSRS to run on an internal web
> server. So teh user has access only to the fron-end web server, and upon a
> report request, he'll be forwarded to the internal server for report
> processing. The question is how to configure the front-end IIS to run the
> reports on the back end IIS.
> Thanks,
> Gilgamesh
> "EMartinez" <emartinez...@.gmail.com> wrote in message
> news:0946c772-2790-4993-ba61-b6cad04b4a79@.y5g2000hsf.googlegroups.com...
> > On Feb 11, 2:06 pm, "John Hiebert" <johndhieb...@.hotmail.com> wrote:
> >> Can you have SQL 2005 reporting services installed on a front end web
> >> server
> >> without a local SQL engine (i.e. the reports DB is on a remote engine).
> >> Reporting is running and working on the remote back end server which has
> >> the
> >> engine as well.
> >> If this is so, can the back end server be SQL 2005 Enterprise SQL 64 bit,
> >> and the front end web server be SQL 2005 Enterprise SQL 32 bit
> > As long as your Report Manager and virtual directories for SSRS are on
> > the front-end server and the back-end server includes the ReportServer
> > and ReportServerTempDB databases, you should be fine with varying
> > editions of SQL Server. Of course, your SQL Server license for SSRS is
> > required in the location of your ReportServer and ReportServerTempDB
> > databases. Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
The best way to accomplish this architecture is to utilize Render() as
part of the SSRS Web Service. So, have the front-end application be an
ASP.NET application that references the SSRS web service and the
reports from the back-end SSRS installation.
http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsexecutionservice2005.reportexecutionservice.render.aspx
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Remote Report Server 2005 using the reportviewer control - parameter problem

I am using an asp.net web page (C#) to access a remote Report Server via the reportviewer contol. After solving the credentials issues, all of my test reports seem to run very nicely if there is no parameter input. When a parameter report is executed, the text box for parameter input is displayed. When the parameter is entered and the View Report button is pressed, the report is NOT Returned. If I go directly to the remote Report Manager and run the report (IE no code behind), it runs as it is supposed to. I've also run the report (web page) on my local report server and it displays the report after the parameter has been input. Why is the remote report server not returning the report after the parameter is input?

Thanks,

John

This problem has been resolved. The page will not work if the "ReportViewer1.ServerReport.ReportServerCredentials = new MyReportServerCredentials();" statement is placed in the Page_Load event.

Here are the steps taken to eliminate the problem:

1. Remove the credentials statement from the Page_Load event.

2. Place this code in the Page_Load event

if (!Page.IsPostBack)
{
ReportViewer1.Visible = false;
}

3. Place a button on the page to display the report.

4. Move all report statements to the push button event. Make sure to include "ReportViewer1.Visible = true"

It now works like a champ and I am happy!

Thanks,

John

Remote Process of Report

Hi,

We have a reports running in a system in our internal network. Now our requirement is we have to publish the same report into web for the public. How can I do that..?

Note :

I can not install reporting service in my Web server system.

There should be a way to put the report from the reporting server to the web server and display in the webpage to the public.

This is really an urgent requirement.

Are you using RS2005? If so, you can embed the report viewer control into your ASP.Net application.|||

I'm using 2003, Is there any way to do this. My problem is I have to show a report to a website which is running in diffrent system in the same network.

the user will be provided by a hyperlink in the asp.net webpage by clicking the link the user should see the report.

Thanks

Mohan

|||

It is tricky in 2003 without the viewer control.

Your user's won't be authenticated against your RS backend, so you will have to get the contents of the report from within your ASP.Net application. You will want to use the HTMLFragment deviceinfo setting. The trickier part is resolving the secondary streams (like images and charts). You will have to use the StreamRoot deviceinfo to redirect image requests back to your ASP.Net application, so you can make them on behalf of your users.

Remote Deployment

I have developed and tested few reports using SQL Server 2000 Reproting
Service.
Now I want to deploy it with my Web Application Setup. Please advice
how can I do
that. I don't have access to remote server as it is on their local
intranet. Client simply
don't want us to access their machines. Is there any solution?
Thank you,
Best Regards
Tanweer BadamiYou can use Reporting Services Scripter to generate deployment scripts. You
can then supply them as is, or modify the batch file so you can pass in the
Report Server name as part of your setup (or simply use them as a basis for
your own deployment scripts)
Download Reporting Services Scripter
http://www.sqldbatips.com/showarticle.asp?ID=62
--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"Robert" <trbadami@.gmail.com> wrote in message
news:1137481899.124207.258680@.g43g2000cwa.googlegroups.com...
>I have developed and tested few reports using SQL Server 2000 Reproting
> Service.
> Now I want to deploy it with my Web Application Setup. Please advice
> how can I do
> that. I don't have access to remote server as it is on their local
> intranet. Client simply
> don't want us to access their machines. Is there any solution?
> Thank you,
> Best Regards
> Tanweer Badami
>|||Thanks alot Smith, I will try that and get back to you asap.
Best Regards
Tanweer Badami|||wow, I deployed it successfully. Reporting Service Scripter is a great
utility.
Thank a lot Smith.
Best Regards
Tanweer Badami|||HI I find difficulty in deploying
I have to pass the password name after running scripts.
"Robert" wrote:
> wow, I deployed it successfully. Reporting Service Scripter is a great
> utility.
> Thank a lot Smith.
> Best Regards
> Tanweer Badami
>

Remote Database

Dear ALL,
I've a customer of mine asked me for a web hosting , and internet site
contains a SQL database.
It seems to be very simple but customer wants database at his office, so my
problem is what is the most suitable solution to make communicate web and
database remotely in order to accomplish security requirements ?
Is it enough SQL SP3 installed and tcp 1433 opened or I have to establish a
VPN for example ?
Regards
Alberto
Brivio
Alberto Brivio
(tel. 1 9 9 2 4 9 8 9 8)
Exposing SQL Server on the net is not a good idea at all, but your customer
has at least three options to secure it:
- Using IP filtering rules to prevent connects from addresses other than web
server's address. He also generally need to implement data encryption using
SSL to do not expose plain data (and espesially SQL passwords!) to public
network during transfer. The simplest method but doesn't implement caller
authentication
- Using IPSec to encrypt/filter and authenticate such connections
- Using VPN which also doing authentication and encryption
WBR, Evergray
Words mean nothing...
"Alberto Brivio" <a.brivio@.adb.it> wrote in message
news:uX5MAIMMGHA.2992@.tk2msftngp13.phx.gbl...
> Dear ALL,
> I've a customer of mine asked me for a web hosting , and internet site
> contains a SQL database.
> It seems to be very simple but customer wants database at his office, so
> my problem is what is the most suitable solution to make communicate web
> and database remotely in order to accomplish security requirements ?
> Is it enough SQL SP3 installed and tcp 1433 opened or I have to establish
> a VPN for example ?
>
> Regards
> Alberto
> Brivio
> --
>
> Alberto Brivio
> (tel. 1 9 9 2 4 9 8 9 8)
>

Remote Database

Dear ALL,
I've a customer of mine asked me for a web hosting , and internet site
contains a SQL database.
It seems to be very simple but customer wants database at his office, so my
problem is what is the most suitable solution to make communicate web and
database remotely in order to accomplish security requirements ?
Is it enough SQL SP3 installed and tcp 1433 opened or I have to establish a
VPN for example ?
Regards
Alberto
Brivio
Alberto Brivio
(tel. 1 9 9 2 4 9 8 9 8)Exposing SQL Server on the net is not a good idea at all, but your customer
has at least three options to secure it:
- Using IP filtering rules to prevent connects from addresses other than web
server's address. He also generally need to implement data encryption using
SSL to do not expose plain data (and espesially SQL passwords!) to public
network during transfer. The simplest method but doesn't implement caller
authentication
- Using IPSec to encrypt/filter and authenticate such connections
- Using VPN which also doing authentication and encryption
WBR, Evergray
--
Words mean nothing...
"Alberto Brivio" <a.brivio@.adb.it> wrote in message
news:uX5MAIMMGHA.2992@.tk2msftngp13.phx.gbl...
> Dear ALL,
> I've a customer of mine asked me for a web hosting , and internet site
> contains a SQL database.
> It seems to be very simple but customer wants database at his office, so
> my problem is what is the most suitable solution to make communicate web
> and database remotely in order to accomplish security requirements ?
> Is it enough SQL SP3 installed and tcp 1433 opened or I have to establish
> a VPN for example ?
>
> Regards
> Alberto
> Brivio
> --
>
> Alberto Brivio
> (tel. 1 9 9 2 4 9 8 9 8)
>

Remote Connections Refused when server under load

Hi All,
We have a .NET 2.0 web application. Occasionally, we get the following
error below when we are doing performance testing. It is not consistent and
only happens every once in awhile. We are using TCP/IP and only have one
instance of SQL running. We do specify connection pooling in the connection
string. There is virtually nothing happening on the database server - it
only contains a few rows of data to control navigation for the site.
System.Data.SqlClient.SqlException: An error has occurred while establishing
a connection to the server. When connecting to SQL Server 2005, this failure
may be caused by the fact that under the default settings SQL Server does not
allow remote connections. (provider: Named Pipes Provider, error: 40 - Could
not open a connection to SQL Server
This is a different error and not quite what you describe but it might be
involved in your problem. This is from the Books Online topic "Server
Network Configuration."
Connections May Be Forcibly Closed When Running on Windows Server 2003 SP1
When testing scalability with a large number of client connection attempts
to an instance of the SQL Server Database Engine running on Windows Server
2003 Service Pack 1, Windows may drop connections if the requests arrive
faster than SQL Server can service them. This is a security feature of
Windows Server 2003 Service Pack 1, which implements a finite queue for
incoming TCP connection requests. It results in the following error:
ProviderNum: 7, Error: 10054, ErrorMessage: "TCP Provider: An existing
connection was forcibly closed by the remote host ...
To resolve this issue, use the regedit.exe utility to add the following
registry key:
Key Type Name Value
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\Tcpip\Parameters\
DWORD
SynAttackProtect
00000000
Security Note:
Setting this registry key may expose the server to a SYN flood,
denial-of-service attack. Add this registry value only if necessary and with
an understanding of the security risks. Remove this registry value when
testing is complete.
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bill P" <Bill P@.discussions.microsoft.com> wrote in message
news:2D3D349D-EE1C-4945-82FE-D3717AD02E2F@.microsoft.com...
> Hi All,
> We have a .NET 2.0 web application. Occasionally, we get the following
> error below when we are doing performance testing. It is not consistent
> and
> only happens every once in awhile. We are using TCP/IP and only have one
> instance of SQL running. We do specify connection pooling in the
> connection
> string. There is virtually nothing happening on the database server - it
> only contains a few rows of data to control navigation for the site.
> System.Data.SqlClient.SqlException: An error has occurred while
> establishing
> a connection to the server. When connecting to SQL Server 2005, this
> failure
> may be caused by the fact that under the default settings SQL Server does
> not
> allow remote connections. (provider: Named Pipes Provider, error: 40 -
> Could
> not open a connection to SQL Server
|||Rick,
Thank you for the reply. It very well could have something to do with this.
I am going to give it a try. It may be a few days before I find anything
out since this happens only once in a while.
Bill Portman
"Rick Byham, (MSFT)" wrote:

> This is a different error and not quite what you describe but it might be
> involved in your problem. This is from the Books Online topic "Server
> Network Configuration."
> Connections May Be Forcibly Closed When Running on Windows Server 2003 SP1
> When testing scalability with a large number of client connection attempts
> to an instance of the SQL Server Database Engine running on Windows Server
> 2003 Service Pack 1, Windows may drop connections if the requests arrive
> faster than SQL Server can service them. This is a security feature of
> Windows Server 2003 Service Pack 1, which implements a finite queue for
> incoming TCP connection requests. It results in the following error:
> ProviderNum: 7, Error: 10054, ErrorMessage: "TCP Provider: An existing
> connection was forcibly closed by the remote host ...
> To resolve this issue, use the regedit.exe utility to add the following
> registry key:
> Key Type Name Value
> HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\Tcpip\Parameters\
> DWORD
> SynAttackProtect
> 00000000
> Security Note:
> Setting this registry key may expose the server to a SYN flood,
> denial-of-service attack. Add this registry value only if necessary and with
> an understanding of the security risks. Remove this registry value when
> testing is complete.
> --
> Rick Byham (MSFT)
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Bill P" <Bill P@.discussions.microsoft.com> wrote in message
> news:2D3D349D-EE1C-4945-82FE-D3717AD02E2F@.microsoft.com...
>

Remote Connections Refused when server under load

Hi All,
We have a .NET 2.0 web application. Occasionally, we get the following
error below when we are doing performance testing. It is not consistent and
only happens every once in awhile. We are using TCP/IP and only have one
instance of SQL running. We do specify connection pooling in the connection
string. There is virtually nothing happening on the database server - it
only contains a few rows of data to control navigation for the site.
System.Data.SqlClient.SqlException: An error has occurred while establishing
a connection to the server. When connecting to SQL Server 2005, this failur
e
may be caused by the fact that under the default settings SQL Server does no
t
allow remote connections. (provider: Named Pipes Provider, error: 40 - Could
not open a connection to SQL ServerThis is a different error and not quite what you describe but it might be
involved in your problem. This is from the Books Online topic "Server
Network Configuration."
Connections May Be Forcibly Closed When Running on Windows Server 2003 SP1
When testing scalability with a large number of client connection attempts
to an instance of the SQL Server Database Engine running on Windows Server
2003 Service Pack 1, Windows may drop connections if the requests arrive
faster than SQL Server can service them. This is a security feature of
Windows Server 2003 Service Pack 1, which implements a finite queue for
incoming TCP connection requests. It results in the following error:
ProviderNum: 7, Error: 10054, ErrorMessage: "TCP Provider: An existing
connection was forcibly closed by the remote host ...
To resolve this issue, use the regedit.exe utility to add the following
registry key:
Key Type Name Value
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControl
Set\Services\Tcpip\Parameters\
DWORD
SynAttackProtect
00000000
Security Note:
Setting this registry key may expose the server to a SYN flood,
denial-of-service attack. Add this registry value only if necessary and with
an understanding of the security risks. Remove this registry value when
testing is complete.
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bill P" <Bill P@.discussions.microsoft.com> wrote in message
news:2D3D349D-EE1C-4945-82FE-D3717AD02E2F@.microsoft.com...
> Hi All,
> We have a .NET 2.0 web application. Occasionally, we get the following
> error below when we are doing performance testing. It is not consistent
> and
> only happens every once in awhile. We are using TCP/IP and only have one
> instance of SQL running. We do specify connection pooling in the
> connection
> string. There is virtually nothing happening on the database server - it
> only contains a few rows of data to control navigation for the site.
> System.Data.SqlClient.SqlException: An error has occurred while
> establishing
> a connection to the server. When connecting to SQL Server 2005, this
> failure
> may be caused by the fact that under the default settings SQL Server does
> not
> allow remote connections. (provider: Named Pipes Provider, error: 40 -
> Could
> not open a connection to SQL Server|||Rick,
Thank you for the reply. It very well could have something to do with this.
I am going to give it a try. It may be a few days before I find anything
out since this happens only once in a while.
Bill Portman
"Rick Byham, (MSFT)" wrote:

> This is a different error and not quite what you describe but it might be
> involved in your problem. This is from the Books Online topic "Server
> Network Configuration."
> Connections May Be Forcibly Closed When Running on Windows Server 2003 SP1
> When testing scalability with a large number of client connection attempts
> to an instance of the SQL Server Database Engine running on Windows Server
> 2003 Service Pack 1, Windows may drop connections if the requests arrive
> faster than SQL Server can service them. This is a security feature of
> Windows Server 2003 Service Pack 1, which implements a finite queue for
> incoming TCP connection requests. It results in the following error:
> ProviderNum: 7, Error: 10054, ErrorMessage: "TCP Provider: An existing
> connection was forcibly closed by the remote host ...
> To resolve this issue, use the regedit.exe utility to add the following
> registry key:
> Key Type Name Value
> HKEY_LOCAL_MACHINE\SYSTEM\CurrentControl
Set\Services\Tcpip\Parameters\
> DWORD
> SynAttackProtect
> 00000000
> Security Note:
> Setting this registry key may expose the server to a SYN flood,
> denial-of-service attack. Add this registry value only if necessary and wi
th
> an understanding of the security risks. Remove this registry value when
> testing is complete.
> --
> Rick Byham (MSFT)
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> "Bill P" <Bill P@.discussions.microsoft.com> wrote in message
> news:2D3D349D-EE1C-4945-82FE-D3717AD02E2F@.microsoft.com...
>

Remote connection to Analysis Service giving problem.

Hi,

I am stuck up with one of the deployment scenario. I have web application through which we can invoke reports. Reports are developed in SQL Server 2005 Reporting Service.

The reporting service project sets data source connection with Analysis Services database.

If we have all this on the same machine, we are able to integrate and see the results end to end.

However we are stuck up with the following deployment scenario.

Say our web application is on A machine
SQL Server 2005 database on B machine
SQL Server 2005 Analysis Services on C machine
SQL Server 2005 Reporting Services on D machine.

so analysis services C machine pointing to database on B machine. and reporting services D machine pointing to analysis services C machine.

So in Reporting Service project when we set the data source connection to a remote Analysis services machine (C)
it gives us the following error that "A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running."

Is this a known issue? I searched on google and this forum but dint get much help. I did check that for analysis service remote connection is enabled.

What exact steps do I have to follow?

First of all is this scenario ok that analysis services and reporting services on different machine?

This is very urgent for our project. Please help me find the solution.

Thanks in advance!

Note: I have posted a similar post in Reporting Services forum.

Ann.

This problem relates to the fact that two separate servers cannot identity a user without that you use Kerberos for authentication. If you have a network with Active Directory it is configuration issue. This feature is already in place.

Search on Windows 2003, Active Directory and Kerberos.

Mosha have a post on this regarding SSAS2005 here:

http://www.mosha.com/msolap/articles/kerberos_delegation.htm

HTH

Thomas Ivarsson

remote connection of the sql reports in express edition

Hello Dear Friends

I work for a small organization and on my reference my team downloaded the Sql express edition of web developer and Sql server

WE have worked on two products

And now i understand that "Report data sources must be SQL Server relational databases that run locally in SQL Server Express" !!!!!!!!

We are able to connect sqlserver database

The work on products is almost complete and at this point cannot revert back to any other reporting services.

DO I HAVE HOPE...is there any way to connect to ssrs remotely ? Please help

Our Client has branches at two locations so the database will be on the server and he would want to acess reports at both places

Please somebody help me as to what should i do?

Sara

Can somebody help me please

Sara

|||

Hello friends

Does anybody have an answer?

Sara

Remote Connection Fails with Web Service

Hello-
I am having a problem with a Web Service written in Visual Studio 2005.
I have a typed dataset that I created using the Visual Studio 2005
Data Source tool. This retrieves its data from a SQL Server 2000
database. My client calls a web service which calls a business
component to retrieve the typed dataset (i.e. Client --> Web Service
--> Business Component).
Whenever I put the web service between my client and my business
component I get the following error:
Server was unable to process request. --> An error has occurred while
establishing a connection to the server. When connecting to SQL Server
2005, this failure may be caused by the fact that under the default
settings SQL Server does not allow remote connections. (provider: Named
Pipes Provider, error: 40 - Could not open a connection to SQL Server)
If I do not put my web service in between my client and business
component, I do not get this error (i.e. Client --> Business
Component).
I have made sure that my SQL 2005 has Remote Connections enabled with
both Named Pipes and TCP/IP.
I don't understand why putting a web service between my client and
business component is making this error appear or how to remedy the
issue. Any help would be much appreciated!
-DrewI found the problem. In my web.config I had to add the following
configuration: <identity impersonate="true" />.
-Drew