Does it matter what version of Office is installed on the clients
machine for opening reports generated by reporting Services?
The reason I am asking is because our users are getting an office
upgrade from 2000 to XP on their machines.No, it does not matter.
"Amit" <amit.gaind@.gmail.com> wrote in message
news:1174400171.358992.243630@.l75g2000hse.googlegroups.com...
> Does it matter what version of Office is installed on the clients
> machine for opening reports generated by reporting Services?
> The reason I am asking is because our users are getting an office
> upgrade from 2000 to XP on their machines.
>|||On Mar 20, 10:42 am, "Norman Yuan" <NotR...@.NotReal.not> wrote:
> No, it does not matter.
> "Amit" <amit.ga...@.gmail.com> wrote in message
> news:1174400171.358992.243630@.l75g2000hse.googlegroups.com...
>
> > Does it matter what version of Office is installed on the clients
> > machine for opening reports generated by reporting Services?
> > The reason I am asking is because our users are getting an office
> > upgrade from 2000 to XP on their machines.- Hide quoted text -
> - Show quoted text -
thank you.
Showing posts with label clients. Show all posts
Showing posts with label clients. Show all posts
Wednesday, March 28, 2012
Friday, March 23, 2012
Newbie question
Hi All,
Is it possible to store tables (in general database objects) in SQL clients and access it from the SQL server?
Thanks
Eva
What are you trying to accomplish?
"Eva" <anonymous@.discussions.microsoft.com> wrote in message
news:2C3CCA52-4F57-409A-A331-4BFC9001F773@.microsoft.com...
> Hi All,
> Is it possible to store tables (in general database objects) in SQL
clients and access it from the SQL server?
> Thanks
>
|||I am designing a system in which there are about 50 computers containing region-wise data in tables. The tables in different regions have same structure but the data is region-specific. I need to transfer data from the tables in each region to a server. T
he problem is that I cannot have 50 SQL servers installations. I am looking for a work around. Can you suggest what should be done?
Thanks.
|||Eva
REPLICATION is what you need.
http://www.swynk.com/friends/achigrik/SetupMR.asp -- Setting Up Merge
Replication: A Step by Step Guide
http://www.mssqlcity.com/Articles/Replic/Replic.htm --Setting All
Replica (Step by step)
"Eva" <anonymous@.discussions.microsoft.com> wrote in message
news:F851497F-8B3B-4A3C-9482-97B5F0B75410@.microsoft.com...
> I am designing a system in which there are about 50 computers containing
region-wise data in tables. The tables in different regions have same
structure but the data is region-specific. I need to transfer data from the
tables in each region to a server. The problem is that I cannot have 50 SQL
servers installations. I am looking for a work around. Can you suggest what
should be done?
> Thanks.
|||Thanks Uri.
Yes, I could have the 50 computers set up as publishers and the server as a subscriber. But, what I understand of Publishers is that they have to be SQL servers!
|||Eva
How do they store the data? With text files?
Do they have an application (vb,c) which can connect to the main server?
"Eva" <anonymous@.discussions.microsoft.com> wrote in message
news:A89D4478-7858-493C-BD95-607A710004B3@.microsoft.com...
> Thanks Uri.
> Yes, I could have the 50 computers set up as publishers and the server as
a subscriber. But, what I understand of Publishers is that they have to be
SQL servers!
|||Data is stored in SQL tables. There is an application running on the server which accesses the tables in each of the 50 machines and fetches data from them!
|||Eva
Have you looked at DTS utility?
"Eva" <anonymous@.discussions.microsoft.com> wrote in message
news:4F67F94C-FFC2-4CB9-8ADB-2C66E427EA8C@.microsoft.com...
> Data is stored in SQL tables. There is an application running on the
server which accesses the tables in each of the 50 machines and fetches data
from them!
|||Merge replication would seem to fit the bill here. In merge the publisher/subscriber metaphore doesn't really hold, so in your case you'd have a central publisher and 50 subscribers. The subscribers don't need to be sql server - they could heterogenous eg
Access. I'm not sure from your post if you have the option of setting up the 50 subscriber's repositories. If so, then you could use MSDE.
Regards,
Paul Ibison
|||Eva,
When you say "SQL Tables" do you mean tables in a SQL Server database? Or is
it in another RDBMS?
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
"Eva" <anonymous@.discussions.microsoft.com> wrote in message
news:4F67F94C-FFC2-4CB9-8ADB-2C66E427EA8C@.microsoft.com...
> Data is stored in SQL tables. There is an application running on the
server which accesses the tables in each of the 50 machines and fetches data
from them!
Is it possible to store tables (in general database objects) in SQL clients and access it from the SQL server?
Thanks
Eva
What are you trying to accomplish?
"Eva" <anonymous@.discussions.microsoft.com> wrote in message
news:2C3CCA52-4F57-409A-A331-4BFC9001F773@.microsoft.com...
> Hi All,
> Is it possible to store tables (in general database objects) in SQL
clients and access it from the SQL server?
> Thanks
>
|||I am designing a system in which there are about 50 computers containing region-wise data in tables. The tables in different regions have same structure but the data is region-specific. I need to transfer data from the tables in each region to a server. T
he problem is that I cannot have 50 SQL servers installations. I am looking for a work around. Can you suggest what should be done?
Thanks.
|||Eva
REPLICATION is what you need.
http://www.swynk.com/friends/achigrik/SetupMR.asp -- Setting Up Merge
Replication: A Step by Step Guide
http://www.mssqlcity.com/Articles/Replic/Replic.htm --Setting All
Replica (Step by step)
"Eva" <anonymous@.discussions.microsoft.com> wrote in message
news:F851497F-8B3B-4A3C-9482-97B5F0B75410@.microsoft.com...
> I am designing a system in which there are about 50 computers containing
region-wise data in tables. The tables in different regions have same
structure but the data is region-specific. I need to transfer data from the
tables in each region to a server. The problem is that I cannot have 50 SQL
servers installations. I am looking for a work around. Can you suggest what
should be done?
> Thanks.
|||Thanks Uri.
Yes, I could have the 50 computers set up as publishers and the server as a subscriber. But, what I understand of Publishers is that they have to be SQL servers!
|||Eva
How do they store the data? With text files?
Do they have an application (vb,c) which can connect to the main server?
"Eva" <anonymous@.discussions.microsoft.com> wrote in message
news:A89D4478-7858-493C-BD95-607A710004B3@.microsoft.com...
> Thanks Uri.
> Yes, I could have the 50 computers set up as publishers and the server as
a subscriber. But, what I understand of Publishers is that they have to be
SQL servers!
|||Data is stored in SQL tables. There is an application running on the server which accesses the tables in each of the 50 machines and fetches data from them!
|||Eva
Have you looked at DTS utility?
"Eva" <anonymous@.discussions.microsoft.com> wrote in message
news:4F67F94C-FFC2-4CB9-8ADB-2C66E427EA8C@.microsoft.com...
> Data is stored in SQL tables. There is an application running on the
server which accesses the tables in each of the 50 machines and fetches data
from them!
|||Merge replication would seem to fit the bill here. In merge the publisher/subscriber metaphore doesn't really hold, so in your case you'd have a central publisher and 50 subscribers. The subscribers don't need to be sql server - they could heterogenous eg
Access. I'm not sure from your post if you have the option of setting up the 50 subscriber's repositories. If so, then you could use MSDE.
Regards,
Paul Ibison
|||Eva,
When you say "SQL Tables" do you mean tables in a SQL Server database? Or is
it in another RDBMS?
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
"Eva" <anonymous@.discussions.microsoft.com> wrote in message
news:4F67F94C-FFC2-4CB9-8ADB-2C66E427EA8C@.microsoft.com...
> Data is stored in SQL tables. There is an application running on the
server which accesses the tables in each of the 50 machines and fetches data
from them!
newbie question
Hi,
i'm kinda new to Microsoft SQL Server. I've just finished my first
install. Now i want to be able to connect macintosh clients to the
server. I'm able to connect using windows 2000 authentification but not
with SQL Server authentification (in mixed mode).
When using "Aqua Data Studio" on my mac, when i try to connect using
the "sa" account it fails because "the connection is not associated to
a secure SQL Server connection".
How can i establish such a secured connection ?
Thanks in advance,
Pierre
When you're connecting to SQL server with sa user you are trying to
authenticate with SQL authentication.
That means that you have to set a mixed mode on the server. Then you'll be
able to connect with sa user.
Secure SQL Server connection error you're getting means that you should use
Windows account to log to SQL Server.
Danijel
"Pierre Chatel" <admin@.chatelp.org> wrote in message
news:2005011413034716807%admin@.chatelporg...
> Hi,
> i'm kinda new to Microsoft SQL Server. I've just finished my first
> install. Now i want to be able to connect macintosh clients to the server.
> I'm able to connect using windows 2000 authentification but not with SQL
> Server authentification (in mixed mode).
> When using "Aqua Data Studio" on my mac, when i try to connect using the
> "sa" account it fails because "the connection is not associated to a
> secure SQL Server connection".
> How can i establish such a secured connection ?
> Thanks in advance,
> Pierre
>
i'm kinda new to Microsoft SQL Server. I've just finished my first
install. Now i want to be able to connect macintosh clients to the
server. I'm able to connect using windows 2000 authentification but not
with SQL Server authentification (in mixed mode).
When using "Aqua Data Studio" on my mac, when i try to connect using
the "sa" account it fails because "the connection is not associated to
a secure SQL Server connection".
How can i establish such a secured connection ?
Thanks in advance,
Pierre
When you're connecting to SQL server with sa user you are trying to
authenticate with SQL authentication.
That means that you have to set a mixed mode on the server. Then you'll be
able to connect with sa user.
Secure SQL Server connection error you're getting means that you should use
Windows account to log to SQL Server.
Danijel
"Pierre Chatel" <admin@.chatelp.org> wrote in message
news:2005011413034716807%admin@.chatelporg...
> Hi,
> i'm kinda new to Microsoft SQL Server. I've just finished my first
> install. Now i want to be able to connect macintosh clients to the server.
> I'm able to connect using windows 2000 authentification but not with SQL
> Server authentification (in mixed mode).
> When using "Aqua Data Studio" on my mac, when i try to connect using the
> "sa" account it fails because "the connection is not associated to a
> secure SQL Server connection".
> How can i establish such a secured connection ?
> Thanks in advance,
> Pierre
>
Newbie question
Hi All,
Is it possible to store tables (in general database objects) in SQL clients
and access it from the SQL server?
ThanksEva
What are you trying to accomplish?
"Eva" <anonymous@.discussions.microsoft.com> wrote in message
news:2C3CCA52-4F57-409A-A331-4BFC9001F773@.microsoft.com...
> Hi All,
> Is it possible to store tables (in general database objects) in SQL
clients and access it from the SQL server?
> Thanks
>|||I am designing a system in which there are about 50 computers containing reg
ion-wise data in tables. The tables in different regions have same structure
but the data is region-specific. I need to transfer data from the tables in
each region to a server. T
he problem is that I cannot have 50 SQL servers installations. I am looking
for a work around. Can you suggest what should be done?
Thanks.|||Eva
REPLICATION is what you need.
http://www.swynk.com/friends/achigrik/SetupMR.asp -- Setting Up Merge
Replication: A Step by Step Guide
http://www.mssqlcity.com/Articles/Replic/Replic.htm --Setting All
Replica (Step by step)
"Eva" <anonymous@.discussions.microsoft.com> wrote in message
news:F851497F-8B3B-4A3C-9482-97B5F0B75410@.microsoft.com...
> I am designing a system in which there are about 50 computers containing
region-wise data in tables. The tables in different regions have same
structure but the data is region-specific. I need to transfer data from the
tables in each region to a server. The problem is that I cannot have 50 SQL
servers installations. I am looking for a work around. Can you suggest what
should be done?
> Thanks.|||Thanks Uri.
Yes, I could have the 50 computers set up as publishers and the server as a
subscriber. But, what I understand of Publishers is that they have to be SQL
servers!|||Eva
How do they store the data? With text files?
Do they have an application (vb,c) which can connect to the main server?
"Eva" <anonymous@.discussions.microsoft.com> wrote in message
news:A89D4478-7858-493C-BD95-607A710004B3@.microsoft.com...
> Thanks Uri.
> Yes, I could have the 50 computers set up as publishers and the server as
a subscriber. But, what I understand of Publishers is that they have to be
SQL servers!|||Data is stored in SQL tables. There is an application running on the server
which accesses the tables in each of the 50 machines and fetches data from t
hem!|||Eva
Have you looked at DTS utility?
"Eva" <anonymous@.discussions.microsoft.com> wrote in message
news:4F67F94C-FFC2-4CB9-8ADB-2C66E427EA8C@.microsoft.com...
> Data is stored in SQL tables. There is an application running on the
server which accesses the tables in each of the 50 machines and fetches data
from them!|||Merge replication would seem to fit the bill here. In merge the publisher/su
bscriber metaphore doesn't really hold, so in your case you'd have a central
publisher and 50 subscribers. The subscribers don't need to be sql server -
they could heterogenous eg
Access. I'm not sure from your post if you have the option of setting up the
50 subscriber's repositories. If so, then you could use MSDE.
Regards,
Paul Ibison|||Eva,
When you say "SQL Tables" do you mean tables in a SQL Server database? Or is
it in another RDBMS?
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
"Eva" <anonymous@.discussions.microsoft.com> wrote in message
news:4F67F94C-FFC2-4CB9-8ADB-2C66E427EA8C@.microsoft.com...
> Data is stored in SQL tables. There is an application running on the
server which accesses the tables in each of the 50 machines and fetches data
from them!
Is it possible to store tables (in general database objects) in SQL clients
and access it from the SQL server?
ThanksEva
What are you trying to accomplish?
"Eva" <anonymous@.discussions.microsoft.com> wrote in message
news:2C3CCA52-4F57-409A-A331-4BFC9001F773@.microsoft.com...
> Hi All,
> Is it possible to store tables (in general database objects) in SQL
clients and access it from the SQL server?
> Thanks
>|||I am designing a system in which there are about 50 computers containing reg
ion-wise data in tables. The tables in different regions have same structure
but the data is region-specific. I need to transfer data from the tables in
each region to a server. T
he problem is that I cannot have 50 SQL servers installations. I am looking
for a work around. Can you suggest what should be done?
Thanks.|||Eva
REPLICATION is what you need.
http://www.swynk.com/friends/achigrik/SetupMR.asp -- Setting Up Merge
Replication: A Step by Step Guide
http://www.mssqlcity.com/Articles/Replic/Replic.htm --Setting All
Replica (Step by step)
"Eva" <anonymous@.discussions.microsoft.com> wrote in message
news:F851497F-8B3B-4A3C-9482-97B5F0B75410@.microsoft.com...
> I am designing a system in which there are about 50 computers containing
region-wise data in tables. The tables in different regions have same
structure but the data is region-specific. I need to transfer data from the
tables in each region to a server. The problem is that I cannot have 50 SQL
servers installations. I am looking for a work around. Can you suggest what
should be done?
> Thanks.|||Thanks Uri.
Yes, I could have the 50 computers set up as publishers and the server as a
subscriber. But, what I understand of Publishers is that they have to be SQL
servers!|||Eva
How do they store the data? With text files?
Do they have an application (vb,c) which can connect to the main server?
"Eva" <anonymous@.discussions.microsoft.com> wrote in message
news:A89D4478-7858-493C-BD95-607A710004B3@.microsoft.com...
> Thanks Uri.
> Yes, I could have the 50 computers set up as publishers and the server as
a subscriber. But, what I understand of Publishers is that they have to be
SQL servers!|||Data is stored in SQL tables. There is an application running on the server
which accesses the tables in each of the 50 machines and fetches data from t
hem!|||Eva
Have you looked at DTS utility?
"Eva" <anonymous@.discussions.microsoft.com> wrote in message
news:4F67F94C-FFC2-4CB9-8ADB-2C66E427EA8C@.microsoft.com...
> Data is stored in SQL tables. There is an application running on the
server which accesses the tables in each of the 50 machines and fetches data
from them!|||Merge replication would seem to fit the bill here. In merge the publisher/su
bscriber metaphore doesn't really hold, so in your case you'd have a central
publisher and 50 subscribers. The subscribers don't need to be sql server -
they could heterogenous eg
Access. I'm not sure from your post if you have the option of setting up the
50 subscriber's repositories. If so, then you could use MSDE.
Regards,
Paul Ibison|||Eva,
When you say "SQL Tables" do you mean tables in a SQL Server database? Or is
it in another RDBMS?
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
"Eva" <anonymous@.discussions.microsoft.com> wrote in message
news:4F67F94C-FFC2-4CB9-8ADB-2C66E427EA8C@.microsoft.com...
> Data is stored in SQL tables. There is an application running on the
server which accesses the tables in each of the 50 machines and fetches data
from them!
newbie question
Hi,
i'm kinda new to Microsoft SQL Server. I've just finished my first
install. Now i want to be able to connect macintosh clients to the
server. I'm able to connect using Windows 2000 authentification but not
with SQL Server authentification (in mixed mode).
When using "Aqua Data Studio" on my mac, when i try to connect using
the "sa" account it fails because "the connection is not associated to
a secure SQL Server connection".
How can i establish such a secured connection '
Thanks in advance,
PierreWhen you're connecting to SQL server with sa user you are trying to
authenticate with SQL authentication.
That means that you have to set a mixed mode on the server. Then you'll be
able to connect with sa user.
Secure SQL Server connection error you're getting means that you should use
Windows account to log to SQL Server.
Danijel
"Pierre Chatel" <admin@.chatelp.org> wrote in message
news:2005011413034716807%admin@.chatelpor
g...
> Hi,
> i'm kinda new to Microsoft SQL Server. I've just finished my first
> install. Now i want to be able to connect macintosh clients to the server.
> I'm able to connect using Windows 2000 authentification but not with SQL
> Server authentification (in mixed mode).
> When using "Aqua Data Studio" on my mac, when i try to connect using the
> "sa" account it fails because "the connection is not associated to a
> secure SQL Server connection".
> How can i establish such a secured connection '
> Thanks in advance,
> Pierre
>
i'm kinda new to Microsoft SQL Server. I've just finished my first
install. Now i want to be able to connect macintosh clients to the
server. I'm able to connect using Windows 2000 authentification but not
with SQL Server authentification (in mixed mode).
When using "Aqua Data Studio" on my mac, when i try to connect using
the "sa" account it fails because "the connection is not associated to
a secure SQL Server connection".
How can i establish such a secured connection '
Thanks in advance,
PierreWhen you're connecting to SQL server with sa user you are trying to
authenticate with SQL authentication.
That means that you have to set a mixed mode on the server. Then you'll be
able to connect with sa user.
Secure SQL Server connection error you're getting means that you should use
Windows account to log to SQL Server.
Danijel
"Pierre Chatel" <admin@.chatelp.org> wrote in message
news:2005011413034716807%admin@.chatelpor
g...
> Hi,
> i'm kinda new to Microsoft SQL Server. I've just finished my first
> install. Now i want to be able to connect macintosh clients to the server.
> I'm able to connect using Windows 2000 authentification but not with SQL
> Server authentification (in mixed mode).
> When using "Aqua Data Studio" on my mac, when i try to connect using the
> "sa" account it fails because "the connection is not associated to a
> secure SQL Server connection".
> How can i establish such a secured connection '
> Thanks in advance,
> Pierre
>
Wednesday, March 21, 2012
Newbie question
Hi All
Is it possible to store tables (in general database objects) in SQL clients and access it from the SQL server
ThankEva
What are you trying to accomplish?
"Eva" <anonymous@.discussions.microsoft.com> wrote in message
news:2C3CCA52-4F57-409A-A331-4BFC9001F773@.microsoft.com...
> Hi All,
> Is it possible to store tables (in general database objects) in SQL
clients and access it from the SQL server?
> Thanks
>|||I am designing a system in which there are about 50 computers containing region-wise data in tables. The tables in different regions have same structure but the data is region-specific. I need to transfer data from the tables in each region to a server. The problem is that I cannot have 50 SQL servers installations. I am looking for a work around. Can you suggest what should be done
Thanks.|||Eva
REPLICATION is what you need.
http://www.swynk.com/friends/achigrik/SetupMR.asp -- Setting Up Merge
Replication: A Step by Step Guide
http://www.mssqlcity.com/Articles/Replic/Replic.htm --Setting All
Replica (Step by step)
"Eva" <anonymous@.discussions.microsoft.com> wrote in message
news:F851497F-8B3B-4A3C-9482-97B5F0B75410@.microsoft.com...
> I am designing a system in which there are about 50 computers containing
region-wise data in tables. The tables in different regions have same
structure but the data is region-specific. I need to transfer data from the
tables in each region to a server. The problem is that I cannot have 50 SQL
servers installations. I am looking for a work around. Can you suggest what
should be done?
> Thanks.|||Thanks Uri
Yes, I could have the 50 computers set up as publishers and the server as a subscriber. But, what I understand of Publishers is that they have to be SQL servers!|||Eva
How do they store the data? With text files?
Do they have an application (vb,c) which can connect to the main server?
"Eva" <anonymous@.discussions.microsoft.com> wrote in message
news:A89D4478-7858-493C-BD95-607A710004B3@.microsoft.com...
> Thanks Uri.
> Yes, I could have the 50 computers set up as publishers and the server as
a subscriber. But, what I understand of Publishers is that they have to be
SQL servers!|||Data is stored in SQL tables. There is an application running on the server which accesses the tables in each of the 50 machines and fetches data from them!|||Eva
Have you looked at DTS utility?
"Eva" <anonymous@.discussions.microsoft.com> wrote in message
news:4F67F94C-FFC2-4CB9-8ADB-2C66E427EA8C@.microsoft.com...
> Data is stored in SQL tables. There is an application running on the
server which accesses the tables in each of the 50 machines and fetches data
from them!|||Eva,
When you say "SQL Tables" do you mean tables in a SQL Server database? Or is
it in another RDBMS?
--
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
"Eva" <anonymous@.discussions.microsoft.com> wrote in message
news:4F67F94C-FFC2-4CB9-8ADB-2C66E427EA8C@.microsoft.com...
> Data is stored in SQL tables. There is an application running on the
server which accesses the tables in each of the 50 machines and fetches data
from them!|||Can't you have just one SQL Server and have all clients store their data in this SQL Server?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Eva" <anonymous@.discussions.microsoft.com> wrote in message
news:F851497F-8B3B-4A3C-9482-97B5F0B75410@.microsoft.com...
> I am designing a system in which there are about 50 computers containing region-wise data in tables. The
tables in different regions have same structure but the data is region-specific. I need to transfer data from
the tables in each region to a server. The problem is that I cannot have 50 SQL servers installations. I am
looking for a work around. Can you suggest what should be done?
> Thanks.
Is it possible to store tables (in general database objects) in SQL clients and access it from the SQL server
ThankEva
What are you trying to accomplish?
"Eva" <anonymous@.discussions.microsoft.com> wrote in message
news:2C3CCA52-4F57-409A-A331-4BFC9001F773@.microsoft.com...
> Hi All,
> Is it possible to store tables (in general database objects) in SQL
clients and access it from the SQL server?
> Thanks
>|||I am designing a system in which there are about 50 computers containing region-wise data in tables. The tables in different regions have same structure but the data is region-specific. I need to transfer data from the tables in each region to a server. The problem is that I cannot have 50 SQL servers installations. I am looking for a work around. Can you suggest what should be done
Thanks.|||Eva
REPLICATION is what you need.
http://www.swynk.com/friends/achigrik/SetupMR.asp -- Setting Up Merge
Replication: A Step by Step Guide
http://www.mssqlcity.com/Articles/Replic/Replic.htm --Setting All
Replica (Step by step)
"Eva" <anonymous@.discussions.microsoft.com> wrote in message
news:F851497F-8B3B-4A3C-9482-97B5F0B75410@.microsoft.com...
> I am designing a system in which there are about 50 computers containing
region-wise data in tables. The tables in different regions have same
structure but the data is region-specific. I need to transfer data from the
tables in each region to a server. The problem is that I cannot have 50 SQL
servers installations. I am looking for a work around. Can you suggest what
should be done?
> Thanks.|||Thanks Uri
Yes, I could have the 50 computers set up as publishers and the server as a subscriber. But, what I understand of Publishers is that they have to be SQL servers!|||Eva
How do they store the data? With text files?
Do they have an application (vb,c) which can connect to the main server?
"Eva" <anonymous@.discussions.microsoft.com> wrote in message
news:A89D4478-7858-493C-BD95-607A710004B3@.microsoft.com...
> Thanks Uri.
> Yes, I could have the 50 computers set up as publishers and the server as
a subscriber. But, what I understand of Publishers is that they have to be
SQL servers!|||Data is stored in SQL tables. There is an application running on the server which accesses the tables in each of the 50 machines and fetches data from them!|||Eva
Have you looked at DTS utility?
"Eva" <anonymous@.discussions.microsoft.com> wrote in message
news:4F67F94C-FFC2-4CB9-8ADB-2C66E427EA8C@.microsoft.com...
> Data is stored in SQL tables. There is an application running on the
server which accesses the tables in each of the 50 machines and fetches data
from them!|||Eva,
When you say "SQL Tables" do you mean tables in a SQL Server database? Or is
it in another RDBMS?
--
Andrew C. Madsen
Information Architect
Harley-Davidson Motor Company
"Eva" <anonymous@.discussions.microsoft.com> wrote in message
news:4F67F94C-FFC2-4CB9-8ADB-2C66E427EA8C@.microsoft.com...
> Data is stored in SQL tables. There is an application running on the
server which accesses the tables in each of the 50 machines and fetches data
from them!|||Can't you have just one SQL Server and have all clients store their data in this SQL Server?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Eva" <anonymous@.discussions.microsoft.com> wrote in message
news:F851497F-8B3B-4A3C-9482-97B5F0B75410@.microsoft.com...
> I am designing a system in which there are about 50 computers containing region-wise data in tables. The
tables in different regions have same structure but the data is region-specific. I need to transfer data from
the tables in each region to a server. The problem is that I cannot have 50 SQL servers installations. I am
looking for a work around. Can you suggest what should be done?
> Thanks.
newbie question
Hi,
i'm kinda new to Microsoft SQL Server. I've just finished my first
install. Now i want to be able to connect macintosh clients to the
server. I'm able to connect using windows 2000 authentification but not
with SQL Server authentification (in mixed mode).
When using "Aqua Data Studio" on my mac, when i try to connect using
the "sa" account it fails because "the connection is not associated to
a secure SQL Server connection".
How can i establish such a secured connection '
Thanks in advance,
PierreWhen you're connecting to SQL server with sa user you are trying to
authenticate with SQL authentication.
That means that you have to set a mixed mode on the server. Then you'll be
able to connect with sa user.
Secure SQL Server connection error you're getting means that you should use
Windows account to log to SQL Server.
Danijel
"Pierre Chatel" <admin@.chatelp.org> wrote in message
news:2005011413034716807%admin@.chatelporg...
> Hi,
> i'm kinda new to Microsoft SQL Server. I've just finished my first
> install. Now i want to be able to connect macintosh clients to the server.
> I'm able to connect using windows 2000 authentification but not with SQL
> Server authentification (in mixed mode).
> When using "Aqua Data Studio" on my mac, when i try to connect using the
> "sa" account it fails because "the connection is not associated to a
> secure SQL Server connection".
> How can i establish such a secured connection '
> Thanks in advance,
> Pierre
>
i'm kinda new to Microsoft SQL Server. I've just finished my first
install. Now i want to be able to connect macintosh clients to the
server. I'm able to connect using windows 2000 authentification but not
with SQL Server authentification (in mixed mode).
When using "Aqua Data Studio" on my mac, when i try to connect using
the "sa" account it fails because "the connection is not associated to
a secure SQL Server connection".
How can i establish such a secured connection '
Thanks in advance,
PierreWhen you're connecting to SQL server with sa user you are trying to
authenticate with SQL authentication.
That means that you have to set a mixed mode on the server. Then you'll be
able to connect with sa user.
Secure SQL Server connection error you're getting means that you should use
Windows account to log to SQL Server.
Danijel
"Pierre Chatel" <admin@.chatelp.org> wrote in message
news:2005011413034716807%admin@.chatelporg...
> Hi,
> i'm kinda new to Microsoft SQL Server. I've just finished my first
> install. Now i want to be able to connect macintosh clients to the server.
> I'm able to connect using windows 2000 authentification but not with SQL
> Server authentification (in mixed mode).
> When using "Aqua Data Studio" on my mac, when i try to connect using the
> "sa" account it fails because "the connection is not associated to a
> secure SQL Server connection".
> How can i establish such a secured connection '
> Thanks in advance,
> Pierre
>
Subscribe to:
Posts (Atom)