Groups | Blog | Home
all groups > sql server connect > november 2006 >

sql server connect : SQL Server 2005 Express


AC
11/10/2006 8:34:01 AM
HELP. I have installed SQL 2005 express onto a WIN XP Pro SP2 machine and
have it working with a piece of software called IRIS.
I have another machine connected to the IRIS software via a network drive,
which I have installed over the mapped drive.
My issue is that when I try to run IRIS software I get the following message.

Module: CORE Emulator failed to start
Cause: Failed to login into database
Unspecified error
HRESULT hr=0x80004004
[DBNETLIB][Connectionopen (Connect()). ] Speccifies SQL Server was not found.

I have the IRIS software installed on the same machine as the SQL server and
this works fine.
I have enabled TCP/IP through CLICONFG on all machines, and also through
SSCM on the main machine.

Any help would be very grateful

Tnx

Roger Wolter[MSFT]
11/10/2006 11:04:34 AM
If you are running off a network drive then the IRIS software is actually
running on your system and just loading the executables off the server.
When the software tries to connect to the database it is probably trying to
connect to a local SQL Server instance and you don't have SQL Server running
on your machine. There are several ways to fix this but they all require
changing the connection string that IRIS is using to connect to SQL Server
so you will have to ask them for help (or read their documentation if they
provided any).

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

[quoted text, click to view]

AC
11/13/2006 1:52:01 AM
Hi,

I have checked the machine with the error and there is no form of SQL on it.
I have also removed all of SQL Express and IRIS and have done a blank
install again. The same error still appears.

I might add that I have other machine in the office with the sme spec and
these work fine with IRIS software.

Cheers

Andy

[quoted text, click to view]
AC
11/13/2006 6:32:01 AM
For you records:

If you install SQL 2005 express with a named instance: ie,
SERVER\SQLEXPRESS then you will need to make sure that under SQL
CONFIGURATION MANAGER\ SQL SERVER 2005 SERVICES\ SQL SERVER BROWSER is
started.

Tnx

AC

[quoted text, click to view]
AddThis Social Bookmark Button