Is it possible to get MSDE & SQL Server 2005 Express run on the same machine?

Hi guys,

I'm just wondering if the MSDE & SQL Server 2005 Express can run on the same machine(winxp) without conflicts. Because I need both the reporting services & the publication functionality of replication.

Thanks in advance.

Hi,

yes running both instances on the same system is possible.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Hi,

Yes as said you can run both on same machine without any problem, my machine have both installed on it.

Hemantgiri S. Goswami

|||Thanks guys. I appreciate ur time. :)

Is it possible to change the connection dynamically.

Hi guys,
We have 2 database one in US another in UK. I am developing 2 reports one
for US and another for UK..
Is there any way to pass/give the connection dynamically?
Regards,
SriOn Apr 26, 11:22 am, Sriman <Sri...@.discussions.microsoft.com> wrote:
> Hi guys,
> We have 2 database one in US another in UK. I am developing 2 reports one
> for US and another for UK..
> Is there any way to pass/give the connection dynamically?
> Regards,
> Sri
The only options I can think of are:
- Have a report parameter (possibly hidden) passed to the query/stored
procedure that is sourcing the report and based on that parameter,
select the correct database (via opendatasource, etc).
- If an ASP.NET application is an option, dynamically set the desired
datasource as part of a custom RDL building process (dynamically) as
part of the <Datasources><Datasource Name="SomeDatasource"></
Datasource></Datasources> tags.
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||So one report connects to US with US database and the other connects to UK
database is it right ? then while creating dont use shared data source
instead create a seperate data source from data tab for each server and each
report.
Sounds simple. Let me know if my understanding is right
Amarnath
"Sriman" wrote:
> Hi guys,
> We have 2 database one in US another in UK. I am developing 2 reports one
> for US and another for UK..
> Is there any way to pass/give the connection dynamically?
> Regards,
> Sri|||wow..both options sounds good to me.
Thanks alot ..
Regards,
Sri
"Amarnath" wrote:
> So one report connects to US with US database and the other connects to UK
> database is it right ? then while creating dont use shared data source
> instead create a seperate data source from data tab for each server and each
> report.
> Sounds simple. Let me know if my understanding is right
> Amarnath
> "Sriman" wrote:
> > Hi guys,
> >
> > We have 2 database one in US another in UK. I am developing 2 reports one
> > for US and another for UK..
> > Is there any way to pass/give the connection dynamically?
> >
> > Regards,
> > Sri|||On Apr 27, 8:06 am, Sriman <Sri...@.discussions.microsoft.com> wrote:
> wow..both options sounds good to me.
> Thanks alot ..
> Regards,
> Sri
> "Amarnath" wrote:
> > So one report connects to US with US database and the other connects to UK
> > database is it right ? then while creating dont use shared data source
> > instead create a seperate data source from data tab for each server and each
> > report.
> > Sounds simple. Let me know if my understanding is right
> > Amarnath
> > "Sriman" wrote:
> > > Hi guys,
> > > We have 2 database one in US another in UK. I am developing 2 reports one
> > > for US and another for UK..
> > > Is there any way to pass/give the connection dynamically?
> > > Regards,
> > > Sri
You're welcome. Let me know if I can be of further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant