Hi everyone, I need your expert advice. I have a w2k AD service with mssql on
it. and I setup another w2k server with IIS on it as webserver. my website
works on NT servers, but when I moved the website to the w2k server, it
doesn't work. It saids:

Can I administer SQL 2000 MSDE Release A from SQL Server's Enterprise
Manager (EM) located on another machine on the same network?
When I try to do this the EM setup wizard locates the host running MSDE but
it cannot connect either with Windows authentication or the strong password

I am retrieving data ntext/text data from SQL using the Microsoft JDBC
driver.
String text = rs.getString(1);
I am noticing that all of the hyphens are being replaced with question

I'm getting this message while performing a BCP command...
can anyone tell me what this means?  Do any of you know
where to find a list of explanations of NativeErrors and
SQLstate errors as well?

This is my first post so I apologize for any errors in my
post.  
The problem: my java programs that use Microsoft JDBC
drivers will no longer connect to the SQL Server 2000

I ammaking use of the microsoft JDBC driver.
In the SP, in a transaction when a error is encountered --> fatal error (PK violation / incompatible data types) then the control returns to the application abruptly.
the error handling within the SP is not carried out.
Any help on the ...

Hi, when using EM to open any table or diagram from a particular database I
get the following message (no error number)
ODBC error: [Microsoft][ODBC SQL Server Driver]Communication link failure
I’ve run DBCC CHECKDB and everything seems ok.

I installed a SQL 2000 (with service pack 3a) on a  Windows 2003 server ,
but Windows 2003 server still automatically close down TCP/IP listening for
SQL ; I reinstalled both 2003 server and SQL server with sp3a again , But I
am still not able to open that listening , any idea ?

While I am trying to open enterprise manger it's showing
the error login failed to the user,Even I am trying to use
domain adminacct I am unable to open it.My sql server
agent also not starting

I've been looking at this problem for hours and hours - any help most
gratefully received!
I'm trying to set-up a test scenario between my desktop running SQL Server
2000 and my laptop (also running SQL Server 2000).  Both machines are

Actually, it appears to install fine.  I used the command line parameters
setup SAPWD="strongpassword" SECURITYMODE=SQL as the instructions described.
I've tried with the double quotes and without.  I've tried on a machine
running  Windows 2000 and XP (home addition).  I tried ...

I have 2 load balanced servers.  One went down and I am
rebuilding it, I would like to somehow import all of my
DSN's from box #2 so I don't have to recreate it all.  I
would also if possible like to set up appcenter to

I am trying to understand this. When i choose either windows NT
authentication,
or SQL authentication and specify an SQL login and a password, the user
credential

My Data Link (udl) files stopped working on just one of
my pcs. The pc has been updated with mdac 2.8. I cant
figure out what could have caused the 'corruption'? but
i've tried creating a new one and get the same error.  

Is it possible to call a stored procedure with parameter
names instead of indexes?
I've only noticed setString(int, String) in ms-jdbc, but
is there setString(String paramName, String) or can you do