Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««1234

Management Studio with SQL Server 2000 Expand / Collapse
Author
Message
Posted Monday, September 24, 2007 1:33 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, September 25, 2007 8:58 AM
Points: 1, Visits: 2
Thought the article was helpful, but I am having issues connecting my SQL 2005 Management Studio on my notebook to the SQL2000 server instance on my workstation.  I keep getting this error, but "help" link doesn't go anywhere.  Any chance you can help me figure this out?  Thanks.

ADDITIONAL INFORMATION:

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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

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

Post #402211
Posted Monday, September 24, 2007 5:09 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, July 2, 2014 1:41 AM
Points: 164, Visits: 364
Greg,

Can you connect to that same server from your client using Enterprise Manager? That error may suggest that the installation of SQL Server may not be letting anyone connect to it from outside the server.

Rob


Rob Farley
LobsterPot Solutions & Adelaide SQL Server User Group
Company: http://www.lobsterpot.com.au
Blog: http://sqlblog.com/blogs/rob_farley
Post #402297
Posted Monday, November 12, 2007 8:47 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, November 12, 2007 8:36 PM
Points: 1, Visits: 0
Hi,
I have the same problem as Greg. I am trying to connect to a remote SQL Server 2000 DB from SQL Server 2005 Management Studio and I get the exact same error message. Any ideas??
I can connect using Enterprise Manager so the remote server is fine.

Thanks,

Scott Anderson
Post #421309
Posted Tuesday, April 8, 2008 7:54 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, November 25, 2013 12:04 PM
Points: 2, Visits: 60
well, i tried to use the SMSS with my SQL SERVER 2000 engine and when i started using the Object Explorer by double click over my Database then Tables, then double click over a given table it shows me this error:



any clue?
Post #481558
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse