I wonder if someone could help me out. Sporadically, I keep getting the
following error on my ASPX pages which connect to SQL Server...
"An error has occured while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be caused by the fact ...

How can I safely reduce the size of the .LDF file that SQL Server 2005
Express creates for a database?
Many thanks.

Getting "[DBNETLIB][ConnectionOpen (Connect()).]SQL Server doesn not exist
or access denied" when trying to connect to SQL 2005 SP2 from a workstation.
From the SQL server itself there are no problems.
The SQL server has a SQL 2005 named instance and SQL Express on it.  The SQL

In a Vb6 program i need to open a "read only" Sql Native Client Connection
to a Sql2005 database.
How can i do this? Is there something i can specify in the connectionstring?
Actually i have found nothing.

I am presented with...
TITLE: Connect to Server
------------------------------
Cannot connect to LARRYTESTBOX\SQLEXPRESS.

We are currently migrating our sequel 6.5 databases to sequel 2005
We have a handful of vb6 apps that connect to the current 6.5 database.
Can anyone recommend the "best practice" for connecting vb6 apps to sequel
2005 databases ?

I am trying to connect to Microsoft SQL Server 2005 through a program I am
writing in Eclipse and am having problems getting connected. I have already
created a database in Microsoft SQL Server 2005 and am trying to access that
database without having to get open the server.  I ...

I am trying to find the way to identify the name of the Windows NT workstation user using T-SQL in SQL Query Analyzer. Using  user_name(), user, SESSION_USER, system_user, etc. gives me current SQL server login name/id;
HOST_NAME(),HOST_id() shows the name of the computer not the ...

I have been running my Java application within the WebSphere test
environment within Rational Application Developer (RAD) - previously I
was using the SQL Server JDBC driver supplied by IBM
(com.ibm.websphere.jdbcx.sqlserver.SQLServerDataSource), which I

I create a webservice and impersonate a specific user only when you run a
connection to sql server to insert the data.
My connection string is as follows:
Integrated Security=SSPI;Persist Security Info=false;Initial

Is there a technical reason why Standard Edition does not support
advanced SSIS features or is it a marketing decision?

I installed a copy of SQL 2005 Express on another computer here using the
automatic download and install from Microsoft supported by the setup
toolkit.
I can't access this server from another machine on the LAN using SQL