all groups > sql server connect > april 2005 > threads for april 1 - 7, 2005
Filter by week: 1 2 3 4 5
Linked SQL Server and Windows 2003 Firewall/SCWQL
Posted by WJ at 4/7/2005 10:14:30 PM
SQL Experts,
1. I have two Windows 2003 Standard Server boxes.
2. Both host MS/SQL Server Standard 2000.
3. Server#2 is linked to Server#1 using SQL/Enterprised Link Server applet.
4. Both servers have Win2k3 Service Pack#1 installed.
5. Both server enable firewall via SCW (Security Config. W... more >>
Netstat TIME_WAIT on SQL Server Connections
Posted by Jesse at 4/7/2005 9:57:26 AM
If I understand correctly, the TIME_WAIT Status when you do a NETSTAT on the
server indicates that the connection has been closed, and it is waiting to
clear. Is that right? If so, we have a lot of SQL Server connections that
are in TIME_WAIT status mode. We may have well over 100 or so of ... more >>
How do I registry the OLE provider for a Exchange 2000 database.
Posted by Dave at 4/7/2005 7:53:22 AM
I receive the following error when I try to query an Exchange database.
Server: Msg 7403, Level 16, State 1, Line 1
Could not locate registry entry for OLE DB provider 'exoledb.DataSource.1'.
OLE DB error trace [Non-interface error: Provider not registered.].
How do I registry the OLE p... more >>
How to move a database
Posted by Clayton Sutton at 4/6/2005 3:40:25 PM
We are running Windows 2003 and MS SQL 2000 w/sp3. Contractors came in and
installed SQL and databases on a RAID 1 disk volume. We want to move the
all the databases (about 4) to a RAID 5 disk volume. Can someone tell me
how to do that. Will there be any downtime while moving the DB? Any ... more >>
intermittent connection problems
Posted by scott.yoder NO[at]SPAM ngc.com at 4/6/2005 2:19:09 PM
We are having an intermittent connection problems with some DTS
packages. We get the following error about 1 out of every 15 days
Login failed for user '(null)'. Reason: Not associated
One DTS package connects to remote SQL servers with a linked server,
another package uses a OLE DB provide... more >>
Problem in W2K and SQL2K
Posted by Arnaldo Fuziy at 4/6/2005 1:49:17 PM
Hi,
My name's Arnaldo and I'm from Brazil (so please forgive me for the poor
english). We use Windows 2000 Server (SP4) with SQL Server 2000 (no SP).
We've been facing a problem for some time now: on January 28th, our system
stopped responding for some reason. When we passed the mouse over the... more >>
"Server does not exist or access is denied"
Posted by CAN'T SEE THE SERVER FROM VS SERVER EXPL at 4/5/2005 10:53:02 PM
Hi,
I am trying to connect a web service to an SQL Server 2000 database. SQL
Server is installed and started and the database appears on the Enterprise
MAnager window but it does not appear in the Server Explorer in VS2003.NET
IDE window.It gives the error "Server does not exist or access i... more >>
server group error
Posted by chunky at 4/5/2005 8:10:57 AM
when trying to open server group...sql is not known to be running would you
like to connect? error
how do i configure that error?
--
chunky... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
missing DTS connections
Posted by Talonsys at 4/5/2005 3:31:06 AM
I am running SQL server 2000 service pack 3 on a windows XP professional
service pack 2 machine. There are four developers using the same
configuration.
All of us have missing connections in the DTS designer. All that is
available are the following:
Microsoft OLEDB provider for sql server
... more >>
Web hosting and SQL Server Enterprise Manager?
Posted by John at 4/5/2005 12:00:00 AM
Do you guys have any idea if web hosting companies usually give access to
SQL Server databases through Enterprise Manager?
I used to have have access to my DB through EE with my previous provider and
now the more I am looking into offers on the net the less I can see this
feature specified.
... more >>
2000k connect from outside domain
Posted by Datasort at 4/4/2005 1:17:06 PM
Login Problem:
Trying to log into a 2000K SQL Server using a windows user account when not
logged into the domain.
Is this possible?
Example:
Domain Account is : aaa
Password is: password
Domain is: domain1
On the Server Box1 have a windows user account called :
\domain1\aaa w... more >>
Last rites declaration of Ioannes Paulus PP. II (Karol Wojtyla)
Posted by Ioannes Paulus PP. II (Karol Wojtyla) at 4/4/2005 8:34:27 AM
"The unforgiveable sins this earth must confront and overcome are
Nationalism, capitalism, and hoarding. The idea of every nation
should be forgot, price should be struck from the commons, and
princes should be seen for the devils they are. The sins include
our church, secret societies... more >>
SQL Server 2000 Generating fatal exception c0000005 When Using Int
Posted by JP Burford at 4/4/2005 7:31:03 AM
I have a SQL server running on a Windows 2000 Server SP 4 and I am having
problems connecting to it. When I attempt to connect to the server using
integrated security as a user in the local Administrators group on the server
I can connect just fine. When I attempt to connect to SQL server us... more >>
Cannot open database requested in login fail for 'Computer\NetSDK'
Posted by jaz2003 at 4/3/2005 10:29:02 AM
Hello;
I tried almost everything I can, give permission to ASPNET to the folder
application, start and restart ASPNET, SQL$Server, checked my sqlstring
connections in the global.axp.vb and still cannot connect to the database.
I am using MSDE (Free engine from microsoft), Can someone please he... more >>
SQL SERVER LINK PROBLEM
Posted by Savas Ates at 4/2/2005 4:56:19 PM
my sql server is not in local network.. it is in remote network... and its
ip , username and password is true...
coz i can access it from enterprise manager from my local sql server...
i looked at my permissions.. from users in my database ...
in my dbo public and db_owner permit checked...... more >>
LINK SQL SERVER DATABASE FROM ACCESS
Posted by Savas Ates at 4/1/2005 7:57:36 PM
i tried link to sql server db from access and i failed.... (What is my
fault.. I think It doenst ask me catalog -database name so it doesnt accept
my username and password..It cant find my username and password which
database has it ..)
i follewed these steps...
1.right click and link ta... more >>
Understanding TDS
Posted by Craig Berntson at 4/1/2005 2:57:22 PM
I'm trying to track down why some workstations are have performance
problems.
Both the "good" and "bad" workstations are running the same EXEs and using
the same MDAC rev. We're connecting with ADO to SQL Server 2000. Both are
connecting with Windows Authentication.
Looking at the networ... more >>
SQL Error
Posted by RTT at 4/1/2005 11:59:37 AM
I keep receiving an SQL error. Not everytime but frequently. Does anyone
know what to problem could be? This is the error i recieve:
Timeout expired. The timeout period elapsed prior to obtaining a connection
from the pool. This may have occurred because all pooled connections were in
use and ... more >>
Connection Timeout
Posted by Fred Herring at 4/1/2005 8:17:02 AM
I am trying to upload data to my sql database via a web service installed on
the same machine as sql server. When my upload takes more than about 2
minutes I get a timeout error message from my web service and the data
tranfer was not completed. Transfers taking less time complete
satisfac... more >>
Unable to remotely connect to all SQL Instances
Posted by Travis Lingenfelder at 4/1/2005 7:41:07 AM
I have four instances of SQL server running on my Server 2K3 Small Business
Server, they are the default instance, SBSMONITORING, SHAREPOINT, and
SANDBOX. I am able to connect to the default instance and the SBSMONITORING
instance from a remote computer. When I try to connect to the SHAREPOI... more >>
|