can we connect?

can we connect named instance through IP like in the network utility I just
defined the IP of the server where the named instance installed and define
the port...
Client Netowork Utility > Alias >
Alias: MyServer
Server: 209.45.23.55
Port : 1434
Protocol: TCP/IP
any thing else I need to do for connecting this... I did the above stuff but
I had failed to connect but why I can connect the default instance... please
guide me..
Thanks and I would highly appreciate if your prompt reply
thanks and have a great day
Hi,
Open the SQL Server error log under the folder
SQL_Server_installation_path>X\MSSQL$instance_name \LOG folder to make sure
that the SQL Server named instance runs well and to find the TCP port which
this named instance is listening.
As well as using Server network utility verify TCP/IP protocol is enabled.
Get the SQL Server name from Error log and use that name to connect from
query analyzer
Thanks
Hari
SQL Server MVP
"Rogers" <Rogers@.discussions.microsoft.com> wrote in message
news:DC15100C-5AC0-4C51-9CA3-8527DBF3DC23@.microsoft.com...
> can we connect named instance through IP like in the network utility I
> just
> defined the IP of the server where the named instance installed and define
> the port...
> Client Netowork Utility > Alias >
> Alias: MyServer
> Server: 209.45.23.55
> Port : 1434
> Protocol: TCP/IP
> any thing else I need to do for connecting this... I did the above stuff
> but
> I had failed to connect but why I can connect the default instance...
> please
> guide me..
> Thanks and I would highly appreciate if your prompt reply
> thanks and have a great day
>
|||First of all Hari, thanks for your reply... I can easily connect the named
instance on that same machine ... I am trying to connect that named instance
through my client machine and facing this problem...
"Hari Prasad" wrote:

> Hi,
> Open the SQL Server error log under the folder
> SQL_Server_installation_path>X\MSSQL$instance_nam e\LOG folder to make sure
> that the SQL Server named instance runs well and to find the TCP port which
> this named instance is listening.
> As well as using Server network utility verify TCP/IP protocol is enabled.
> Get the SQL Server name from Error log and use that name to connect from
> query analyzer
> Thanks
> Hari
> SQL Server MVP
>
> "Rogers" <Rogers@.discussions.microsoft.com> wrote in message
> news:DC15100C-5AC0-4C51-9CA3-8527DBF3DC23@.microsoft.com...
>
>

Can someone help explain?

Hi,

I am working with several tables, but for now I just mention 4 : one is fact table (named Usage), and 3 dimensional tables Periods, Products, and Regions. The fact table contains references to the dimensional tables. Table Periods contain two other columns month and year.

I created a cube containing columns from those 4 tables. Deployment was successful. Trouble comes when I want to create a mining structure using Time Series containing these columns :

- Period
- Amount (of money)
- Product name
- Region name

When I choose to use cube (instead of table) as source for mining structure, I'm forced to choose only one dimension (among the Periods, Products, and Regions). Whatever dimension I choose I end up being unable to use the column period as the Time-Key column. Effectively I cannot use Time Series method since I cannot use the column period.

(1) Why is this so [why Visual Studio forced us to use only one dimension from the cube] ?
(2) Why Visual Studio eliminates the column period, column that has relationship with the
time dimension?
(3) What is the use of Cube anyway to the mining? Is there still any use for it?
(4) What is the solution to that kind of problem I face?

Thank you,

Bernaridho
Dear all,

I have not received any answer why can I use only one dimension when using a cube to mine data. Can someone help explain please? The details are ini my previous posting.

Thank you,

Bernaridho
|||

#1. The current design on OLAP-based mining structures requires that case-level columns be member properties of the key - this is a strict way of making sure that the attributes refer to the same entity (the case) and the requirement is met if all the case columns come from the same dimension.

#2. The data mining engine does not have time intelligence in terms of recognizing the special status of the time dimension so unless there is explicit relationship through inclusion of the case dimension and time dimension in a measuregroup, the dimension cannot be included (as a nested table).

#3. Building mining models on top of cubes is useful when you already have the data in that form (and you don't want to or don't have access to the source data) and also for applying the results of data mining back to the cube to slice/dice the fact data with the hierarchies discovered by the model. For instance, you could build a cluster model and slice your facts by the clusters.

#4. In your case, it might be better to build your time series model directly on the source (relational) data since you will have much more flexibility in that case.

