all groups > sql server connect > september 2004 > threads for september 1 - 7, 2004
Filter by week: 1 2 3 4 5
SQL 2000 server TCP bind problem
Posted by mmazick at 9/7/2004 5:28:27 PM
I am running SQL 2000 sp3. I am getting an error in the
log files that states the SQL server "can not bind to
TCP: port 1433"
I can not find much info on this other than what is in
the log files. It appears that the server errored last on
an integrity check of the SQL master db.
Is th... more >>
problem
Posted by Inamori Izumi at 9/7/2004 10:58:50 AM
My win 2000 server is connected with MS SQL server 2000
There are around 10 applications on this server. Some webpage will be
refereshed itself within 20 seconds to retrieve update data in sql server
This server run 2 years till now.
Recently we face the problems. When refershing the page,... more >>
xp_fileexist to SAMBA-mounted drive
Posted by Tillman Erb at 9/6/2004 1:01:03 PM
I am unable to get xp_fileexist to view files on a SAMBA-mounted Unix/Linux
share using SQL 2000. I have successfully mounted the drive as a mapped drive
on the SQL server. I am using UNC to reference the share.
Is this possible? Am I missing a network or security setup configuration?
Tha... more >>
Creating link via Internet
Posted by Oded Kovach at 9/6/2004 11:13:55 AM
Hello there
I have local sql server database on my server
I have also another sql database on my internet
I would like to transfare data from my local server to the internet server
at 12:00 pm every day
How can i create kink to the database on the server?
... more >>
SQL Server - NT Connectivity.
Posted by Manyam. at 9/6/2004 2:19:28 AM
Hi,
I have a concern, Well I wan't to connect to a sql-server,
without having the UserID and Password. But the server
exists in the same domain. The problem is that, the server
to which I connect, can change the IP Address and I may
not be able to Identify at my side. So, can we have any ... more >>
OLEDB connection error
Posted by J Demory at 9/6/2004 12:53:02 AM
I could sure use some help.
I'm running Sql Server 2000 on a windows 2003 server using windows
authentication only. I can successfully run the following opendatasource
sproc from query analyzer on the windows 2003 server, however when I try to
run it from query analyzer on another machine in... more >>
The ConnectionString property has not been initialized.
Posted by Hugh G. Johnson at 9/5/2004 9:45:54 PM
I have a asp.net and SQL 2000 db ecommerce site template I purchased. I
installed the database via running a script in QA and have connected to the
DB through QA and EM with no problems. However, when I try connecting via a
Connection String I get the error "The ConnectionString property has not
... more >>
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
Posted by Riane de Oliveira Torres Santos at 9/3/2004 12:00:03 PM
I Still have problems.
Now I have two win 2k server, one with IIS and one with Sql Server 2k.
When I try to access from a client with 2k professional i have this error:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
sa Password changing
Posted by Tony Wheeldon at 9/2/2004 4:11:38 AM
Running SQL 2000 (with blank sa password tut tut!!)on
Windows 2003. On Tuesday all connections to SQL server
failed. Checked ODBC connection and it too failed.
Checked in EM and reset sa password back to 'blank'. All
seemed OK. This has now happened 4 times since then.
There was a worm a w... more >>
XP SP2. COM+ with transaction couldn't open connection to sql serv
Posted by Tueur at 9/2/2004 2:41:04 AM
Situation:
Database server on WinXP SP2: SQLServer2000 SP3
Client machine on WinXP SP2: VB6 COM+ and VB6 client application.
Firewall is disabled on both machines.
There were no troubles before installing SP2.
We have test component, with one public method which calls directly
from client. ... more >>
Must specify protocol/Named Instance
Posted by Kevin3NF at 9/1/2004 1:41:21 PM
SQL Server 2000 standard, sp3
Win2K Adv. Server, SP4
CLients are XP SP1, WIn2k Pro
Server has two named instances, no default.
First NI works normally. Users connect via:
servername\instancename
On the second (New) named instance, users must specify the
port or the pipe and the proto... more >>
Loss of server
Posted by Griff at 9/1/2004 9:47:25 AM
Dear all
Having read BOL, I was of the understanding that if a machine was lost
(anything but disk failure) then it was very difficult to recover the data.
The reason being that the data- and log-files were still "attached" to the
dead SQLServer and needed to be detached from it before they co... more >>
|