I have recently installed SQL Server 2005 onto my development machine and
another developers machine.  I am trying to connect to his server via my SQL
Server Management Studio but I am getting the following error.
==================================================

I have spent the best part of 4 days trying to connect to SQL 2005
express from an winforms app! Yes , I have checked surface config and
TCP/IP blah blah ...
I have trawled the net and spent countless hours on MSDN and many have

I have a big problem with the JDBC driver 1.1 and SQLServer2005 Express SP1:
I have a stored procedure that has an output parameter and also returns a
result set.
If I attempt to retrieve the output parameter after I execute the stored

I have a sp where the last statement is a "select * from...."
Now can I capture this resultset that is returned, into a table ?
(without modifying the sp itself)
Something like this ? (this obviously does not work :) )

Hi
I'm not sure if this is the right Newsgroup for this question, apologies if
it's off topic.
I've got a stored procedure that calls a second stored procedure on a linked

I have just moved from Sybase to SQL Server 2005 (9.0.2047) and am using the
1.1 JDBC driver with Java 1.5.0 06.
I'm getting a TDS_RET_STATUS SQLServerException.
I have multiple processes updating a particular table and when the load is

We are moving from Sybase to SQL Server 2005 (9.0.2047) and we are using the
1.1 JDBC driver with Java 1.5.0 06.
Some of our code uses the execute method of a CallableStatement to get a
result set and checks that the boolean return parameteris true before then

I have an Access 2003 database that I have split, then upsized to SQL Server
2005.  The database works find on the machine that has the SQL Server 2005,
but when I try to run the program from another machine on the network, I get
the following error:

When I try to connect one one of our SQL Server databases using SQL Server
2005 client tools I get the following error.
An error has occurred while establishing a connection to the server.  When
connecting to SQL Server 2005, this failure may be caused by the fact that

I'm having trouble connecting to an instance of SQL Server 2005 (Express)
from 2 individual Windows Server 2003 machines running IIS (asp.net 2.0)
I have an IIS on each 2k3 machine, both with identical sites. The idea is
simply that we have a third sql server which is accessed by ...

can you help me with following message:
Error: 10054, ErrorMessage: "TCP Provider: An existing connection was
forcibly closed by the remote host".
Env:

I am new in MSSQL server JDBC.
I am using SQL 2000 with SP4 on XP, firewall is turned off.  When I tried to
connect to SQL server with
Connection connection = DriverManager.getConnection(

Hate to be an idiot but, well, this isn't really my world. Just getting
started...
I downloaded the SS 2005 JDBC Driver 1.1 and ran the sqljdbc...enu.exe file
that came down. That appears to be a self-extracting zip and, once executed,

I would like to know how can I count SQL CAL on the servers
I mean i.e. if I assign 50 CALs to a SQL server 2005, how can I know how
many users connect to the server in order to compliance licensing
I know the SQL license model. I do not care Processor license because I can

When I open SQL Server Enterprise and try to connect via my SQL Server
Registration, I get the error message “SQL server does not exist or access
denied”. If I try to modify the Registered SQL Server properties, I get the
error message that it failed to connect for the same ...