|||

You can also use DMX to create the models. DMX allows the form

INSERT INTO <mining model>(<columns>)

<MDX statement>

In this form it uses the flattening semantics of MDX to populate the mining model. This way you can create any arbitrary dataset as input into the mining model.

|||Are there any more details to this question?

Can one instance listen on multi IP Addresses?

Hi Everybody,
Is it possible to configure one virtual SQL server named instance to listen
on multi IP Address those additional IP Addresses associate with different
virtual SQL network name?
At the result like for example: SQL Server 2005 EE installed on (Windows
2003 64 bit OS cluster server) named instance SQL-V01\test1, it listen on IP
172.11.1.10. And it also should listens on IP 172.11.1.11, virtual network
name is SQL-V02\test1 as well as IP 172.11.1.12, virtual network name is
SQL-V03\test1.
Regards!
-Chen
You can indeed add extra IPs. We do it to add a backup network into the mix,
works great.
Now for the extra network name, you can add a name but I honestly don't know
how SQL will answer on it. SQL is configured for only one.
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"Chen" <Chen@.discussions.microsoft.com> wrote in message
news:E8A70912-0AAD-4E78-9F5A-2E32C7802D97@.microsoft.com...
> Hi Everybody,
> Is it possible to configure one virtual SQL server named instance to
> listen
> on multi IP Address those additional IP Addresses associate with different
> virtual SQL network name?
> At the result like for example: SQL Server 2005 EE installed on (Windows
> 2003 64 bit OS cluster server) named instance SQL-V01\test1, it listen on
> IP
> 172.11.1.10. And it also should listens on IP 172.11.1.11, virtual network
> name is SQL-V02\test1 as well as IP 172.11.1.12, virtual network name is
> SQL-V03\test1.
> Regards!
> -Chen
>
|||Thanks for quick response. Can you indicate some article I can follow to add
second IP Address in one instance?
"Rodney R. Fournier [MVP]" wrote:

> You can indeed add extra IPs. We do it to add a backup network into the mix,
> works great.
> Now for the extra network name, you can add a name but I honestly don't know
> how SQL will answer on it. SQL is configured for only one.
> Cheers,
> Rodney R. Fournier
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering Website
> http://msmvps.com/clustering - Blog
> http://www.clusterhelp.com - Cluster Training
> ClusterHelp.com is a Microsoft Certified Gold Partner
>
> "Chen" <Chen@.discussions.microsoft.com> wrote in message
> news:E8A70912-0AAD-4E78-9F5A-2E32C7802D97@.microsoft.com...
>
>
|||Right-click add resource. IP Address. Dependencies none. Then make the
network name for SQL dependent on it, if it's mission critical to also have
this second IP online.
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"Chen" <Chen@.discussions.microsoft.com> wrote in message
news:A214ED7F-C0A1-4D4A-A8B2-AB2FEFCFA6F3@.microsoft.com...[vbcol=seagreen]
> Thanks for quick response. Can you indicate some article I can follow to
> add
> second IP Address in one instance?
> "Rodney R. Fournier [MVP]" wrote:
|||It is much easier to set a network name at the DNS level rather than the
machine lever. Use a SRV record type in DNS to map a network name to an
IPaddress/port number combination.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:e9Kpm6V7GHA.4288@.TK2MSFTNGP02.phx.gbl...
> Right-click add resource. IP Address. Dependencies none. Then make the
> network name for SQL dependent on it, if it's mission critical to also
> have this second IP online.
> Cheers,
> Rodney R. Fournier
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering Website
> http://msmvps.com/clustering - Blog
> http://www.clusterhelp.com - Cluster Training
> ClusterHelp.com is a Microsoft Certified Gold Partner
>
> "Chen" <Chen@.discussions.microsoft.com> wrote in message
> news:A214ED7F-C0A1-4D4A-A8B2-AB2FEFCFA6F3@.microsoft.com...
>
|||Agreed! And not cause I know better then to ever disagree with you on SQL
matters
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:%23GVaS5W7GHA.728@.TK2MSFTNGP04.phx.gbl...
> It is much easier to set a network name at the DNS level rather than the
> machine lever. Use a SRV record type in DNS to map a network name to an
> IPaddress/port number combination.
>
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
> message news:e9Kpm6V7GHA.4288@.TK2MSFTNGP02.phx.gbl...
>