No Email

Hello.
I have created a domain account, granted the account Administrator access on
the report server machine, have changed the two windows services to run as
that account, and have created an Exchange mailbox for the domain account.
I created a simple report that has no data source. I created a shared
calendar that runs every 1 minute. I subscribed to the report on that
schedule, no report.
The report is not being emailed.
Any thoughts?
Thanks in advance,
MikeAlso, SQL server instance is on a different machine.
I don't think that the report is even running. Does reporting services use
the SQL agent?
"mike" <milop@.slomins.com> wrote in message
news:Or03HXtuFHA.2076@.TK2MSFTNGP14.phx.gbl...
> Hello.
> I have created a domain account, granted the account Administrator access
> on the report server machine, have changed the two windows services to run
> as that account, and have created an Exchange mailbox for the domain
> account.
> I created a simple report that has no data source. I created a shared
> calendar that runs every 1 minute. I subscribed to the report on that
> schedule, no report.
> The report is not being emailed.
> Any thoughts?
> Thanks in advance,
> Mike
>|||No,Mike it does not.
"mike" wrote:
> Also, SQL server instance is on a different machine.
> I don't think that the report is even running. Does reporting services use
> the SQL agent?
> "mike" <milop@.slomins.com> wrote in message
> news:Or03HXtuFHA.2076@.TK2MSFTNGP14.phx.gbl...
> > Hello.
> >
> > I have created a domain account, granted the account Administrator access
> > on the report server machine, have changed the two windows services to run
> > as that account, and have created an Exchange mailbox for the domain
> > account.
> >
> > I created a simple report that has no data source. I created a shared
> > calendar that runs every 1 minute. I subscribed to the report on that
> > schedule, no report.
> >
> > The report is not being emailed.
> >
> > Any thoughts?
> >
> > Thanks in advance,
> >
> > Mike
> >
>
>|||As Per my knowledge an SQL Agent job is created for each schedule. SQL Server
Agent is very much required to run the Scheduled SRS Reports.
Ashish
"ProJester" wrote:
> No,Mike it does not.
>
> "mike" wrote:
> > Also, SQL server instance is on a different machine.
> >
> > I don't think that the report is even running. Does reporting services use
> > the SQL agent?
> >
> > "mike" <milop@.slomins.com> wrote in message
> > news:Or03HXtuFHA.2076@.TK2MSFTNGP14.phx.gbl...
> > > Hello.
> > >
> > > I have created a domain account, granted the account Administrator access
> > > on the report server machine, have changed the two windows services to run
> > > as that account, and have created an Exchange mailbox for the domain
> > > account.
> > >
> > > I created a simple report that has no data source. I created a shared
> > > calendar that runs every 1 minute. I subscribed to the report on that
> > > schedule, no report.
> > >
> > > The report is not being emailed.
> > >
> > > Any thoughts?
> > >
> > > Thanks in advance,
> > >
> > > Mike
> > >
> >
> >
> >sql

No administrator privileges

I've logged into our database server to update some reports and found
out that I go to manage RS I have no admin privileges! This happened
all of a sudden as a week ago with the same login details I could do it
just fine and now I just have vanilla screen for users with no rights.
I've most probably stuffed something up without realising it, please
help!Check the websites. Most likely you have turned anonymous on (this is an IIS
thing). If anonymous then you are anonymous, RS doesn't know you are an
admin.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<ocbka1@.gmail.com> wrote in message
news:1145322356.507391.151480@.v46g2000cwv.googlegroups.com...
> I've logged into our database server to update some reports and found
> out that I go to manage RS I have no admin privileges! This happened
> all of a sudden as a week ago with the same login details I could do it
> just fine and now I just have vanilla screen for users with no rights.
> I've most probably stuffed something up without realising it, please
> help!
>|||Thanks!! I've taken anonymous access off but that also means that
whenever I try to access a report (web server is a different box) it's
asking me for username and password. What should I do?

No access from Application to SQL Server 2005 - Solved

Hi

I have installed the 2005 SQL Server and its up running. I can connect to the database direct as administrator, but my simple test application returns an exception.

SqlConnection con = new SqlConnection("server=mercur\\sqlserver2005,database=AdventureWorks;integrated security=true");

con.Open();

As the output confirms it might be the default settings. Im not familiar with the enviroment and will appreciate your help.

Mosquito

I receive this exception:

System.Data.SqlClient.SqlException: 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. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

at System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup)

at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)

at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)

at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)

at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)

at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)

at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)

at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)

at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)

at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

at System.Data.SqlClient.SqlConnection.Open()

at HelloWorld.Form1.button1_Click(Object sender, EventArgs e) in D:\Visual Studio 2005\Projects\HelloWorld\HelloWorld\Form1.cs:line 26

The reason is given in the Exception. The connection string is not valid.

The separation between server string and database string has to be a semicolon and everything works just fine.

No access from Application to SQL Server 2005

Hi

I have installed the 2005 SQL Server and its up running. I can connect to the database direct as administrator, but my simple test application returns an exception.

SqlConnection con = new SqlConnection("server=mercur\\sqlserver2005,database=AdventureWorks;integrated security=true");

con.Open();

As the output confirms it might be the default settings. Im not familiar with the enviroment and will appreciate your help.

Mosquito

I receive this exception:

System.Data.SqlClient.SqlException: 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. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

at System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup)

at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)

at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)

at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)

at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)

at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)

at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)

at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)

at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)

at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

at System.Data.SqlClient.SqlConnection.Open()

at HelloWorld.Form1.button1_Click(Object sender, EventArgs e) in D:\Visual Studio 2005\Projects\HelloWorld\HelloWorld\Form1.cs:line 26

The reason is given in the Exception. The connection string is not valid.

The separation between server string and database string has to be a semicolon and everything works just fine.

No access from Application to SQL Server 2000

I have installed the SQL Server 2000 and its up running.

I can connect to the database direct as administrator, but my test application(asp.net 2.0) returns an exception.

SqlConnection sqlConn = new SqlConnection("data source=10.61.90.24;initial catalog=testdb;persist security info=False;user id=sa;pwd=data;Type System Version=SQL Server 2000;");

sqlConn.Open();

I receive this exception:

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. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: 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. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

This is a configuration problem. You need to go into the 'SQL Server Configuration' tool and enable Named Pipes.

Regards

Paul.

|||

I have enabled Named Pipes.The connection is still failed.

thanks.

newbie: telnet localhost 1433 fails

I don't understand why.
My SQL Server 2005 is called PC\SQLEXPRESS. I use PC\Robert (administrator)
account on Windows XP Professional. I use Windows Authentication. Remote
connections are switched on ("Using both TCP/IP and names pipes.")
Please help. Thank you.
/RAM/Since this is a named instance, the port is not 1433. The SQL Server error
log will list the listening network protocols, interfaces and ports.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"R.A.M." <r_ahimsa_m@.poczta.onet.plwrote in message
news:ejeg8o$oiv$1@.news.onet.pl...

Quote:

Originally Posted by

>I don't understand why.
My SQL Server 2005 is called PC\SQLEXPRESS. I use PC\Robert
(administrator)
account on Windows XP Professional. I use Windows Authentication. Remote
connections are switched on ("Using both TCP/IP and names pipes.")
Please help. Thank you.
/RAM/
>

|||I see no port number in C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\LOG.
Could you help me please?

Uzytkownik "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.netnapisal w
wiadomosci news:wLE6h.7391$6t.4871@.newssvr11.news.prodigy.com ...

Quote:

Originally Posted by

Since this is a named instance, the port is not 1433. The SQL Server
error log will list the listening network protocols, interfaces and ports.

|||You should have a log entry like the example below if the server is
listening on TCP/IP:

2006-11-15 08:11:39.68 Server Server is listening on [ 'any' <ipv4>
10489].

In this case, the port is 10489.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"R.A.M." <r_ahimsa_m@.poczta.onet.plwrote in message
news:ejfqcn$42h$1@.news.onet.pl...

Quote:

Originally Posted by

>I see no port number in C:\Program Files\Microsoft SQL
>Server\MSSQL.1\MSSQL\LOG.
Could you help me please?
>
Uzytkownik "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.netnapisal w
wiadomosci news:wLE6h.7391$6t.4871@.newssvr11.news.prodigy.com ...

Quote:

Originally Posted by

>Since this is a named instance, the port is not 1433. The SQL Server
>error log will list the listening network protocols, interfaces and
>ports.

>
>

|||Thank you I found.
Some application I need uses SQL Server 2005. I need to provide connection
string (that's why I need port number).
If I have named instance, shall I have to change my connection string every
time I run Windows?
/RAM/

Uzytkownik "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.netnapisal w
wiadomosci news:yoQ6h.6288$IR4.968@.newssvr25.news.prodigy.net ...

Quote:

Originally Posted by

You should have a log entry like the example below if the server is
listening on TCP/IP:
>
2006-11-15 08:11:39.68 Server Server is listening on [ 'any' <ipv4>
10489].
>
In this case, the port is 10489.

|||If I have named instance, shall I have to change my connection string

Quote:

Originally Posted by

every time I run Windows?

You don't need to hard-code the port in the connection string if you enable
the SQL Browser service. This will allow clients to discover the port
dynamically based in the instance name.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"R.A.M." <r_ahimsa_m@.poczta.onet.plwrote in message
news:ejh2j5$lao$1@.news.onet.pl...

Quote:

Originally Posted by

Thank you I found.
Some application I need uses SQL Server 2005. I need to provide connection
string (that's why I need port number).
If I have named instance, shall I have to change my connection string
every time I run Windows?
/RAM/
>
Uzytkownik "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.netnapisal w
wiadomosci news:yoQ6h.6288$IR4.968@.newssvr25.news.prodigy.net ...

Quote:

Originally Posted by

>You should have a log entry like the example below if the server is
>listening on TCP/IP:
>>
>2006-11-15 08:11:39.68 Server Server is listening on [ 'any' <ipv4>
>10489].
>>
>In this case, the port is 10489.

>
>

Newbie: Object name 'ProductSubCategory' is not valid.

Hi all,
I have just installed Reporting Services in a W2003 server (without VS.Net).
and SQL Server 2000.
I have run the Report Administrator, and after inserting my the windows
admin user and its password, looks like it works.
Then I load the example file Company Sales.rdl which is in the
Samples\Reports folder. looks like it loads perfectly.
But when I click on it in order to see the file, gives me that error:
Error while processing report(rsProcessingAborted). Query execution error
for Sales dataset (rsErrorExecutingCommand).
The object name 'ProductSubCategory' is not valid.
What am I doing wrong?
Any help/hint or whatever will be wellcome.
Thanks in advance,
Ibai Peña"Ibai Peña" <IbaiPea@.discussions.microsoft.com> wrote in message
news:5AB26ADF-387C-4588-AD49-0202DC75D34E@.microsoft.com...
<cut>
> Then I load the example file Company Sales.rdl which is in the
> Samples\Reports folder. looks like it loads perfectly.
> But when I click on it in order to see the file, gives me that error:
> Error while processing report(rsProcessingAborted). Query execution error
> for Sales dataset (rsErrorExecutingCommand).
> The object name 'ProductSubCategory' is not valid.
>
Have you created the Datasource yet? You need to create a data source for
the sample reports to run. The Books Online explains how to and what
settings to use.
Kaisa|||Thank you for your replay.
I was just to post that I have found that the datasource wasn´t defined.
What leads me to the next question:
Is is possible to set a default datasource for all reports?
Thanks,
Ibai Peña
"Kaisa M. Lindahl" wrote:
> "Ibai Peña" <IbaiPea@.discussions.microsoft.com> wrote in message
> news:5AB26ADF-387C-4588-AD49-0202DC75D34E@.microsoft.com...
> <cut>
> > Then I load the example file Company Sales.rdl which is in the
> > Samples\Reports folder. looks like it loads perfectly.
> >
> > But when I click on it in order to see the file, gives me that error:
> >
> > Error while processing report(rsProcessingAborted). Query execution error
> > for Sales dataset (rsErrorExecutingCommand).
> > The object name 'ProductSubCategory' is not valid.
> >
> Have you created the Datasource yet? You need to create a data source for
> the sample reports to run. The Books Online explains how to and what
> settings to use.
> Kaisa
>
>|||RSConfig.exe file. Sorry, sometimes it is better to spend some time before
asking.
Regards,
Ibai Peña
"Ibai Peña" wrote:
> Thank you for your replay.
> I was just to post that I have found that the datasource wasn´t defined.
> What leads me to the next question:
> Is is possible to set a default datasource for all reports?
> Thanks,
> Ibai Peña
> "Kaisa M. Lindahl" wrote:
> > "Ibai Peña" <IbaiPea@.discussions.microsoft.com> wrote in message
> > news:5AB26ADF-387C-4588-AD49-0202DC75D34E@.microsoft.com...
> > <cut>
> > > Then I load the example file Company Sales.rdl which is in the
> > > Samples\Reports folder. looks like it loads perfectly.
> > >
> > > But when I click on it in order to see the file, gives me that error:
> > >
> > > Error while processing report(rsProcessingAborted). Query execution error
> > > for Sales dataset (rsErrorExecutingCommand).
> > > The object name 'ProductSubCategory' is not valid.
> > >
> >
> > Have you created the Datasource yet? You need to create a data source for
> > the sample reports to run. The Books Online explains how to and what
> > settings to use.
> > Kaisa
> >
> >
> >