Changing SSRS reports datasource.

I have a web site that has reports stored in two places.The local site, and in SSRS.The local reports get there data from a class that has a dataset method on it.I would like to store all my reports in SSRS.Is this possible?Can I get just the RDL of a report from the SSRS web service, or change the dataset to what my class generates?

You can adopt one to two approaches:

1) store the RDLC you'll use in a report viewer control on the report server as a resouce.

2) store actual RDL in the report server and use the GetReportDefinition method to obtain the RDL.

What is interesting here is that the data source definitions between the RDLC the control expect and the RDL that the server expects is a little different.

Here's the reference for GetReportDefinition:

http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.reportingservice2005.getreportdefinition.aspx

-Lukasz

Changing SQL authentication method

Have a central SQL box (SQL server 2000 SP3a) which serves
requests from web servers. It is configured to use Windows
authentication. However I have a requirement for another
web server to use SQL authentication. Would I be able to
change the SQl Server's configuration to SQL and Windows
without breaking anything?
Many thanksOn Wed, 11 Aug 2004 01:45:08 -0700, Gary wrote:

>Have a central SQL box (SQL server 2000 SP3a) which serves
>requests from web servers. It is configured to use Windows
>authentication. However I have a requirement for another
>web server to use SQL authentication. Would I be able to
>change the SQl Server's configuration to SQL and Windows
>without breaking anything?
>Many thanks
Hi Gary,
Yes, this is possible. You can make this change through Enterprise
Manager: right-click the server, select Properties and on the Security
tab, set the required authentication mode.
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)|||Hi,
There will not be any impact in changing the authentication. Only thing is,
you need to stop and start the MSSQL server service
to make the changes (Mixed authentication) active.
Thanks
Hari
MCDBA
"Gary" <anonymous@.discussions.microsoft.com> wrote in message
news:3be701c47f7f$817996e0$a301280a@.phx.gbl...
> Have a central SQL box (SQL server 2000 SP3a) which serves
> requests from web servers. It is configured to use Windows
> authentication. However I have a requirement for another
> web server to use SQL authentication. Would I be able to
> change the SQl Server's configuration to SQL and Windows
> without breaking anything?
> Many thanks|||Gary,
Make sure the sa password is strong before doing this, as people will be
able to attempt to login with it now, and possibly even attempt a brute
force crack. Apart from that, should be OK.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Gary wrote:
> Have a central SQL box (SQL server 2000 SP3a) which serves
> requests from web servers. It is configured to use Windows
> authentication. However I have a requirement for another
> web server to use SQL authentication. Would I be able to
> change the SQl Server's configuration to SQL and Windows
> without breaking anything?
> Many thanks|||Hi Mark
Again thanks for the advice. The sa password has already
been set during service pack 3a installation and is strong.
Gary

Changing SQL authentication method

Have a central SQL box (SQL server 2000 SP3a) which serves
requests from web servers. It is configured to use Windows
authentication. However I have a requirement for another
web server to use SQL authentication. Would I be able to
change the SQl Server's configuration to SQL and Windows
without breaking anything?
Many thanksOn Wed, 11 Aug 2004 01:45:08 -0700, Gary wrote:
>Have a central SQL box (SQL server 2000 SP3a) which serves
>requests from web servers. It is configured to use Windows
>authentication. However I have a requirement for another
>web server to use SQL authentication. Would I be able to
>change the SQl Server's configuration to SQL and Windows
>without breaking anything?
>Many thanks
Hi Gary,
Yes, this is possible. You can make this change through Enterprise
Manager: right-click the server, select Properties and on the Security
tab, set the required authentication mode.
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)|||Hi,
There will not be any impact in changing the authentication. Only thing is,
you need to stop and start the MSSQL server service
to make the changes (Mixed authentication) active.
Thanks
Hari
MCDBA
"Gary" <anonymous@.discussions.microsoft.com> wrote in message
news:3be701c47f7f$817996e0$a301280a@.phx.gbl...
> Have a central SQL box (SQL server 2000 SP3a) which serves
> requests from web servers. It is configured to use Windows
> authentication. However I have a requirement for another
> web server to use SQL authentication. Would I be able to
> change the SQl Server's configuration to SQL and Windows
> without breaking anything?
> Many thanks|||Hi chaps
Thanks for the advice - thought as much, I'll give it a
whirl.
Gary|||Gary,
Make sure the sa password is strong before doing this, as people will be
able to attempt to login with it now, and possibly even attempt a brute
force crack. Apart from that, should be OK.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Gary wrote:
> Have a central SQL box (SQL server 2000 SP3a) which serves
> requests from web servers. It is configured to use Windows
> authentication. However I have a requirement for another
> web server to use SQL authentication. Would I be able to
> change the SQl Server's configuration to SQL and Windows
> without breaking anything?
> Many thanks|||Hi Mark
Again thanks for the advice. The sa password has already
been set during service pack 3a installation and is strong.
Gary

Changing SQL authentication method

Have a central SQL box (SQL server 2000 SP3a) which serves
requests from web servers. It is configured to use Windows
authentication. However I have a requirement for another
web server to use SQL authentication. Would I be able to
change the SQl Server's configuration to SQL and Windows
without breaking anything?
Many thanks
On Wed, 11 Aug 2004 01:45:08 -0700, Gary wrote:

>Have a central SQL box (SQL server 2000 SP3a) which serves
>requests from web servers. It is configured to use Windows
>authentication. However I have a requirement for another
>web server to use SQL authentication. Would I be able to
>change the SQl Server's configuration to SQL and Windows
>without breaking anything?
>Many thanks
Hi Gary,
Yes, this is possible. You can make this change through Enterprise
Manager: right-click the server, select Properties and on the Security
tab, set the required authentication mode.
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)
|||Hi,
There will not be any impact in changing the authentication. Only thing is,
you need to stop and start the MSSQL server service
to make the changes (Mixed authentication) active.
Thanks
Hari
MCDBA
"Gary" <anonymous@.discussions.microsoft.com> wrote in message
news:3be701c47f7f$817996e0$a301280a@.phx.gbl...
> Have a central SQL box (SQL server 2000 SP3a) which serves
> requests from web servers. It is configured to use Windows
> authentication. However I have a requirement for another
> web server to use SQL authentication. Would I be able to
> change the SQl Server's configuration to SQL and Windows
> without breaking anything?
> Many thanks
|||Gary,
Make sure the sa password is strong before doing this, as people will be
able to attempt to login with it now, and possibly even attempt a brute
force crack. Apart from that, should be OK.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Gary wrote:
> Have a central SQL box (SQL server 2000 SP3a) which serves
> requests from web servers. It is configured to use Windows
> authentication. However I have a requirement for another
> web server to use SQL authentication. Would I be able to
> change the SQl Server's configuration to SQL and Windows
> without breaking anything?
> Many thanks
|||Hi Mark
Again thanks for the advice. The sa password has already
been set during service pack 3a installation and is strong.
Gary

Changing path of web service?

I have 2 report services servers one for development and one for live, I
need to add a reference to the web service in my app, but during development
it has to refernce development server, during deployment it has to reference
what ever the end user calls their server, can you change the reference url
of a web service at run time? if so how? thanks! the web services will all
have the same definition at all times. I'm also doing this in VB.NETSmokey Grindle wrote:
> I have 2 report services servers one for development and one for live, I
> need to add a reference to the web service in my app, but during development
> it has to refernce development server, during deployment it has to reference
> what ever the end user calls their server, can you change the reference url
> of a web service at run time? if so how? thanks! the web services will all
> have the same definition at all times. I'm also doing this in VB.NET
IIRC, when you declare an instance of the web service, you can set it's
URL property to the correct one.

changing passwords

I'm new on a project and need to change all web users passwords. Were would you start from Enterprise Manager?Are you talking about logging in to sql server?

I wouldn't think so...if it's a web app you're probably pooling...

Do they applcaition level security?

Do you use NT security (not for web users )

What's you're security model?|||Thanks for reply. It appears the last person in my spot did'nt follow any name convention that I see. Someone returned today from Thanksgiving vacation who show a strange table named then it made since. I was able to make the changes and get up & Runing.

Thanks
Originally posted by Brett Kaiser
Are you talking about logging in to sql server?

I wouldn't think so...if it's a web app you're probably pooling...

Do they applcaition level security?

Do you use NT security (not for web users )

What's you're security model?

changing Field Lenght via query analyzer

Hi
My DB is on the web so but I want change Field Lenght of one of my Fileds on my DB
its 70 rights now I want change it to 120 its a nvarchar
how can I do it , I am using a ASP page
ThanksALTER TABLE tablename ALTER COLUMN columnname NVARCHAR(120)

You can just pass this statement to the database.

You should check out Books Online. it's free documentation that comes with SQL server.

Changing DSN to DSN-Less

hi

I bought a web site of ebay for about 4500 (www.uktattoostudios.co.uk). I decided to get the web site hosted on a new hosting company called namesco.co.uk. the only problem is they dont support DSN and have DSN-Less

How would I change the site to work with DSN-Less?

the site is a tattoo studio directory.It uses MS SQL database with about 1000 studios listed. The studios can log in and change there details etc.

The only file I find on the site with dsn in is this code call tattoo.asp

<%
' FileName="Connection_odbc_conn_dsn.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_TATTOO_STRING
MM_TATTOO_STRING = "dsn=TATTOO;uid=dt-data;pwd=XXXXXXXX;"
%>

