Archived Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
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 >>



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 >>


DevelopmentNow Blog