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