[dba-SQLServer] PRETTY URGENT: How to connect to SQL Server 2005 on a workstation, not the server

Jeff B jeff.developer at gmail.com
Tue Dec 8 14:05:41 CST 2009


I believe that you need a NAMED copy of SQL Server in order to connect from
a different workstation.  

Jeff Barrows
MCP, MCAD, MCSD
 
Outbak Technologies, LLC
Racine, WI
jeff.developer at gmail.com

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Steve
Erbach
Sent: Tuesday, December 08, 2009 12:58 PM
To: Discussion concerning MS SQL Server
Subject: [dba-SQLServer] PRETTY URGENT: How to connect to SQL Server 2005 on
a workstation, not the server

Dear Group,

I'm trying to help my wife who is the de facto network administrator for the
small company she works for.  The main order processing application uses SQL
Server 2005 on the domain server.  That SQL Server is having problems.

What we've tried is to copy the MDF and log file to a workstation that has
SQL Server 2005 installed on it.  The application is an Access MDB connected
via ODBC to the SQL Server database.  We can connect to the SQL Server
database just fine if we run the Access application on that workstation.

The problem comes in when we try to connect to the database from another
workstation on the LAN.  We keep getting "SQL Server not found".  I can't
get the System ODBC connection to "see" the SQL Server on the
workstation...nor can I get Access 2003 to create an ADP project to connect
directly to SQL Server 2005 on that other workstation.

We've got a call into Microsoft support to do the surgery necessary to get
the main domain server's installation of SQL Server up and running...it's
just that we thought we could point the Access application to the database
on the workstation copy of SQL Server 2005 and at least get a couple
workstations going with entering orders, etc.

The server is Windows Small Business Server 2008 which includes SQL Server
2005 Standard edition.  The installation of SQL Server 2005 on the
workstation is also Standard edition.

Any clue as to how we can connect to a workstation copy of SQL Server?  I'm
pulling my hair out trying to figure out why other workstations cannot "see"
the SQL Server on the workstation.

Regards,

Steve Erbach
Neenah, WI
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com

No virus found in this incoming message.
Checked by AVG - www.avg.com 
Version: 9.0.709 / Virus Database: 270.14.98/2552 - Release Date: 12/08/09
01:34:00





More information about the dba-SQLServer mailing list