Re: Using SQL Server Express on Shared PC

No, you don't need to install SSMS or VS on the client system. However, using ODBC (against our recommendations) you're making the job of getting connected more difficult. ODBC requires either a REGISTERED DSN, a file-based DSN or a "DSN-less" connection. This DSN basically contains the ConnectionString key/value pairs that identify the server etal. We have stopped recommending ODBC (except in special cases where there are no other ..NET drivers) some time ago. I suggest using SqlClient to connect to SQL Server in .NET or the SNAC provider in VB6.

To "see" the server, you have enable the ports and protocols as well as start the SQL Browser service. You also need to configure the Network-shared SQL Server service to permit access by whatever credentials you have chosen.

By "Read and still no connection..." I assume you've read Chapter 9 and/or my whitepaper on Connecting...

--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker’s Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________
"dbguru316" <dbguru316@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:BB63F1BC-8084-4051-B57B-DE8E280088AD@xxxxxxxxxxxxxxxx
Read and still no connection - If I am reading this correctly, you are
expected to install managament studio on the other computer as well? How
come it can be even simpler and connect to it using the ODBC driver that is
installed on the other computer?

"dbguru316" wrote:

We are using a PC to run SQL server express, and need other PCs to be able to
connect to the SQL database through an ODBC connection. What is the best
conenction method to make this happen. I cannot seem to locate the server
when using Windows Authentication Mode, perhaps switching to a SQL server
authentication will work?

I just don't know how to make the SQL server and its databases available to
other PCs on the network. I know how to share directories and folder to make
availabel to others, but not a SQL database.

Please advise.
Tim


.

Relevant Pages

  • Re: Strange Problems with ODBC connection to SQL Server
    ... When accessing Jet data, use DAO. ... This way you are not exposing connection information in clear ... >accesses an SQL Server 2000 repository via ODBC data source. ...
    (microsoft.public.data.odbc)
  • Re: Access and processor usage
    ... and you are using an ODBC connection, that would be your bottle neck. ... bottleneck - need to step up to Sql Server. ...
    (comp.databases.ms-access)
  • Re: VS 2008 Team - Database not supported / Cant load file or ass
    ... Visual Studio 2008 Team Database Edition ... SQL Server 2005 Enterprise SP2 ... Unable to add data connection. ... Install the following from Microsoft SQL Server 2008 Feature Pack RC0, ...
    (microsoft.public.vstudio.general)
  • RE: [ODBC SQL Server Driver][Shared Memory]ConnectionWrite (send()) er
    ... I understand that you encountered the ODBC error message on your ecommerce ... TCP/IP protocol to your SQL Server instance by calling conn.Open, ... SQL Server instance and see if there is a connection reset when this issue ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.connect)
  • RE: [ODBC SQL Server Driver][Shared Memory]ConnectionWrite (send()
    ... remote connection. ... should I just check named pipes only or both TCP/IP and ... I understand that you encountered the ODBC error message on your ecommerce ... TCP/IP protocol to your SQL Server instance by calling conn.Open, ...
    (microsoft.public.sqlserver.connect)