Please help - Named instances and full-text search

I asked this last week and no one replied :-(
i have a sql server 2000 default instance and i'm planning on adding
a sql server 2005 named
instance to the server. both will be using full text search. i
assume that each
instance should be assigned separate directories for their full text
catalog files?
Hi Derek
"Derek" wrote:

> I asked this last week and no one replied :-(
> i have a sql server 2000 default instance and i'm planning on adding
> a sql server 2005 named
> instance to the server. both will be using full text search. i
> assume that each
> instance should be assigned separate directories for their full text
> catalog files?
>
The location for the FTS catalogs can be specified using the ON PATH
parameter of the CREATE FULLTEXT CATALOG command
http://msdn2.microsoft.com/en-gb/library/ms189520.aspx
or by us filling in the Catalog location in the dialog presented on SSMS
http://msdn2.microsoft.com/en-us/library/ms183531.aspx
Each instance has it's own FTS service therefore they can be configured
separately.
http://msdn2.microsoft.com/en-us/library/ms142490.aspx
and (I believe) there is an option to specify the default directory during
setup.
John

Please help - Named instances and full-text search

I asked this last week and no one replied :-(
i have a sql server 2000 default instance and i'm planning on adding
a sql server 2005 named
instance to the server. both will be using full text search. i
assume that each
instance should be assigned separate directories for their full text
catalog files?Hi Derek
"Derek" wrote:

> I asked this last week and no one replied :-(
> i have a sql server 2000 default instance and i'm planning on adding
> a sql server 2005 named
> instance to the server. both will be using full text search. i
> assume that each
> instance should be assigned separate directories for their full text
> catalog files?
>
The location for the FTS catalogs can be specified using the ON PATH
parameter of the CREATE FULLTEXT CATALOG command
http://msdn2.microsoft.com/en-gb/library/ms189520.aspx
or by us filling in the Catalog location in the dialog presented on SSMS
http://msdn2.microsoft.com/en-us/library/ms183531.aspx
Each instance has it's own FTS service therefore they can be configured
separately.
http://msdn2.microsoft.com/en-us/library/ms142490.aspx
and (I believe) there is an option to specify the default directory during
setup.
Johnsql

Please help - Named instances and full-text search

I asked this last week and no one replied :-(
i have a sql server 2000 default instance and i'm planning on adding
a sql server 2005 named
instance to the server. both will be using full text search. i
assume that each
instance should be assigned separate directories for their full text
catalog files?Hi Derek
"Derek" wrote:
> I asked this last week and no one replied :-(
> i have a sql server 2000 default instance and i'm planning on adding
> a sql server 2005 named
> instance to the server. both will be using full text search. i
> assume that each
> instance should be assigned separate directories for their full text
> catalog files?
>
The location for the FTS catalogs can be specified using the ON PATH
parameter of the CREATE FULLTEXT CATALOG command
http://msdn2.microsoft.com/en-gb/library/ms189520.aspx
or by us filling in the Catalog location in the dialog presented on SSMS
http://msdn2.microsoft.com/en-us/library/ms183531.aspx
Each instance has it's own FTS service therefore they can be configured
separately.
http://msdn2.microsoft.com/en-us/library/ms142490.aspx
and (I believe) there is an option to specify the default directory during
setup.
John

Playing with Named Sets

Hi,

Considering these data, which shows turnover per Salesmen/region

SalesMan1

SalesMan2

SalesMan3

SalesMan4

A

20

30

45

65

B

40

60

90

135

C

45

65

100

150

D

30

45

70

105

E

50

75

115

150

F

15

25

40

60

I created different named sets such as :

CREATE SET CURRENTCUBE.[Without F Region]

AS {EXCEPT([Region].[Region Code].[All].Children,

[Region].[Region Code].&[F])};

CREATE SET CURRENTCUBE.[SalesMan1]

AS {EXCEPT([Sales Force].[SalesMan].[All].Children,

[Sales Force].[SalesMan].&[SalesMan1])};

Using those named sets I would like to define a measure that will show the turnover for region A B C D E and SalesMan1 ...

SalesMan1

SalesMan2

SalesMan3

SalesMan4

A

20

0

0

0

B

40

0

0

0

C

45

0

0

0

D

30

0

0

0

E

50

0

0

0

F

0

0

0

0

I tryed different syntax

SUM(([Without F Region],[SalesMan1]),[Turnover])

SUM(Crossjoin([Without F Region],[SalesMan1]),[Turnover])

but I cannot get it work. The total is correct, but using dimension, the result is not splited.

SalesMan1

SalesMan2

SalesMan3

SalesMan4

A

185

185

185

185

B

185

185

185

185

C

185

185

185

185

D

185

185

185

185

E

185

185

185

185

F

185

185

185

185

Any idea ?

Regards

Ayzan

The problem is that the named sets are evaluated before the context is set in the query.

If you are using AS2005 you could force the context to be re-evaluated with the EXISTING statement

eg

SUM(Crossjoin(EXISTING [Without F Region], EXISTING [SalesMan1]),[Turnover])

|||

Thank you for your reply.

It works perfectly.

Regards

Ayzan

PLASE HELP - remote connectivity to named instance of 2005

Hi all,
I just installed version 2005, and it is co-existing with
an instance of 2000. I am trying to test the remote connection string from
an ASP .Net page which works fine already in 2000. However it does not work
in 2005.
In 2005, I went to configuration Manager/Protocols/TCP IP, and entered 7544
as the default port, and for port value in IP1, IP2, and IP3. Then, in my
connection string I just included the port number, and changed the
databasename to point to 'AdventureWorks' instead of the DB that I used for
2K. The connection could not be openned. I also configured the user id, and
password the same way as I have in 2K, and re-started the engine.
This is a sample of my connection string:
this.sqlConnection1.ConnectionString =
"Server=xxx.xx.xx.xx\\<myNamedServerInstance>,7544;Database=AdventureWorks;U
ser
ID=myUID;Password=myPWD;Trusted_Connecti
on=True";
I tested the local connection to this server/Database, and it works fine,
however, there is a problem with the remote connection.
Any help will be appreciated.
Thanks in advance,
CarlosNever mind.. I got it Thanks.
"Carlos" <chsanin@.earthlink.net> wrote in message
news:uaKDKFB5FHA.2560@.TK2MSFTNGP12.phx.gbl...
> Hi all,
> I just installed version 2005, and it is co-existing with
> an instance of 2000. I am trying to test the remote connection string from
> an ASP .Net page which works fine already in 2000. However it does not
> work in 2005.
> In 2005, I went to configuration Manager/Protocols/TCP IP, and entered
> 7544 as the default port, and for port value in IP1, IP2, and IP3. Then,
> in my connection string I just included the port number, and changed the
> databasename to point to 'AdventureWorks' instead of the DB that I used
> for 2K. The connection could not be openned. I also configured the user
> id, and password the same way as I have in 2K, and re-started the engine.
> This is a sample of my connection string:
> this.sqlConnection1.ConnectionString =
> "Server=xxx.xx.xx.xx\\<myNamedServerInstance>,7544;Database=AdventureWorks
;User
> ID=myUID;Password=myPWD;Trusted_Connecti
on=True";
> I tested the local connection to this server/Database, and it works fine,
> however, there is a problem with the remote connection.
> Any help will be appreciated.
> Thanks in advance,
> Carlos
>

PLASE HELP - remote connectivity to named instance of 2005

Hi all,
I just installed version 2005, and it is co-existing with
an instance of 2000. I am trying to test the remote connection string from
an ASP .Net page which works fine already in 2000. However it does not work
in 2005.
In 2005, I went to configuration Manager/Protocols/TCP IP, and entered 7544
as the default port, and for port value in IP1, IP2, and IP3. Then, in my
connection string I just included the port number, and changed the
databasename to point to 'AdventureWorks' instead of the DB that I used for
2K. The connection could not be openned. I also configured the user id, and
password the same way as I have in 2K, and re-started the engine.
This is a sample of my connection string:
this.sqlConnection1.ConnectionString =
"Server=xxx.xx.xx.xx\\<myNamedServerInstance>,7544 ;Database=AdventureWorks;User
ID=myUID;Password=myPWD;Trusted_Connection=True";
I tested the local connection to this server/Database, and it works fine,
however, there is a problem with the remote connection.
Any help will be appreciated.
Thanks in advance,
Carlos
Never mind.. I got it Thanks.
"Carlos" <chsanin@.earthlink.net> wrote in message
news:uaKDKFB5FHA.2560@.TK2MSFTNGP12.phx.gbl...
> Hi all,
> I just installed version 2005, and it is co-existing with
> an instance of 2000. I am trying to test the remote connection string from
> an ASP .Net page which works fine already in 2000. However it does not
> work in 2005.
> In 2005, I went to configuration Manager/Protocols/TCP IP, and entered
> 7544 as the default port, and for port value in IP1, IP2, and IP3. Then,
> in my connection string I just included the port number, and changed the
> databasename to point to 'AdventureWorks' instead of the DB that I used
> for 2K. The connection could not be openned. I also configured the user
> id, and password the same way as I have in 2K, and re-started the engine.
> This is a sample of my connection string:
> this.sqlConnection1.ConnectionString =
> "Server=xxx.xx.xx.xx\\<myNamedServerInstance>,7544 ;Database=AdventureWorks;User
> ID=myUID;Password=myPWD;Trusted_Connection=True";
> I tested the local connection to this server/Database, and it works fine,
> however, there is a problem with the remote connection.
> Any help will be appreciated.
> Thanks in advance,
> Carlos
>