I will try to describe my problem:
I need 3 workstations to work with one, the same database file (*.mdf) at
the same time. My idea is to install MS SQL Server 2005 Express engine on all
3 workstations and connect each of it to this file placed on linux server. Is
it possible?
I tried to connect my *.mdf (using path like this: \\Server\infotec.mdf)
file to one of engines using MSS Management Studio Express but I get message
that attaching databases from naetwork paths is impossible.
Is there any possibility to do this?
I can't install Database Engine on Server and use it by all of the
workstations because I don't have a Microsoft operation system server.
sorry for my English
Tomash wrote:
> I will try to describe my problem:
> I need 3 workstations to work with one, the same database file (*.mdf) at
> the same time. My idea is to install MS SQL Server 2005 Express engine on all
> 3 workstations and connect each of it to this file placed on linux server. Is
> it possible?
> I tried to connect my *.mdf (using path like this: \\Server\infotec.mdf)
> file to one of engines using MSS Management Studio Express but I get message
> that attaching databases from naetwork paths is impossible.
> Is there any possibility to do this?
> I can't install Database Engine on Server and use it by all of the
> workstations because I don't have a Microsoft operation system server.
> sorry for my English
A database file can only be attached to one server at a time. Express
doesn't require a server OS. You could put the data file on one of the
3 workstations and run Express there. The other two should still be
able to connect to that instance of Express using whatever client
application you have.
Bear in mind that Express only supports databases upto 4GB. If your
data is larger than that you'll have to buy Workgroup Edition.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
|||Thank you for your reply David.
Yes, that is true that I can install SQL Engine on one of the workstations
but in this case I need to keep this workstation working all the time i need
to connect from another workstation. And this is not so comfortable. So I see
that the simpliest but expensive solution would be changing my Linux server
to MS OS server.
Showing posts with label install. Show all posts
Showing posts with label install. Show all posts
Monday, March 19, 2012
Database attaching
I will try to describe my problem:
I need 3 workstations to work with one, the same database file (*.mdf) at
the same time. My idea is to install MS SQL Server 2005 Express engine on al
l
3 workstations and connect each of it to this file placed on linux server. I
s
it possible?
I tried to connect my *.mdf (using path like this: \\Server\infotec.mdf)
file to one of engines using MSS Management Studio Express but I get message
that attaching databases from naetwork paths is impossible.
Is there any possibility to do this'
I can't install Database Engine on Server and use it by all of the
workstations because I don't have a Microsoft operation system server.
sorry for my EnglishTomash wrote:
> I will try to describe my problem:
> I need 3 workstations to work with one, the same database file (*.mdf) at
> the same time. My idea is to install MS SQL Server 2005 Express engine on
all
> 3 workstations and connect each of it to this file placed on linux server.
Is
> it possible?
> I tried to connect my *.mdf (using path like this: \\Server\infotec.mdf)
> file to one of engines using MSS Management Studio Express but I get messa
ge
> that attaching databases from naetwork paths is impossible.
> Is there any possibility to do this'
> I can't install Database Engine on Server and use it by all of the
> workstations because I don't have a Microsoft operation system server.
> sorry for my English
A database file can only be attached to one server at a time. Express
doesn't require a server OS. You could put the data file on one of the
3 workstations and run Express there. The other two should still be
able to connect to that instance of Express using whatever client
application you have.
Bear in mind that Express only supports databases upto 4GB. If your
data is larger than that you'll have to buy Workgroup Edition.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||Thank you for your reply David.
Yes, that is true that I can install SQL Engine on one of the workstations
but in this case I need to keep this workstation working all the time i need
to connect from another workstation. And this is not so comfortable. So I se
e
that the simpliest but expensive solution would be changing my Linux server
to MS OS server.
I need 3 workstations to work with one, the same database file (*.mdf) at
the same time. My idea is to install MS SQL Server 2005 Express engine on al
l
3 workstations and connect each of it to this file placed on linux server. I
s
it possible?
I tried to connect my *.mdf (using path like this: \\Server\infotec.mdf)
file to one of engines using MSS Management Studio Express but I get message
that attaching databases from naetwork paths is impossible.
Is there any possibility to do this'
I can't install Database Engine on Server and use it by all of the
workstations because I don't have a Microsoft operation system server.
sorry for my EnglishTomash wrote:
> I will try to describe my problem:
> I need 3 workstations to work with one, the same database file (*.mdf) at
> the same time. My idea is to install MS SQL Server 2005 Express engine on
all
> 3 workstations and connect each of it to this file placed on linux server.
Is
> it possible?
> I tried to connect my *.mdf (using path like this: \\Server\infotec.mdf)
> file to one of engines using MSS Management Studio Express but I get messa
ge
> that attaching databases from naetwork paths is impossible.
> Is there any possibility to do this'
> I can't install Database Engine on Server and use it by all of the
> workstations because I don't have a Microsoft operation system server.
> sorry for my English
A database file can only be attached to one server at a time. Express
doesn't require a server OS. You could put the data file on one of the
3 workstations and run Express there. The other two should still be
able to connect to that instance of Express using whatever client
application you have.
Bear in mind that Express only supports databases upto 4GB. If your
data is larger than that you'll have to buy Workgroup Edition.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||Thank you for your reply David.
Yes, that is true that I can install SQL Engine on one of the workstations
but in this case I need to keep this workstation working all the time i need
to connect from another workstation. And this is not so comfortable. So I se
e
that the simpliest but expensive solution would be changing my Linux server
to MS OS server.
Tuesday, February 14, 2012
Data Transformation Project Template for SQL 2005
Does anyone know where I can download and install the Data Transformation Project template for SQL Server 2005 Integation Services?
I'm having the same issue. Did you ever find a solution?|||Data tranformations are done through the dataflow controls, to start a project you will need to have the management tools loaded onto the machine and start the SQL Server business intelligence studio from the start menu. You can also access this through the visual studio system... Once the management tools are loaded onto the machine.
|||Try looking at the integration services template|||I have the Business Intelligent Project but inside I don't have Data Transformation Project Template.
I have:
* Analisys Services Project
* Integration Services Project
* Report Model Project
* Import Analisys Services 9.0 Database
* Report Server Project Wizard
* Report Server Project
Like the question, I don't have the Data Transformation Project Template and I have SQL Server 2005 Client Tools instaled.
Maybe I have to have something else instaled.... what?
tkx in advance
Paulo Aboim Pinto
Odivelas - Portugal
Data Transformation Project Template for SQL 2005
Does anyone know where I can download and install the Data Transformation Project template for SQL Server 2005 Integation Services?
I'm having the same issue. Did you ever find a solution?|||Data tranformations are done through the dataflow controls, to start a project you will need to have the management tools loaded onto the machine and start the SQL Server business intelligence studio from the start menu. You can also access this through the visual studio system... Once the management tools are loaded onto the machine.
|||Try looking at the integration services template|||I have the Business Intelligent Project but inside I don't have Data Transformation Project Template.
I have:
* Analisys Services Project
* Integration Services Project
* Report Model Project
* Import Analisys Services 9.0 Database
* Report Server Project Wizard
* Report Server Project
Like the question, I don't have the Data Transformation Project Template and I have SQL Server 2005 Client Tools instaled.
Maybe I have to have something else instaled.... what?
tkx in advance
Paulo Aboim Pinto
Odivelas - Portugal
Data Transformation Project Template for SQL 2005
Does anyone know where I can download and install the Data Transformation Project template for SQL Server 2005 Integation Services?
I'm having the same issue. Did you ever find a solution?|||Data tranformations are done through the dataflow controls, to start a project you will need to have the management tools loaded onto the machine and start the SQL Server business intelligence studio from the start menu. You can also access this through the visual studio system... Once the management tools are loaded onto the machine.
|||Try looking at the integration services template|||I have the Business Intelligent Project but inside I don't have Data Transformation Project Template.
I have:
* Analisys Services Project
* Integration Services Project
* Report Model Project
* Import Analisys Services 9.0 Database
* Report Server Project Wizard
* Report Server Project
Like the question, I don't have the Data Transformation Project Template and I have SQL Server 2005 Client Tools instaled.
Maybe I have to have something else instaled.... what?
tkx in advance
Paulo Aboim Pinto
Odivelas - Portugal
Data Transformation Project Template for SQL 2005
Does anyone know where I can download and install the Data Transformation Project template for SQL Server 2005 Integation Services?
I'm having the same issue. Did you ever find a solution?|||Data tranformations are done through the dataflow controls, to start a project you will need to have the management tools loaded onto the machine and start the SQL Server business intelligence studio from the start menu. You can also access this through the visual studio system... Once the management tools are loaded onto the machine.
|||Try looking at the integration services template|||I have the Business Intelligent Project but inside I don't have Data Transformation Project Template.
I have:
* Analisys Services Project
* Integration Services Project
* Report Model Project
* Import Analisys Services 9.0 Database
* Report Server Project Wizard
* Report Server Project
Like the question, I don't have the Data Transformation Project Template and I have SQL Server 2005 Client Tools instaled.
Maybe I have to have something else instaled.... what?
tkx in advance
Paulo Aboim Pinto
Odivelas - Portugal
Data Transformation Project Template
Does anyone know how to install or make available the Data Transformation Project Template in SQL Server 2005? I can not find it using Integration Services.
Not quite sure what you are asking but this might answer your question: http://blogs.conchango.com/jamiethomson/archive/2005/11/12/2380.aspx
-Jamie
Subscribe to:
Comments (Atom)