However it works perfectly if I specify the full server name like this
192-55-55-55\SQLEXPRESS.
Is there any way to configure it so I would be able to connect to it using
localhost?

I don't understand why.
My SQL Server 2005 is called PC\SQLEXPRESS. I use PC\Robert (administrator)
account on Windows XP Professional. I use Windows Authentication. Remote
connections are switched on ("Using both TCP/IP and names pipes.")

  I'm trying to manage two connections created from different datasources
using two instances of com.microsoft.jdbcx.sqlserver.SQLServerDataSource.
DataBases are in the the same instance of SQLServer. Starting a new
transaction i get a "xa_start (40000) returns -8" when getting ...

I am using SQL Server 2005 standard edition.  Here is the version
information in the logs
Database product version : 9.00.2153
JDBC driver name  : Microsoft SQL Server 2005 JDBC Driver

I have SQL 2000 installed on the server, and running VB6.0 program on the
clients.
Everything was working ok until user began to complain they cannot logon
because of a invalid username or password. the exact error is:

I provide for complete creation of a database in SQL Express from a script.
When the moon is in the seventh house and Jupiter lies in Mars, it works
wonderfully.
HOWEVER, if I have used any external tool to look at the db such as the IDE

I need to change the IP address of the server where SQL 2000 is running. What
implications can that have on the SQL DB?

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.

when i try to attach file there is an error occur
" 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 under the default settings SQL Server does not allow remote

I'm going to copy all the tables from one database in one server to other
database in another server. A couple of days later I will want to copy the
new (and updated) records (from those couple of days) instead of copying
everything again.

I have a user application that runs on MS Access 2000.  On one client PC, the
user's PC log in and got the following error:
17[Microsoft][ODBC SQL Server Driver][DBNETLIB]AQL Server does not
  exist or access denied.:53[Microsoft][ODBC SQL Server Driver][DBNETLIB]

Running into an issue when I run the following code:
try{
            CallableStatement stmt = rdbConn.prepareCall("{? = call
dbo.usp_test_add(?,?,?,?,?) }");

I have suddenly started getting a runtime error 3155 when attempting to
insert new rows into a linked SQL (2000 on Windows 2003 server) database
table from Access (2002 under XP).
A new bit of code in the Access database attempts to insert a database login

I have a strange problem.
I have a few procedures which run fast in query analyzer, but extremely slow
from Access (via ODBC) and for example Crystal Reports. The difference is
enormous, the procedure takes about 1 second to run from QA; it takes about

I have a bunch of SQL 2K servers that can see each other fine and can
connect to each other.
I have 2 SQL 2K servers on Win2K3R2 and everyone can see each other except
these 2 can't see each other.  I can force a connection, but the green light