I have a problem connecting to SQL Server 2005. After I set "user
connections" to 1 and restarted sql service, I cannot connect to server
anymore. Do you have maybe any suggestion how to set "user connection" back
to 0? It's a SQL Server 2005 Standard with SP1 in two node cluster ...

I have just got the trial dvd for Visual Studio 2005 Professional
When trying to make a new sql server database, I get an error box:-
********************************************************************************************************
An error has occured while establishing a ...

I am trying to connect to a SQL Server 2005 instance from another machine
using Query Analyzer (SQL Server 2000 version) and I am getting the following
error:
Server: Msg 11, Level 16, State 1

Suddenly my trusted connection no longer works in VS. I try to create a new
one and recieve this:
"Database schema could not be retrieved for this connection. Please make
sure the connection settings are correct and the database is online

I can connect easily using C# & ADO.NET on standalone programs.
I am trying to connect from a web site program under .NET 1.1 VS 7 and
always get
Login failed for user 'LANDON\ASPNET'.

I've installed Visual Studio 2005 pro  SQL Server 2005 dev on a WMCE PC.
When I try to connect from VS to SQL I get the following error:
----------------------------------------
A connection cannot be made to the database.

I am having ongoing problems connecting to the server. I thought I had it
solved thanks to help from a prev post:
C:\>sqlcmd -S dimension9150\SQLExpress
HResult 0xFFFFFFFF, Level 16, State 1

Is it possible to do this using ADONET2 and how would you achieve it?
My data layer uses adapters exclusively, which works well, but now I need to
connect asynchronous to speed up my UI.
Thanks

where can i find resources on how to connect from C# 2003 to SQL Express 2005?

I'm trying to connect to the SharePoint MSDE database from Windows XP
SP2 machine over Ethernet LAN. I was getting server not found or access
denied, until I enabled TCP/IP via svrnetcn.exe. Now, I'm getting
OK

Ok i know this is simple but i just don't know the syntax. What I have
is a bunch of values and i want to be able to display them as money
values with a $ in front.
eg.

Environment:
OS of sql server 2000 server: windows 2003 standard server , .NEt framework
1.1 , sql server does not have any service pack, machine has the latest
Windows service pack. Personal firewall is not enabled on this machine. All

I have a SQL server that is hosting 5 databases, when I
try and use Enterprise Manager running it from the server
its self and connect to one specific database I get
A runtime Error has occurred

within my network, one laptop get installed MSSQL2005, all services are
activated, network configuration as follows:
shared memory -- enabled
named pipes -- disabled

Hi I am possible to connect via the SQL Server Management Studio to the
database in the network. I have difficulties to connect via the Visual Studio
C# Express to the database. What can I do? What could be the failure?
Everything works fine with the SQL Server Management Studio ...