3 workstations previously installed and able to access server.
4th workstation am able to map to server access files but when
attempting to log in receive the following error.
EXTERNAL DATABASE OPEN FAILURE

Has anyone used the JDBC driver for SQL Server 2005 to access a SQLExpress
database? Could you please share how did you configure SQLExpress to be able
to do this? What connection string did you use?

we have an Oracle Linked Server (8i) running linked from SQL Server 2000
SP4.
The performance is ok when selecting data from the sql server, but poor when
trying to insert data into the oracle database via linked server.

I can connect to the SQL Server database through Enterprise Manager and
the SQL Server Service Manager is showing the database running but I
cannot connect to the database through Query Analyzer.  Any
suggestions?

I currently have a development SQL server running locally on my laptop.  
After my laptop comes out of hibernation, existing connections to the server,
such as from Query Analyzer, work fine, but I can not make new connections to
the server.  I've tried restarting the server ...

I am trying to link to an AS400 server. When I set up the link I am getting
Error 7303 Could not initialize data source object of OLE DB provider.
I know that there are problably parameters that I need to add to the
connection but am not sure where to start. Can someone help me ...

If we use connection pooling, then a sp 'sp_reset_connection' will be
executed to clean the connection.  Does this sp clears the context_info for
the connection or not?  Our initial tests shows that it is not clearing the
context_info.  How to clear context_info in connection ...

     hi
     i have sqlserver that running on windows 2003
     i have  connecton to this server from an other computer
     and i need tcp/ip connection to this sql server

How can I make it so that our intranet clients can connect to the SQLServer
via our FQDN?  Our extranet clients work fine via that way, but once they go
behind the VPN, the FQDN doesn't work.  Also for onsite intranet clients we
can connect fine via server name, but not via IP ...

Server is quad processor with 3 gig of RAM of whcih 2 gig is allocated to SQL.
Last weekend we upgraded the SQL from SP2 to SP4, since then the ODBC
queries trhey run via MSQUERY appear to be really hitting the CPU and
sqlserver.exe is consuming up to 90% of the CPU. It is looking ...

running this now, but need the names, & not emp ID's.
select ticketid, acct, date, createuser
from ticket
where createuser in ('k1001', 'k1002', 'k1003', 'k1004')

The following JUnit code fails:
// elided ...
   public void testSelectMethod()
   {

I run Visual Interdev 6... I have 2 web servers and 2 database
servers... (1 of each located in my home - A; and 1 of each co-located
at an ISP - B with our own firewall at each location).
Location A:

A little background...
I have a cube that automatically refreshes every 10 minutes and pulls it's
data from a view ('ViewA') in sql server 2000.
The cube takes around a minute and a half to completely refresh.  During

10/17/2005
Hi Sue,
The problem is occuring when I am attempting to run a query from Query
Analyzer