Re: Quick Question on SQL Server 2005 Express

Thank you for that prompt reply Andrew.

It is what I suspected.
My main problem then is, if the SQL Database is located at a remote
location..another building for example, then my client will NOT be able to
run queries/change tables/etc using the Management Consule for a SQL Server
2005 instance on HIS local machine? Sorry for the rather basic question,
but this is all sort of new to me

Regards

David

"Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx> wrote in message
news:eeWb6H42IHA.2424@xxxxxxxxxxxxxxxxxxxxxxx
That is correct. None of the versions of SQL Server support the database
files residing on a networked share. But you don't attach the db from the
server to a client anyway. The client should not be the sqls server
service itself, it should be an application suing the client / server
approach. The client talks to the server and hence the db thru the SQL
Server service on the server and thus the client has no need to access the
files directly.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"David Clifford" <someone@microso> wrote in message
news:%23xkWz432IHA.4988@xxxxxxxxxxxxxxxxxxxxxxx
Hello All

A quick question. We are moving an Access database over to SQL Server
2005. No problems. The SQL Server database will be located on it's own
server. To test the system, I installed SQL Server 2005 Express onto the
server, got the database attached etc. No problems. I installed the same
Express version onto a client computer so that the operator could use the
database from his workstation, tried to attach the database, but the
network drive was not listed in the file dropdown box..only the local C:
and D: drives. My gut says that Express won't look at network drives,
anyone care to comment?

Thank you

David.




.

Relevant Pages

  • Re: Help with first VB application - Data Entry form
    ... I assumed a desktop / winform client application ... time' stamp from the database machine - control machine ... ... problem solved - web server is control system. ...
    (microsoft.public.dotnet.languages.vb)
  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: Help with first VB application - Data Entry form
    ... I assumed a desktop / winform client application ... time' stamp from the database machine - control machine ... ... problem solved - web server is control system. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Remobjects v KBM
    ... >> client query components) follow from that. ... Then, connections can be created to say SQL Server, Oracle, Interbase and ... can then be created from the abstract dataset definition in 'customers' to ... implicitly - this makes your code not be database connection specific). ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Help with first VB application - Data Entry form
    ... stamp from the database machine - control machine ... ... unnecessary data to the client ... ... and when building a database independent UI / Client - Server application, ... JavaScript, for example) and thus, will get the time from the web server, ...
    (microsoft.public.dotnet.languages.vb)