I have an active/active SQL2005 cluster.  Node1 has a default instance of
SQL 2005 installed (i.e. no named instance).  Node2 has a named instance of
SQL 2005 (i.e. node2\sqlb).  I can connect remotely to node1 SQL 2005
without problem.  When I attempt to connect to node2 ...

I inherited database and trying to figure out what is the majority of the
workload by running SQL profiler for a couple of hours. All I see right now
is preparing SQL statement and then executing it and then removing it. It
happens every couple of seconds. There is virtually no ...

I installed the latest version of VB Express & SQL Express with no
trouble.  VB fails to connect to any database -- even the sample
applications fail with an SQL Exception:
System.Data.SqlClient.SqlException was unhandled

Here is the situation:
I have SQL server express 2005 installed on my pc as instance
SQLEXPRESS.
I have created a Visual Basic applicaion with the following as

I am using SQLServer 2000, Visual Studio 2003, C#.
I am writing a web part which requires me to connect to a local sql
database.
I wrote a class which handles the connection and reading of the table.

we have a Application on a Bea Weblogic Server 8.1 SP6 and tried to use the
ms jdbc 1.1.1501.101 with a ms sql 2005 enterprise with sp1.
We have a sql statement that works fine with the jdbc for sql 2000 on a ms
sql 2000 enterpise. But now with the new jdbc aand the sql 2005 we ...

Can someone please help me with this problem.
I Did a database backup from serverA and restore to
serverB using w2k. I detached the database from serverB,
and when try to attach to the restored database, I got an

Win2003 Server R2 Sql2005
My problem is unless I Login as a user with administrator permissions I
cannot
connect the SQL DB on the main server.

I'm using the AttachDBFilename option in the SQL connection string to attach
a database to a SQLExpress instance on another machine.
The is an error though, it seems to want to refer to a log file on the
machine the .mdf was originally created on.  The error is as follows:

what does teh MSSQL$SQLEXPRESS event ID 17110 really men?
can I just ignore that
Event Type: Information
Event Source: MISSAL$SQLEXPRESS

I have a W2k3 with SQL Server 2000 SP4. I have configured the server
to use named pipes and TCP on 1433 (at least that is what the registry
and server configuration tool say)
However the server does not accept tcp connections (i tried with

i installed sql server 2005 express on a windows xp prof. sp2 system.
i also installed the 2005 studio management tool.
I can connect to the sql server (sqlcmd -S), i can create a new database in
the 2005 studio management tool, but i can't attach a mdf file. I'm

       I am able to connect to the degault instance of a remote server But
not able to connect to a Named Instance called DEVELOPMENT on a same remote
server.  I am using SQL Server 2005 Developer edition on my server, Windows
server 2003 SP1 & on client side I am using XP Proff ...

If this is not the correct groups to post this, please redirect me.
I have a .NET application and SQL Server 2005 Express running on a Windows
Server 2003 Web Edition. Both connect to a remote SQL Server 2000 database
running on Windows 2000.

When I try to update a column value using MS SQL Server 2005 Management
Studio (SMS), I am getting "timeout period elapsed prior to the completion
of the operation".
Our server setup is: