| Groups | Blog | Home |
|
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 August 2008 |
Filter by week: 1 2 3 4 5 Can't start SQLServerAgent Posted by evadla at 1/7/2004 1:26:28 PM All of sudden, getting a Dr. Waston error with illegal
instruction on boot up.
If I tried to start it from the Services menu, get "Could
not start the SQLServerAgent service on \\server_name
Error 1067: The process terminated unexpectedly"
Do I need to reload the software... I have not fo...more >>
error 1069 Posted by BILL at 1/7/2004 12:51:23 PM 'the service did not start due to a logon failure' return
trying to start SQL server after I changed my password.
Does this make sense?...more >>
Sql Password Posted by Nuno Paiva at 1/7/2004 6:47:06 AM After i create my database i want user of the connection
by default "SA" doesn't have password...
there is any way to insert a password to the user?
Thanks......more >>
SQL2000 SQL7 changed ip can't connect Posted by mike NO[at]SPAM emap.co.za at 1/6/2004 11:18:47 AM Hi Guru's
I have changed the IP address on a dev machine running an instance of
both SQL7/SQL2000. My developers can now no longer connect via their
EM. They can see both instances when registering the servers but
cannot connect to them. All that was changed is the IP Address. There
are no fi...more >>
Error when trying to update Posted by Nader Galal at 1/6/2004 10:43:32 AM Hi All
I get this error when i open a specific table from enterprise manager and
try to update values in it.
Data has changed since the results pane was last updated. Do you want to
save your changes now?
Click Yes to save your chnages and update the database.
Click No to discard your changes ...more >>
sp_addlinkedserver - Secure Access DB Posted by Jason at 1/6/2004 9:31:50 AM I am trying to create a linked server using a secure
Access database. The problem I am having is getting the
connection to recognize the system database (MDW) that is
needed to connect.
SQL Server BOL says to change the registry to use teh
system database you want. I don't want to do th...more >>
The system cannot find the file specified Posted by murphy at 1/6/2004 8:08:13 AM when trying to attach the database ...more >>
enterprise manager can't see databases Posted by eileen at 1/6/2004 4:31:09 AM Hi everyone
Happy New Year ! Another year of fun ahead, solving sql server problems. I can hardly wait
We have Sql Server 2000 installed on a server called taggart. On the client p.c. we have Enterprise Manager and Query Analyser installed
Using query analyser I can connect to taggart and ca...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
ODBC Posted by Yama at 1/5/2004 7:54:29 PM Hi,
Using VB.NET how can I deploy ODBC connection to automatically install when
the package is installed?
Yama
...more >>
Cannot Connect to the Analysis Server Posted by J.B. at 1/5/2004 6:01:05 PM I'm trying to retrieve a list of cubes from AS Server using Microsoft DSO in an ASP.NET page
Here's my sample code
Dim dsoServer As New DSO.Serve
Dim dsoDB As DSO.MDStor
Dim dsoCube As DSO.MDStor
dsoServer.Connect ("LocalHost"
For Each dsoDB In dsoServer.MDStore
If dsoDB.Name = "XXX" T...more >>
SQL2K ODBC driver & Older ODBC Driver Posted by Jared at 1/5/2004 1:52:49 PM What the solution for connecting a single client
workstation to two different versions of SQL Server (2000
and 6.5)? Since the ODBC diver files are the same name
(but different versions), I can't have both on my machine
at once. Is the new driver fully compatible with older
versions of SQL...more >>
Run Time Error '-2147467259(80004005)': Posted by jimmy thomas at 1/5/2004 11:51:49 AM WE have couple of applications using sql and were working
till friday 01/02/04. This morning when users are trying
to access it giveing the error Run Time Error '-2147467259
(80004005)':
Invalid connection String.
Any Idea.
Application connects to 2 sql 6.5 servers and 1 sql 2000
server....more >>
What TCP ports are used by SQL Server Named Pipes? Posted by John Fredrickson at 1/4/2004 1:07:44 AM Guys,
I'm having trouble communicating with one of my SQL Servers within my
Windows domain. The symptoms are that I can read a DTS package but when I
try to execute it or save it, I get an error saying that DBNETLIB cannot
find the server.
I believe the problem is that my firewall allows th...more >>
Cannot connect to MSDE database from Enterprise Manager Posted by Roberto Rocco at 1/3/2004 2:04:10 AM Hello,
I try to access a MSDE 2000 3.0a Database installed on Windows Server =
2003 as the default instance.
MSDE has been installed with the following options:
[Options]
TARGETDIR=3D"C:\Program Files\MSDE 2000\"
SAPWD=3D"<My Password>"
DISABLENETWORKPROTOCOLS=3D0
SECURITYMODE=3DSQL
I...more >>
Multiple simultaneous osql network connections fail Posted by Precious McGillen at 1/2/2004 3:50:24 PM I am attempting to make 1000 simultaneous osql connections from one Windows
2000 server with sp4 to another Windows 2000 sever with sp4 that is hosting
a SQL 2000 server database with sp3a, but I reach an upper limit of about
30 - 40 connections.
Is osql limited to the number of simultaneous con...more >>
Error when creating Stored Procedure Posted by Vince NO[at]SPAM Netflow at 1/2/2004 1:18:50 PM I am trying to create a new stored procedure:
*******************************************************
CREATE PROCEDURE XXX_GetInfo AS
select cast(info.id as varchar) refno, info.begindt, enddt, info.company,
info.type, info.weight
from info info
union
select cast(test.id as varchar) refno, t...more >>
Error in ASP/SQL Server Posted by devanoy NO[at]SPAM hotmail.com at 1/2/2004 12:41:49 PM Hello,
I have searched all over the web in order to find a solution to this,
but nothing I find seems to fit my problem.
My IIS and SQL Server reside on the same server. I am trying to
connect my ASP page to that SQL Server. My connection string looks
like
"Provider=sqloledb;Data Source=...more >>
Eudora Mapi Posted by Steven at 1/2/2004 10:02:08 AM I'm setting up SQL Server 2000 on a replacement server.
I've decided to move and run a couple of small
applications to the SQL Server server. The apps use ODBC
to connect to SQL Server. Both apps require a controlled
MAPI session. Ever since Outlooks MAPI session related
security patch...more >>
Error 0: This server has been disconnected Posted by Jeff T. Severson at 1/2/2004 8:49:52 AM Hi all,
I'm having a problem with an SQL Server that I'm working
with and I haven't been able to find any information on
how to resolve it. I am able to log in to the the SQL
Server via Enterprise Manager and on the server, there are
around 10 - 15 databases.
I can log in to all the data...more >>
open connection side DB after close adodb connection side client Posted by Antonio Catalano at 1/2/2004 6:42:46 AM when i close the connection ado in the script ASP the
server DB relieve that the connection is more open for 60
seconds.
Thanks
...more >>
Named Pipes or TCPIP Posted by John at 1/2/2004 2:24:44 AM I remember reading somewhere that TCPIP gives better
performance than named pipes. Can anyone explain why or
point me in the direction of a tech doc that explains why
we should use TCPIP rather than N/Ps?
...more >>
DB2 & SQL server? Posted by Jim at 1/1/2004 11:16:39 PM Hi Folks,
We have a DB2 database on a WAN at work. I want to access the database from
some Visual Basic for Applications code that I have written at work.
The database itself is not directly accessable and as it was described to me
is "buffered"
from the users by a second computer which pas...more >>
Can't create a new record using Access? Posted by Steve P at 1/1/2004 3:05:33 PM Please forgive this basic question but I am just getting started. I am using
an Access project file connected to an SQL table. I used the Enterprise
Manager to create a simple table with only 3 fields. When I open the
database from the Tables section in Access it will not let me add a new
record...more >>
SQL Data Source Posted by phil at 1/1/2004 9:57:06 AM I have installed sql 2000 onto xp but when I come to
create a data source the sql server doesnt appear in the
drop down...
Any ideas for a school boy so that the server will appear
in the drop down list.....
I'm tying to create a data source using dot net etc...
muchos...more >>
SQL-DMO Connect using SQL Authentication Posted by Mark Story at 1/1/2004 7:38:16 AM When I try and use the SQL-DMO library to connect with NT
Authentication, it works fine - either on local machine or
across the network.
However, I cannot get SQL Authentication to work. I use:
moSQLServer.Connect "172.16.72.4", "sa", "sa"
and get error:
[Microsoft][ODBC SQL Server D...more >>
Metadata info retrieval Posted by Arrun S at 1/1/2004 5:01:06 AM I am working on a project that needs to retrieve the metadata details of a schema (in MS SQL Server).
Could anyone help me out..
TIA,
Arrun...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |