all groups > sql server connect > july 2005 > threads for july 15 - 21, 2005
Filter by week: 1 2 3 4 5
DMO SQLServer->Connect failed for user name with special characters
Posted by Ajey at 7/21/2005 12:59:19 PM
Hi,
If I give a user name or password having special character (mainly
semi-colon) then I cannot connect to the SQL Server. Following is the error:
Login failed for user 'a`~!@#$%^&*()_+|-=[]'.
TCP Provider: An existing connection was forcibly closed by the
remote host.... more >>
Too many connections
Posted by willyE at 7/21/2005 12:40:04 PM
We have many SQL 2000 server, that is not setup as a distributor or a
publisher. It is not involved in replication. we we have been
seeing a bunch of connections on the server from user
NT AUTHORITY/SYSTEM application SQLDMO executing exec
sp_helpdistpublisher @check_user = 1 a number of time... more >>
Access denied after OS Disk upgrade!?
Posted by TomJ at 7/21/2005 12:29:55 AM
I recently had to upgrade my WIN-XP SP2 OS harddrive. I am now getting the
following error message when I attemp to start MSSQL 2000 Developer edition
through Enterprise Manager or Query Analyzer: "A connection could not be
established to (LOCAL) Reason:SQL Server does not exist or access deni... more >>
TCP/IP Connection to new Windows2003 SQL Server
Posted by Francois at 7/19/2005 2:40:02 PM
I've just dropped a new Windows 2003 SP1 server with SQL Server 2000 SP4 in
my hosted center. That server replaces an older Windows 2000 based server
running SQL Server 2000 SP3. I have a firewall-firewall VPN setup between my
office network and the data centre. I also have two seperate dom... more >>
Need to find all named ranges in Excel workbook from DTS
Posted by Andy S. at 7/19/2005 10:52:30 AM
I'm trying to write an activex script to read in all the named ranges that
end with a $ in an Excel workbook from a DTS package. I've gotten as far as
grabbing the filename of the excel file. I've been trying to find an answer
without much luck, does anyone have any suggestions?
--
... more >>
intermitent connection failure
Posted by scottrm at 7/19/2005 7:51:06 AM
We have written a thread to monitor whether the database connection is still
alive or not.
This monitoring thread executes a stored procedure, sp_TestDB, with ADO
_CommandPtr every 3 seconds.
Most of the time we have no problems executing it. However, we receive the
following error rand... more >>
Unexpected Login Screen When Accessing SQL Data Via .NET Intranet
Posted by Scott Thompson at 7/15/2005 12:56:01 PM
I have an intranet application running on IIS 6. It accesses SQL Server 2000
data and the SQL Server is on the same server. I know that it's not great to
use IIS on the SQL Server, but we're behind a firewall, have a pretty small
user base, and everything's been working fine for over a year.... more >>
Parallel Install 2005 CTP & 2000 Leads to Connection Problems
Posted by The Oracle at 7/15/2005 11:02:02 AM
Hey All,
More fun and games with SQL Server 2005.
Mike: thanks for your help before on the Beta. I was able to uninstall and
regain connectivity. I didn't have to wipe the box, but came close!!
Here is a new twist:
Previous situation:
- One data server
- 2 instances: SQL Serve... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
|