we're running SQL Server 2005 on a Windows Server 2008. One networkcard -
fixed IP 192.168.3.1 (WAN) - is the internet gateway. The other - 192.168.0.2
(LAN) - connects this server with our local network.
As long as the WAN network cards is disabled, the default instance of SQL

I've got a problem with connecting to sql 6.5.
There's an old application running on sql 6.5 with windows 2000 server.
Some new applications running on another server (sql 2000 sp4, windows
2003 server sp1) need to connect to the sql 6.5 by Data Transformation

I need to test the multi-user connection (500-600 users) for the SQL Server
2005 and for some dbs in this environment.
Does exist any tools in order to do it?
Many thanks

Is it possible to connect to and manage a remote database on the Internet
using SQL Server Management Studio for Express? If it is, does anyone know
where I can find step-by-step instructions on how to establish the connection?
I currently have SSMSE sp2 and I cannot get it to ...

I have an auto generated excel file(.xlsx) in a particular format .
I tried importing the file to the SQL server database using the query
below.
SELECT * INTO temp_ExcelData2 FROM OPENROWSET('Microsoft.ACE.OLEDB.

I'm having a problem connecting to SQL-Server 2005 using the JTDS 1.22 JDBC
driver.
This occurs for only one of two SQL-Server 2005 instances I have.  The  
specifics are:

I am not conversant with SQL but I need to know what tools or apps can be
used to connect to SQL Server 2005 on SBS 2003 Premium or what methods there
are for connecting to it. Basically, my manager (who knows nothing about
databases) demands that he needs to connect to the ...

A reboot of an older server running Windows Server 2000 and SQL Server 2000
seems to have resulted in a cascade of issues.  Obvious results include the
desktop profile and internet access being reset to default, applications set
to start with the OS no longer do and SQL Server ...

We have few DTS packages, which I moved from one SQL Server instance to
another SQL Server Instance. Below are the configurations of Old SQL server
OS – Windows 2003 Sp2 x 32 bit
SQL Server – SQL Server 2000 Developer Edition

if SQL Server uses pooling even if i didnt do any setting in my connection
string i wanted to know haw this default setting will behave if i sent with
each connection string of my application a different user name and password ?
will it make a new pool for each connection ? isnt ...

How do I resolve the Micosoft SQL Server Login Error Message Prompts:
Connection fail:
SQLState: 08001
SQL Server ERROR: 17

I am working on SQL2000. Lately I find some users repeated executing INSERT
OR DELETE on SQL2000 remotely. May I disconnect these users when they
execute Insert operation 5 times? How can I relize it? Or may I disconnect
specified user by user name?

I am trying to connect to a demo version of the Northwind.mdf database file
that goes along with a Microsoft tutorial on ASP.NET
I have a running version of SQL SERVER Express on my system  and whether I
try to attach to the database file using Server Managment Studio Express or

We have a java app connecvting to SQL 2005 SP2 via JDBC. The connect gets
established for the first 60 seconds or so. We test the connection pool after
120 seconds (Select 1) but the server sends a connection reset error. If we
change the test to occur every 30 second, the ...

I have SQL Server 2005 SP2 running with Shared Memory and TCP/IP network
protocol enabled. Encryption is also enabled on this instance. I have several
test machines with similar configuration. But some SQL Server instances
report the error 17835 with the message "Encryption is ...