SQL 2000 MMC Error

I upgraded a SQL 6.5 NT 4.0 server to SQL 2000 sp1. I successfully upgraded the databases and everything appeared to be working properly. When I attempted to create a backup device the Enterprise Manager MMC seemed to freeze and would not respond. I closed EM and tried to reopen. I get an error box that states "Snap-in failed to initialize. Name: Microsoft SQL Enterprise Manager CLSID:{00100100-1816-11D0-8EF5-00AA0062C58F}".
I have tried loading a generic MMC console and adding the EM snap-in, same error. I have reloaded the NT SP5. I have rebuilt the registry and tried reinstalling the SQL 2000 sp1. Nothing seems to work.
Any ideas?
Thanks in advance
Janet

View Replies


ADVERTISEMENT

Irregular Error In SQL 2000-Named Pipes Provider, Error: 40, Could Not Establish Connection

I have a web application developed in VS.NET 2005 [using C# as code behind]; and it uses SQL Server 2000 Enterprise edition as backend.
The application runs fine, though it gives an error on IRREGULAR intervals on SQL data requests.
Error Details:
An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
 
My problem is this:
1) Why does it show an error of SQL 2005, while I use SQL 2000. SQL 2005 is not even installed on the server, though VS.NET 2005 is installed.
2) The error comes only at irregular intervals. Users are able to login properly otherwise.
3) Application starts working again if we do either of the following:  (a) Restart IIS   (b) Restart application pool   (c) Restart server.
4) Named pipes and TCP/IP are added to the "Network Configuration" of the SQL server 2000.
5) Error does not come on any specific page; or any specific code; or at any specific time.
6) We do not have any background service or any other activity happening on the server; and the server hosts only this application, within a single virtual root.
 
Any thoughts on why is this happening, and how to resolve this?

View Replies View Related

SQL 2000 Reovery Fails Sometimes. Error Code (Error 3136). How To Make Database Write Mode?

Hello,

I am applying hourly differential backup to the backup server from production with the following command. This command makes the database on standby server into read only mode.


RESTORE DATABASE ARSYSTEM FROM DISK = 'E:SQL backup from productionsql_full_backup'
WITH MOVE 'arsystem' TO
'd:ardataarsystem.mdf' ,
MOVE 'arsystem_log' TO 'D:ARLOGARsystem' ,
STANDBY = 'E:SQL backup from productionSQL daily diff back up'


Now I want to run a command which will put the database in write mode. I have created a job which would make the datbase Write mode. This job runs successfully sometimes and fails sometimes. I need to ensure that the job always succeeds. When it fails, how do I troubleshoot and what is the possible fix?

Thanks in advance.

The error message is

Cannot apply the backup on device 'E:SQL backup from productionSQL daily diff back up' to database 'ARSYSTEM'. [SQLSTATE 42000] (Error 3136) RESTORE DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.


The steps for the job are as follows with the failing step highlighted in bold.


copy /y "\172.31.9.12Remedy BackupackupSQL backupsql_full_backup" "E:SQL backup from productionsql_full_backup"

copy /y "\172.31.9.12Remedy BackupackupSQL backupSQL daily diff back up" "E:SQL backup from productionSQL daily diff back up"

xp_cmdshell 'net stop "bmc remedy action request system server"'

exec rp_kill_db_processes 'ARSYSTEM'

RESTORE DATABASE ARSYSTEM

FROM DISK = 'E:SQL backup from productionsql_full_backup'

WITH

MOVE 'arsystem' TO 'd:ardataarsystem.mdf' ,

MOVE 'arsystem_log' TO 'D:ARLOGARsystem' ,

NORECOVERY


Failing step

RESTORE DATABASE ARSYSTEM

FROM DISK = 'E:SQL backup from productionSQL daily diff back up'

WITH

MOVE 'arsystem' TO 'd:ardataarsystem.mdf' ,

MOVE 'arsystem_log' TO 'D:ARLOGARsystem' ,

RECOVERY



xp_cmdshell 'del /f "E:SQL backup from productionsql_full_backup"'

xp_cmdshell 'del /f "E:SQL backup from productionsql daily diff back up"'

xp_cmdshell 'net start "bmc remedy action request system server"'





I have scheduled the following hourly diffential restore job too which never fails.

RESTORE DATABASE ARSYSTEM FROM DISK = 'E:SQL backup from productionsql_full_backup'
WITH MOVE 'arsystem' TO
'd:ardataarsystem.mdf' ,
MOVE 'arsystem_log' TO 'D:ARLOGARsystem' ,
STANDBY = 'E:SQL backup from productionSQL daily diff back up'
EXEC MASTER..XP_CMDSHELL 'del /f "E:SQL backup from productionSQL daily diff back up"'

View Replies View Related

SQL 2000 Error: 1203, Severity: 20, State: 1 Error

Our SQL Server 200 box is getting perflib errors when we get a decentamount of people using an application that I wrote, call queue system,web based. To accomplish a queue type system on a button push I wrotea query like this...BEGIN TRANSACTION;Select top 1...fields here...FROM table with (xlock,readpast)(2 joins)WHERE numerous where clausesORDER BY 2 order bys.Now our sql server starts timing out..then in the app log this showsup....Error: 1203, Severity: 20, State: 1Process ID 62 attempting to unlock unowned resource PAG: 6:1:126407.For more information, see Help and Support Center athttp://go.microsoft.com/fwlink/events.asp.The reason I am doing xlock is to make a record not viewable to 2people if they click the button on the web form that runs the abovequery within the same minute, they would get different records....So to avoid this error which I assume is due to my xlock should Irethink my query?

View Replies View Related

Attempt To Catch Error Using @@ERROR In SQL 2000 Is Failing

We have a stored procedure that calculates the floor nr for users at our company campus using their office location. The calculation is done by a function that returns an integer. Unfortunately, not all users enter their information correctly so the function sometimes raises an error. Below is the code of that stored procedure.



UPDATE PERSONS

SET FLOORNR = dbo.FloorNR(OFFICELOCATION)

WHERE OFFICELOCATION IS NOT NULL



IF(@@ERROR <> 0 OR @@ROWCOUNT = 0)

BEGIN

RAISERROR ('Failed to calculate the floor number', 16, 1 ) with nowait

END



However, when the function dbo.FloorNR fails, it doesn't raise our error, but it seems to raise the error that comes from dbo.FloorNR.



How can we catch errors that come from dbo.FloorNr so that we can raise our own error? Our company still uses SQL 2000, so we cannot use the SQL 2005 try/catch option.

View Replies View Related

SQL 2000: T-SQL @@Error Not Picking Up Error

Hi

I'm trying to finish a DTS Package by controlling the error flow with @@ERROR.
Yet, there's one error which I can't seem to capture
'Syntax error converting the varchar valueto a column of data type int'

If you try the code below, I can't seem to pull an @@ERROR ID from it.

IF
OBJECT_ID('tempdb..##LogTemp') IS NOT NULL
BEGIN
DROP TABLE
##LogTemp
END

CREATE TABLE
##LogTemp
(
Error_ID INT
)
INSERT INTO ##LogTemp
(
Error_ID
)

VALUES
(
'Test'
)

PRINT @@ERROR

Query Analyzer prints this out:

Server: Msg 241, Level 16, State 1, Line 83
Syntax error converting datetime from character string.

View Replies View Related

Error In SQL 2000 / Help

Hi

Some times I get this eeror when I want open my web pages

what is this?

=========

Microsoft OLE DB Provider for SQL Server error '80004005'

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

/common.asp, line 260

=========

note: some times I get this error

I installed SQL on my system

My web site is in ASP

thanks

View Replies View Related

Connecting To Sql Server 2000 On Godaddy Error: (provider: Named Pipes Provider, Error: 40 - Could Not Open A Connection To SQL Server)

Facts:1. I am using my account on Godaddy trying to connect to my sql server db.2. I can get into my db using user id and password.3. Godaddy's help file shows this for a connection string: connectstr = "Driver={SQL Server};SERVER=" & db_server & ";DATABASE="
&db_name & ";UID=" & db_username & ";PWD=" &
db_userpassword4. My connection string: "Server=whsql-v09.prod.mesa1.secureserver.net;uid=dbasolutions;pwd=***;database=DB_87972;"  & _                    "Trusted_Connection=False providerName=System.Data.SqlClient"{password **** out}5. Get error message  An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) I tried to email Godaddy's help desk with this information. There first response: We do not allow remote connections to our sql server database.There second response was to read the help file!Does anybody have any suggestions?  Thanks in advance,bswanson     

View Replies View Related

Error In Using SQL Server 2000

 Hi  i need help.,What does this error means and what should i do to fix it.BTW. i made a data driven site, using Visual Web Dev 2008, and i used the Sql Server 2000 enterprise all in the same PC, when i run it in my IIS also in the same PC, this error apear, please help me.thanks 
Server Error in '/' Application.


Login failed for user 'P078731ASPNET'. Description:
An unhandled exception occurred during the execution of the current web
request. Please review the stack trace for more information about the error and
where it originated in the code. Exception Details:
System.Data.SqlClient.SqlException: Login failed for user
'P078731ASPNET'.Source Error:



Line 2679: this.Adapter.SelectCommand = this.CommandCollection[0];Line 2680: Red.acoDataTable dataTable = new Red.acoDataTable();Line 2681: this.Adapter.Fill(dataTable);Line 2682: return dataTable;Line 2683: }Source File:
c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET
Files
oot9c387db932ec7141App_Code.v1ipo9zs.0.cs    Line: 2681
Stack Trace:



[SqlException (0x80131904): Login failed for user 'P078731ASPNET'.] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +800131 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1932 System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33 System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +172 System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +381 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +181 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +173 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +357 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +30 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +494 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121 System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) +162 System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) +107 RedTableAdapters.acoTableAdapter.GetData() in c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
oot9c387db932ec7141App_Code.v1ipo9zs.0.cs:2681[TargetInvocationException: Exception has been thrown by the target of an invocation.] System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +0 System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +72 System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) +308 System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +29 System.Web.UI.WebControls.ObjectDataSourceView.InvokeMethod(ObjectDataSourceMethod method, Boolean disposeInstance, Object& instance) +480 System.Web.UI.WebControls.ObjectDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1960 System.Web.UI.WebControls.ListControl.OnDataBinding(EventArgs e) +92 System.Web.UI.WebControls.ListControl.PerformSelect() +31 System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70 System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82 System.Web.UI.WebControls.ListControl.OnPreRender(EventArgs e) +26 System.Web.UI.Control.PreRenderRecursiveInternal() +86 System.Web.UI.Control.PreRenderRecursiveInternal() +170 System.Web.UI.Control.PreRenderRecursiveInternal() +170 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2041

Version Information: Microsoft .NET Framework Version:2.0.50727.1433;
ASP.NET Version:2.0.50727.1433  

View Replies View Related

The Error Of Sub Query ( SQL 2000)

select  ZT_AuthDetail  
Where  MasterKey in  (select *  from ZT_AuthDetail d, ZT_AuthMaster  m where  (ReplyTime Between '2004/11/22' and '2004/12/31') And (m.CustId = '33196700') And (m.Prikey = '1840'))
 
when I run this query , the error message shows somethins wrong with "Sub Query from Exists....."
  if I run (select *  from ZT_AuthDetail d, ZT_AuthMaster  m where  (ReplyTime Between '2004/11/22' and '2004/12/31') And (m.CustId = '33196700') And (m.Prikey = '1840'))  alone
the result is fine and Ok.. but with select ZT_AuthDetail where MasteKey in... I got error message
can you please tell me why and how to fix it?
 ** I use SQL2000
thank you very much

View Replies View Related

Error When Connecting To Sql 2000

I am trying to connect to a sql 2k database using a Microsoft Application block. I get the following error. It is saying about 2005, I verified that SQL 2K is running on the server.
System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings
 
Any help will be appreciated.

View Replies View Related

Error Connecting To SQL 2000

I am using Visual Studio 2005 with SQL Server 2000. I'm having an issue where I can build my website just fine for long periods of time, and then for what appears to be no reason, my site errors out when trying to connect to the database with the message below -- the thing is I don't want to use a SQL Server 2005 database, nor do I have Server 2005 or Server Express loaded. How can I unhook this and make it use SQL 2000?"An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.) "

View Replies View Related

Error In SQL Server 2000

Hi

I just installed SQL Server 2000 EVAL ver, in my Win XP Pro machine and the installtion was succesful though I get the following error once I run the code.

What does this mean ? What should I do here ?




----------------------------------------------------------------------
[SqlException: Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +472
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +311
System.Data.SqlClient.SqlConnection.Open() +383
ASP.DropDownList_aspx.Page_Load() +61
System.Web.Util.ArglessEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +10
System.Web.UI.Control.OnLoad(EventArgs e) +55
System.Web.UI.Control.LoadRecursive() +27
System.Web.UI.Page.ProcessRequestMain() +731

View Replies View Related

How To Fix Error 207 In Ms Sql Server 2000

How to fix error 207 in ms sql server 2000 with out applying SP4service pack 4,on SQL SERVER 2000 wit sevice pack 3a - currentenvironment ?

View Replies View Related

Sql 2000 Update Error?

HELP

I'm trying to add the new record to the database, but got the error from IE.

HTTP 500 - Internal server error
Internet Explorer

How can I add my info to my company SQL Sever 2000???
Following is my code:

<%
Dim sql

Dim objConn
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=c:InetPubwwwrootdalyfpdbmarket.mdb"

sql="INSERT INTO Attendees (AttendeeFirstName,AttendeeLastName)"
sql=sql & " VALUES "
sql=sql & "('Saleng', 'Teng')"

objConn.Execute sql
objConn.close
%>

Thanks for your help.

scn@daly.com

View Replies View Related

Log Shipping Error On SQL 2000 SP4

I'm attempting to configure log shipping on 2 servers with SQL Server 2000 sp4 Enterprise Edition. I keep getting the following error when the job attemtps to execute.

Error 14261: The specified primary_server_name.primary_database_name('C')
already exists.

I have tried this KB http://support.microsoft.com/kb/298743 and i got the same error again!

Please HELP!

View Replies View Related

SQL Server 2000 Error

Hi,

I have a question to the SQL Server experts.
I have a kind of problem with an system that is trying to modify some records in a SQL Server 2K Database.

Server configuration:
Windows Server 2003 Standard Edition
MDAC 2.81 SP2
SQL Server 2000 SP3

The error that I receive is:
Description [Timeout expired], NativeError [0] SQLState [HYT00], Source [Microsoft OLE DB Provider for SQL Server], Number [-2147217871]

It happens when I try to execute a store procedure that updates a record and is just with that procedure, there's no error when I execute procedure to insert rows.

I would feel so much thankful about any suggestions.

View Replies View Related

Server Error In SQL 2000

I installed the DevInfo 5.0 web software on our server and followed the configurations instructions accordingly.
Now we have a problem of accessing the application from both the server and the client.
I am getting the following error message:

Server Error in '/DI5Web' Application.
--------------------------------------------------------------------
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Version Information: Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832

We do not have SQL Server 2005 but SQL Server 2000

Any assistance will be highly appreciated

View Replies View Related

Help MS SQL 2000 Server Error

Hi guys im new on this Forum
and a NOOB @ SQL

Recently one of our clients had power interruptions and they are now getting this error on there SQL. Wondering if you guys can give some input here.

Unfortunately there is no Backups availible!

Error is as Follows:

Error 9003,severity 20 state 1
(9:307:1) passed to log scan in database 'model' is invalid


Due to this the ISA server2004 wont start either.

Any Help please?

View Replies View Related

Error When SQL 2000 Start

When starting my SQL Server 2000 generate error and stop. This is the log:
Standard Edition on Windows NT 4.0 (Build 1381: Service Pack 6)

2004-01-20 11:05:36.59 server Copyright (C) 1988-2000 Microsoft Corporation.
2004-01-20 11:05:36.59 server All rights reserved.
2004-01-20 11:05:36.59 server Server Process ID is 115.
2004-01-20 11:05:36.59 server Logging SQL Server messages in file 'C:MSSQL7logERRORLOG'.
2004-01-20 11:05:36.63 server SQL Server is starting at priority class 'normal'(1 CPU detected).
2004-01-20 11:05:36.66 server SQL Server configured for thread mode processing.
2004-01-20 11:05:36.66 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
2004-01-20 11:05:36.67 server Attempting to initialize Distributed Transaction Coordinator.
2004-01-20 11:05:38.69 spid3 Starting up database 'master'.
2004-01-20 11:05:38.85 spid3 Server name is 'DB_SERVER'.
2004-01-20 11:05:38.85 server Using 'SSNETLIB.DLL' version '8.0.194'.
2004-01-20 11:05:38.87 server SQL server listening on TCP, Shared Memory, Named Pipes.
2004-01-20 11:05:38.87 server SQL server listening on 192.168.1.29:1433, 172.16.48.10:1433, 127.0.0.1:1433.
2004-01-20 11:05:38.87 server SQL Server is ready for client connections
2004-01-20 11:05:38.87 spid5 Starting up database 'model'.
2004-01-20 11:05:38.87 spid8 Starting up database 'msdb'.
2004-01-20 11:05:38.87 spid9 Starting up database 'pubs'.
2004-01-20 11:05:38.87 spid10 Starting up database 'Northwind'.
2004-01-20 11:05:38.87 spid11 Starting up database 'SIM'.
2004-01-20 11:05:39.21 spid5 Error: 9003, Severity: 20, State: 1
2004-01-20 11:05:39.21 spid5 The LSN (5:377:1) passed to log scan in database 'model' is invalid..
2004-01-20 11:05:39.31 spid8 Bypassing recovery for database 'msdb' because it is marked SUSPECT.
2004-01-20 11:05:39.39 spid11 Starting up database 'GMS'.
2004-01-20 11:05:39.39 spid8 Starting up database 'euro'.
2004-01-20 11:05:40.14 spid10 Starting up database 'TigrisDB'.

View Replies View Related

SQL 2000 SP1 Supersocket Error

I stopped and started SQL Server this morning and got this error message in the NT EVent log and SQL log (SQL 2000 SP1)

Supersocket info: Bind Failed on TCP port 1433. This error is new, it was not there in previous starts of SQL Server 2000, Any ideas? thx in advance

View Replies View Related

SQL 2000 Error !URGENT!

hello,
thanks in advance for your help. I have sql 2000 installed on my database server. Recently we had the need to change all the passwords on the server for security reasons. I changed the administrator password and i changed all the services to use a system account instead of the administrator account. Now the sql server service will not start.

Please help

Thanks,
Brian

View Replies View Related

DTS Designer Error In SQL 2000

I installed SQL Server 2000 and after having installed it on a machine with SQL 7 already on it, everything went OK.

I am unable to view/edit a "local package" in DTS.

When I attempt to go into the "Designer" (right click on package, select "design package"), I receive a message box titled "DTS Designer Error" with the message "Class Not Registered". I can click OK, I and get into the "Designer" window, but I can't do anything.

For example, when I double click on the "connection arrow", the message "No provider is selected. To continue, you must select a valid provider" appears.

After which, the DTS package window opens but I can't see any of the tasks in the tool bar. I can't select any tasks from the Task option in the menu bar either.

Has anyone experienced anything similar? Any suggestions would be appreciated.

Thanks.
Barb

View Replies View Related

DTS Designer Error In SQL 2000

I am testing SQL Server 2000 and after having installed it on a machine with SQL 7 already on it everything went OK.

However, if I try to create a DTS package (or open and existing one) on either of my SQL Server instances I get a "DTS Designer Error". After which, the DTS package window opens but I can't see any of the tasks in the tool bar. I can't select any tasks from the Task option in the menu bar either.

Has anyone experienced anything similar? Any suggestions would be appreciated.

Regards,

Karl

View Replies View Related

DTS Designer Error In SQL 2000

I am testing SQL Server 2000 and after having installed it on a machine with SQL 7 already on it everything went OK.

However, if I try to create a DTS package (or open and existing one) on either of my SQL Server instances I get a "DTS Designer Error". After which, the DTS package window opens but I can't see any of the tasks in the tool bar. I can't select any tasks from the Task option in the menu bar either.

Has anyone experienced anything similar? Any suggestions would be appreciated.

Thanks.
Barb

View Replies View Related

DTS 2000 Package Error(s)

From MS SQL Server Management Studio 2005, I register and connect to MS SQL 2000 (SP4) running on another server.  I can see the list of 2000 DTS packages on the other server, but when I try to open them I first get:


Error Source : Microsoft Data Transfformation Services (DTS) Package

Error Description : The DTS host failed to load or save the package properly.

I click the OK button and get:


The selected package cannot be opened. The DTS Desiger has been closed.

I click this OK button and get to now famous:


SQL Server 2000 DTS Designer components are required to edit DTS packages. Install the special Web download, "SQL Server 2000 DTS Designer Components" to use this feature. (Microsoft.SqlServer.DtsObjectExplorerUI)

I have already been to the Feature Pack for Microsoft SQL Server 2005 - November 2005 page and installed the Microsoft SQL Server 2005 Backward Compatibility Components and the Microsoft SQL Server 2000 DTS Designer Components.

Now, the DTS Designer does not close.  It stays open.  I can see inside the package, but all I see are the transformation lines and the precedence lines.  The icons are invisable. If I click on the invisable icons, at the end of the lines, an icon appears.  This is not a normal icon.  It looks like little windows with a blue border and title bar.   Nothing I've seen before.  Oh it gets better.  If I now double-click the icons, the properties window appear as normal.  Looks good...  I don't need to change anything.  I then press the OK button and get the Task references, like I modified the connection.  I do not clear the trasformation.  I just click the OK and like magic the connection icon looks at it should.  This works on everthing I've tried, except for Execute SQL Task icons.  I can save it, but not as the save name.  I can open the new saved package.  It look and works fine.

So whats up? 

 

 

View Replies View Related

Error Connecting To SQL 2000

I am using Visual Studio 2005 with SQL Server 2000. I'm having an issue where I can build my website just fine for long periods of time, and then for what appears to be no reason, mysite errors out when trying to connect to the database with the message below-- the thing is I don't want to use a SQL Server 2005 database, nor do I have Server 2005 or Server Express loaded. How can I unhook this and make it use SQL 2000?

"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.) "

View Replies View Related

SQL 2000 Replication Error...

I have been trying to get a SQL 2000 server replicated with another - and keep getting the same error:



SQL Server Enterprise Manager could not configure "Server Name" as the Distributor for "Server Name"



Error 18483: Could not connect to server "Server Name" because 'distributor_admin' is not defined as a remote log in at the server.



I found several sites that helped me to get some feedback - but I am still hitting the same error.



Any thoughts would really help now.


Thanks!



M

View Replies View Related

SqlDumpExceptionHandler Error On SQL 2000 SP4.

Im hoping
that someone will be able to help me with a problem that Im having
with a SQL 2000 SP4 box that weve got. Roughly every other day Im
seeing the following errors appear in the SQL Server Log.
1.
SqlDumpExceptionHandler: Process 58 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
2.Error: 0, Severity: 19, State: 0
3.Invalid buffer received from client.
4.Error: 17805, Severity: 20, State: 3
5.Stack Signature for the dump is 0x59335BD4
6.The exception information has been submitted to Watson error reporting.

The
Server will usually carry on working ok if the error only occurs one
but sometimes it can occur three times over night and kill the machine.
The box is running Windows 2000 SP4 with SQL Server 2000 SP4. It is
also part of a replicated system running as a subscriber. Ive run all
hardware checks and everything returns ok.

I can supply the SQLDump Exception, SQLDUMP.txt and sqldiag.txt if anyone can help.

Has
anyone got any advise on what is causing these errors? Ive been
through KB articles and seen resolutions for the errors that state you
need to install SP4. But SQL SP4 is already installed. The errors
werent appearing before SQL SP4 but I cant say for sure that they did
start appearing directly after it was installed.

Any help would be much appreciated.

Thanks

d

View Replies View Related

Fresh SQL 2000 To SP4 Gives Error

Hi,

I'm trying to Service Pack 4 a fresh installation of SQL 2000 (a named instance called 'SQLSERVER2000') and get the error "Installation of the Microsoft Full-Text Search Engine package failed. (-2147467259) 0x80004005 Unspecified Error" towards the end of the process thus I cannot service Pack my fresh installation of SQL 2000. I have done this many times before on other machines, but its not working for me this time.

At http://www.dbforums.com/ ( http://www.dbforums.com/showthread.php?t=1198047 ) someone ran into this problem and mentioned to re-install Microsoft Full-Text Search. I have followed the article http://support.microsoft.com/kb/827449 but run into problems at step 2C. At step 2C it says to start the Microsoft Search service via the Services console, but Microsoft Search was nowhere to be found.

Going back a step to Step 2B it says that all registry keys that were previously-deleted are now available and the previously-deleted 'MSSearch' folder is recreated. I took a look, but both the keys and folder WERE NOT there.

It is a fresh OS installation of MS Windows 2003 Standard SP1, 768MB RAM and is running fine.

Can you please point me in the right direction here?

Brad.

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved