Showing posts with label setup. Show all posts
Showing posts with label setup. Show all posts

Tuesday, 20 March 2012

connect to AS2000 cube error

Here is my setup: I have Reporting Service and SQL Server 2000 in one box
(Box A), and IIS and Analysis Service in another box (Box B), which has
couple of cubes based on the database in Box A, using SQL Authentication and
Allow save password. Create AS2000 data source at Reporting Project, then
create a report, I can preview the report fine in VS.2003. But I got the
following error after deploying the report to the reportserver and browse the
report:

Cannot create a connection to data source 'Cube'. (rsErrorOpeningConnection)
Get Online Help
Database 'Cube' does not exist.
Do I miss anything?

Thanks

Reporting services and Analysis Services only support Windows authentication.

Another problem with your setup is that even if you use windows authentication you cannot validate users between to servers without using Kerberos and account delegation.

Its possible to use standalone servers and maintain the same windows accounts on the separate machines manually.

Regards

Thomas Ivarsson

sqlsql

Monday, 19 March 2012

Connect Sql server Mobile with VS2005

I have a default SQL server 2005 setup on my machine.

There is a large database to whom i can connect.

I made my own data by Sql server Mobile on my local machine and then try to connect it

to the the application in visual studio 2005.

But it each time it gives that the port cannot be open.

I am a native client for SQL server.

Do we have any idea how wil i connect to database local to machine with the

application in Visual studio 2005 with C# language.

thanks

Prashant Gupta

The actual message i am getting

Microsoft SQL Native Client Version 09.00.2047

Running connectivity tests...

Attempting connection
[Microsoft][SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server [53].
[Microsoft][SQL Native Client]Login timeout expired
[Microsoft][SQL Native Client]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.

TESTS FAILED!

Sorry, but your question is off topic here, since this is the forum with smart device development. Move to Sql Server 2005 forum.

Hint: it seems like the connection string is not correct.

Thanks!

|||Please post your connection string. Make sure that you enabled remote connections (see the screencast on my site for more information how to do this)

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||Do you need more help, or did you solve the problem ?
Jens K. Suessmeyer.

http://www.sqlserver2005.de

Connect Sql server Mobile with VS2005

I have a default SQL server 2005 setup on my machine.

There is a large database to whom i can connect.

I made my own data by Sql server Mobile on my local machine and then try to connect it

to the the application in visual studio 2005.

But it each time it gives that the port cannot be open.

I am a native client for SQL server.

Do we have any idea how wil i connect to database local to machine with the

application in Visual studio 2005 with C# language.

thanks

Prashant Gupta

The actual message i am getting

Microsoft SQL Native Client Version 09.00.2047

Running connectivity tests...

Attempting connection
[Microsoft][SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server [53].
[Microsoft][SQL Native Client]Login timeout expired
[Microsoft][SQL Native Client]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.

TESTS FAILED!

Sorry, but your question is off topic here, since this is the forum with smart device development. Move to Sql Server 2005 forum.

Hint: it seems like the connection string is not correct.

Thanks!

|||Please post your connection string. Make sure that you enabled remote connections (see the screencast on my site for more information how to do this)

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||Do you need more help, or did you solve the problem ?
Jens K. Suessmeyer.

http://www.sqlserver2005.de

Connect SQL 2005 to another database?

I'm trying to connect my SQL server to a Progress database. I have the DSN setup but I don't have a clue how to get to it or the database I'm trying to access. All I want to do is be able to view all the tables in SQL from the Progress database so I can build reports. I can't imagine this is too difficult but right now it is for me. Any help is greatly appreciated.
Thanks,
Tony Sheehan
Tony
Linked Servers?
"Tony" <tsheehan@.tji-holdings.com> wrote in message news:%23qeeAlMbIHA.1168@.TK2MSFTNGP02.phx.gbl...
I'm trying to connect my SQL server to a Progress database. I have the DSN setup but I don't have a clue how to get to it or the database I'm trying to access. All I want to do is be able to view all the tables in SQL from the Progress database so I can build reports. I can't imagine this is too difficult but right now it is for me. Any help is greatly appreciated.
Thanks,
Tony Sheehan
|||Hi Uri,
Thanks for the idea. I managed to speak with someone yesterday that mentioned this and this is the answer I was looking for. Thank you for your reply.
Tony
"Uri Dimant" <urid@.iscar.co.il> wrote in message news:eg8bdBVbIHA.3696@.TK2MSFTNGP03.phx.gbl...
Tony
Linked Servers?
"Tony" <tsheehan@.tji-holdings.com> wrote in message news:%23qeeAlMbIHA.1168@.TK2MSFTNGP02.phx.gbl...
I'm trying to connect my SQL server to a Progress database. I have the DSN setup but I don't have a clue how to get to it or the database I'm trying to access. All I want to do is be able to view all the tables in SQL from the Progress database so I can build reports. I can't imagine this is too difficult but right now it is for me. Any help is greatly appreciated.
Thanks,
Tony Sheehan

Saturday, 25 February 2012

confused about pull

I have setup multiple merge replications that are continuously updating.
Now, we need to have laptops in the field that connect occasionally that
will merge. Because of that, I assume it needs merge PULL subscription.
I have had tons of problems and it has never worked. Right now it seems
to always be a permission issue.
First, I need to test this in the office to make sure it works. If it is
working, can I take that laptop out in the field, connect via the
internet, and it will work there with no changes? This is needed because
90% of the time the user is in the field, but occasionally he is in the
office, and I don't want to have to change configurations when he comes
and goes.
Next, to get a pull setup and functioning in the office, this seems to
require both access to SQL (via a sql login I created) AND access to the
server via a windows login - is this true? If so, what is the windows
login access for (the snapshot I beleive)?
So, I guess in a perfect world the laptop can be first configured and
replicated in the office (to get the snapshot) and then taken out of the
office and connect via the internet.
Does all of this sound reasonable. I know (according to Hilary) this is
a very complex issue and I am discovering it is. Hopefully this is like
a push/merge that seemed complex until it was working, then it was(is)
easy.
Let me know people's thoughts.
Thanks.
Darin
*** Sent via Developersdex http://www.codecomments.com ***
Darin,
the initial Initialization process will require access to the share holding
the snapshot files. This access is by default achieved using the sql server
agent and impersonation. If the account which the agent uses doesn't have
rights to the distributor's working folder (snapshot share) or if the
account is simply not recognised on this server, then there will be
problems. In the case of a non-trusted environment you then have to use an
alternative (usually FTP) to get the initialization going. Once it's going,
the merge agent uses whatever you've set up to do synchronization, over your
configured port. This can be trusted or sql authentication, and by default
it is also trusted.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Confused about MSDE installation

I needed to distribute the MSDE components to the computers that use my
software so I decided to build a setup program using InstallShield that
included the MSDE files.
After I ran the installation, I noticed that the setup created a folder on
my computer using the MSDE instance name I told the setup program to used
prefixed by a "$" character. So the folder created for an instance named
such as MACHOGRANDE was "C:\Program Files\Microsoft SQL
Server\MSSQL$MACHOGRANDE"
After noticing that, I went on to explore this folder and notice that it had
a bunch of files in it, I was surprised to see that one of the files was
named sqlservr.exe! It almost looked like the installation of my MSDE
instance was like a totally independent sql server installation! Like if it
had nothing to do with the other MSDE instance I had running. I doubt this
is the case since I am pretty sure there must be a gazzilion other files
installed on the computer that are sheared by all the database that use the
MSDE engine.
So my question is,
1. Why did the instance of MSDE crated all of this extra files (such as
sqlservr.exe)? Instead of simply created the ldf and mdf files like a
regular SQL server database? Aren't the MSDE and SQL server supposed to be
the same thing?
2. Also is there a special reason for the "$" character"?
ThanksRene,
what happened is actually exactly what should happen. If you install a
new (named)instance it will always be installed in a folder like
MSSQL$Instancename. It doesn't even matter if you use MSDE or any other
SQL Server edition. A new instance includes it's own sqlserver.exe and
is basically a new installation of the SQL Server engine.
If you just wanted to add a new database you could have done so in your
existing SQLServer installation.
>2. Also is there a special reason for the "$" character"?
I have no idea why MS uses $, probably someone at MS thought this makes
it easier to see that your dealing with a named instance.
M|||Thanks Markus,
If you don't mind, could you tell me if MSDE suffers from the same security
issues as the regular SQL Server?
For example, if a security vulnerability was found in SQL Server where the
server could be exploited by a hacker from the Internet, will I also have
the same problem with the MSDE instance? Or do MSDE instances only run
locally therefore its immune to those types of attacks?
Thanks.
"MarkusB" <m.bohse@.quest-consultants.com> wrote in message
news:1126682536.660588.222940@.f14g2000cwb.googlegroups.com...
> Rene,
> what happened is actually exactly what should happen. If you install a
> new (named)instance it will always be installed in a folder like
> MSSQL$Instancename. It doesn't even matter if you use MSDE or any other
> SQL Server edition. A new instance includes it's own sqlserver.exe and
> is basically a new installation of the SQL Server engine.
> If you just wanted to add a new database you could have done so in your
> existing SQLServer installation.
> I have no idea why MS uses $, probably someone at MS thought this makes
> it easier to see that your dealing with a named instance.
> M
>|||Hi Rene,
Welcome to use MSDN Managed Newsgroup!
I have noticed you posted a duplicated post in the
microsoft.public.sqlserver.msde. To keep the integrity of newsgroup, I will
reply and follow up in that post. Thank you for your patience and
cooperation.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.|||"Rene" <nospam@.nospam.com> wrote in message
news:O73fJRQuFHA.3452@.TK2MSFTNGP14.phx.gbl...
> Thanks Markus,
> If you don't mind, could you tell me if MSDE suffers from the same
> security issues as the regular SQL Server?
> For example, if a security vulnerability was found in SQL Server where the
> server could be exploited by a hacker from the Internet, will I also have
> the same problem with the MSDE instance? Or do MSDE instances only run
> locally therefore its immune to those types of attacks?
>
MSDE is SQL Server, but in order to reduce the possibility that widely
dispersed MSDE machines could be vulnerable to a network attack, network
connectivity is off my default in MSDE (and its sucessor SQL 2005 Express
Edition).
See
[url]http://support.microsoft.com/? kbid=814130#XSLTH5167121121120121120120[
/url]
David

Confused about MSDE installation

I needed to distribute the MSDE components to the computers that use my
software so I decided to build a setup program using InstallShield that
included the MSDE files.
After I ran the installation, I noticed that the setup created a folder on
my computer using the MSDE instance name I told the setup program to used
prefixed by a "$" character. So the folder created for an instance named
such as MACHOGRANDE was "C:\Program Files\Microsoft SQL
Server\MSSQL$MACHOGRANDE"
After noticing that, I went on to explore this folder and notice that it had
a bunch of files in it, I was surprised to see that one of the files was
named sqlservr.exe! It almost looked like the installation of my MSDE
instance was like a totally independent sql server installation! Like if it
had nothing to do with the other MSDE instance I had running. I doubt this
is the case since I am pretty sure there must be a gazzilion other files
installed on the computer that are sheared by all the database that use the
MSDE engine.
So my question is,
1. Why did the instance of MSDE crated all of this extra files (such as
sqlservr.exe)? Instead of simply created the ldf and mdf files like a
regular SQL server database? Aren't the MSDE and SQL server supposed to be
the same thing?
2. Also is there a special reason for the "$" character"?
Thanks
Rene,
what happened is actually exactly what should happen. If you install a
new (named)instance it will always be installed in a folder like
MSSQL$Instancename. It doesn't even matter if you use MSDE or any other
SQL Server edition. A new instance includes it's own sqlserver.exe and
is basically a new installation of the SQL Server engine.
If you just wanted to add a new database you could have done so in your
existing SQLServer installation.
>2. Also is there a special reason for the "$" character"?
I have no idea why MS uses $, probably someone at MS thought this makes
it easier to see that your dealing with a named instance.
M
|||Thanks Markus,
If you don't mind, could you tell me if MSDE suffers from the same security
issues as the regular SQL Server?
For example, if a security vulnerability was found in SQL Server where the
server could be exploited by a hacker from the Internet, will I also have
the same problem with the MSDE instance? Or do MSDE instances only run
locally therefore its immune to those types of attacks?
Thanks.
"MarkusB" <m.bohse@.quest-consultants.com> wrote in message
news:1126682536.660588.222940@.f14g2000cwb.googlegr oups.com...
> Rene,
> what happened is actually exactly what should happen. If you install a
> new (named)instance it will always be installed in a folder like
> MSSQL$Instancename. It doesn't even matter if you use MSDE or any other
> SQL Server edition. A new instance includes it's own sqlserver.exe and
> is basically a new installation of the SQL Server engine.
> If you just wanted to add a new database you could have done so in your
> existing SQLServer installation.
> I have no idea why MS uses $, probably someone at MS thought this makes
> it easier to see that your dealing with a named instance.
> M
>
|||Hi Rene,
Welcome to use MSDN Managed Newsgroup!
I have noticed you posted a duplicated post in the
microsoft.public.sqlserver.msde. To keep the integrity of newsgroup, I will
reply and follow up in that post. Thank you for your patience and
cooperation.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
|||"Rene" <nospam@.nospam.com> wrote in message
news:O73fJRQuFHA.3452@.TK2MSFTNGP14.phx.gbl...
> Thanks Markus,
> If you don't mind, could you tell me if MSDE suffers from the same
> security issues as the regular SQL Server?
> For example, if a security vulnerability was found in SQL Server where the
> server could be exploited by a hacker from the Internet, will I also have
> the same problem with the MSDE instance? Or do MSDE instances only run
> locally therefore its immune to those types of attacks?
>
MSDE is SQL Server, but in order to reduce the possibility that widely
dispersed MSDE machines could be vulnerable to a network attack, network
connectivity is off my default in MSDE (and its sucessor SQL 2005 Express
Edition).
See
http://support.microsoft.com/?kbid=8...21120121120120
David

Confused about MSDE installation

I needed to distribute the MSDE components to the computers that use my
software so I decided to build a setup program using InstallShield that
included the MSDE files.
After I ran the installation, I noticed that the setup created a folder on
my computer using the MSDE instance name I told the setup program to used
prefixed by a "$" character. So the folder created for an instance named
such as MACHOGRANDE was "C:\Program Files\Microsoft SQL
Server\MSSQL$MACHOGRANDE"
After noticing that, I went on to explore this folder and notice that it had
a bunch of files in it, I was surprised to see that one of the files was
named sqlservr.exe! It almost looked like the installation of my MSDE
instance was like a totally independent sql server installation! Like if it
had nothing to do with the other MSDE instance I had running. I doubt this
is the case since I am pretty sure there must be a gazzilion other files
installed on the computer that are sheared by all the database that use the
MSDE engine.
So my question is,
1. Why did the instance of MSDE crated all of this extra files (such as
sqlservr.exe)? Instead of simply created the ldf and mdf files like a
regular SQL server database? Aren't the MSDE and SQL server supposed to be
the same thing?
2. Also is there a special reason for the "$" character"?
ThanksRene,
what happened is actually exactly what should happen. If you install a
new (named)instance it will always be installed in a folder like
MSSQL$Instancename. It doesn't even matter if you use MSDE or any other
SQL Server edition. A new instance includes it's own sqlserver.exe and
is basically a new installation of the SQL Server engine.
If you just wanted to add a new database you could have done so in your
existing SQLServer installation.
>2. Also is there a special reason for the "$" character"?
I have no idea why MS uses $, probably someone at MS thought this makes
it easier to see that your dealing with a named instance.
M|||Thanks Markus,
If you don't mind, could you tell me if MSDE suffers from the same security
issues as the regular SQL Server?
For example, if a security vulnerability was found in SQL Server where the
server could be exploited by a hacker from the Internet, will I also have
the same problem with the MSDE instance? Or do MSDE instances only run
locally therefore its immune to those types of attacks?
Thanks.
"MarkusB" <m.bohse@.quest-consultants.com> wrote in message
news:1126682536.660588.222940@.f14g2000cwb.googlegroups.com...
> Rene,
> what happened is actually exactly what should happen. If you install a
> new (named)instance it will always be installed in a folder like
> MSSQL$Instancename. It doesn't even matter if you use MSDE or any other
> SQL Server edition. A new instance includes it's own sqlserver.exe and
> is basically a new installation of the SQL Server engine.
> If you just wanted to add a new database you could have done so in your
> existing SQLServer installation.
>>2. Also is there a special reason for the "$" character"?
> I have no idea why MS uses $, probably someone at MS thought this makes
> it easier to see that your dealing with a named instance.
> M
>|||Hi Rene,
Welcome to use MSDN Managed Newsgroup!
I have noticed you posted a duplicated post in the
microsoft.public.sqlserver.msde. To keep the integrity of newsgroup, I will
reply and follow up in that post. Thank you for your patience and
cooperation.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||"Rene" <nospam@.nospam.com> wrote in message
news:O73fJRQuFHA.3452@.TK2MSFTNGP14.phx.gbl...
> Thanks Markus,
> If you don't mind, could you tell me if MSDE suffers from the same
> security issues as the regular SQL Server?
> For example, if a security vulnerability was found in SQL Server where the
> server could be exploited by a hacker from the Internet, will I also have
> the same problem with the MSDE instance? Or do MSDE instances only run
> locally therefore its immune to those types of attacks?
>
MSDE is SQL Server, but in order to reduce the possibility that widely
dispersed MSDE machines could be vulnerable to a network attack, network
connectivity is off my default in MSDE (and its sucessor SQL 2005 Express
Edition).
See
http://support.microsoft.com/?kbid=814130#XSLTH5167121121120121120120
David

Friday, 24 February 2012

conflict resolution

I have a merge replication setup.
I am using column level tracking
Subscribers are CLIENTS, so they are at the same level
Initially values in table t1 as
C1 -> 1
C2 -> 2
C3 -> 3
C4 -> 4
Sub1 updates,
C1->11
C2->22
Sub2 updates,
C2->222 (CONFLICT)
C3->33
1.sub1 synchronizes
2.sub2 synchronizes
3.sub1 synchronizes
My final values are,
C1->11
C2->22
C3->3
C4->4
I am expecting
C1->11
C2->22
C3->33
C4->4
Can anyone put some light?
What does the conflict viewer reveal?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Ravi Lobo" <RaviLobo@.discussions.microsoft.com> wrote in message
news:33A93D07-D0DB-416D-8E7A-21D0FB06EEEB@.microsoft.com...
>I have a merge replication setup.
> I am using column level tracking
> Subscribers are CLIENTS, so they are at the same level
> Initially values in table t1 as
> C1 -> 1
> C2 -> 2
> C3 -> 3
> C4 -> 4
> Sub1 updates,
> C1->11
> C2->22
> Sub2 updates,
> C2->222 (CONFLICT)
> C3->33
> 1. sub1 synchronizes
> 2. sub2 synchronizes
> 3. sub1 synchronizes
> My final values are,
> C1->11
> C2->22
> C3->3
> C4->4
> I am expecting
> C1->11
> C2->22
> C3->33
> C4->4
> Can anyone put some light?
>

Friday, 17 February 2012

Configuring SQL Mail

Hello,
Please pardon my ignorance. I am doing some testing on my local machine (and
then I need to setup a server). I have a mail profile, but when I try to
configure SQL Mail the profile isn't listed. Should it be? When I setup the
server do I need to have Outlook installed? It will be SQL Server 2000.
Thanks for any help, I really appreciate it.
Thanks,
NickSee http://www.aspfaq.com/2403 for troubleshooting tips for SQL Mail.
My suggestion, as that article should make clear, would be to use
xp_smtp_sendmail. We use it on all of our production servers and banished
SQL Mail ages ago.
A
"Nick" <nickfinity@.nospam.nospam> wrote in message
news:B46FAF5C-2223-47A8-8C32-084DE8827592@.microsoft.com...
> Hello,
> Please pardon my ignorance. I am doing some testing on my local machine
> (and
> then I need to setup a server). I have a mail profile, but when I try to
> configure SQL Mail the profile isn't listed. Should it be? When I setup
> the
> server do I need to have Outlook installed? It will be SQL Server 2000.
> Thanks for any help, I really appreciate it.
> Thanks,
> Nick|||Aaron,
Thanks a lot! I'm giving it a try now. I really appreciate your help.
Thanks,
Nick
"Aaron Bertrand [SQL Server MVP]" wrote:

> See http://www.aspfaq.com/2403 for troubleshooting tips for SQL Mail.
> My suggestion, as that article should make clear, would be to use
> xp_smtp_sendmail. We use it on all of our production servers and banished
> SQL Mail ages ago.
> A
>
> "Nick" <nickfinity@.nospam.nospam> wrote in message
> news:B46FAF5C-2223-47A8-8C32-084DE8827592@.microsoft.com...
>
>|||Hello,
Thanks for update. If anything is unclear, get in touch.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
========================================
=============
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.

Tuesday, 14 February 2012

Configuring Linked Server (mysql)

Hi,

I have setup a MYSQL server as a linked server in SQL SERVER 2000. I am able to select from a table using OPENQUERY as I understand that you can't use the 4 part qualifier to access an object from MYSQL as the ODBC driver does not expose the proper interface for this. The problem is that I cannot update,delete or insert into the OPENQUERY() table

eg.
UPDATE OPENQUERY(MySQL_LinkedServer,'select id from msqlTableTest') SET id = 0

INSERT INTO OPENQUERY(MySQL_LinkedServer,'select id from msqlTableTest') VALUES(0)

DELETE FROM OPENQUERY(MySQL_LinkedServer,'select id from msqlTableTest') WHERE id = 0

This is the OLEDB PROVIDER FOR ODBC error I am getting...

The requested operation could not be performed because the OLE DB provider 'MSDASQL' does not support the required transaction interface.
OLE DB error trace [OLE/DB Provider 'MSDASQL' IUnknown::QueryInterface returned 0x80004002].

I know there are brilliant Professionals on this forum. Please tell me that this is just an MDAC upgrade or something that is not configured correctly...Linked server query must be supported and contained a pass-thru query (OpenQuery, or OpenRowset with query a inside it).
SELECT/INSERT/UPDATE/DELETE statement against a 4-part name for which SQL Server generates a query against the provider for optimization.

And see whether this KBA http://support.microsoft.com/default.aspx?scid=KB;en-us;q270119 is any help.|||Thanks for the article reference. I had a look at it and it is definitely a different error that is explained in it. As I said above, you can't use 4 part names to access objects in mysql as the odbc driver does not allow it. Does anyone at all know why this error would be causes as MS does not document the reasons for it. Remember, I can select from the openquery but not update,insert,delete...

Sunday, 12 February 2012

Configuring a Report Server for E-Mail Delivery

I've installed Report Services and need to setup the E-Mail Delivery.
There are documents like 'Configuring a Report Server for E-Mail Delivery'
that talk about entering values in the SMTPServer field in the
rswebapplication.config file, but there isn't enough specific information
about setting up e-mail delivery.
What needs to be done to setup e-mail delivery?
Thanks,
JimAre you just talking about a basic subscription? If so, during the
installation you were asked for an smtp server.
That should be all it takes. You might try to create a subscription and
see what happens.
You can also edit the config file and change the SMTP server, but I have
no experience with that.
"Jim" <Jim@.discussions.microsoft.com> wrote in message
news:Jim@.discussions.microsoft.com:
> I've installed Report Services and need to setup the E-Mail Delivery.
> There are documents like 'Configuring a Report Server for E-Mail Delivery'
> that talk about entering values in the SMTPServer field in the
> rswebapplication.config file, but there isn't enough specific information
> about setting up e-mail delivery.
> What needs to be done to setup e-mail delivery?
> Thanks,
> Jim|||It can be done during installation but otherwise just do the following:
If you have a smtp server somewhere then you can just use that and use the
mail client that comes with Reporting Services. That is what I do.
In rsreportserver.config look for:
<SMTPServer>123.45.6.78</SMTPServer>
and put in the address for your smtp server. I found I had to hardcode the
address rather than use the name.
Also put in this one as well:
<From>somebody@.somewhere.com</From>
These two are the minimum to put in. There are more items you can configure
but those two should get you going.
Of course, for this to work you smtp server needs to accept mail from
anonymous sources. If it doesn't then there is more you will have to do (in
my case I didn't so I can't help with that scenario).
Hopefully this gets you going in the right direction.
Note that you do not need any mail client installed on the server. RS just
sends your mail to an existing smtp server.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jim" <Jim@.discussions.microsoft.com> wrote in message
news:21BECCFA-BB0F-4785-A1DE-CE7C9009D944@.microsoft.com...
> I've installed Report Services and need to setup the E-Mail Delivery.
> There are documents like 'Configuring a Report Server for E-Mail Delivery'
> that talk about entering values in the SMTPServer field in the
> rswebapplication.config file, but there isn't enough specific information
> about setting up e-mail delivery.
> What needs to be done to setup e-mail delivery?
> Thanks,
> Jim|||Report Services were installed before the SMTP server, so I would like to
configure the email server without removing the Report Services.
Did try a subscription and it did not work.
"John Geddes" wrote:
> Are you just talking about a basic subscription? If so, during the
> installation you were asked for an smtp server.
> That should be all it takes. You might try to create a subscription and
> see what happens.
> You can also edit the config file and change the SMTP server, but I have
> no experience with that.
>
> "Jim" <Jim@.discussions.microsoft.com> wrote in message
> news:Jim@.discussions.microsoft.com:
> > I've installed Report Services and need to setup the E-Mail Delivery.
> >
> > There are documents like 'Configuring a Report Server for E-Mail Delivery'
> >
> > that talk about entering values in the SMTPServer field in the
> > rswebapplication.config file, but there isn't enough specific information
> >
> > about setting up e-mail delivery.
> >
> > What needs to be done to setup e-mail delivery?
> >
> > Thanks,
> > Jim
>
>|||What structure in the rsreportserver.config do the values belong in?
"Bruce L-C [MVP]" wrote:
> It can be done during installation but otherwise just do the following:
> If you have a smtp server somewhere then you can just use that and use the
> mail client that comes with Reporting Services. That is what I do.
> In rsreportserver.config look for:
> <SMTPServer>123.45.6.78</SMTPServer>
> and put in the address for your smtp server. I found I had to hardcode the
> address rather than use the name.
> Also put in this one as well:
> <From>somebody@.somewhere.com</From>
> These two are the minimum to put in. There are more items you can configure
> but those two should get you going.
> Of course, for this to work you smtp server needs to accept mail from
> anonymous sources. If it doesn't then there is more you will have to do (in
> my case I didn't so I can't help with that scenario).
> Hopefully this gets you going in the right direction.
> Note that you do not need any mail client installed on the server. RS just
> sends your mail to an existing smtp server.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
>
> "Jim" <Jim@.discussions.microsoft.com> wrote in message
> news:21BECCFA-BB0F-4785-A1DE-CE7C9009D944@.microsoft.com...
> > I've installed Report Services and need to setup the E-Mail Delivery.
> >
> > There are documents like 'Configuring a Report Server for E-Mail Delivery'
> > that talk about entering values in the SMTPServer field in the
> > rswebapplication.config file, but there isn't enough specific information
> > about setting up e-mail delivery.
> >
> > What needs to be done to setup e-mail delivery?
> >
> > Thanks,
> > Jim
>
>|||The lines are already in there, you do not need to put them in, just search
for them and put your values in.
I.e. you will see this:
<SMTPServer></SMTPServer>
and you need to make it look like this
<SMTPServer>123.45.6.78</SMTPServer>
except, of course, put in the ip address. I had no luck putting the name in
for some reason so I put the IP address instead
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jim" <Jim@.discussions.microsoft.com> wrote in message
news:8CB03B63-A8C0-413E-AEB1-546E8E7C340B@.microsoft.com...
> What structure in the rsreportserver.config do the values belong in?
> "Bruce L-C [MVP]" wrote:
> > It can be done during installation but otherwise just do the following:
> >
> > If you have a smtp server somewhere then you can just use that and use
the
> > mail client that comes with Reporting Services. That is what I do.
> >
> > In rsreportserver.config look for:
> > <SMTPServer>123.45.6.78</SMTPServer>
> > and put in the address for your smtp server. I found I had to hardcode
the
> > address rather than use the name.
> >
> > Also put in this one as well:
> > <From>somebody@.somewhere.com</From>
> >
> > These two are the minimum to put in. There are more items you can
configure
> > but those two should get you going.
> >
> > Of course, for this to work you smtp server needs to accept mail from
> > anonymous sources. If it doesn't then there is more you will have to do
(in
> > my case I didn't so I can't help with that scenario).
> >
> > Hopefully this gets you going in the right direction.
> >
> > Note that you do not need any mail client installed on the server. RS
just
> > sends your mail to an existing smtp server.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> >
> >
> >
> > "Jim" <Jim@.discussions.microsoft.com> wrote in message
> > news:21BECCFA-BB0F-4785-A1DE-CE7C9009D944@.microsoft.com...
> > > I've installed Report Services and need to setup the E-Mail Delivery.
> > >
> > > There are documents like 'Configuring a Report Server for E-Mail
Delivery'
> > > that talk about entering values in the SMTPServer field in the
> > > rswebapplication.config file, but there isn't enough specific
information
> > > about setting up e-mail delivery.
> > >
> > > What needs to be done to setup e-mail delivery?
> > >
> > > Thanks,
> > > Jim
> >
> >
> >|||The lines aren't in the file I have.
"Bruce L-C [MVP]" wrote:
> The lines are already in there, you do not need to put them in, just search
> for them and put your values in.
> I.e. you will see this:
> <SMTPServer></SMTPServer>
> and you need to make it look like this
> <SMTPServer>123.45.6.78</SMTPServer>
> except, of course, put in the ip address. I had no luck putting the name in
> for some reason so I put the IP address instead
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Jim" <Jim@.discussions.microsoft.com> wrote in message
> news:8CB03B63-A8C0-413E-AEB1-546E8E7C340B@.microsoft.com...
> > What structure in the rsreportserver.config do the values belong in?
> >
> > "Bruce L-C [MVP]" wrote:
> >
> > > It can be done during installation but otherwise just do the following:
> > >
> > > If you have a smtp server somewhere then you can just use that and use
> the
> > > mail client that comes with Reporting Services. That is what I do.
> > >
> > > In rsreportserver.config look for:
> > > <SMTPServer>123.45.6.78</SMTPServer>
> > > and put in the address for your smtp server. I found I had to hardcode
> the
> > > address rather than use the name.
> > >
> > > Also put in this one as well:
> > > <From>somebody@.somewhere.com</From>
> > >
> > > These two are the minimum to put in. There are more items you can
> configure
> > > but those two should get you going.
> > >
> > > Of course, for this to work you smtp server needs to accept mail from
> > > anonymous sources. If it doesn't then there is more you will have to do
> (in
> > > my case I didn't so I can't help with that scenario).
> > >
> > > Hopefully this gets you going in the right direction.
> > >
> > > Note that you do not need any mail client installed on the server. RS
> just
> > > sends your mail to an existing smtp server.
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > >
> > >
> > >
> > > "Jim" <Jim@.discussions.microsoft.com> wrote in message
> > > news:21BECCFA-BB0F-4785-A1DE-CE7C9009D944@.microsoft.com...
> > > > I've installed Report Services and need to setup the E-Mail Delivery.
> > > >
> > > > There are documents like 'Configuring a Report Server for E-Mail
> Delivery'
> > > > that talk about entering values in the SMTPServer field in the
> > > > rswebapplication.config file, but there isn't enough specific
> information
> > > > about setting up e-mail delivery.
> > > >
> > > > What needs to be done to setup e-mail delivery?
> > > >
> > > > Thanks,
> > > > Jim
> > >
> > >
> > >
>
>|||Are you sure? Are you looking at rsreportserver.config , there is more than
one configuration file.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jim" <Jim@.discussions.microsoft.com> wrote in message
news:D865ED28-C98C-471F-B900-CB5BAED34BD8@.microsoft.com...
> The lines aren't in the file I have.
> "Bruce L-C [MVP]" wrote:
>> The lines are already in there, you do not need to put them in, just
>> search
>> for them and put your values in.
>> I.e. you will see this:
>> <SMTPServer></SMTPServer>
>> and you need to make it look like this
>> <SMTPServer>123.45.6.78</SMTPServer>
>> except, of course, put in the ip address. I had no luck putting the name
>> in
>> for some reason so I put the IP address instead
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Jim" <Jim@.discussions.microsoft.com> wrote in message
>> news:8CB03B63-A8C0-413E-AEB1-546E8E7C340B@.microsoft.com...
>> > What structure in the rsreportserver.config do the values belong in?
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> > > It can be done during installation but otherwise just do the
>> > > following:
>> > >
>> > > If you have a smtp server somewhere then you can just use that and
>> > > use
>> the
>> > > mail client that comes with Reporting Services. That is what I do.
>> > >
>> > > In rsreportserver.config look for:
>> > > <SMTPServer>123.45.6.78</SMTPServer>
>> > > and put in the address for your smtp server. I found I had to
>> > > hardcode
>> the
>> > > address rather than use the name.
>> > >
>> > > Also put in this one as well:
>> > > <From>somebody@.somewhere.com</From>
>> > >
>> > > These two are the minimum to put in. There are more items you can
>> configure
>> > > but those two should get you going.
>> > >
>> > > Of course, for this to work you smtp server needs to accept mail from
>> > > anonymous sources. If it doesn't then there is more you will have to
>> > > do
>> (in
>> > > my case I didn't so I can't help with that scenario).
>> > >
>> > > Hopefully this gets you going in the right direction.
>> > >
>> > > Note that you do not need any mail client installed on the server. RS
>> just
>> > > sends your mail to an existing smtp server.
>> > >
>> > > --
>> > > Bruce Loehle-Conger
>> > > MVP SQL Server Reporting Services
>> > >
>> > >
>> > >
>> > >
>> > > "Jim" <Jim@.discussions.microsoft.com> wrote in message
>> > > news:21BECCFA-BB0F-4785-A1DE-CE7C9009D944@.microsoft.com...
>> > > > I've installed Report Services and need to setup the E-Mail
>> > > > Delivery.
>> > > >
>> > > > There are documents like 'Configuring a Report Server for E-Mail
>> Delivery'
>> > > > that talk about entering values in the SMTPServer field in the
>> > > > rswebapplication.config file, but there isn't enough specific
>> information
>> > > > about setting up e-mail delivery.
>> > > >
>> > > > What needs to be done to setup e-mail delivery?
>> > > >
>> > > > Thanks,
>> > > > Jim
>> > >
>> > >
>> > >
>>|||Bruce,
You were right. It was the wrong file.
Thanks,
Jim
"Bruce L-C [MVP]" wrote:
> Are you sure? Are you looking at rsreportserver.config , there is more than
> one configuration file.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Jim" <Jim@.discussions.microsoft.com> wrote in message
> news:D865ED28-C98C-471F-B900-CB5BAED34BD8@.microsoft.com...
> > The lines aren't in the file I have.
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> The lines are already in there, you do not need to put them in, just
> >> search
> >> for them and put your values in.
> >>
> >> I.e. you will see this:
> >> <SMTPServer></SMTPServer>
> >> and you need to make it look like this
> >> <SMTPServer>123.45.6.78</SMTPServer>
> >> except, of course, put in the ip address. I had no luck putting the name
> >> in
> >> for some reason so I put the IP address instead
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Jim" <Jim@.discussions.microsoft.com> wrote in message
> >> news:8CB03B63-A8C0-413E-AEB1-546E8E7C340B@.microsoft.com...
> >> > What structure in the rsreportserver.config do the values belong in?
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> > > It can be done during installation but otherwise just do the
> >> > > following:
> >> > >
> >> > > If you have a smtp server somewhere then you can just use that and
> >> > > use
> >> the
> >> > > mail client that comes with Reporting Services. That is what I do.
> >> > >
> >> > > In rsreportserver.config look for:
> >> > > <SMTPServer>123.45.6.78</SMTPServer>
> >> > > and put in the address for your smtp server. I found I had to
> >> > > hardcode
> >> the
> >> > > address rather than use the name.
> >> > >
> >> > > Also put in this one as well:
> >> > > <From>somebody@.somewhere.com</From>
> >> > >
> >> > > These two are the minimum to put in. There are more items you can
> >> configure
> >> > > but those two should get you going.
> >> > >
> >> > > Of course, for this to work you smtp server needs to accept mail from
> >> > > anonymous sources. If it doesn't then there is more you will have to
> >> > > do
> >> (in
> >> > > my case I didn't so I can't help with that scenario).
> >> > >
> >> > > Hopefully this gets you going in the right direction.
> >> > >
> >> > > Note that you do not need any mail client installed on the server. RS
> >> just
> >> > > sends your mail to an existing smtp server.
> >> > >
> >> > > --
> >> > > Bruce Loehle-Conger
> >> > > MVP SQL Server Reporting Services
> >> > >
> >> > >
> >> > >
> >> > >
> >> > > "Jim" <Jim@.discussions.microsoft.com> wrote in message
> >> > > news:21BECCFA-BB0F-4785-A1DE-CE7C9009D944@.microsoft.com...
> >> > > > I've installed Report Services and need to setup the E-Mail
> >> > > > Delivery.
> >> > > >
> >> > > > There are documents like 'Configuring a Report Server for E-Mail
> >> Delivery'
> >> > > > that talk about entering values in the SMTPServer field in the
> >> > > > rswebapplication.config file, but there isn't enough specific
> >> information
> >> > > > about setting up e-mail delivery.
> >> > > >
> >> > > > What needs to be done to setup e-mail delivery?
> >> > > >
> >> > > > Thanks,
> >> > > > Jim
> >> > >
> >> > >
> >> > >
> >>
> >>
> >>
>
>

Configuring a Report Server for E-Mail Delivery

Bruce
I am pretty much in the same boat I have setup a test reporting
services instance on a Windows 2003 box. I now want to setup the
WIndows SMTP server and make reporting services send emails to the
SMTP server running on Windows.
Your help would be highly appreciated if you can specify the steps in
setting up Windows 2003 SMTP server and making reporting services talk
to it.
Thanks
KarenI have not setup the SMTP server. I use Reporting Services ability to be a
client and have it send to an existing SMTP server. There should be no
difference with the setup for Reporting Services, it just needs a SMTP
server, regardless of where it is. So what you need to know is how to
install and setup Windows SMTP server. Two different things, Report Services
SMTP client support and SMTP server. One option once you have the SMTP
server working is you can have RS deposite the report in a directory that
then the SMTP server picks up and emails or you can have it send the report
to the SMTP server which then forwards it on its way. For SMTP Server help I
would check out a Windows 2003 newsgroup.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Karen Middleton" <karenmiddleol@.yahoo.com> wrote in message
news:a5fd468a.0501062053.763b670e@.posting.google.com...
> Bruce
> I am pretty much in the same boat I have setup a test reporting
> services instance on a Windows 2003 box. I now want to setup the
> WIndows SMTP server and make reporting services send emails to the
> SMTP server running on Windows.
> Your help would be highly appreciated if you can specify the steps in
> setting up Windows 2003 SMTP server and making reporting services talk
> to it.
> Thanks
> Karen

Configuring a domain & SQL SERVER 2005 to work.

Attempting to link Access 2003 to SQL 2005, there is something keeping from doing so.

1 I setup the instance as sqlexpress.

2 I have a database shell there also.

3 It connects when I start the instance service.

4 My remote connections are configured to handle TCP/IP & Named Pipes.

Not in this order, but you get the idea. Now that I have these in place, I went first to the Access 2003 database to link the tables to this. When I came accross trouble in the form of need for a DSN to the domain for the things I created above.

In attempting to create one that looked functional, I came back to the same step. But, unsuccessful to link the tables again because browsing to that domain does not even show that particular file. This is the problem.

I do believe that once I am able to select a DSN, I will have a "healthy baby connection". I will then be the proud father of my first Server-side database setup!!!! But I am trying to get over these labor pains.

If you can′t use Windows authentication you will probably have to use SQL Server authentication. In addition you could try to set the network credentials of the user (Under the User account settings) to the domain which you want to connect to.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Configuring a domain & SQL SERVER 2005 to connection to another pc on another domain.

Attempting to link Access 2003 to SQL 2005, there is something keeping from doing so.

1 I setup the instance as sqlexpress.

2 I have a database shell there also.

3 It connects when I start the instance service.

4 My remote connections are configured to handle TCP/IP & Named Pipes.

Not in this order, but you get the idea. Now that I have these in place, I went first to the Access 2003 database to link the tables to this. When I came accross trouble in the form of need for a DSN to the domain for the things I created above.

In attempting to create one that looked functional, I came back to the same step. But, unsuccessful to link the tables again because browsing to that domain does not even show that particular file. This is the problem.

I do believe that once I am able to select a DSN, I will have a "healthy baby connection". I will then be the proud father of my first Server-side database setup!!!! But I am trying to get over these labor pains.

If you can′t use Windows authentication you will probably have to use SQL Server authentication. In addition you could try to set the network credentials of the user (Under the User account settings) to the domain which you want to connect to.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Configure Report Server - SharePoint Integration

Hello,

I'm trying to set up SharePoint Integration for our report server. The setup we have is: 1. SQL server hosting the SharePoint databases and the Reporting Server, 2. SharePoint web front end hosting all SharePoint services. I've installed the reporting services SP2 on the SQL server and the reporting services add-in on the SharePoint server.

I configured the report server following the directions here: http://download.microsoft.com/download/f/d/c/fdcb3a53-0cb1-4e67-a1b6-45b89b3c59cf/readme_rsaddin.htm and here: http://www.sharepointblogs.com/helloitsliam/archive/2007/02/21/19801.aspx

Everything seems to be set up correctly, but when I open the Reporting Services Configuration Manager, the SharePoint Integration option shows the error, "The report server cannot access setting in the SharePoint configuration database. Most likely, the Windows SharePoint Services object model...."

I do have WSS 3.0 installed on the report server.

When I look in the logs on the report server it says the login failed for the account I have set as the Windows Service Identity however, when I look at the logs on the SharePoint server it shows that it is granting the account read and write access to each of the SPWebApplications I have set up.

Any suggestions?

Thanks,

Cynthia

I just figured it out. It always happens that after days of unsuccessful attempts, I figure out the problem as soon as I post to a forum.

In case anyone else has the same problem:

In the Reporting Services Configuration Manager, under Windows Service Identity, I re-entered the name and password of the account and this caused a new dialog box to open prompting me to create an encryption key back-up. I provided a password and file location and then it worked. I'm not sure why I didn't get that dialog box initially, but everything works fine now.

Thanks,

Cynthia

|||

Hi

Can you people please confirm me that

Is that SQL Reporting Services 2005 can only be integrated with MOSS but not WSS 3.0

I am using wss3.0 (Not MOSS) and SQL reporting services 2005.

Configuration steps completed but i am not able to see the Reporting Services section in Application management

of Central Administration.

I installed SQL SP2 and Reporting Services Add ins and everything is on one system, i mean SQL2005 and wss3.0 on one system

I could use SQL Report configuration tool and set all the properties but not able to find Reporting Services section in Application management

of Central Administration.

Please Advice

Thanks,

Tiger

|||

Yes i got the solution for this

We need to Activate the Reporting services in the Central Administration this can be done by the following steps

1. Go to Site settings

2.In the Site collection Administration navigate to Site collection Features

3. Enable the Settings for Reporting Sevices

This will dispay the Reporting Section in the Application Management of Central Administration

Hope this will be help full.

Many Thanks,

Tiger

Friday, 10 February 2012

Configure SQL Express to utilize Windows clustering

We are planning to setup SQL Express on a windows os clustered environment and trying to shoot for a active-passive configuration. We know that SQL server 2005 has this ability and will be leveraging that for mission critial production applications, however there are several other apps that we intend to use internally and would like to leverage windows clustering. Has anyone done this?

- Should we share the INSTALLSQLDATADIR? If yes, then how to specify the SQL Express installtion on cluster node#2 that, "hey..utilized this dir as the data dir".

- Or Should we not worry about it, and only the databases that we create for our apps be on the quorum/clustered resource drive?

Any pointers?

SQL Express does not support Clustering.

Regards,

Mike Wachal
SQL Express team

Configure RS in sql express

Reporting Services Log

The Reporting Services installation options you specified in Setup determine whether further configuration is required before you can access the report server. If you installed the default configuration, the report server can be used immediately. If you installed just the program files, you must run the Reporting Services Configuration tool to deploy the report server.
I just installed sql express without sql developer or enterprise edition, I dont see Reporting Services on virtual directorys on IIS. I dont know how to acess the report server and configure it.

Tks

i have the same problem
i serch information about instalation RS on express edition and i find nothink, only info about futures
probably there are no RS in SQL Express setup, maby later...|||But Microsoft has a page where they say sql express has reporting services. Where is it?|||Yes. SQL Server Express has RS. However, not now. it will be available in the first half of the next year.

Alejandro Leguizamo
SQL Server MVP
Colombia|||Thank you Alejandro for answering to my email.

So the solution for this I think will be easy.

I will create my database on sql server express, I also will install sql server 2005 enterprise edition and make the reports in there, when the sql express with reporting services has been released the only thing I need to change will be the deployment options and thats it.

Correct me if I am wrong.|||

We have a client who requires RS 2005 (cause RS2004 has bugs), however is not ready to update to SQL 2005 (yet). The plan was to install Express with RS 2005, however it has been pointed out that RS is not packaged yet.

Is it possible to install Reporting Services off the developer edition cd onto a SQL Express instance? (Without using the developer licence in doing so).

Thanks

David

|||

No, this is not possible. A specific "package" which includes SQL Express and SSRS (Called SQL Server Express Edition with Advanced Services) will be available next year. This "Express SSRS" is the only version that will function against an Express database. I've had a customer or two try what you've suggested already, and it doesn't work.

I'm also not sure this idea would be "legal" (as you'd be putting SQL Developer into production which you may not do until the more recent MSDN SKUS), but that's above and beyond the technical part of the answer, anyway.

Configure RS in sql express

Reporting Services Log

The Reporting Services installation options you specified in Setup determine whether further configuration is required before you can access the report server. If you installed the default configuration, the report server can be used immediately. If you installed just the program files, you must run the Reporting Services Configuration tool to deploy the report server.
I just installed sql express without sql developer or enterprise edition, I dont see Reporting Services on virtual directorys on IIS. I dont know how to acess the report server and configure it.

Tks

i have the same problem
i serch information about instalation RS on express edition and i find nothink, only info about futures
probably there are no RS in SQL Express setup, maby later...
|||But Microsoft has a page where they say sql express has reporting services. Where is it?|||Yes. SQL Server Express has RS. However, not now. it will be available in the first half of the next year.

Alejandro Leguizamo
SQL Server MVP
Colombia|||Thank you Alejandro for answering to my email.

So the solution for this I think will be easy.

I will create my database on sql server express, I also will install sql server 2005 enterprise edition and make the reports in there, when the sql express with reporting services has been released the only thing I need to change will be the deployment options and thats it.

Correct me if I am wrong.|||

We have a client who requires RS 2005 (cause RS2004 has bugs), however is not ready to update to SQL 2005 (yet). The plan was to install Express with RS 2005, however it has been pointed out that RS is not packaged yet.

Is it possible to install Reporting Services off the developer edition cd onto a SQL Express instance? (Without using the developer licence in doing so).

Thanks

David

|||

No, this is not possible. A specific "package" which includes SQL Express and SSRS (Called SQL Server Express Edition with Advanced Services) will be available next year. This "Express SSRS" is the only version that will function against an Express database. I've had a customer or two try what you've suggested already, and it doesn't work.

I'm also not sure this idea would be "legal" (as you'd be putting SQL Developer into production which you may not do until the more recent MSDN SKUS), but that's above and beyond the technical part of the answer, anyway.

Configure Report Server Initialization Problem (SQL 2005) Seeking for expert

I setup Report Server Virtual Directory, Report Manager Virtual Directory,
Windows Service identity, Web service identity, database setup, they all
working fine. When I click on [Inititialization] I get this error
----
Reporting Services Configuration Manager
--
There was an error while switching panels. The most likely cause is an error
retrieving WMI properties. The exception details are:
An error occurred when attempting to connect to the report server remote
procedure call (RPC) end point. Verify that the Report Server Windows
service is running, and then retry the operation.
Details:
The RPC server is not listening. (Exception from HRESULT: 0x800706B3)
-----
Experts, please help me out, I'm stuck. Thank you very much!Server Status and Initialization has (x) on it, should initiazation solve
first or make server running first?
"news.microsoft.com" <Astroboy@.hotmail.com> wrote in message
news:%23oixTfCgGHA.4304@.TK2MSFTNGP05.phx.gbl...
>I setup Report Server Virtual Directory, Report Manager Virtual Directory,
>Windows Service identity, Web service identity, database setup, they all
>working fine. When I click on [Inititialization] I get this error
> ----
> Reporting Services Configuration Manager
> --
> There was an error while switching panels. The most likely cause is an
> error retrieving WMI properties. The exception details are:
> An error occurred when attempting to connect to the report server remote
> procedure call (RPC) end point. Verify that the Report Server Windows
> service is running, and then retry the operation.
> Details:
> The RPC server is not listening. (Exception from HRESULT: 0x800706B3)
> -----
> Experts, please help me out, I'm stuck. Thank you very much!
>