Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
m.akki
Starting Member
1 Post |
 Posted - 2007-08-10 : 09:20:21
|
| Hi all,We have a small office network consisting of 6 workstations and a server. I want to know if it is possible to be able to run sql server from the workstations and host the created sql databases on the server rather than an individual pc? If so how do i do this?Thanks |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-08-10 : 09:53:37
|
| Yes.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-08-10 : 12:29:56
|
| You have a network so presumably they are all connected.Just connect to the machine name of the machine with sql server installed- i.e. put that name in the connection string.You will have to add the login for the user to the server too.The fun part is allowing the server to accept the connection - that will depend on the version of windows and how your network is set up.Try it first and see what happens.You can use the profiler to check whether a login is being attempted and which which login name.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Networking SQL server