Can't get it to listen on TCP port 1433

Been having SQL Server 2000 running for some time now, but recently it stopped listening on TCP port 1433, the log reports its listening on shared memory, Named pipes and Rpc, but no sign of 127.0.0.1 port 1433 or any errors to say why it won't listen.

I've done a netstat -na and nothing else is listening on that port, tried restarting using the enterprise manager, gonna try restarting the entire Server when everyone has gone home, but I'm pretty sure its been restarted recently.

All the other archive logs going back a few days show its not listening.

Yes, I have used the Server network utility to make sure TCP/IP is enabled and set to 1433, even added a comma and 1434 to see if it will listen on multiple ports, no go.

Any help?
What service pack do you have installed?|||Have you told your firewall to allow connections to Microsoft SQL Server?|||SQL Server 2000 - 8.00.194 build 3790 Service pack 1

Mmmm, isn't SP3 out?
Lets hope it doesn't break it even more, as after the restart of the entire server last night, its now not responding to TCP connections locally 127.0.0.1

Not sure about the firewall, I'll have to check, its been fine with it for the past few years.

|||

SP4 has been out for quite some time. Here is a handy web site which lists all of the hot fix and service packs which have been released http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx.

Start by upgrading to SQL 2000 SP4. Odds are a Windows 2000 hot fix shuts down SQL from talking over the net if prior to SP3 as there is a major security flaw prior to SP3 which the SQL Slammer worm expliots.

Can't find Reporting Service?

I wanted to add Reports Service to my sql express. I downloaded the SQLEXPR_ADV.EXE and also Edition Toolkit SP1. But can't see the option to install Report service.

Any help please.

Juvan

Reporting Services is included with SQL Express Advanced. Launch this installer and you will see an option to install it during the "Feature Selection" dialog.

Thanks,
Sam Lester (MSFT)

Can't find Reporting Service?

I wanted to add Reports Service to my sql express. I downloaded the SQLEXPR_ADV.EXE and also Edition Toolkit SP1. But can't see the option to install Report service.

Any help please.

Juvan

Reporting Services is included with SQL Express Advanced. Launch this installer and you will see an option to install it during the "Feature Selection" dialog.

Thanks,
Sam Lester (MSFT)

Cant find diagram property

Hi,

i set up an diagram with crystal reports and Visual Basic 2005.
Everythink works fine, but I got in trouble with a font size property of the so called "datalabel". I did not find the property where I can set the fontsize to a smaller one. To demonstrate my problem I attached a picture with the meant label surrounded.

Can anybody help me?Ok, I asked the supprt of crystal. It is not possible with the visual studio integrated version, you have to update to XI :(

Can't export report to CSV,XMl correctly, sql 2005 reporting service

Hi all,

I am developing reports using sql2005 report service. I can export reports in excel and pdf format, but can't export to csv and xml correctly.

The exported csv and xml files only contain some thing like the textbox,..., but no report content are there.

Anybody can help? thanks in advance.

BTW, all reports are matrix, is martrix can cause some issues?

Hi,

For most items on your report, you can define how it needs to be rendered to XML. For example the xml output for an item in a matrix can be set as follow:

select the item in the matrix|||

Thanks, Greert.

Your reply is really helpful. Now I know how to export report in xml format. But, how about CSV? I still can't export report to csv.

Thanks again

|||

Hi,

The same goes for CSV. For example if you set the Output of a column to No, you will see that the column is not included in the CSV file.

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

|||Hi Geert,

Thanks a lot.

When I set th output of a column to yes, it works. Before, the the output of column was set to Auto.

Can't email reports

Hello
I'm trying to send the reports in Report Manager by mail, but I have always
the same message -> "Error sending email.
System.Runtime.InteropServices.COMException (0x80040211): The message could
not be sent to the SMTP server. The transport error code was 0x800ccc15. The
server response was not available."
I have installed W XP SP2, and have no firewall
When I installed Rep. Serv. I specified a valid smtp adress.
Can everyone help me pleaseSorry Bruno; it appears you have not included enough information in your
question. How are you trying to send the e-mail? Are you using the
subscription feature in Reporting Services? If so, take a look at the file
RSReportServer.config which is in the ReportServer subfolder of your
Reporting Services installation folder (this in turn is located in the folder
where your SQL Server instance is installed). In this file, there is an XML
element called RSEmailDPConfiguration. Within this element there is a
subelement called SMTPServer. This is where your SMTP server is configured.
Is this configured correctly, i.e. is it pointing to a valid SMTP server like
an Exchange Server?
I am assuming you are trying to send the report using the subscription
feature.
Charles Kangai, MCT, MCDBA
"Bruno" wrote:
> Hello
> I'm trying to send the reports in Report Manager by mail, but I have always
> the same message -> "Error sending email.
> System.Runtime.InteropServices.COMException (0x80040211): The message could
> not be sent to the SMTP server. The transport error code was 0x800ccc15. The
> server response was not available."
> I have installed W XP SP2, and have no firewall
> When I installed Rep. Serv. I specified a valid smtp adress.
>
> Can everyone help me please|||Hello Charles and thanks to help me
Yes, I am using the subcription feature to send email in report manager site.
I follow the suggestion do check the RSReportServer.config and everything is
ok as you can see above:
<RSEmailDPConfiguration>
<SMTPServer>10.250.1.123</SMTPServer> <SMTPServerPort></SMTPServerPort>
<SMTPAccountName></SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing></SendUsing>
<SMTPAuthenticate></SMTPAuthenticate>
<From>reports@.abcorp.com</From>
..................
The smtp adress is valid, because is from the exchange server.
All the sql server services and report services are starting with a domain
account and the sql server uses the mix mode autentication.
When I installed the rep server I selected the sql autentication (sa user)
in credentials to connect to sql server.
When I depoy the reports to Report manager, I can see them perfectly, but
can't send them by mail. The error is always the same "Error sending email.
System.Runtime.InteropServices.COMException (0x80040211): The message could
not be sent to the SMTP server. The transport error code was 0x800ccc15. The
server response was not available"
Can SP2(WinXP) the problem?
Thank you for the help!!!
"Charles Kangai" wrote:
> Sorry Bruno; it appears you have not included enough information in your
> question. How are you trying to send the e-mail? Are you using the
> subscription feature in Reporting Services? If so, take a look at the file
> RSReportServer.config which is in the ReportServer subfolder of your
> Reporting Services installation folder (this in turn is located in the folder
> where your SQL Server instance is installed). In this file, there is an XML
> element called RSEmailDPConfiguration. Within this element there is a
> subelement called SMTPServer. This is where your SMTP server is configured.
> Is this configured correctly, i.e. is it pointing to a valid SMTP server like
> an Exchange Server?
> I am assuming you are trying to send the report using the subscription
> feature.
> Charles Kangai, MCT, MCDBA
> "Bruno" wrote:
> > Hello
> >
> > I'm trying to send the reports in Report Manager by mail, but I have always
> > the same message -> "Error sending email.
> > System.Runtime.InteropServices.COMException (0x80040211): The message could
> > not be sent to the SMTP server. The transport error code was 0x800ccc15. The
> > server response was not available."
> >
> > I have installed W XP SP2, and have no firewall
> > When I installed Rep. Serv. I specified a valid smtp adress.
> >
> >
> > Can everyone help me please|||The problem was in Anti-Virus (McAfee 8 Ent)
"Bruno" wrote:
> Hello
> I'm trying to send the reports in Report Manager by mail, but I have always
> the same message -> "Error sending email.
> System.Runtime.InteropServices.COMException (0x80040211): The message could
> not be sent to the SMTP server. The transport error code was 0x800ccc15. The
> server response was not available."
> I have installed W XP SP2, and have no firewall
> When I installed Rep. Serv. I specified a valid smtp adress.
>
> Can everyone help me please

Can't deliver reports in Web Archive format

I can't deliver reports in web archive format using subscriptions.
If I choose to send only the link it's working.
I used to have SP1 for Reporting Services but I was forced to unintall it
because I am using Romanian lang for my reports and all reports with date
fields where not working when I try to export them to PDF.
Any ideas ?
Sorin Sandu
RomaniaI forgot my error
"Failure sending mail: An error has occurred during report processing" on
the subscriptions page.
"spp" <spp@.nospam.nospam> a scris în mesajul de
ºtiri:%23mJdsxpOFHA.3072@.TK2MSFTNGP09.phx.gbl...
>I can't deliver reports in web archive format using subscriptions.
> If I choose to send only the link it's working.
> I used to have SP1 for Reporting Services but I was forced to unintall it
> because I am using Romanian lang for my reports and all reports with date
> fields where not working when I try to export them to PDF.
> Any ideas ?
> Sorin Sandu
> Romania
>|||I'm having the same problem - is there a log file somewhere I can check? I
checked event viewer, and also looked at the reportserver's tables in SQL but
I didn't find anything around the time of my test email
"spp" wrote:
> I forgot my error
> "Failure sending mail: An error has occurred during report processing" on
> the subscriptions page.
> "spp" <spp@.nospam.nospam> a scris în mesajul de
> ºtiri:%23mJdsxpOFHA.3072@.TK2MSFTNGP09.phx.gbl...
> >I can't deliver reports in web archive format using subscriptions.
> > If I choose to send only the link it's working.
> > I used to have SP1 for Reporting Services but I was forced to unintall it
> > because I am using Romanian lang for my reports and all reports with date
> > fields where not working when I try to export them to PDF.
> > Any ideas ?
> > Sorin Sandu
> > Romania
> >
>
>

can''t create reports via VS 2005 Standard

From what I read about the versions, VS 2005 Standard allows for SSRS development.

If I create a new project, I don't see the option to create anything from the BI section to create a report project.

I have SQL Server Express on my machine, and am able to run the SSRS configuartion management tool.

Do I have to run an .exe file or something?

Thanks!

When you installed SQL, did you expand all of the components and specify that you WANT them to be installed? For some reason they all default to do NOT intall.

I believe there is a component in client components (business intelligence studio) or something like that which actually installs the SQL server report project to Visual Studio.

Yes, Visual Studio comes with a menu in the create project wizard for Business Intelligence Projects. However, there are most likely no project types in that section for you, because the proper components were not installed when SQL was installed.

|||You have to install the SQL Server 2005 workstation tools including the Business Intelligence Studio AFTER VS 2005 is installed, and several new modules will show in the VS2005 startup splash, and new project types will be available.

If this still does not appear properly, you may need to rebuild your project templates. I took me a couple re-installs to get it right.
|||

did a re-install of the tool set which includes the BI templates and that worked.

Thanks!

can''t create reports via VS 2005 Standard

From what I read about the versions, VS 2005 Standard allows for SSRS development.

If I create a new project, I don't see the option to create anything from the BI section to create a report project.

I have SQL Server Express on my machine, and am able to run the SSRS configuartion management tool.

Do I have to run an .exe file or something?

Thanks!

When you installed SQL, did you expand all of the components and specify that you WANT them to be installed? For some reason they all default to do NOT intall.

I believe there is a component in client components (business intelligence studio) or something like that which actually installs the SQL server report project to Visual Studio.

Yes, Visual Studio comes with a menu in the create project wizard for Business Intelligence Projects. However, there are most likely no project types in that section for you, because the proper components were not installed when SQL was installed.

|||You have to install the SQL Server 2005 workstation tools including the Business Intelligence Studio AFTER VS 2005 is installed, and several new modules will show in the VS2005 startup splash, and new project types will be available.

If this still does not appear properly, you may need to rebuild your project templates. I took me a couple re-installs to get it right.
|||

did a re-install of the tool set which includes the BI templates and that worked.

Thanks!

can''t create reports via VS 2005 Standard

From what I read about the versions, VS 2005 Standard allows for SSRS development.

If I create a new project, I don't see the option to create anything from the BI section to create a report project.

I have SQL Server Express on my machine, and am able to run the SSRS configuartion management tool.

Do I have to run an .exe file or something?

Thanks!

When you installed SQL, did you expand all of the components and specify that you WANT them to be installed? For some reason they all default to do NOT intall.

I believe there is a component in client components (business intelligence studio) or something like that which actually installs the SQL server report project to Visual Studio.

Yes, Visual Studio comes with a menu in the create project wizard for Business Intelligence Projects. However, there are most likely no project types in that section for you, because the proper components were not installed when SQL was installed.

|||You have to install the SQL Server 2005 workstation tools including the Business Intelligence Studio AFTER VS 2005 is installed, and several new modules will show in the VS2005 startup splash, and new project types will be available.

If this still does not appear properly, you may need to rebuild your project templates. I took me a couple re-installs to get it right.
|||

did a re-install of the tool set which includes the BI templates and that worked.

Thanks!

can''t create reports via VS 2005 Standard

From what I read about the versions, VS 2005 Standard allows for SSRS development.

If I create a new project, I don't see the option to create anything from the BI section to create a report project.

I have SQL Server Express on my machine, and am able to run the SSRS configuartion management tool.

Do I have to run an .exe file or something?

Thanks!

When you installed SQL, did you expand all of the components and specify that you WANT them to be installed? For some reason they all default to do NOT intall.

I believe there is a component in client components (business intelligence studio) or something like that which actually installs the SQL server report project to Visual Studio.

Yes, Visual Studio comes with a menu in the create project wizard for Business Intelligence Projects. However, there are most likely no project types in that section for you, because the proper components were not installed when SQL was installed.

|||You have to install the SQL Server 2005 workstation tools including the Business Intelligence Studio AFTER VS 2005 is installed, and several new modules will show in the VS2005 startup splash, and new project types will be available.

If this still does not appear properly, you may need to rebuild your project templates. I took me a couple re-installs to get it right.
|||

did a re-install of the tool set which includes the BI templates and that worked.

Thanks!

Can't connect to Report Server Model

I've created and successfully deployed a Report Server Model. However, when I try to use it as a data source to write reports against, I can't connect to it. When I create a new shared data source, the option of Report Server Model appears in the Type: dropdown, but there's no way for me to add/edit the connection string. That option is grayed out.

Is this a security issue? I've checked all the permission options in Management Studio and I should have access to everything. I'm not sure what he problem is here.

Any help is appreciated.

BTW, I can create reports using Report Builder (web interface), but not in BIDS.

Anyone?