I can connect to the ms sql server , Would I need to change the MS SQL 2005 database codes? If yes how would I do this. and what do i change in the above code

Finally would changing it to dsn-less cause any problems?

thanks
dave
info@.uktattoostudios.co.ukUse this t replace what u av:
************************************************** **********************************
<%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="true"
' Catalog=""
' Schema=""
Dim MM_connme_STRING
MM_connme_STRING = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=dt-data;Initial Catalog=Databasename;Data Source=localhost;pwd=XXXXXXXX;"
%>
************************************************** ********************************
/*
Note:
Initial Catalog : - is/should be d name of ur database
datasource : - is d name of d computer on which d database(on MS-SQL 2000) resides(ds can be computer name or IP Address)
*/

Changing default listening port

Hi,
I need to change the default listening port on sql server from 1433 to
another port. The server is being connected to by multiple web sites some
using DSN connections and others not and also via a number of connections
using Enterprise Manager. I'm worried that if I change the port, the
websites will not be able to connect. Can anyone give me some advice on what
will need to be changed to make this update smooth.
Many thanks,
Luke.You can create an alias on the client using "Client Network Utility" and there specify the port
number. Or, you can specify the port number in the server name/connection string. From memory, you
do like SERVERNAME;portnumber, I.e.:
MYSERVER;1067
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Luke Fields" <lfields228@.hotmaik.com> wrote in message
news:egS7UeluDHA.2520@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I need to change the default listening port on sql server from 1433 to
> another port. The server is being connected to by multiple web sites some
> using DSN connections and others not and also via a number of connections
> using Enterprise Manager. I'm worried that if I change the port, the
> websites will not be able to connect. Can anyone give me some advice on what
> will need to be changed to make this update smooth.
> Many thanks,
> Luke.
>|||You can change the port SQL Server is listening on use the Server Network
Utility in the SQL Server program group. If there are firewalls between the
server and the clients you will need to open the new port on the firewall
so the traffic can get through.
Also if you are using dynamic discovery of the SQL Server on the network
UDP port 1434 will need to be opened as well.
Rand
This posting is provided "as is" with no warranties and confers no rights.

Changing default listening port

Hi,
I need to change the default listening port on sql server from 1433 to
another port. The server is being connected to by multiple web sites some
using DSN connections and others not and also via a number of connections
using Enterprise Manager. I'm worried that if I change the port, the
websites will not be able to connect. Can anyone give me some advice on what
will need to be changed to make this update smooth.
Many thanks,
Luke.You can create an alias on the client using "Client Network Utility" and the
re specify the port
number. Or, you can specify the port number in the server name/connection st
ring. From memory, you
do like SERVERNAME;portnumber, I.e.:
MYSERVER;1067
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ls
erver
"Luke Fields" <lfields228@.hotmaik.com> wrote in message
news:egS7UeluDHA.2520@.TK2MSFTNGP10.phx.gbl...

quote:

---

> Hi,
> I need to change the default listening port on sql server from 1433 to
> another port. The server is being connected to by multiple web sites some
> using DSN connections and others not and also via a number of connections
> using Enterprise Manager. I'm worried that if I change the port, the
> websites will not be able to connect. Can anyone give me some advice on wh
at
> will need to be changed to make this update smooth.
> Many thanks,
> Luke.
>

---

Changing database query (server, database, tables and query)

I'm working with ASP.NET web forms (using Visual Studio and C# code)
I've now introduced 'SQL Server 2000 Reporting Services' and am impressed
with what I've seen so far (albeit that I've only spent a few hours with it).
:)
1). I need the ability to point the report to a server / database rather
than always have it running against the same target. Similarly I may need to
change the SQL syntax of the query being run (rather than relying on
parameter passing).
It looks as if I need to do this via making use of the web service - but I
can't get my head around this.
Thanks in advance
SteveI've just posted a DPE to
http://workspaces.gotdotnet.com/appworld that may help you.
Regards
Toby
"Steve_S3T" <Steve_S3T@.discussions.microsoft.com> wrote in message
news:4AEF4962-798A-4C11-BFEF-B30E4800ADDA@.microsoft.com...
> I'm working with ASP.NET web forms (using Visual Studio and C# code)
> I've now introduced 'SQL Server 2000 Reporting Services' and am impressed
> with what I've seen so far (albeit that I've only spent a few hours with
it).
> :)
> 1). I need the ability to point the report to a server / database rather
> than always have it running against the same target. Similarly I may need
to
> change the SQL syntax of the query being run (rather than relying on
> parameter passing).
> It looks as if I need to do this via making use of the web service - but
I
> can't get my head around this.
> Thanks in advance
> Steve