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 > july 2003 > threads for july 22 - 28, 2003

Filter by week: 1 2 3 4 5

IIS 6.0, Windows 2003, SQL Server 2000 Integrated Authentication error (null user)
Posted by Julie Cooper at 7/28/2003 2:15:32 PM
Hello, I have been attempting to configure an intregrated (AD and Windows) authentication between two servers running an ASP.NET/SQL Server 2000 environment for months. I have not been able to make this work as documented, no matter what KB articles I follow or how much I upgrade software. ...more >>


monitor_"Number_of_Deadlocks/sec"
Posted by hb_zhang at 7/28/2003 1:37:29 AM
we monitor "Number of Deadlocks/sec" use system monitor and SQL alert, but we get the very different result, system monitor only get 1 or 0 SQL alert get mor than 100. Why the value is so fidderent? which value can we use for performance tuning? Thanks....more >>

OLEDB
Posted by anjelina at 7/26/2003 9:28:37 PM
I have an application written using powerbuilder and want the application end users to connect using the OLEDB drivers. How do we setup the Client machines to be able to connect. In ODBC we created a system DSN. What do you need to do for OLEDB?? Thanks, Anjelina...more >>

Connection error from Project2002 to SQL-server - wrong server-name
Posted by Kasper at 7/26/2003 1:25:07 PM
Hi When connection from MS Project 2002 using the Enterprise options, I'm confronted with a dialogue-box saying: Connection failed: SQLState: '01000' SQL Server Error: 53 [Micosoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). Connection failed: SQLState: '08001' SQL Ser...more >>

Database connection failure
Posted by yang at 7/26/2003 1:46:57 AM
Hi, We have a SQL 2000 which is used as CMS and application database. Recently the web site seems very unstable and hangs a few times per day. When the problem occurs, we just stop and restart the SQL service, then it works. In the application error log, it says "[Microsoft ODBC Driver]...more >>

HOWTO: Block SQL Server EM connections (or visibility of inaccessible databases)
Posted by R Baker at 7/25/2003 6:17:07 PM
Is there a way to grant access to a SQL Server database while not permitting connections via SQL Enterprise Manager. We find that it is showing all the database names (even those for which the connecting user has no access/permissions), and this is a security exposure. Thanks! ...more >>

Datetime field in linked server
Posted by B. Cline at 7/25/2003 4:36:20 PM
Hi, I'm getting the following error (loosely translated from the German) while trying to query a view in a linked server: View SELECT AUFTLT FROM AUFTRAEGE WHERE (AUFTLT > convert(datetime, '20030714',112 )) Error: During the converstion of a char-datatype in a datetime-datatype, the d...more >>

SQL Connection problem
Posted by Aboki at 7/24/2003 1:42:40 PM
This is the error my user is getting. The environment is clustered. He can connect to the other two clustered environments in QA and dev. but not in production. Connection failed SqlState:'01000' SQL Server Error:10061 [Microsoft][ODBC SQL Server Driver][TCP/IP sockets] ConnectionOpen (...more >>



Newbie Connection String Issue.. SQL Server 2000
Posted by Brent at 7/24/2003 1:19:55 PM
Hi, I'm running SQL Server 2000 that came with Office XP developer. I am trying to connect to a default instance of SQL Server through a C# file using the SQLConnection object. ie, SqlConnection cn; cn = new SqlConnection ("server=xxx;uid=sa;pwd=zzz;database=Northwind;" ); My O...more >>

Connection problem after running SQL Critical Update Kit
Posted by JeffDrummond at 7/24/2003 12:17:02 PM
I installed the SQL Critical Update Kit to get rid of the Slammer. I am now unable to use user id = sa to login. Any thoughts?...more >>

Communication Failure
Posted by Robert Bemmer at 7/24/2003 9:19:40 AM
My NT4.0 server is running SQL 7.0. My clients are a mix of NT4.0 workstation and Win2k Pro. The problem is on my NT4.0 clients which are on a wireless network. I keep on getting the following error ... 7/22/2003 2:19:31 PM Module...Inven Activity...Inven.bas, GetPaperID. Error -21474672...more >>

Why Windows authentication slow?
Posted by Srinivasulu at 7/22/2003 7:38:03 PM
Dear All, In my VC++ program I am trying to connect to SQL Server 2000 using ADODB. When I am using windows authentication ( ie strConnection = "Driver={SQL Server};Server=MyServerName;Database=MyDatabaseName;Trusted _Connection=yes;" ) it is very slow( Approx 60 %less) when compare...more >>

Error 5177: Encountered an unexpected error while checking the sector size
Posted by Tim at 7/22/2003 5:38:20 PM
I'm working with SS2K, and this error appeared over the weekend. The error occurs during service startup when trying to create TEMPDB.MDF, and so, the SQLServer service will not start. Anyone see this before or have some suggestions? Thanks...more >>

IP Change on Standalone
Posted by Timotheus at 7/22/2003 12:08:30 PM
Can SQL Server 2000 EE in a standalone environment automatically adjust to a change of the server IP address?...more >>


DevelopmentNow Blog