Ad-hoc reporting

Is the ad-hoc reporting available for SQL Server 2005 reporting
services a web based environment or is it an application that has to be
installed?
Thanks
Robertits a clickonce application.
this required that the user have the .Net Framework 2.0 installed locally.
then the reportbuilder application is downloaded automatically without any
install process.
but its not a webbased application. its a client/server application which
use webservices calls to the server to execute andrender queries.
"rhoenig" <rhoenig@.charter.net> wrote in message
news:1158956048.392781.78140@.m7g2000cwm.googlegroups.com...
> Is the ad-hoc reporting available for SQL Server 2005 reporting
> services a web based environment or is it an application that has to be
> installed?
> Thanks
> Robert
>

Additional Components?

I have a clustered SQL installed but never added the
Replication feature along with the initial setup.
Now I ned to configure replication and thought I could
just go back to the origianl setup files, modify the
installation, add the componenets I need...and I'd be
done. No such luck!
When I go through the setup diologue the option to modify
an existing installation is -not- available and I can't
figure out why.
If someone can help me out I'd sure appreciate it....
TIA,
Jay
After you install a virtual instance of SQL Server on your computer, you cannot add the SQL Server components to your virtual instance of SQL Server by running the Setup
program. To work around this problem, you must remove the virtual instance of SQL Server from your computer and then reinstall the virtual instance of SQL Server by
using a custom installation.
This is documented in Microsoft Knowledge Base article
You cannot add SQL Server components to an existing virtual instance of SQL Server by running the Setup program
http://support.microsoft.com/?kbid=867650
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way
to do this is to visit the following websites: http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||Thanks Uttam!!
How is RRE life treating you...?

>--Original Message--
>After you install a virtual instance of SQL Server on
your computer, you cannot add the SQL Server components to
your virtual instance of SQL Server by running the Setup
>program. To work around this problem, you must remove
the virtual instance of SQL Server from your computer and
then reinstall the virtual instance of SQL Server by
>using a custom installation.
>This is documented in Microsoft Knowledge Base article
>You cannot add SQL Server components to an existing
virtual instance of SQL Server by running the Setup program
>http://support.microsoft.com/?kbid=867650
>Best Regards,
>Uttam Parui
>Microsoft Corporation
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>Are you secure? For information about the Strategic
Technology Protection Program and to order your FREE
Security Tool Kit, please visit
>http://www.microsoft.com/security.
>Microsoft highly recommends that users with Internet
access update their Microsoft software to better protect
against viruses and security vulnerabilities. The easiest
way
>to do this is to visit the following websites:
http://www.microsoft.com/protect
>http://www.microsoft.com/security/guidance/default.mspx
>
>.
>
|||You are most welcome.
Life is good -- learning something new everyday.
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way
to do this is to visit the following websites: http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx

adding the vc express bundled sql server to odbc

Hi, I have installed a trial version of VC++ Express 2005 with the
budled SQL Server. After creating a C++ Forms prototype, with some
tables into a database file named Test1.mdb, now I want to make ODBC
available this local database.

What are the steps required to add and ODBC entry so any ODBC-capable
program may access my prototype?

I know in advance the location of the database file and log file, know
it is local (so the server is localhost or just (local) ) and also the
driver name and the port number.

What is unknown to me is the user id and password as the installlation
was done to auth with OS credentials.
Could be "sa" without password?

Thanks in advance, CarlosChuck (carlos.crosetti@.gmail.com) writes:

Quote:

Originally Posted by

Hi, I have installed a trial version of VC++ Express 2005 with the
budled SQL Server. After creating a C++ Forms prototype, with some
tables into a database file named Test1.mdb, now I want to make ODBC
available this local database.
>
What are the steps required to add and ODBC entry so any ODBC-capable
program may access my prototype?
>
I know in advance the location of the database file and log file, know
it is local (so the server is localhost or just (local) ) and also the
driver name and the port number.
>
What is unknown to me is the user id and password as the installlation
was done to auth with OS credentials.
Could be "sa" without password?

Why can't use Windows authentication? Why would the ODBC application
log in as sa?

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspxsql

adding sql licenses

As I recall, I set the licensing format and number of licenses when I
installed SQL Server.
a) How can I tell how many and type of licenses that are setup
b) How can I increase the number.
I can't seem to get back to that original screen.
Thanks,
Rickselect serverproperty('LicenseType') as LicenseType
go
select serverproperty('NumLicenses') as NumLicenses
Thanks
Hari
"Rick" <rick@.abasoftware.com> wrote in message
news:1174501125.493472.118810@.l75g2000hse.googlegroups.com...
> As I recall, I set the licensing format and number of licenses when I
> installed SQL Server.
> a) How can I tell how many and type of licenses that are setup
> b) How can I increase the number.
> I can't seem to get back to that original screen.
> Thanks,
> Rick
>

Adding PDF indexing with Sql Server 2005

I am trying to use the full-text indexes with Sql Server 2005, and wanted to
index pdf files. I have downloaded and installed the Adobe PDF iFilter from
Adobe, and have tested it using the iFiltTst on a directory with PDF files.
It does index the pdf files.
I then moved the files into a sql server table into a varbinary(max) field.
I re-popualted the index, but it is not being indexed. Also, when I use the
"sp_help_fulltext_extensions" command, the ".pdf" extension does not appear.
Any suggestions on how to get this to work?
Steve
issue the following
sp_fulltext_service 'verify_signature', 0
sp_fulltext_service 'load_os_resources',1
bounce sql server and it should work (provided you have the PDF iFilter
installed).
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Steven Paplanus" <sapaplanus@.hotmail.com> wrote in message
news:u0j55Zc8EHA.208@.TK2MSFTNGP12.phx.gbl...
> I am trying to use the full-text indexes with Sql Server 2005, and wanted
to
> index pdf files. I have downloaded and installed the Adobe PDF iFilter
from
> Adobe, and have tested it using the iFiltTst on a directory with PDF
files.
> It does index the pdf files.
> I then moved the files into a sql server table into a varbinary(max)
field.
> I re-popualted the index, but it is not being indexed. Also, when I use
the
> "sp_help_fulltext_extensions" command, the ".pdf" extension does not
appear.
> Any suggestions on how to get this to work?
> Steve
>
|||This will work, but beware that making this change makes your SQL instance a
little less secure.
Be sure to read the documentation for these flags so you understand the
risk.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:efcPGQt8EHA.3700@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> issue the following
> sp_fulltext_service 'verify_signature', 0
> sp_fulltext_service 'load_os_resources',1
> bounce sql server and it should work (provided you have the PDF iFilter
> installed).
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> "Steven Paplanus" <sapaplanus@.hotmail.com> wrote in message
> news:u0j55Zc8EHA.208@.TK2MSFTNGP12.phx.gbl...
wanted
> to
> from
> files.
> field.
> the
> appear.
>

Adding New Drive

SQL 2000 installed on C drive filling up added D drive is
there anything I need to do to the D drive before I attach
a database *.ldf and *.mdf to the D drive - Do I need
another instance or any files or folders from C or do I
need to change anything on the setup. I can't find this
info anywhere.
Thank You!There is nothing you need to do unless this is a clustered instance of SQL
Server. Just create the appropriate directories, move the files into them,
and then attach the database.
If you are running a clustered server it gets a bit more involved.
"Jennifer" <jennifer.chmiel@.elder-beerman.com> wrote in message
news:030901c36d8d$256a5dd0$a101280a@.phx.gbl...
> SQL 2000 installed on C drive filling up added D drive is
> there anything I need to do to the D drive before I attach
> a database *.ldf and *.mdf to the D drive - Do I need
> another instance or any files or folders from C or do I
> need to change anything on the setup. I can't find this
> info anywhere.
> Thank You!

Adding MS Access Project

I am VERY NEW to this.
I'm installed the MSDE and it's running on my desktop.
I'm trying to make a new Ms Access Project.
It asks for a user name and password and I supply sa as the user and leave
the password blank.
I get an error back saying that:
Connection Failed
SQLState: '01000'
SQL Server Error: 10054
and more...is that enough of the error for you to know what I'm doing
wrong?
Thanks.
Also, I'm familiar with MS Access frontend/backend setup. When I get it
working, does the project work as the frontend and the SQL database the
backend?
Is there a link to intro info on all of this?
Thanks.
Sorry for the double post. Didn't mean to.
I found that Norton Personal Firewall is blocking this from running. Which
program do I need to allow access. MS Access has access.
Thanks.
"SAC" <someone@.microsoft.com> wrote in message
news:OY3Xbjr8EHA.2900@.TK2MSFTNGP09.phx.gbl...
> I am VERY NEW to this.
> I'm installed the MSDE and it's running on my desktop.
> I'm trying to make a new Ms Access Project.
> It asks for a user name and password and I supply sa as the user and leave
> the password blank.
> I get an error back saying that:
> Connection Failed
> SQLState: '01000'
> SQL Server Error: 10054
> and more...is that enough of the error for you to know what I'm doing
> wrong?
> Thanks.
> Also, I'm familiar with MS Access frontend/backend setup. When I get it
> working, does the project work as the frontend and the SQL database the
> backend?
> Is there a link to intro info on all of this?
> Thanks.
>
>
|||hi,
"SAC" <someone@.microsoft.com> ha scritto nel messaggio
news:OY3Xbjr8EHA.2900@.TK2MSFTNGP09.phx.gbl
> I am VERY NEW to this.
> I'm installed the MSDE and it's running on my desktop.
> I'm trying to make a new Ms Access Project.
> It asks for a user name and password and I supply sa as the user and
> leave the password blank.
> I get an error back saying that:
> Connection Failed
> SQLState: '01000'
> SQL Server Error: 10054
> and more...is that enough of the error for you to know what I'm doing
> wrong?
> Thanks.
> Also, I'm familiar with MS Access frontend/backend setup. When I get
> it working, does the project work as the frontend and the SQL
> database the backend?
> Is there a link to intro info on all of this?
> Thanks.
please have a look at http://tinyurl.com/4vho5
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Adding More processors not helping improve performances

