.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Post New Web Links

To connect to this server you must use SQL Server Management Studio or SQL Server Management Objects

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :

What could be wrong?

I get this error when a stored procedure is executing sp_OAMethod from SQL Server 2000 SP4.

EXEC @rc = master..sp_OAMethod @Obj, 'Execute'

The linked server is SQL Server 2005 x64.  Already installed is SQLServer2005_BC_x64.msi version April 15, 2006.  Local server is SQL Server 2000 SP4. 

I can execute the sproc successfully in Query Analyzer from my local dev box which has both 2000 and 2005 installed.  Profiler in 2005 indicates success for the whole sproc. 

It fails when I execute in Query Analyzer while connected on SQL 2000 SP4.  Tried this with 3 different machines SQL Server 2000 SP4.  The server do not have any 2005 component installed.

According to Profiler in 2005, the last event that happen is

SQL: BatchCompleted

if (object_id('master.dbo.sp_MSSQLDMO80_version') is not null) exec master.dbo.sp_MSSQLDMO80_version else if
(object_id('master.dbo.sp_MSSQLDMO70_version') is not null) exec master.dbo.sp_MSSQLDMO70_version else select 0

Below is the trapped Query Analyzer message.

Error Source: Microsoft Data Transformation Services (DTS) Package 
Error Description:Package failed because Step 'dts_name_removed' failed. 
Error code: 80040428 \
Error Help File:sqldts80.hlp 
Error Help Context ID:700 

Step Error Source: Microsoft SQL-DMO (O

View Complete Post

More Related Resource Links

How to connect to local instance of SQL Server 2008 Management Studio Express ?


I just installed SQL Server 2008 Management studio Express on my Vista machine.

i tried connecting to local machine using :

.\sqlexpress, (local)\sqlexpress, or .\SQLExpress, MyPCNAME\SQLExpress

nothing is working, getting this error:

Cannot connect to PC-NAME\SQLEXPRESS. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Can't connect to SQL 2005 Enterprise using Management Studio with Server Name (only (local) works

This is a test system, everything running locally & no domains. Win 2003 Ent. Server & SQL Server 2005 Enterprise. I can't log into SQL Server Management Studio using the server name & using either Windows Authentication or SQL login. If I change the name of the server in the drop-down list to "(local)", I connect just fine (both Windows & SQL security modes). Shared Memory, Named Pipes & TCP/IP enabled in both server & client. Remote connections allowed. I have IP adresses (both & external IP) in my hosts file pointing to the server name. Does SQL require a DNS server? This wouldn't be a problem except for the fact that I can't install SQL 2005 SP3 due to authentication failure since there's no way to enter (local) as the server name. SQL tools (management studio, SP install) seem to see the SQL server running but won't authenticate the user through any means other than setting server name to (local). This is driving me crazy!!!

how to connect my hosting database from my pc using sql server management studio 2005



I have one asp.net hosting account with some service provider.. 

They have given me some xxx.xxxxxx.com to access sql server from my desktop... 

I enter xxx.xxxxx.com in server name and username and password but it will not connect.. 

so please let me know what are the steps i have to do to access my hosting database...

they have given sql server 2008 im using in local sql server 2005 management studio so let me know how to connect

thanks in advance

Unable to Connect to SQL Serrver using SQL Server Management Studio


I just installed the 64bit version of SQL Server using the Developer edition CD for SQL Server.  The problem I'm having is that I cannot connect to SQL Server using SQL Server Management Studio.  I’m getting the message “a network-related or instance specific error occurred while establishing a connection to sql server. the server was not found or not accessible. verify that the instance name is correct and that sql server is configured to allow remote connections.”.  I’ve done a lot of Google searches but yet to find a solution.  I've checked to be sure it is started and enabled all protocols except VIA.  I have remote connections allowed.  I used the default name MSSQLSERVER which is what I'm using to connect to in Management Studio.

Can someone help, I have no idea what to check now.  BTW, I've also installed SP3.

Error while trying to connect with SSRS through Sql server management studio



I have installed SQL Server 2008 R2 on my system. Reports manager is working fine for me, but when I tried to connect to Reporting service instance using SSMS, I got the following error. I am not able to understnad why it is happening.

TITLE: Microsoft SQL Server Management Studio

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476


The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. (System.Web.Services)


The remote certificate is invalid according to the validation procedure. (System)



how can i connect to my sql server management studio??


when i run the SSMS,while i have to enter my server name,i dont know it...

also,in the installation time,the istall didn't require any password or server name or anything to enter...

in other word,i dont have any server name for my sql server and so that i got this error:

TITLE: Connect to Server

Cannot connect to Bahador-gh-PC.


A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476



how can i resolve it??

plz as soon as you can, answer me...

tnx a lot :):)

