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 2004 > threads for april 8 - 14, 2004

Filter by week: 1 2 3 4 5

Third Party Software can't connect with SQL Server using TPC/IP
Posted by Armando at 4/14/2004 6:13:15 PM
Hello all, I have this really really strange problem with one of the application we support in Latin America, this is a 3rd party software for accounting that uses SQL Server for it's DB handling, we are using SQL Server Client Network Utility to connect to the SQL, but this morning, the ...more >>


Weird Problem
Posted by kpatel5 NO[at]SPAM utk.edu at 4/14/2004 1:48:48 PM
I have a weird situation here... I have a website with asp pages running on windows 2003 server that updates a database running on a sql 2000 server.(The web site was developed using visual interdev and has DTCs) The site works fine when browsed using windows 2000/xp machine. But, when i br...more >>

PROVIDER=SQLOLEDB connection error
Posted by Laura at 4/14/2004 10:40:46 AM
I am connecting to my database using PROVIDER=SQLOLEDB; I am gettting the error of "Requested Operation Requires an OLE DB Session Object, which is not supported by the current provider" I have MDAC 2.8 and SQL 2000. Has anyone come across this error? Thanks....more >>

RDS
Posted by nahumkl at 4/13/2004 8:29:31 PM
I am trying to connect to my SQL server but I keep getting this message: RDS Failed to execute SQL="SELECT * From Users WHERE UserID Like "name"', err=-214012889, Desc="Internet Client Error: Cannot to Server./nRetry? Can someone help me decipher this and give a solution Pleae!...more >>

'sp_addlinkedsrvlogin' requires sysadmin account
Posted by Mike at 4/13/2004 1:59:58 PM
Hi, I'm using 'sp_addlinkedsrvlogin' in a stored procedure that pulls data from Oracle into SQLserver2K. BOL states that only members of the sysadmin and securityadmin fixed server roles can execute sp_addlinkedsrvlogin. How can I get around this such that non-sysadmin users can use...more >>

SQL Server does not exist or access denied - Enterprise Manager Clustered SQL 2000
Posted by Phil Holmes at 4/13/2004 1:49:20 PM
Help, I can no longer connect Enterprise Manager (register) to a clustered (un-named instance) of SQL 2000 running on 2kadv from a particular XP pro machine and another Windows 2000 Server, it lists the above error. I can connect to several other (all non-clustered) physical servers from thes...more >>

what happend if deny login to "sa"??
Posted by Hernán_Castelo at 4/13/2004 1:36:21 PM
hello well, its all said: what happend if deny login to "sa"?? i get more secure? -- atte, Hernán Castelo UTN Buenos Aires .. . . . . . . . . . . . . . . . . . . . . . . . . . ...more >>

SQL Server/ADO/XP problem "query cannot be executed"
Posted by George Copeland at 4/12/2004 10:42:31 PM
This is a request for help fixing a SQL Server 2000/ADO problem on Windows XP. I would appreciate any useful assistance. PROBLEM: SQL Server access on my machine fails as follows: 1. All of my VB6 apps reference the following ADO typelib: Microsoft ActiveX Data Objects 2.7 Library Locate...more >>



SQL Server 2000 Security
Posted by Lawrence at 4/12/2004 9:48:55 PM
Hello, I need to setup a web server on our DMZ in the firewall. This web server has a linked server on the LAN that is protected. I can open up an access rule for web server to connect to sql database on LAN by opening port 1433 to LAN database. What security risks I'm I looking at? Is this th...more >>

replication / dmz
Posted by Hernán_Castelo at 4/12/2004 5:50:57 PM
hi if have a firewall with 3 nic cards - 1 for incoming - 1 for intranet - 1 for web app so that intranet is isolated from the web server its still possible "replication" from the intra-net SQLServer to web server ? -- atte, Hernán Castelo UTN Buenos Aires .. . . . . . . ...more >>

Strange problem connecting from asp.net
Posted by Tim Almond at 4/12/2004 4:13:19 PM
If I run my application, I get a 'database does not exist'. If I then go onto the machine with the database on (different machine) and log in to query analyser, I can then go back to the web browser, it connects fine. Three machines involved... My PC web server db server Order of events i...more >>

SQL SERVER registration failed because of thhe connection failure
Posted by Seena Blace at 4/12/2004 8:59:21 AM
Hi, The ping between 2 sql server box is working fine.But when I'm trying to register to second box on first sql server box,It's showing following error. " SQL SERVER registration failed because of thhe connection failure sql server does not exist or access denied" can some one suggest how ...more >>

I get this error on my SQL server 2000
Posted by Mark at 4/11/2004 11:12:51 PM
When I try to connect to my SQL server 2000 which is installed on WIN 2000 server. The folloeing message box appears: "This service doesn't exist as an installed service", also in some ocasions it will give me error 1060. This SQL server instance was working ok, till I removed an appli...more >>

Connecting to SQL server Over Internet/ Phone line etc.
Posted by Lisa Jones at 4/10/2004 8:16:05 AM
Hi I am have an application that is running on table PC and connecting to SQL server using wireless network. But I want to be able also connected to the SQL server from other locations. Is there a way to do that? Without changing all my routines with web services? I am looking for a way for exampl...more >>

Heterogeneous Query and ANSI_NULLS/_WARNINGS
Posted by Troy at 4/9/2004 1:06:06 PM
I'm trying to create a stored proc that creates a link to a remote server and executes other stored procedures as needed. Each of the sub-procs will be running Heterogeneous Queries I'm having trouble creating these sub-procs, I get the error message that state Heterogeneous Queries require AN...more >>

Wireless Connectivity
Posted by MP Lopez at 4/8/2004 1:11:02 PM
We use an application that utilizes SQL 2000. This application was written by a company that happens to be our IT support as well. We do have a wireless network installed and our users use thin client machines. We wanted to purchase tablet PCs for them and have them run as Fat Clients. Our IT compan...more >>

scope_identity through ODBC
Posted by George Keradinides at 4/8/2004 4:46:05 AM
I have a problem retrieving the scope_identity through an ODBC connection (Excel for Example). It returns null Any idea Thank ...more >>

Connect to SQL Server from ASP.Net and through firewall
Posted by Scott Simms at 4/8/2004 12:31:07 AM
We have a development SQL Server 2000 (running on Win2K SP4) machine that we want to move into our DMZ and access it via the internet and our internal LAN. We have opened the firewall to allow our applications on the LAN to connect to SQL server in the DMZ. We connect to SQL Server using the .Net...more >>


DevelopmentNow Blog