I have created a user (calladmin2) of a database in SQL Server Enterprise
Manager. When I load SQL Query Analyzer and attempt to File->Connect using
this user name I get:
Msg. 18452, Level 16, State 1

We have a classic ASP application which runs fine on NT Server, W2K Server and with SQL7.0 and SQL 2000.
However, we are having problems with IIS6.0 and Windows 2003 Server when connecting to a second Windows 2003 Server running SQL 2000 Server.  IIS6.0 and SQL on the same server ...

We have several loptops that run Windows XP and have SQL
Server databases, which we access through a Java
application. After WinXP Service Pack 2 was installed,
none of the laptops can connect to the database. We have

I need to find a way to connect from AS/400 DB2 to SQL Server database. Is
there any way to do this? I know how to go the other way.
I see that there is DB2 Information Integrator but it seems to be very
pricey.

I have a stored procedure that uses varchar variable to compose a query. It
uses input variables and is then executed using the EXEC(@var) instruction.
The procedure runs perfectly fine using Query Analyzer but when trying to
execute it (using a CallableStatement) from JDBC, it ...

Job 'bla' : Step 1, 'execute spbla' : Began Executing 2004-10-13 10:33:13
Msg 7410, Sev 16: Remote access not allowed for Windows NT user activated by
SETUSER. [SQLSTATE 42000]
I get the above error when I try to execute a sp sitting on a remote server

Can someone tell me where the connection string is set up in MSDE
TIA
cds

Can you use #temp tables in stored procedures that access data for a
website?
Will this not cause a slowdown if say 5 users of the website access the same
Stored Procedure at the same time?  As far as I can tell if I use a

I recently upgrade a WinNT 4 SP6a Proxy server to Win2K SP4 with ISA SP2. I
have to allow remote users to connect to a SQL server 7 SP4  on Winnt 4 SP6a
behind ISA. The IP is static. It was working fine with Proxy but now I have
the following with clients on the Web:

Problem:  I came in this morning, and our SQL server's IP address was
changed from a static to dynamic IP.  I changed it back, but not sure if
that is the cause of the problem I am having.
Running some reports in Access 2000 that queries through ODBC to our SQL

I am on an XP SP1 system and when I use the ODBC Administrator application
to establish a new SQL Server DSN the process fails.
After launching the ODBC Administrator I push the "Add" button and select
"SQL Server" from the list of available drivers.  When I then push the

I have installed Windows XP SP2 RC2 on a machine with SQL Server 2000.  I cannot connect to that machine's port 1433.  I have disabled the Windows Firewall.  I have run netstat -a to check what ports are listening but I don't see port 1433 and port 1434.
I have not tried telnet to ...

May be my question its simple, but I don't know the answer, I need to
connect to a named instance into a Remote Server using an IP Address, how I
can do that ???
Thanks

We have just had a 64-bit SQL Server 2000 cluster installed in our
network and I am having difficulties connecting to it.
The named instance I am trying to access is 192.168.0.108\DX
I can connect to it from a machine on the same subnet using Enterprise

Can someone advise where I locate the connection string in SQL server 2000.
I keep getting a "Server does not exist" message when trying to connect to
another SQLserver computer (although the server is running).
TIA