Hi
I had Enterprise SQL Server installed on my server with 4 processors. Its was great performances in the beginning. Later we got more processes to run.
So, I upgrade hardware to 8 Processors, but surprisingly no improvement in processing time wise. My processes is taking same time as they used to take when I have 4 processors.
E.g. Job-1 was taking 2:15 minutes with 4 processors, it is still taking same time with 8 processors.
Is there anything I am missing while upgrading to processors? I have windows Advanced Server 2000.
appreciate your help.
Thankx
JP
Processor power is only one possible constraint on your system. It is probably that memory, disk, network or design is your current contraint. I would recommend monitoring your database to determine what resource the SQL Server is waiting for.
|||SQL really prefers for each processor to work on a different connection,
instead of having multiple processors work on a single piece of work... You
might check in SQL Enterprise Manager,Right click your
server->Properties->Processors and make sure Use all processors is selected
and Max processors per query is whatever you wish...
However you are likely to get better throughput ( not faster for a single
query tho) by setting max processors per query to 2 or 1. ...
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
"JP" <anonymous@.discussions.microsoft.com> wrote in message
news:7DBC43F5-09E2-4B37-A91F-BDADC78EBCF9@.microsoft.com...
> Hi
> I had Enterprise SQL Server installed on my server with 4 processors. Its
was great performances in the beginning. Later we got more processes to run.
> So, I upgrade hardware to 8 Processors, but surprisingly no improvement in
processing time wise. My processes is taking same time as they used to take
when I have 4 processors.
> E.g. Job-1 was taking 2:15 minutes with 4 processors, it is still taking
same time with 8 processors.
> Is there anything I am missing while upgrading to processors? I have
windows Advanced Server 2000.
> appreciate your help.
> Thankx
> JP
>
|||I already have Use all processors checked out.. There is no issues of performance.
Just wondering, how come it is taking same time as 4 processors while I have 8 processors.
Or I believe, 4 processors of 2 GHz is maxed out and when I add another 4 processors it is doing better load sharing instead of gaining timewise performances.
-- Wayne Snyder wrote: --
SQL really prefers for each processor to work on a different connection,
instead of having multiple processors work on a single piece of work... You
might check in SQL Enterprise Manager,Right click your
server->Properties->Processors and make sure Use all processors is selected
and Max processors per query is whatever you wish...
However you are likely to get better throughput ( not faster for a single
query tho) by setting max processors per query to 2 or 1. ...
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
"JP" <anonymous@.discussions.microsoft.com> wrote in message
news:7DBC43F5-09E2-4B37-A91F-BDADC78EBCF9@.microsoft.com...[vbcol=seagreen]
> Hi
was great performances in the beginning. Later we got more processes to run.[vbcol=seagreen]
processing time wise. My processes is taking same time as they used to take
when I have 4 processors.[vbcol=seagreen]
same time with 8 processors.[vbcol=seagreen]
windows Advanced Server 2000.
> Thankx
> JP
>

Adding More processors not helping improve performances

Hi
I had Enterprise SQL Server installed on my server with 4 processors. Its wa
s great performances in the beginning. Later we got more processes to run.
So, I upgrade hardware to 8 Processors, but surprisingly no improvement in p
rocessing time wise. My processes is taking same time as they used to take w
hen I have 4 processors.
E.g. Job-1 was taking 2:15 minutes with 4 processors, it is still taking sam
e time with 8 processors.
Is there anything I am missing while upgrading to processors? I have windows
Advanced Server 2000.
appreciate your help.
Thankx
JPProcessor power is only one possible constraint on your system. It is proba
bly that memory, disk, network or design is your current contraint. I would
recommend monitoring your database to determine what resource the SQL Serve
r is waiting for.|||SQL really prefers for each processor to work on a different connection,
instead of having multiple processors work on a single piece of work... You
might check in SQL Enterprise Manager,Right click your
server->Properties->Processors and make sure Use all processors is selected
and Max processors per query is whatever you wish...
However you are likely to get better throughput ( not faster for a single
query tho) by setting max processors per query to 2 or 1. ...
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
"JP" <anonymous@.discussions.microsoft.com> wrote in message
news:7DBC43F5-09E2-4B37-A91F-BDADC78EBCF9@.microsoft.com...
> Hi
> I had Enterprise SQL Server installed on my server with 4 processors. Its
was great performances in the beginning. Later we got more processes to run.
> So, I upgrade hardware to 8 Processors, but surprisingly no improvement in
processing time wise. My processes is taking same time as they used to take
when I have 4 processors.
> E.g. Job-1 was taking 2:15 minutes with 4 processors, it is still taking
same time with 8 processors.
> Is there anything I am missing while upgrading to processors? I have
windows Advanced Server 2000.
> appreciate your help.
> Thankx
> JP
>|||I already have Use all processors checked out.. There is no issues of perfor
mance.
Just wondering, how come it is taking same time as 4 processors while I have
8 processors.
Or I believe, 4 processors of 2 GHz is maxed out and when I add another 4 pr
ocessors it is doing better load sharing instead of gaining timewise perform
ances.
-- Wayne Snyder wrote: --
SQL really prefers for each processor to work on a different connection,
instead of having multiple processors work on a single piece of work... You
might check in SQL Enterprise Manager,Right click your
server->Properties->Processors and make sure Use all processors is selected
and Max processors per query is whatever you wish...
However you are likely to get better throughput ( not faster for a single
query tho) by setting max processors per query to 2 or 1. ...
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
"JP" <anonymous@.discussions.microsoft.com> wrote in message
news:7DBC43F5-09E2-4B37-A91F-BDADC78EBCF9@.microsoft.com...
> Hi
was great performances in the beginning. Later we got more processes to run.[vbcol=seagreen]
processing time wise. My processes is taking same time as they used to take
when I have 4 processors.[vbcol=seagreen]
same time with 8 processors.[vbcol=seagreen]
windows Advanced Server 2000.[vbcol=seagreen]
> Thankx
> JP
>

Adding Integration Services to the existing Sqlserver 2005 - Question

Hello to everybody,

Installed the Integration Services to the existing Sqlserver 2005. But I am not seeing the 'Integration Services' in the

SQL Server Management Studio, like the 'SQL Server Agent' in the server. I am not sure what the next step is after installing the 'Integration Services'. Appreciate any help on this. Thanks for your time in advance.

Thanks,
Gopal.

It's a different server type, like Analysis Services. When you start a new connection, choose Integration Services instead of Database Engine.

|||

Also please notice that you should be doing most SSIS work in BIDS (Business Intelligence Dev Studio), not in SSMS. I recommend starting with Books Online or the Guided Tour: http://www.microsoft.com/sql/technologies/integration/tours.mspx, in particular Visual Development Environment Guided Tour.

Adding buttons Pl help me

Hi
I installed Microsoft SQl Server Reporting services server in one of our server(which doesn't have .NET Installation) and installed the client in my development machine.I already installed Microsoft VS.NET 2003 in my PC.
I already installed Microsoft SQl Server Reporting services
service pack 1 in my server and client machines.
I am developing the reports in my client machine using Reports Project template.I created one sample project and created sample reports ,those reports can view in WEB browser successfully.Now i want place my own button in default toolbar ,when ever user press that button page want to redirect some other aspx page.How and where i have to do it.I am developing reports in client pc so i dont find any script file in my project.
Pl advice me where i have to do settings or coding to do this simple task.
thanks.There is no way to extend the built-in toolbar. If you want to add
additional functionality, you need to create a separate aspx page similar to
the way Report Manager works. It adds its own toolbars and links on an aspx
page and contains an iframe to the reportserver vroot.
--
This posting is provided "AS IS" with no warranties, and confers no rights
"sr" <sr@.discussions.microsoft.com> wrote in message
news:FCB8098F-F906-4BF9-BA68-083FD4BEE9A4@.microsoft.com...
> Hi
> I installed Microsoft SQl Server Reporting services server in one of our
server(which doesn't have .NET Installation) and installed the client in my
development machine.I already installed Microsoft VS.NET 2003 in my PC.
> I already installed Microsoft SQl Server Reporting services
> service pack 1 in my server and client machines.
> I am developing the reports in my client machine using Reports Project
template.I created one sample project and created sample reports ,those
reports can view in WEB browser successfully.Now i want place my own button
in default toolbar ,when ever user press that button page want to redirect
some other aspx page.How and where i have to do it.I am developing reports
in client pc so i dont find any script file in my project.
> Pl advice me where i have to do settings or coding to do this simple task.
> thanks.