I am very new to RS so please excuse my ignorance. Developers and business
are asking if they can have RS running on the same SQL Server instance I have
my transactional based database's on. I have always segregated my transaction
and DSS database from one another. Does anyone have any documentation
detailing the prerequisites for Reporting Services?Microsoft has a couple of great articles on their web site...
Maybe this one will help
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"FredG" <FredG@.discussions.microsoft.com> wrote in message
news:DDD8C9EE-C7F2-41FC-91BB-C3400E318785@.microsoft.com...
>I am very new to RS so please excuse my ignorance. Developers and business
> are asking if they can have RS running on the same SQL Server instance I
> have
> my transactional based database's on. I have always segregated my
> transaction
> and DSS database from one another. Does anyone have any documentation
> detailing the prerequisites for Reporting Services?|||Hello Mr. Snyder,
Thank you very much for the doucmentation. Do you know of any whitepapers or
discussions detailing performance of RS?
"Wayne Snyder" wrote:
> Microsoft has a couple of great articles on their web site...
> Maybe this one will help
> http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "FredG" <FredG@.discussions.microsoft.com> wrote in message
> news:DDD8C9EE-C7F2-41FC-91BB-C3400E318785@.microsoft.com...
> >I am very new to RS so please excuse my ignorance. Developers and business
> > are asking if they can have RS running on the same SQL Server instance I
> > have
> > my transactional based database's on. I have always segregated my
> > transaction
> > and DSS database from one another. Does anyone have any documentation
> > detailing the prerequisites for Reporting Services?
>
>
Showing posts with label asking. Show all posts
Showing posts with label asking. Show all posts
Thursday, March 22, 2012
Monday, February 13, 2012
Apologies for half a post below ... as I was asking
How can I find out what appications ( if any ) are connecting to the database
using the sa password. Keeping in mind these are old applications that may
have the uid and pwd hardcoded in them. They are old apps with no
documentation and we, the DBA's are seperate from developers.
Any ideas would be welcome.exec sp_who2
Shows a wealth of good information.
Rick Sawtell
MCT, MCSD, MCDBA
Shou
"MANCPOLYMAN" <MANCPOLYMAN@.discussions.microsoft.com> wrote in message
news:8074B1F2-C889-4A83-852B-F4BAC5C5CD85@.microsoft.com...
> How can I find out what appications ( if any ) are connecting to the
database
> using the sa password. Keeping in mind these are old applications that
may
> have the uid and pwd hardcoded in them. They are old apps with no
> documentation and we, the DBA's are seperate from developers.
> Any ideas would be welcome.|||This is a multi-part message in MIME format.
--=_NextPart_000_008B_01C4ABE7.E14691B0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable
You can also use profiler to filter this.
Tunji O
"MANCPOLYMAN" <MANCPOLYMAN@.discussions.microsoft.com> wrote in message =news:8074B1F2-C889-4A83-852B-F4BAC5C5CD85@.microsoft.com...
How can I find out what appications ( if any ) are connecting to the =database using the sa password. Keeping in mind these are old applications =that may have the uid and pwd hardcoded in them. They are old apps with no documentation and we, the DBA's are seperate from developers.
Any ideas would be welcome.
--=_NextPart_000_008B_01C4ABE7.E14691B0
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">
&
You can also use profiler to filter this.
Tunji O
"MANCPOLYMAN" wrote in message news:807=4B1F2-C889-4A83-852B-F4BAC5C5CD85@.microsoft.com...How can I find out what appications ( if any ) are connecting to the =database using the sa password. Keeping in mind these are old =applications that may have the uid and pwd hardcoded in them. They are =old apps with no documentation and we, the DBA's are seperate from developers.Any ideas would be =welcome.
--=_NextPart_000_008B_01C4ABE7.E14691B0--
using the sa password. Keeping in mind these are old applications that may
have the uid and pwd hardcoded in them. They are old apps with no
documentation and we, the DBA's are seperate from developers.
Any ideas would be welcome.exec sp_who2
Shows a wealth of good information.
Rick Sawtell
MCT, MCSD, MCDBA
Shou
"MANCPOLYMAN" <MANCPOLYMAN@.discussions.microsoft.com> wrote in message
news:8074B1F2-C889-4A83-852B-F4BAC5C5CD85@.microsoft.com...
> How can I find out what appications ( if any ) are connecting to the
database
> using the sa password. Keeping in mind these are old applications that
may
> have the uid and pwd hardcoded in them. They are old apps with no
> documentation and we, the DBA's are seperate from developers.
> Any ideas would be welcome.|||This is a multi-part message in MIME format.
--=_NextPart_000_008B_01C4ABE7.E14691B0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable
You can also use profiler to filter this.
Tunji O
"MANCPOLYMAN" <MANCPOLYMAN@.discussions.microsoft.com> wrote in message =news:8074B1F2-C889-4A83-852B-F4BAC5C5CD85@.microsoft.com...
How can I find out what appications ( if any ) are connecting to the =database using the sa password. Keeping in mind these are old applications =that may have the uid and pwd hardcoded in them. They are old apps with no documentation and we, the DBA's are seperate from developers.
Any ideas would be welcome.
--=_NextPart_000_008B_01C4ABE7.E14691B0
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">
&
You can also use profiler to filter this.
Tunji O
"MANCPOLYMAN"
--=_NextPart_000_008B_01C4ABE7.E14691B0--
Apologies for half a post below ... as I was asking
How can I find out what appications ( if any ) are connecting to the database
using the sa password. Keeping in mind these are old applications that may
have the uid and pwd hardcoded in them. They are old apps with no
documentation and we, the DBA's are seperate from developers.
Any ideas would be welcome.
exec sp_who2
Shows a wealth of good information.
Rick Sawtell
MCT, MCSD, MCDBA
Shou
"MANCPOLYMAN" <MANCPOLYMAN@.discussions.microsoft.com> wrote in message
news:8074B1F2-C889-4A83-852B-F4BAC5C5CD85@.microsoft.com...
> How can I find out what appications ( if any ) are connecting to the
database
> using the sa password. Keeping in mind these are old applications that
may
> have the uid and pwd hardcoded in them. They are old apps with no
> documentation and we, the DBA's are seperate from developers.
> Any ideas would be welcome.
|||You can also use profiler to filter this.
Tunji O
"MANCPOLYMAN" <MANCPOLYMAN@.discussions.microsoft.com> wrote in message news:8074B1F2-C889-4A83-852B-F4BAC5C5CD85@.microsoft.com...
How can I find out what appications ( if any ) are connecting to the database
using the sa password. Keeping in mind these are old applications that may
have the uid and pwd hardcoded in them. They are old apps with no
documentation and we, the DBA's are seperate from developers.
Any ideas would be welcome.
using the sa password. Keeping in mind these are old applications that may
have the uid and pwd hardcoded in them. They are old apps with no
documentation and we, the DBA's are seperate from developers.
Any ideas would be welcome.
exec sp_who2
Shows a wealth of good information.
Rick Sawtell
MCT, MCSD, MCDBA
Shou
"MANCPOLYMAN" <MANCPOLYMAN@.discussions.microsoft.com> wrote in message
news:8074B1F2-C889-4A83-852B-F4BAC5C5CD85@.microsoft.com...
> How can I find out what appications ( if any ) are connecting to the
database
> using the sa password. Keeping in mind these are old applications that
may
> have the uid and pwd hardcoded in them. They are old apps with no
> documentation and we, the DBA's are seperate from developers.
> Any ideas would be welcome.
|||You can also use profiler to filter this.
Tunji O
"MANCPOLYMAN" <MANCPOLYMAN@.discussions.microsoft.com> wrote in message news:8074B1F2-C889-4A83-852B-F4BAC5C5CD85@.microsoft.com...
How can I find out what appications ( if any ) are connecting to the database
using the sa password. Keeping in mind these are old applications that may
have the uid and pwd hardcoded in them. They are old apps with no
documentation and we, the DBA's are seperate from developers.
Any ideas would be welcome.
Subscribe to:
Posts (Atom)