Can connect with Windows NT authentication, but not with SQL server auth. So
all my
code has stopped working ...
When I try to make a new SQL Server registration

am trying to run a simple .net code thro visual studio in which i just want
to display table data into datagrid from sql server running on my local pc.
i.e off localhost. but am getting run time error as below.
Do i have create a new asp.net user in sql server ? or what ? i have

2005-11-18 12:50:12.09 logon    Login failed for user 'sa'.
2005-11-18 12:50:36.85 logon    Login succeeded for user 'NT
AUTHORITY\SYSTEM'. Connection: Trusted.
and some more that might be useful -

I just installed SQL Server on XP (SP2) attempted to access the Server
through JDBC and got a error abut the socket connect. After much searching I
find that the port is not active even though all app that would set the port
have port 1433 set. If you follow. I ran netstat -ano ...

I am using Crystal Reports 8.0 in Visual Basic 6.0 With SQL Server 7.0.
When I pass the parameters to the report to see the results the following
error message appears
"ODBC Error : [Microsoft][ODBC SQL Server Driver]Invalid Descriptor Index"

I use ODBC to operate SQL Server 2000. I want to know the data type for each
column in a table. But for image data, text , varchar.... , all the return
value are negative.
In addition, how can I realize a table structure copy with ODBC ?

I am using C++ to develop an application to support SQL Server 2005. I have
a problem whant I use SQLColAttribute function. It only returns "Collation
Name", instead of the real column's collation name. Does any body has any
idea?

ASP.NET application with intermittent returns of 503 errors with the
following message.
System.Data.SqlClient.SqlException: SQL Server does not exist or access
denied. SQL Server does not exist or access denied.

I installed SQL2005 as default instance.
After that I installed SQL2000 with instance name "SQL2K". Then I installed
SP4.
I can'not connect to SQL2K instance from remote machine. But if I log on at

A web application is running on a Windows Server 2003 and SQL Server
Standard Edition with JDBC-Driver. If some users are logged in, every
now and then a
user can't log in and the logged error is

I have a customer who's running an application that's using an OLE DB
connection to the database and when retrieving records a counter shows on the
screen. As soon as the count reaches somewhere between 3900 and 4000 the
counting stops and the grid never fills. The message ...

I am just starting in the SQL world, so I know this will probably be
extremely easy questions to answer.
1.  On a machine that doesn't have SQL Server listed in the ODBC, how do I
install that driver?  By installing MDAC?

I'm using SQL Server 2000 and I'm trying to connect via TCP/IP. When I test
it using telnet in port 1433, nothing happends.
I need to connect to this server via Internet.
How can I do?

On Windows XP running SQL Server, how do I create a user who will be
considered a "trusted connection?
I currently have SQL server set up for Windows Authentication? Do I have to
change this?

When trying to log into a ODBC connection as a power user on a network we
receive the following error:
Connection failed:
SQLState:'01000'