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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|