all groups > sql server connect > april 2004 > threads for april 1 - 7, 2004
Filter by week: 1 2 3 4 5
connect to cluster server issue
Posted by Yuling at 4/7/2004 4:11:07 PM
Hi
I had SQL 2000 client, and tried to register to SQL 7 cluster server in Enterprise Manager. But the registering process hang
Does anyone know the issue? It happen to other users as well
Thanks
yuling... more >>
Connection problem when registering a remote SQL2000
Posted by Charles at 4/7/2004 2:09:39 PM
Hello,
I try to register a remote SQL Server 2000 installed in a W2003, but it
doesn't work. Afer 6 or 7 seconds, it says: Timeout expired.
In that network , port 1433 is open and what it really surpises me, is that
I can connect via ODBC to any database of that remote SQL Server2000 !!!
... more >>
connecting to sql from ASP
Posted by Ngan Bui at 4/7/2004 12:42:14 PM
I created a webpage where someone can enter in new client
info. Using asp, I want to connect to the sql db and add
the new record. I'm using SQL2k in an W2K environment. I
want to use the trusted connection so SQL would use the
windows login to authenticate. Below is the code for
conne... more >>
Unable to Connect to Database
Posted by Wolfgang at 4/7/2004 12:07:20 PM
I just upgraded a WIN98 PC to WINXP. The PC is running
SQL Server 2000 Personal Edition. After upgrade to WINXP
the SQL Server will not start. I get the following
error:"An Error 1060 - The Specified Service Does Not
Exist as an Installed Service..." There are no SQL
Services listed un... more >>
Timeout expired. Help!!!
Posted by ak at 4/7/2004 10:34:13 AM
Hallo,
when I try to perform a SELECT statement against a view with Enterprise
Manager or with a VB 6.0 application, I get the following message:
[Microsoft][ODBC SQL Server Driver] Timeout expired. This appears on both
SQL Server 7.0 and 2000.
The SELECT Statement works on the Query Analyz... more >>
sql server job failing
Posted by biju george at 4/7/2004 5:29:37 AM
Hi Guys,
from sql server 2000 (desk top) i created a link to oracle
7.3 and created a procedure which will update sql tables
and insert into oracle table.
from query analyser i can execute this procedure. but when
i configure a job to execute this procedure it is failing?
any idea
pls advi... more >>
Cannot connect via Linked Server
Posted by Frank Jones at 4/6/2004 6:16:03 PM
We have two servers, each with named instances of SQL Server 2000 SP3a installed. Server1\Instance1 has a linked server to Server2\Instance2. The linked server is using the SQLOLEODB provider. This linked server is setup with remote login and a correct password. We get an error #17: SQL Server d... more >>
Problem connection to SQL Server with ODBC
Posted by Ian Spanswick at 4/6/2004 10:12:37 AM
Hi,
Getting very frustrated by the following problem, using SQL Server 2000 (inc
SP3a), using an application that connects to a DB via ODBC and the following
error message comes up:
Connection failed:
SQLSTATE: '01000'
SQL Server Error: 1703
[Microsoft][ODBC SQL Server Driver][Shared Memo... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
MS Query Analyser and MS Access
Posted by Evan Tomlinson at 4/6/2004 5:07:47 AM
Hi,
As far as I understand MS Access supports the SQL language, thus it should
be possible to use tools such as MS SQL Query Analyser to connect to your MS
Access database. But I cannot get this to work.
My thought was to use the path to the file rather than the name of the
server, but this... more >>
SERVERS
Posted by CHRIS MOOS at 4/5/2004 7:01:05 PM
HOW DO I GET CONECTIVITY FROM THE SERVER TO THE CLIENT?... more >>
How do I find I am administrator?
Posted by Sunny at 4/5/2004 3:26:18 PM
This is the first time I will be using SQL server although I have good
experience in FoxPro and ACCESS database, I have limited knowledge of SQL
server.
We have installed SQL server 2000 on WIN2K. Our IT people has installed
Enterprise Manager on my win2000 workstation. How do I find I am in a... more >>
In Plain English
Posted by Nick DiToro at 4/4/2004 11:33:45 AM
I am a project manager trying to implement a 3rd-party application at my
company. The application has a FAT client and a SQL 2000 Server DB. The
guidelines from our infrastructure security group are as follows:
1. Authentication to the SQL server must not use SQL authentication.
2. The crede... more >>
cannot connect to sql server 6.5 after installed the mdac 9.0
Posted by Simon Wu at 4/3/2004 12:05:15 PM
Hi all
I cannot create the odbc connection, the error says this mdac I am using des
not support sql. server 6.5 or older. Can anyone have ideas on it?
Simon
... more >>
net session \\servername /delete
Posted by Winn, Chris at 4/2/2004 5:18:26 PM
Anyone know how to perform this on a remote server?
Thanks,
Chris
... more >>
Can't Connect to SQL Server
Posted by Me at 4/2/2004 4:27:13 PM
someone told me to delete BUILTIN\Adminiistrator becuase
it was a security risk and now i cant access the
Enterprise manager.
can anyone help?... more >>
Weird Locking Issue
Posted by Randy at 4/2/2004 3:14:07 PM
I develop on an Access Database that is a Front End to SQL Server. We
have been sailing along for years without any problems. Now, several of
our customers are starting to have weird locking problems. Innocent
seeming passthru queries are causing Table Locks. Simple COmbo box look
ups on... more >>
Problem in starting local SQL SERVER
Posted by Siva at 4/1/2004 10:40:12 PM
When I try to start my local sql server it is giving the
following error.
"An error 23 - (Data error(cyclic redundancy check))
occurred while performing this service operation on the
MSSQLServer Service."
Can anybody help me out in this issue..
Thanks & Regards
Siva... more >>
Connecting to a remote server
Posted by Murphy at 4/1/2004 9:13:02 PM
We are setting up a webserver (172.16.0.2) that lives in the DMZ behind our
firewall (172.16.0.1)
I would like this server to connect to a db that lives on an SQL Server
(PDC: 192.168.16.2) on our internal lan.
I have opened port 1433 on the firewall between 172.16.0.2 & 192.168.16.2
On the web... more >>
|