Why is it so hard to connect SQL2000 over Static IP?
I thought it would be as easy as setting up a static ip with the ISP, and
forwarding port 5000 from the router to the actual server box, and the
sql2000 instance running on the server would listen to the port and do its

I need to change the port SQL Server 2000 Listens on to 6521
I have went into the SQL Server     Utility and changed the port to
6521
I have also added this port to windows firewall exception list.

I have a client PC running a C# program that obtains data from an SQL Server
database.  The computer hosting the database is on a local network and is
accessed by using the following connection string:  Both computers are
Windows XP SP2.

on my pc I have sqlserver2000 and sqlserver2005
in odbc control panel, I create a new connection, but native client is
not listed.
I have uninstalled and reinstalled native client several times.

Hello.  I need to set add an SQL ODBC System DSN to each computer on
our domain.
The suggestions I've seen so far involve setting up a GPO startup
script using VBScript to call an API, or a batch file using odbcconf.

I have a Windows 2003 member server that has SQL on it.  I have a remote XP
machine in a workgroup that does have an account in the domain but does not
login to the domain (only used for OWA).  Is it possible for this machine to
pass its authentication (same username and password) ...

I have PHP 5.0.2 on Apache2/WinXP and database on MS SQL 2005 express.
I cannot connect to server:
Warning: mssql_connect() [function.mssql-connect]: Unable to connect to
server: TESTSERVER\SQLEXPRESS in C:\xxx\test.php on line 11

I'm a newbie to SQL Server 2005 and i've installed 180 days trial ver.
When i tried to open the SQL Management Studio,i get the following
error.Kindly help in resolving this issue.
Regards,

I use the SQL driver with a sql server 2005 database from a java struts
web application. I use
org.apache.commons.dbcp.DelegatingPreparedStatement as a delegate for
connection.

i think i am getting this error because of the jvm i am running.  can i use
this driver on a jboss server that only support jvm 1.3?
setup as follows:
mssql.xml in jboss\server\deploy directory -

I am using OSQL to create database.
When I am using it to create the database localy it works great when I
use the -s switch (target manchine) the call ended successfuly only the
database is created om my PC and not on the remote one.

Hello dear all,
I'm not sure if I'm posting to the right newsgroup,
if not please direct me to the right one.
I've installed "Microsoft SQL Server 2005 Express",

I have my J2EE application (SUN JAVA Application server ) accessing business
data stored in MS SQL Server 2000.
I'm using  com.microsoft.jdbc.sqlserver.SQLServerDriver class for JDBC
connectivity.

How do you compare the feature set as well as performance with JNetDirect's
JSQLConnect version 5.0 driver?
-payyans

I installed SQL Server 2005 on my XP Professional personal PC last night.  
Everything loaded OK.  But when I tried to access some of the servces, I was
prompted to connect to a server and the Server Name was blank.  I guess my
question is how do I set up my XP Professional to run ...