Getting SQL Server 2000 to listen only to the loopback device

Is it possible to get SQL Server 2000 to listen only to connections on
the Microsoft loopback device?
I am running a proprietary analysis package on top of SQL Server that
requires that a TCP/IP connection. I will never connect to SQL Server
remotely, so I would like to avoid having SQL Server listen for
connections on my network adapter.
I am running SQL Server Personal Edition on Windows 200 SP4.
Any thoughts on how to set this up?
Thanks,
Chris Green
joeionnojitsu AT comcast.netThe MS loopback device is network address 127.0.0.1 ' Is that what
you are referring to'
Have you looked at the following articles?
http://support.microsoft.com/?id=287932
http://support.microsoft.com/default.aspx?kbid=814130
Since the entire point behind a server is to provide for several
clients, your goal doesn't seem feasible unless you have a firewall
that blocks everything destined for the server, and not coming from
the local host.
Lou Arnold
On Thu, 24 Jun 2004 06:13:27 GMT, c green
<joeionnojitsu@.NOSPAM.comcast.net> wrote:
>Is it possible to get SQL Server 2000 to listen only to connections on
>the Microsoft loopback device?
>I am running a proprietary analysis package on top of SQL Server that
>requires that a TCP/IP connection. I will never connect to SQL Server
>remotely, so I would like to avoid having SQL Server listen for
>connections on my network adapter.
>I am running SQL Server Personal Edition on Windows 200 SP4.
>Any thoughts on how to set this up?
>Thanks,
>Chris Green
>joeionnojitsu AT comcast.net

Getting SQL Server 2000 to listen only to the loopback device

Is it possible to get SQL Server 2000 to listen only to connections on
the Microsoft loopback device?
I am running a proprietary analysis package on top of SQL Server that
requires that a TCP/IP connection. I will never connect to SQL Server
remotely, so I would like to avoid having SQL Server listen for
connections on my network adapter.
I am running SQL Server Personal Edition on Windows 200 SP4.
Any thoughts on how to set this up?
Thanks,
Chris Green
joeionnojitsu AT comcast.netThe MS loopback device is network address 127.0.0.1 ' Is that what
you are referring to'
Have you looked at the following articles?
http://support.microsoft.com/?id=287932
http://support.microsoft.com/default.aspx?kbid=814130
Since the entire point behind a server is to provide for several
clients, your goal doesn't seem feasible unless you have a firewall
that blocks everything destined for the server, and not coming from
the local host.
Lou Arnold
On Thu, 24 Jun 2004 06:13:27 GMT, c green
<joeionnojitsu@.NOSPAM.comcast.net> wrote:

>Is it possible to get SQL Server 2000 to listen only to connections on
>the Microsoft loopback device?
>I am running a proprietary analysis package on top of SQL Server that
>requires that a TCP/IP connection. I will never connect to SQL Server
>remotely, so I would like to avoid having SQL Server listen for
>connections on my network adapter.
>I am running SQL Server Personal Edition on Windows 200 SP4.
>Any thoughts on how to set this up?
>Thanks,
>Chris Green
>joeionnojitsu AT comcast.netsql

Getting SQL Server 2000 to listen only to the loopback device

Is it possible to get SQL Server 2000 to listen only to connections on
the Microsoft loopback device?
I am running a proprietary analysis package on top of SQL Server that
requires that a TCP/IP connection. I will never connect to SQL Server
remotely, so I would like to avoid having SQL Server listen for
connections on my network adapter.
I am running SQL Server Personal Edition on Windows 200 SP4.
Any thoughts on how to set this up?
Thanks,
Chris Green
joeionnojitsu AT comcast.net
The MS loopback device is network address 127.0.0.1 ? Is that what
you are referring to?
Have you looked at the following articles?
http://support.microsoft.com/?id=287932
http://support.microsoft.com/default.aspx?kbid=814130
Since the entire point behind a server is to provide for several
clients, your goal doesn't seem feasible unless you have a firewall
that blocks everything destined for the server, and not coming from
the local host.
Lou Arnold
On Thu, 24 Jun 2004 06:13:27 GMT, c green
<joeionnojitsu@.NOSPAM.comcast.net> wrote:

>Is it possible to get SQL Server 2000 to listen only to connections on
>the Microsoft loopback device?
>I am running a proprietary analysis package on top of SQL Server that
>requires that a TCP/IP connection. I will never connect to SQL Server
>remotely, so I would like to avoid having SQL Server listen for
>connections on my network adapter.
>I am running SQL Server Personal Edition on Windows 200 SP4.
>Any thoughts on how to set this up?
>Thanks,
>Chris Green
>joeionnojitsu AT comcast.net

Getting Server name for Analysis Services 2005 Cube for use in SQL Reporting Services

Hi

We have been struggling getting the Servername to include on a SQL Reporting Services report. The Reporting server and the Analysis Services cube will not be on the same server, so the ReportURL option is not of much use to us. Is there any way of getting the servername where the cube is through a MDX Query. If this is not possible any other suggestions.

Andre

I am not sure I understand your scenario. The server name is specified in the data source. What exactly are you trying to do and what's ReportURL option?|||

I will try to make it clearer.

Our datasource for Reporting services is an Analysis Services Cube. We want to get the servername of the datasouce (or cube) and use it in the report - in a textbox which is part of a table or Matrix. Note the reporting server and Cube may or may not be on the same server as we are rolling this out to a variety of clients.

How do we retrieve the actual servername itself to use in the report. 2 of us have been searching and have not come up with anything as yet.

Andre

|||

Not that easy. Two options come to mind:

1. Use an expression-based connection string (works with a private data sources only) and store the server name in the Report Server web.config file. This sample demonstrates this scenario.

2. Write .NET code in an exernal assembly that retrieves the data source info for the report by calling GetDataSourceContents API.

Getting Server name for Analysis Services 2005 Cube for use in SQL Reporting Services

Hi

We have been struggling getting the Servername to include on a SQL Reporting Services report. The Reporting server and the Analysis Services cube will not be on the same server, so the ReportURL option is not of much use to us. Is there any way of getting the servername where the cube is through a MDX Query. If this is not possible any other suggestions.

Andre

I am not sure I understand your scenario. The server name is specified in the data source. What exactly are you trying to do and what's ReportURL option?|||

I will try to make it clearer.

Our datasource for Reporting services is an Analysis Services Cube. We want to get the servername of the datasouce (or cube) and use it in the report - in a textbox which is part of a table or Matrix. Note the reporting server and Cube may or may not be on the same server as we are rolling this out to a variety of clients.

How do we retrieve the actual servername itself to use in the report. 2 of us have been searching and have not come up with anything as yet.

Andre

|||

Not that easy. Two options come to mind:

1. Use an expression-based connection string (works with a private data sources only) and store the server name in the Report Server web.config file. This sample demonstrates this scenario.

2. Write .NET code in an exernal assembly that retrieves the data source info for the report by calling GetDataSourceContents API.

Getting error while using CREATE GLOBAL CUBE

Hi,

I am getting this following error while trying to create a local cube using CREATE GLOBAL CUBE stmt:

[ 1] Microsoft? OLE DB Provider for Analysis : Data source provider error.
[ 2] Microsoft? OLE DB Provider for Analysis : One or more errors occurred during processing of command.
[ 3] Microsoft? OLE DB Provider for Analysis : Column expression associated with level '_TemplateLevel' is not found

The MDX stmt used is:

CREATE GLOBAL CUBE

---

STORAGE 'D:\Codes\PPlay1.cub'
FROM

---

(
MEASURE

---

.[Org Salary],
MEASURE

---

.[Count],
DIMENSION

---

.[Store]
(
LEVEL [Store Country],
LEVEL [Store State],
LEVEL [Store City],
LEVEL [Store Name],
MEMBER [Store].[Store Country].&[USA]
),
DIMENSION

---

.[Time]
(
LEVEL [Year],
LEVEL [Quarter],
LEVEL [Month]
),
DIMENSION

---

.[Employees]
(
LEVEL [CEO],
LEVEL [Senior Management],
LEVEL [Level],
LEVEL [Level 01],
LEVEL [Level 02],
LEVEL [Level 03],
LEVEL [Level 04]
),
DIMENSION

---

.[Department]
(
LEVEL [Department Description]
),
DIMENSION

---

.[Position]
(
LEVEL [Management Role],
LEVEL [Position Title]
),
DIMENSION

---

.[Store Type]
(
LEVEL [Store Type]
),
DIMENSION

---

.[Pay Type]
(
LEVEL [Pay Type]
)
)

While trying to run this MDX stmt directly in MDX Query appln, i can see an error message saying "Unable to open cellset"

Any pointers to this would be highly appreciated.

Thanks in advance.
Santosh.

On further debugging found following error being thrown:

Errors in the metadata manager. The 'Level 4' source attribute ID of the 'Level 4' level does not correspond to an existing attribute in the dimension.

And when i remove all levels from the Employee dimension, it works:

CREATE GLOBAL CUBE

---

STORAGE 'D:\Codes\PPlay1.cub'
FROM

---

(
MEASURE

---

.[Org Salary],
MEASURE

---

.[Count],
DIMENSION

---

.[Store]
(
LEVEL [Store Country],
LEVEL [Store State],
LEVEL [Store City],
LEVEL [Store Name],
MEMBER [Store].[Store Country].&[USA]
),
DIMENSION

---

.[Time]
(
LEVEL [Year],
LEVEL [Quarter],
LEVEL [Month]
),
DIMENSION

---

.[Employees],
DIMENSION

---

.[Department]
(
LEVEL [Department Description]
),
DIMENSION

---

.[Position]
(
LEVEL [Management Role],
LEVEL [Position Title]
),
DIMENSION

---

.[Store Type]
(
LEVEL [Store Type]
),
DIMENSION

---

.[Pay Type]
(
LEVEL [Pay Type]
)
)

But not sure, why is this happening...Any known issues?

Thanks,
Santosh