Re: Quick Question on SQL Server 2005 Express

Why not? Your users even - if they'd be on the Moon- can query your SQL Server databases if you enable remote connection in your SQL Server Express Edition instance. Which is disabled by default. And of course you need an internet connection =)

You should open up SQL Server Surface Area Configuration tool of SQL Server to enable this protocol. Or you can perform this action from SQL Server Configuration Manager.

If your SQL Server instance is a Named Instance, then I suggest you to use a static port and let this port in your Firewall software\hardware. If it's a Default Instance then your port would be 1433 by default. And you'll configure these settings from Configuration Manager.

--
Ekrem Önsoy



"David Clifford" <someone@microso> wrote in message news:u%23lnfg42IHA.4500@xxxxxxxxxxxxxxxxxxxxxxx
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: Access 2007->SQL Server2005 "connection was forcibly closed",G
    ... an Access database in former times this was a lot of work which took me ... closed connections - but all of these errors are in the version which used ... the SQL Server 2000 and everything worked ... client for programming easy, fast and good applications. ...
    (microsoft.public.sqlserver.connect)
  • Re: Quick Question on SQL Server 2005 Express
    ... you can't attach a database in a remote machine in your network as Andrew has already mantioned. ... One database can be used only by one SQL Server instance and as far as I understand the database in question is already attached to a SQL Server instance. ... Why not installing only SQL Server Management Studio and connect to your remote instance and perform actions this way? ... The Client can live anywhere as long as it has TCP access to the server. ...
    (microsoft.public.sqlserver.setup)
  • Re: Permissions problem on SBS 2003 R2 for SQL Server 2005 clients
    ... use SQL Server authentication instead. ... I've been testing a SQL Server 2005 Express database in a multiuser ... environment using Window Small Business Server 2003 R2 with Windows XP ... On a given client computer to which I may have logged on with Windows ...
    (microsoft.public.windows.server.sbs)
  • Re: Quick Question on SQL Server 2005 Express
    ... I have not seen any documentation yet that states connecting other editions of SQL Server using SSMSE would break any license agreement. ... As Ekrem stated they should have a licensed edition of the full client tools and then all they have to do is register the server in the registered servers dialog and they should be all set. ... I have installed SQL Server 2005 Express, and now I want to connect to the remote database and use the Management Studio to manipulate the database. ...
    (microsoft.public.sqlserver.setup)
  • Re: Why not Access...?
    ... Next, I DID NOT SAY Oracle was considered a "best choice," only a sufficient ... It is a desktop application and the database in also on the same machine. ... I also want to know why Oracle is considered a best choice as compared to SQL Server. ... > Also, you need to answer the question regarding whether or not each client> will be using an individual database, and individual copy of a central> organization database, or making straight calls to a centralized ...
    (microsoft.public.sqlserver.server)