SQL server management studio reconnects / connect fails / connects fine



I am checking out an application performance issue on a particular (distributed SQL express) machine - and now have the machine back in my possession. I have narrowed it to SQL and/or our application.

In short SQL seems 'hesitant' - SSMS connects first time sometimes, fails another time, disconnects after being connected and so-on. I'm connecting to the machine via real simple cable-hub-cable, and I'm positive its not networking as I'm RDP'd onto the machine and get quick responses whilst SSMS is being moody.

SQL logs show nothing, neither default trace or custom trace show anything, or windows logs.

In SSMS I have a query open, it returns immediately on some runs and takes 2 mins on other runs - it is a tiny query, straight select.

The treeview in SSMS is sporadically taking a long time to respond and times out sometimes - other times it was connected and then prompts for authentication ....fails to connect, you cancel, then reconnects first time after that.

...something odd is happening.

There are loads of other angles I have tried - autoclose is disabled by the way.

Anyone experiencing this sort of behaviour elsewhere or have any thoughts ?  I use SQL connections and technologies everywhere in my normal working day - this has me scratching my head.

Thanks for your brain cycles in advance !

Can't connect to SQL Express 2008 from Visual Studio, but can connect from SQL Server Management St



I've been struggling with the following issue for 3 days:  I can access and use my SQL Express 2008R2 database flawlessly from SQL Server Management Studio.  But I can only intermittently access it from Visual Studio (ultimate edition with TF Server).  Sometimes it works, sometimes it doesn't.  I mostly see the error when I try to "Update Model from Database" within my Entity framework model, or when I try to access the database from within Server Explorer.


Here is the error I see when I try to update my Entities form the Database: An error occurred while connecting to the database.  The database might be unavailable.  An exception of type 'System.Data.SqlClient.SqlException' occurred.  The error message is: 'Cannot open user default database. Login failed.  Login failed for user 'Tim-PC\Tim'.'


I think the connection string is fine as I am able to connect

Data Points: SQL Server Management Objects


SQL Server Management Objects offer developers a robust toolset for backing up and restoring databases, and issuing DDL commands, as John Papa explains.

John Papa

MSDN Magazine June 2007

SQL Server and DMO: Distributed Management Objects Enable Easy Task Automation


SQL Server can be administered programmatically using system stored procedures, but Distributed Management Objects (DMO) offer a more modern, object-oriented alternative. This article introduces SQL-DMO in SQL Server 7.0 and SQL Server 2000 and describes the SQL-DMO object model, then focuses primarily on the Databases tree and the JobServer tree of the object model. The sample code and the article show how to use various objects such as the Registry object, the Configuration object, and the Database object to automate common administration tasks such as programmatically retrieving configuration settings, creating new databases, applying T-SQL scripts, and creating and scheduling backups.

Francesco Balena

MSDN Magazine May 2001

SQL Server Management Studio


Hi folks


Am sorry if this mght be abit silly question am a Novice Developer.

If am using Visual Studio 2008 Pro, Do I need SQL Server Management Studio? or is it included in the VS 2008 Pro Suite? Am learning C# and SQL Server.



SQL Server Management Studio Slow Grid Draw and Refresh

I've istalled SQL2005/SSMS on my development machine and connecting to a local SQL Server 2005. Executing queries is fast but the results grid populating is slow and so is the refresh of the same data. This is not a slow query, its the gridview draw/redraw. I've other PC's with slower processors and less ram with the same software run circles around the SMSS Performance on this Laptop   I've read posts about nvidia graphics drivers and mouse drivers causing issues similar to this. I do have an nvidia quadro x1600M (this is a laptop Compaq 8710w) and switching off the accelerator using Displays/Advanced/Troubleshooting by moving the slider to the middle/center position causes the gird refresh to dramatically increase. It's funny how turning oof the accelerator increases performance.   I have the latest HP nvidia drivers and SSMS is useable without hardware acceleration  but I also develop software that uses directx and its getting really troublesome to work this way.   I am running:   Operating System: Windows XP Professional (5.1, Build 2600) Service Pack 2 (2600.xpsp_sp2_qfe.070227-2300)Language: English (Regional Setting: English)System Manufacturer: Hewlett-PackardSystem Model: HP Compaq 8710wBIOS: EPP runtime BIOS - Version 1.1 Processor: Intel(R) Core(TM)2 Duo CPU     T7300  @ 2.00GHz (2 CPUs)Memory: 3072MB RAMPage File: 515MB used, 4439MB availableWindows Dir: C:\WIN

Error 2908 while installing sql server 2005 management objects collection on Win 7

I have SQL Server native client 2005 installed on Win 7 64-bit machine. While installing SQL Server XMO 2005 it gives error 2908 and aborts installation. Any suggestion on the error?

Please Help Installing SQL Management Studio (not Express) w/ local SQL Server Express

I have recently formatted my hard drive and over the past few days I've been reloading my software.  I have installed on my machine SQL Server Express 2005 SP3.  I prefer to have SQL Express running on my development machine because that is what my customers primarily use.  I also have a full MSDN license, and I would need to install SQL Management Studio 2005.  However, when I download the SQL Server 2005 Developer ISO from MSDN, and run the setup file I get an error message that states: Installation of Microsoft SQL Server Native Client failed because a higher version already exists on the machine.  To proceed, uninstall the higher version and then run Microsoft SQL Server Native Client Setup. I would assume the problem is that the copy of SQL Server - Dev Edition that is available through my MSDN subscription is using an earlier version of SQL Server 2005 (most likely the version prior to SP1.)  I would just unistall SQL Server Express 2005 SP3 and reinstall it with out any service pack updates.  The problem is that I also see within my Add or Remove Programs list  four SQL Server 2008 R2 entries, that I believe were installed when I installed Visual Studio Pro 2010 (they are, Microsoft SQL Server 2008 R2 Data-Tier Application Framework, Microsoft SQL Server 2008 R2 Data-Tier Application Project, Microsoft SQL Server 20

SQL Server CE in Management studio express

Hello,I am trying to connect to sql server CE trough SQL Management studio express. But it seems like it only wants to connect to an SQL server express instance. Does SQL server CE needs to run as a server? because I can't seem to be able to just connect to a file. Does Anyone know how to connect to SQL CE?Thanks!Greetings,Mark

SQL Server 2008 Management Studio

Been around SQL Server since 7.0 days.   In SQL Server 2008 Management Studio I don't seem to be able to display Created Date for Views. I can't really believe MS have taken this away so hence my Q.   I find it useful to see Created Data to script my recently developed View and other objects.   Robert, Edinburgh    Bob as MCSD.NET 2003

Cannot Create Database Diagrams - SQL Server 2008 Management Studio

I cannot create a database diagram with my client-side SQL Server Management Studio.  I can do this if I am on the actual db server itself.  Please help.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend