Can I Have Link Between Several servers

hello all

I have a web application(asp.net) and Database(sql server 2005) .

we have installed them on several servers.

now we want to have a connection between apllication on one server to a database on another server .

for example we have Server(A) and Server(B) the DataBases and Web apllications on two server are the same.

sometimes the Apllication on server(A) must connect to database on server(B).

whats the solution plz?

note that the number of servers can be inceased in the future this mean the number of servers are not fixed.

thanks

Use the function sp_linkedServer of the SQL to link the borh servers.

helped?

Regards

Can I Have link Between Several Servers

hello all

I have a web application(asp.net) and Database(sql server 2005) .

we have installed them on several servers.

now we want to have a connection between apllication on one server to a database on another server .

for example we have Server(A) and Server(B) the DataBases and Web apllications on two server are the same.

sometimes the Apllication on server(A) must connect to database on server(B).

whats the solution plz?

note that the number of servers can be inceased in the future this mean the number of servers are not fixed.

thanks

Not sure I follow -- do you mean you have 2 different database serves that should mirror each other, ie, the data is the same and updates on one should be mirrored on the other?

|||

You have a database in the server A .. connect to it by using ConnectionStringA , and any need data from Server B .. use another ConnectionString (e.g. ConnectionStringB).

So, in the web.config file you will have tow ConnectionStrings (A & B).. when to connect to the database in the same server use StringConnectionA and the other used to connect to the database in the another server (server B) - called ConnectionString B.

Good luck.

|||

thank you

for Contributor : i have defrerent data in each databas i cant use replication

for Participant : i must connect to different web server .

i get it that i must to use splinkserver to link servers

thanks forever.

Can I get a link to step-by-step MSDE install instrustions on WIN2

Hi All,
I new when it comes to MSDE but all I need to do is install it and setup an
ODBC data source for an application I run. It's on Windows 2003 Server and no
matter what I do I can't setup an ODBC connection using SQL authentication
because I get error 18456 all the time. I've granted my windows account login
access, the install is NOT set for windows authentication only, and TCP/IP is
enabled. I can login as sa from the command line but not through the ODBC
manager. I'm on about my 5th reinstall and have become very frustrated here.
Can some one point me in the right direction please?
Thanks
That error is a login failure, it surely doesn't help reinstalling. You need
permission to log into your SQL Server.
If you are member of the local administrators group, you shouldn't get this
error.
Other possibilities could be if you have semi-colon in your username (there
is a KB article on this).
Please use your full name when posting to these newsgroups.
Jon Jahren
"ComfortablySAD" <ComfortablySAD@.discussions.microsoft.com> wrote in message
news:D5C5E09E-BEE4-4BC9-A2E4-4E1BAEFB67BB@.microsoft.com...
> Hi All,
> I new when it comes to MSDE but all I need to do is install it and setup
an
> ODBC data source for an application I run. It's on Windows 2003 Server and
no
> matter what I do I can't setup an ODBC connection using SQL authentication
> because I get error 18456 all the time. I've granted my windows account
login
> access, the install is NOT set for windows authentication only, and TCP/IP
is
> enabled. I can login as sa from the command line but not through the ODBC
> manager. I'm on about my 5th reinstall and have become very frustrated
here.
> Can some one point me in the right direction please?
> Thanks

Can I add a link in a users "My Reports" to a report on a different report server?

We are in the process of commissioning a new reporting server. In the interim, I want to be able to update/modify reports and publish to one location only, and publish links to the users "My Reports" on the old server. Any ideas folks?

Report Manager only talks to a single server, so you can't mix reports from one server with another.

A quick workaround would be to upload an HTML file as a resource into the user's My Reports folder which redirects them to the new server.

Can Fact table link to more than 16 dimensions?

Hi,

I am new to building cubes. I am trying to build a cube which includes:

7 database dimensions

22 cube dimensions (19 cube dimensions are liked to 4 table dimensions)

The problem is when I try to make the PK of the fact table to include the 22 fields I receive an error that the PK cannot be more than 16 fields. What should I do?

Thanks in advance,

Aref

It is a bit strange design. You should not have that many cube dimensions in you only have 7 database dimensions.

Make sure you take a look at the AdventureWorks sample database for example of how to build your cube.

Going through tutorial is also a good idea.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

I might be wrong. But I have 6 date cube dimensions which I relate to one date database dimension.

Aref

|||

Do you have all 6 columns in your fact table so you can relate Date dimension to your Measure Group?

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Yes I have the 6 cube dimension fields in my fact table. But what I know about star schema fact tables is that all dimension fields should be PK. Am I wrong?

|||

You are correct. That is the recommendation in most cases.

I dont think you should try and create a single PK including 6 columns. You can create 6 separate PK's.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

But these 6 columns are only part of the 22 dimension fields that I have.

I am thinking of creating another table that holds all the possible combination of these multiple dimensions related to one database dimensions the use then use the PK of that combination as a single dimension field in my fact table then use a view to represent my fact table and the dates combinations table in the cube.

Do you think that's a good way to solve the issue or you have better suggestions?

Thanks,

Aref

|||

Take a look at the AdventureWorks sample database and see how it implements Date dimension.

It is single dimension in the database but included 3 times in the cube. Every time it is playing different role Date, ShipDate, DeliveryDate.

If you look at the way relationship between FactSalesSummary table and DimTime table are defined you would see 3 FK- PK relationships.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

That's what I have so far, but the problem if I want to include every cube dimension in a PK FK relation I need to have a number of PK fields equal to my cube dimensions = 22 fields which violate the SQL Server 2005 limitation of number of fields in a PK.

Please Help!

Aref

|||

Are you trying to create a single PK with 22 fields or 22 distinct PK's?

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

I don't know what is the difference. I want to define 22 fields in my fact table to be the PK for this table. In Star schema I gather all the PKs of the cube dimensions to be the PK of my fact table. Right?

Calling UDF over Server Link

For some reason, over a server link, the following call to a UDF on a linked server does not work, it seems it is treating the UDF as a table.

The same UDF called on the local server works fine.

--call/select from function
SELECT
MASTERID
FROM
PAUL.RISK_DB.dbo.FNTRADEFILEPRICE('10/2/2006')

error:
Server: Msg 170, Level 15, State 31, Line 5
Line 5: Incorrect syntax near '('.

Thanks.I created a sproc that calls the function, works like a charm. Still does not expain why calling the function natively from a remote server does not work, this is a work-around though.

Thanks,
Schmed.