Can not Connect SQL Server Through a Firewall

All,
We are trying to connect one of our custom's SQL Server Database outside our firewall. Our Custom opened the Port #1433 for us. We also open the port on our side. However, we stil can not connect. We got "SQL Server Does Not Exist or Access Denied" erro
rs. Can anyone help us? We even could not figure out which side have issues. (Our side or our custom side)....
Lisa
Are you using a default instance or a named instance of SQL Server?
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||I used IP address and DB Name. Here is the connect string:
Password=xxx;Persist Security Info=True;User ID=xxxx;Initial Catalog=DBNAME;Data Source=123.456.78.90;
Anything wrong? THANKS?
|||Rand,
Forgot to tell that I also added ";Network Library =dbmssocn" in the connections string as well...
|||Test making an ODBC DSN and post the entire error message here.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
sql

Can not Connect SQL Server Through a Firewall

All,
We are trying to connect one of our custom's SQL Server Database outside our
firewall. Our Custom opened the Port #1433 for us. We also open the port o
n our side. However, we stil can not connect. We got "SQL Server Does Not E
xist or Access Denied" erro
rs. Can anyone help us? We even could not figure out which side have issues.
(Our side or our custom side)....
LisaAre you using a default instance or a named instance of SQL Server?
Rand
This posting is provided "as is" with no warranties and confers no rights.|||I used IP address and DB Name. Here is the connect string:
Password=xxx;Persist Security Info=True;User ID=xxxx;Initial Catalog=DBNAME;
Data Source=123.456.78.90;
Anything wrong? THANKS?|||Rand,
Forgot to tell that I also added ";Network Library =dbmssocn" in the connect
ions string as well...|||Test making an ODBC DSN and post the entire error message here.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Can inherited from a custom report

I must make many report in my project.
All the reports must have header of company name and footer of page number.
Can I desgin a template custom report, then all reports in my project are
inherited from it?Create a Report with the Bare Bones on it for your template and then save
that RDL in
C:\Program Files\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject
This "template" will now pop up in your context menu when you select to add
a new item to your report project.
Hope this helps.
"ad" wrote:
> I must make many report in my project.
> All the reports must have header of company name and footer of page number.
> Can I desgin a template custom report, then all reports in my project are
> inherited from it?
>
>|||David,
Great idea.. I have been just opening up a report I named template.rdl and
viewing the code and copying it into the new report. Your method is slicker.
Another option is not to do any formatting until the end and run the .rdl
(which is XML) through a custom app that adds the formatting and such. This
does require a good understanding of XML and the RS spec though. I recommend
the template option.|||This is great but what if you need to change something in the template. None
of your previous reports will inherit the change.
I wish we could use a stylesheet and place it on the webserver and have the
reports pickup the formatting from that.
"Craig" wrote:
> David,
> Great idea.. I have been just opening up a report I named template.rdl and
> viewing the code and copying it into the new report. Your method is slicker.
> Another option is not to do any formatting until the end and run the .rdl
> (which is XML) through a custom app that adds the formatting and such. This
> does require a good understanding of XML and the RS spec though. I recommend
> the template option.

Can I use Custom UI for executing Package in C#?

Hi

I've a doubt. I don't know whether it is possible or not.

I've a very less knowledge in DTS packages.

When I execute a package in C#. it is displaying predefined GUI for showing process.

Can I've my own UI when executing DTS.

Thanks in advance.

Could you clarify what you mean by "When I execute a package in C#" and whether the question is about DTS 2000 or SSIS. This forum is about SSIS, BTW.|||

Thanks for the reply Michael

I'm using SSIS

I'm putting the C# code here

public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
Package package;
ConnectionManager ConMgr;

Package p;
private void Form1_Load(object sender, EventArgs e)
{
string pkg ="Package.dtsx";

Microsoft.SqlServer.Dts.Runtime.Application app = new Microsoft.SqlServer.Dts.Runtime.Application();
p = app.LoadPackage(pkg, null);

}

private void button1_Click(object sender, EventArgs e)
{
if(p!=null)

p.Execute();

}
}

When I click on Button ie) p.Execute(); is invoked I need my own UI to see the processing . Is it possible.

Thank u

|||Of course - you need to implement event sink interface (IDTSEvents) and/or logging sink interface (IDTSLogging), and call package.Execute(...) version that takes these interfaces (pass null for all other arguments). You'll get the information about the package progress and can show the UI similar (or completely different if you choose) to the one DtExecUI shows (DtExecUI uses the same interfaces).|||

Thanks michael

It is useful

and can I know abt DtExecUI for what it is useful for?.]

|||Well, it executes the packages :)

Some people use command line and some people like to use GUI to execute packages. We provide DTEXEC and DTEXECUI for each group appropriately.|||

Thank u Michael .

Thanks for ur support to know these.

And finally one , can u provide some resource to learn , how to create custom UI. and executing package.etc

|||

Hi

I've one more doubt.

Executing package is a single threaded or multi threaded?

Can I catch the names of the currently transfering table when Executing package?

Thanks in advance.

|||Execution is multithreaded, you'll need to gather information you need from the event and pass it to the UI thread, and probably call package.Execute() on a different thread too to avoid locking up the UI.

There are many events and log information, see Books Online for details. Creative use of this information joined with the package information (e.g. transform properties) may give you most of the information you need.

I don't have any sample, sorry.|||

Thanks alot Michael.

Can I set expressions programmatically?

I'm building SSIS packages through code and I would like to set the properties of some custom tasks (not data flow tasks) to expressions. I've done some searches but turned up nothing. This is the only thing I'm hitting a brick wall on at the moment; Books Online has been excellent in detailing how to create packages via code up to this point.

For the sake of argument, let's say I want to set the SqlStatementSource property of an Execute SQL task to this value:

"INSERT INTO [SomeTable] VALUES (NEWID(), '" + @.[User:omeStringVariable] + "')"

What would the code look like?

TaskHost has a SetExpression method:

TaskHost.SetExpression Method

http://msdn2.microsoft.com/de-de/library/microsoft.sqlserver.dts.runtime.taskhost.setexpression.aspx

I presume all of the other container types (Package, Sequence etc..) will do too.

-Jamie

|||AAAGGGGHHH!! I was expecting a property, not a method! So then in order to retrieve all expressions on a task, you'd have to iterate the Properties collection and call GetExpression() with the name of each one to see if it's non-null. Doesn't seem like a particularly good design to me. Why not a simple collection? Oh well, thanks for the help.|||

JeffJohnsonMVPVB wrote:

AAAGGGGHHH!! I was expecting a property, not a method! So then in order to retrieve all expressions on a task, you'd have to iterate the Properties collection and call GetExpression() with the name of each one to see if it's non-null. Doesn't seem like a particularly good design to me. Why not a simple collection? Oh well, thanks for the help.

Yep. I was expecting a Collection as well.

Maybe a read-only collection would be nice that is populated by SetExpression(). Are there such things as read-only collections? I've no idea - I'm no developer.

I too would be interested in seeing the rationale for this. I hope someone from MSFT chimes in.

Regards

-Jamie