|
|
|
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 |
Filter by week: 1 2 3 4 5 Changing SQL2K port no. on Windows 2003 Posted by Ayad at 5/21/2004 3:57:48 PM Hi,
I installed SQL2K SP3a on Windows 2003 server. During the install I changed
the SQL port number 1433 to 14330. Everything finished successfully.
But when the clients are trying to build the ODBC to connect to SQL server,
they cann't connect if they leave the Dynamically determine port ch...more >>
QueryTimeout Posted by Thomas.LeBlanc NO[at]SPAM NoSpam.Com at 5/21/2004 12:56:03 PM Can the QueryTimeout property be set in a connection string
We are using SharePoint 2002, and when going through the Wizard to setup a connect, there is no prompt for QueryTimeout, but we are able to contruct our own Connection String
So, I was hoping that we could use the querytimeout in the co...more >>
Connectivity Posted by John at 5/21/2004 7:33:44 AM Hi
Im very new to SQL server so forgive me if this is a basic
question. Im running SQL server on a windows 2000 machine
and when I run Analysis Services it picks up the server
(my local computer name) perfectly. However, when I try
and register the server in Enterprise Manager it cant fi...more >>
Replication General Network Error Posted by ms1746 at 5/20/2004 6:36:41 PM
I have looked through all the posts and I have seen similar problems bu
nothing that answers my issue so I am trying not to ask the sam
question as everyone else.
Here is the configuration:
Distributor and Publisher:
Windows 2000 Advanced Server Clustered
Sql Server 2000 Sp3a Clustered Ac...more >>
Odd connection problem Posted by rcause at 5/20/2004 2:00:50 PM I (running SQL 7 client only) cannot connect to the
server via my machine, but CAN connect (after installing
client) to the server from ANY other machine on the LAN.
My SysAdmin and I have been workin on this for days but
have come up empty, any ideas?
Could it be some other software I'm...more >>
XP Home Sql Server 2000 client? Posted by dperez NO[at]SPAM juno_nospam.com at 5/19/2004 8:14:29 PM I'm sure this has been beat to death but I'm not finding the solution.........
I've got a server running either Windows 2000 Pro or XP Pro, that
has SQL Server 2000 on it. With databases and all the normal junk.
I have a normal PC running XP Pro with Enterprise manager and standard junk on
...more >>
compile Posted by Syl at 5/19/2004 11:10:16 AM Anyone have an idea why a program that compiles in
developer will give a 'not responding' message when being
compiled to create an executable?...more >>
Windows 2003 server automatically close down TCP/IP listening for SQL Posted by George at 5/19/2004 9:17:06 AM I installed a SQL 2000 (with service pack 3a) on a Windows 2003 server ,
but Windows 2003 server still automatically close down TCP/IP listening for
SQL ; I reinstalled both 2003 server and SQL server with sp3a again , But I
am still not able to open that listening , any idea ?
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
connection pooling Posted by Steve at 5/19/2004 5:30:47 AM We have windows xp pro running on a laptop. I can connect
to the server and our databases but when I try to open a
table I get the following message
"[Microsoft][ODBC Driver manager] Only SQL_DRIVER_NOPROMPT
is allowed when connection pooling is enabled"
Does anybody know why this is ...more >>
Establishing VPN Connection thru DTS package Posted by umjunk NO[at]SPAM hotmail.com at 5/19/2004 4:32:47 AM Hi,
I have defined a DTS package which establishes VPN connection with my
client's server. When I execute this package thru SQL Enterprise
Manager (SEM) it works fine, but when I schedule it as a job or try to
execute thru SQL Query Analyzer using 'xp_cmdShell' stored proc, it
doesn't establi...more >>
MDAC 2.7 SP1 release? Posted by Joe at 5/18/2004 10:21:04 AM Can anyone tell me if Microsoft has set a release date for MDAC 2.7 SP1 yet
Please email me at joeydba@yahoo.com - thanks....more >>
Named pipes vs TCP/IP and NETWORKIO wait type Posted by Peter Apostolakopoulos at 5/18/2004 8:41:08 AM I am experiencing a problem whereby a 3rd party application is performing data transfers between tables in a database and they are taking enormous amounts of time
I have no way of knowing what it is actually doing but when I examine the current activity, the RUNNABLE process shows NETWORKIO in the...more >>
SQL Authenication problem Posted by Harry Mace at 5/17/2004 10:06:54 PM Our users use a third party app that connects to a SQL
database on a windows 2003 member server. The app
works if the user has a windows 2003 user account local
on the server.
1. All of our user accounts are in a Novell Netware
Domain.
2. We have purchased a processor license for t...more >>
Ole db error Posted by Julian at 5/17/2004 9:58:40 PM Hi frnds,
New problems evryday ..
we had migrated our intranet website(in asp) frm win 2k t
win 2k3 last week , for 2 days all went ok but then the
trouble(s) started ...
frm yest we are getting an error time in and again
"Microsoft Ole DB provider for ODBC Drivers
error '80040e31'"
I ha...more >>
can not generate SSPI Context Posted by Chambonneau at 5/17/2004 3:24:50 PM Hello everybody
I have a VB6 app using Trusted Connection to a SQL Server 2000.
This application can also run when creating a VPN Connection and using a
TCP/IP Connectionstring
I upgrade my MDAC installation (2.8) and now when I tried to run my app over
VPN, I obtain: "cannot generate S...more >>
Connecting to Database Posted by Reg Coles at 5/17/2004 8:46:41 AM Connected to SQL database via network but now I have
copied database onto laptop to work from home, I got SQL
2000 Server Edition on laptop but I cannot seem to connect
to local database on laptop, it comes up with errors
saying no database found or access denied. Tried to tell
it to look ...more >>
Max Number Of Connections Posted by ruby at 5/16/2004 10:41:01 PM i asked this question yesturday and got an answer from John Bell (thanks by the way) and i want to clarify what i need
is there any document that say for each hardware the number of connections the sql can tolerate and still working fine
i have 2 processores (1.4 ghz) computer with 2 gb ram and st...more >>
outgoing network packets going crazy!!!! Posted by Roland Greene at 5/16/2004 8:01:02 AM I have two nics on my sql box. The first being a gig nic for internal networking which works fine.
The second nic however is not doing so well. It works great for a couple of hours then all of a sudden it starts sending packets out at a alarming rate. This behavior will eventually hose our entire i...more >>
max connections Posted by ruby at 5/16/2004 12:56:01 AM hello everybody
does anyone knows the max connections the sql server can work with. i need to know about the sql server capability according to hardware limits ( for exe:how many connection can the sql manege on 2 cpu's computer with 2.gb ram, etc'
thank
Ruby...more >>
SQL Server Enterprise Manager not connecting Posted by Eddie Butler at 5/15/2004 4:43:23 PM I am trying to connect with enterprise manager, but i am
gettin the error;
---
A connection could not be established to BWSI.
Reason: Login failed for user 'sa, SQLService, (null),
etc'. Reason: Not associated with a trusted SQL Server
connection..
Please verify SQL Server is running a...more >>
Microsoft OLE DB Provider for SQL Server error '80004005' Posted by Joey at 5/15/2004 2:16:02 PM I am receiving this error when trying to establish a connection to SQL Server 2000 sp3a running on a Windows 2003 server. I am able to make a connection to the SQL server from the phyiscal machine it resides on, but not from other machines. The complete error message is listed below. I have also a...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |