Hi, I've just installed MSDE 2000 Release A on a Windows NT Server 4.0 w/SP6. I'm on a WinXP machine and I've installed the Enterprise Manager, and am trying to register a new server registration. However, I'm getting the error: Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection. I've made sure that both the client and server are using TCP/IP for the protocol list, and I've tried using the physical server's name and it's IP address to register, but keep getting the same error. Thanks for the help.
Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'. The request failed with the error message: -- <html> <head> <title> SQL Server Reporting Services </title><meta name="Generator" content="Microsoft SQL Server Reporting Services 9.00.2047.00" /> <meta name="HTTP Status" content="500" /> <meta name="ProductLocaleID" content="9" /> <meta name="CountryLocaleID" content="1033" /> <meta name="StackTrace" content=" at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load() at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Construct(String configFileName) at Microsoft.ReportingServices.Diagnostics.RSConfiguration..ctor(String configFileName, String location) at Microsoft.ReportingServices.Diagnostics.RSConfigurationManager..ctor(String configFileName, String configLocation) at Microsoft.ReportingServices.Library.Global.get_ConfigurationManager() at Microsoft.ReportingServices.WebServer.Global.StartApp() at Microsoft.ReportingServices.WebServer.Global.Application_BeginRequest(Object sender, EventArgs e)" /> <style> BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black} H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt} LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt; DISPLAY:inline} .ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray} A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none} A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300; TEXT-DECORATION:underline} A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none} A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300; TEXT-DECORATION:underline}
</style> </head><body bgcolor="white"> <h1> Reporting Services Error<hr width="100%" size="1" color="silver" /> </h1><ul> <li>The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) </li><ul> <li>Access to the path 'c:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServerRSReportServer.config' is denied.</li> </ul> </ul><hr width="100%" size="1" color="silver" /><span class="ProductInfo">SQL Server Reporting Services</span> </body> </html> --. (Microsoft.SqlServer.Management.UI.RSClient)
Hey, I can't enable caching on my local computer..I use daspnet_regsql -S "localhostSQLEXPRESS" -E -d books -edand aspnet_regsql -S "AdminSQLEXPRESS" -E -d books -edto try to start but i get a login error...cannot open database "books" requested by login. The login failed. Login failed for user Computer2/Adminunable to connect to SQL database for cache dependency registrationI tested connection with vwd and sql express management and it connects so I don't know what i'm doing wrong since I followed the direction and I googled for answer but not coming up with anything that's helping me..anyone have this problem and know how to resolve so i can cache some data output on my project
Hi: My pc is windows 2003 server and I have installed SQL SERVER 2005 EXPRESS. From Management Studio I made a New Server Registration with Windows Authentication. I can't run the new server, its icon appears with a white dot (instead of green when a server is running or red when the server is stopped) I go to server properties and click the "Test" button and I get the next message error: Testing the registered server failed. Verify the server name, credentials, an database, an then click Test again. 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) what could be wrong? How can I run the server? Thanks!
hi, when we go for a new sql server registration, then there are two authentication modes i.e either through windows authentication or through sql server authentication. May anyone please tell me the default password for the windows authentication mode for user "sa". Thanks & Regards, Sitangshu Roy
i need to know how can i register my SQL server with WEb based SQL server i have the address MSSQL2.MINUTESUAE.COM now how can i register my SQL Server with them. when i m going to conect with this server it register but after that Database not show it take to much time.
I'm attempting to register a new sql server through the enterprise manager and recieving the following error message: login incorrect, userid not found.
I'm using the sql server wizard to register and selecting the sql server login information as the authentication mode. The login name and password is a valid account on the Windows NT server when i view the domain information.
I was trying to register a new server. When I start the new ser. registration wizzard I've selected a pc with the MSDE installed and when I entered all the correct passwords it doesn't register. Both pc's are the domain administrators.
I tried with windows authent. too and still the same. To be onest I was playing with this for about 2 days ;(
Both PC's are runnoing windows xp pro. I did hoewer manage to connect to the MSDE on the windows 2000 server.
I am trying for the first time to learn what to do and how to use SQLServer. I am following instructions in Books on Line to make a New Server Registration. The instructions read as follows:
Connecting to Servers
The toolbar of the Registered Servers component has buttons for the Database Engine, Analysis Services, Reporting Services, SQL Server Mobile, and Integration Services. You can register any of these server types for convenient management. Try this exercise to register the AdventureWorks database.
To register the AdventureWorks database
On the Registered Servers toolbar, click Database Engine if necessary. (It may already be selected.)
Right-click Database Engine, point to New, and then click Server Registration. The New Server Registration dialog box opens.
In the Server name text box, type the name of your SQL Server instance.
In the Registered server name box, type AdventureWorks.
On the Connection Properties tab, in the Connect to database list, select AdventureWorks, and then click Save.
I did steps 1 and 2 --- no problem. At step 3, for server name I typed MARKSDESKTOPSQLEXPRESS
At step 4 I typed: Adventureworks
At step 5 I went to Connection Properties and at the "Connect to database drop down box there were 2 choices: <default> or <browse server> (not Adventureworks). If I click on browse server, The browse server for Database window pops up but Adventureworks is not listed there either.
I did a search on my C drive and there are lots of Adventureworks files present so I must have downloaded the database OK.
Does anyone know where I go from here to connect to the Adventureworks database so I can continue with this tutorial?
TITLE: Microsoft SQL Server Management Studio Express ------------------------------
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: 41 - Cannot open a Shared Memory connection to a remote SQL server) (Microsoft SQL Server, Error: 87)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=87&LinkId=20476
------------------------------ BUTTONS:
OK ------------------------------
TITLE: Browse Server for Database ------------------------------
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) (Microsoft SQL Server, Error: 53)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=53&LinkId=20476
------------------------------ BUTTONS:
OK ------------------------------
ABove is the error msg. Anybody any suggesstion. I'm newbie in SQL Server. This happen when i follow the tutorial for server registration at Server Management Studio.
'To register the AdventureWorks database'
I had enable all the protocol. I'm using win XP Sp2.
have a standalone machine with SQL Server 7 installed....service is up and running but am having trouble registering the server in the Enterprise Manager.....
error message:
A connection could not be established to MACHINENAME - Client unable to establish connection ConnectionOpen (CreateFile()).. Please verify SQL Server is running and check your SQL Server registration properties (by right-clicking on the MACHINENAME node) and try again
have tried both nt security and the sa account but always get same message
I hv 'SQL 2k' working on W2k. Initially the server name was 'GENOMESQL2000'. Today I hv changed the server name(sp_dropserver 'genomesql2000') to 'genomesql2k' by using the command sp_addserver 'genomesql2k',local.
After that I hv stopped the service and restarted the server, the server name was changed to 'genomesql2k'.
When I went and saw the SQL Server Group in the Enterprise Manager still the old name 'genomesql2000' exists. I hv refreshed the server it is showing the old name.
Now I got a doubt that this name is different from the server name or it should match the servername with the 'select @@servername'.
I'm not sure what the Admin installed on my Windows 98 computer; and he is on vacation. I tried registering a server, but I get the following error message: SQL Server registration failed because of the connection failure. General network error. ConnetionOpen (connect()). I checked the utilities and the default network library is TCP/IP. Any suggestions?
Thanks, Samantha
The log file shows the following:
10:55:00 Begin Setup 10:55:00 7.00.623 10:55:00 Mode=Normal 10:55:00 ModeType=NORMAL 10:55:01 ValueFTS returned: 1 10:55:01 ValuePID returned: 1 10:55:01 ValueLic returned: 1 10:55:01 GetDefinitionEx returned: 0, Extended: 0xf000000 10:55:01 System: Windows 98 10:55:01 SQL Server ProductType: Developer Edition [0x2] 10:55:01 Begin Action: SetupInitialize 10:55:01 End Action SetupInitialize 10:55:02 Fixed install: 0 10:55:02 Begin Action: CheckRequirements 10:55:02 Platform ID: 0xf0000 10:55:02 Version: 4.10.67766446 10:55:02 DCOM95 has been detected. 10:55:02 File Version - C:WINDOWSSYSTEMshdocvw.dll: 5.0.2919.6307 10:55:02 ComputerName: Samantha 10:55:02 User Name: Samantha 10:55:02 Domain: Samantha 10:55:02 OS Language: 0x409 10:55:02 End Action CheckRequirements 10:55:02 Begin Action: Detection 10:55:02 End Action Detection 10:55:02 Begin Action: ODBCLocked 10:55:02 C:WINDOWSTEMP\_ISTMP0.DIRodbcinst.exe -IsLocked -Silent 1 -SourceDir F:X86ODBC -LogFile C:WINDOWSsqlodbci.log 10:55:03 Process Exit Code: (0) 10:55:03 End Action ODBCLocked 10:55:03 This combination of Package and Operating System allows a client install only. 10:55:20 The Developer Edition server component cannot be installed on Windows 98 using this CD. Only client components will be available for installation.
10:55:20 Reading SoftwareMicrosoftWindowsCurrentVersionCommonFilesD ir ... 10:55:20 CommonFilesDir=C:Program FilesCommon Files 10:55:20 Windows Directory=C:WINDOWS10:55:20 Begin Action: ShowDialogs 10:55:20 Begin Action: DialogShowSdWelcome 10:55:21 End Action DialogShowSdWelcome 10:55:21 Begin Action: DialogShowSdLicense 10:55:23 End Action DialogShowSdLicense 10:55:23 Begin Action: DialogShowSdRegisterUserEx 10:55:24 End Action DialogShowSdRegisterUserEx 10:55:24 Begin Action: DialogShowCdKey 10:55:24 End Action DialogShowCdKey 10:55:24 Begin Action: DialogShowPID 10:55:24 End Action DialogShowPID 10:55:24 Begin Action: DialogShowSdSetupType 10:55:29 [SetupTypeSQL] 10:55:29 szDir=C:MSSQL7 10:55:29 Result=303 10:55:29 szDataDir=C:MSSQL7 10:55:29 End Action DialogShowSdSetupType 10:55:29 Begin Action: DialogShowSdComponentMult 10:55:29 basesys=0, baseinst=0,basedata=0 10:55:48 SQL program folder: C:MSSQL7 10:55:48 SQL data folder: C:MSSQL7 10:55:48 Windows system folder: C:WINDOWSSYSTEM10:55:48 Prog req: 46703, Data req: 0, Sys req: 58434 10:55:48 Prog avail: 2147155, Data avail: 2147155, Sys avail: 2147155 10:55:48 Prog req vs. avail, 105137, 2147155 10:55:48 Data req vs. avail, 0, 2147155 10:55:48 Sys req vs. avail, 58434, 2147155 10:55:48 DisplaySystemPreReq 10:55:48 [SQLComponentMult] 10:55:48 Component= 10:55:48 Result=1 10:55:48 End Action DialogShowSdComponentMult 10:55:48 Begin Action: DialogShowSdStartCopy 10:55:49 End Action DialogShowSdStartCopy 10:55:49 Begin Action: DlgCPLLicense 10:55:49 End Action DlgCPLLicense 10:55:49 End Action ShowDialogs 10:55:49 Begin Action ProcessBeforeDataMove: 10:55:49 DeinstallStart returned (C:MSSQL7): 0 10:55:49 End Action ProcessBeforeDataMove: 10:55:49 Begin Action ProcessComponentSelection: 10:55:49 End Action ProcessComponentSelection 10:55:49 Begin Action LogSelectedComponents: 10:55:49 MgtTool 10:55:49 MgtToolSEM 10:55:49 MgtToolSEMHTML 10:55:49 MgtToolSEMMSD98 10:55:49 MgtToolSEMMSD98SYS 10:55:49 MgtToolSEMMSD98Res 10:55:49 MgtToolSEMMSD98Hlp 10:55:49 MgtToolSEMHelp 10:55:49 MgtToolSEMSEMSys 10:55:49 MgtToolSEMRes1033 10:55:49 MgtToolSEMResIntl 10:55:49 MgtToolSEMMSD98RsI 10:55:49 MgtToolProfiler 10:55:49 MgtToolProfilerHelp 10:55:49 MgtToolProfilerRes1033 10:55:49 MgtToolProfilerResIntl 10:55:49 MgtToolQryanlz 10:55:49 MgtToolQryanlzHelp 10:55:49 MgtToolQryanlzRes1033 10:55:49 MgtToolQryanlzResIntl 10:55:49 MgtToolDTCCLi 10:55:49 MgtToolWzcnflct 10:55:49 MgtToolWzcnflctWzcnsys 10:55:49 MgtToolWzcnflctWzcnHlp 10:55:49 MgtToolUtilSys 10:55:49 MgtToolUtilBinn 10:55:49 Connect 10:55:49 ConnectConnSys 10:55:49 ConnectConn9x 10:55:49 ConnectConnNT 10:55:49 Books 10:55:49 BooksBookso 10:55:49 BooksBooksCD 10:55:49 DevTools 10:55:49 DevToolsHeaders and Libraries 10:55:49 DevToolsHeaders and LibrariesInclude 10:55:49 DevToolsHeaders and LibrariesLibx86 10:55:49 DevToolsHeaders and LibrariesLibAlpha 10:55:49 DevToolsHeaders and LibrariesESQLC 10:55:49 DevToolsMDAC SDK 10:55:49 DevToolsVDI 10:55:49 DevToolsVDIInc 10:55:49 DevToolsVDISamples 10:55:49 DevToolsDbg Int 10:55:49 DevToolsDbg IntDbg Int Common 10:55:49 DevToolsDbg IntEXE 10:55:49 Samples 10:55:49 SamplesADO 10:55:49 SamplesDBLIB 10:55:49 SamplesDTS 10:55:49 SamplesESQLC 10:55:49 SamplesMSDTC 10:55:49 SamplesODBC 10:55:49 SamplesODS 10:55:49 SamplesOLEAut 10:55:49 SamplesRepl 10:55:49 SamplesSQLDMO 10:55:49 SamplesSQLNS 10:55:49 Core 10:55:49 CoreSys 10:55:49 ODBC 10:55:49 OLEDB 10:55:49 Repostry 10:55:49 RepstSys 10:55:49 CoreMisc 10:55:49 Monarch 10:55:49 Jet 10:55:49 NetCore 10:55:49 NetExt 10:55:49 SFExt 10:55:49 ReplExt 10:55:49 Core1033 10:55:49 CoreIntl 10:55:49 CrMi1033 10:55:49 CrMiIntl 10:55:49 Monr1033 10:55:49 MonrIntl 10:55:49 SFEx1033 10:55:49 SFExIntl 10:55:49 RpEx1033 10:55:49 RpExIntl 10:55:49 SysCore 10:55:49 VOLEDB 10:55:49 VODBC 10:55:49 MiscCore 10:55:49 MCHlp 10:55:49 MC1033 10:55:49 MCIntl 10:55:49 CnctBinn 10:55:49 CrRepCom 10:55:49 {E07FDDC8-5A21-11d2-9DAD-00C04F79D434} 10:55:49 {E07FDDBE-5A21-11d2-9DAD-00C04F79D434} 10:55:49 {E07FDDC7-5A21-11d2-9DAD-00C04F79D434} 10:55:49 {E07FDDBF-5A21-11d2-9DAD-00C04F79D434} 10:55:49 End Action LogSelectedComponents 10:55:49 Begin Action MoveFileData: 10:56:31 End Action MoveFileData 10:56:31 Begin Action ProcessAfterDataMove: 10:56:31 DeinstallSetReference (C:MSSQL7sqlservr.exe) returned: 0 10:56:31 End Action ProcessAfterDataMove 10:56:31 Begin Action InstallPkgs: 10:56:31 Setup is installing Microsoft Data Access Components (MDAC) ... 10:56:31 F:x86Othermdac_typ.exe /q:a /c:"setup.exe /qtn" 10:56:59 Process Exit Code: (3010) 10:56:59 Setup is installing Microsoft Management Console (MMC) ... 10:56:59 F:x86Otherinstmmc.exe /Q 10:57:20 Process Exit Code: (0) 10:57:20 Setup is installing Microsoft Distributed Transaction Coordinator (MSDTC) ... 10:57:20 F:x86Otherdtcsetup.exe /q:a /r:n 10:57:22 Process Exit Code: (0) 10:57:22 Setup is installing HTML Help ... 10:57:24 HTML Help installer exit code: 0 10:57:24 End Action InstallPkgs 10:57:24 SetNewPath returned: 3010 10:57:24 Path successfully updated. 10:57:24 Begin Action SelfRegister 10:57:30 Return code: 0 10:57:30 End Action SelfRegister 10:57:30 Begin Action SetupRegistry: 10:57:30 End Action SetupRegistry 10:57:30 Begin Action PostSetupRegistry: 10:57:30 C:MSSQL7BINNdcomscm.exe /RegServer 10:57:30 Process Exit Code: (0) 10:57:30 C:PROGRA~1COMMON~1MICROS~1SQLDEB~1sqldbreg.exe -RegServer 10:57:30 Process Exit Code: (-2147312566) Error loading type library/DLL.
I recently just changed my server's IP address. Now I can't access my named server in the Enterprise Manager. I can get to the server using the (LOCAL) name but not the machine name. Any pointers on how to fix this problem? Thanks!
I had 50+ servers that are to be registered under 10 Groups. My Sr.DBA dumped all registered servers from his registry to a shared location as with file name as Servers.reg. I clicked this file and added to to the Registry.
But the problem is when I opened the Enterprise manager i could see only the group names but the servers are missing???
Some one please help me in this ... How can we add all the Servers to my registry.
I have 65 servers registered in SQL Server 7.0 that I can see in Enterprise Manager. When I load the desktop client for 2000 I lose all the registered servers, and I have to register them all again.
I have 3 SQL Servers running here. Here are their configurations:
SERVER 1: OS: Windows 2000 SP 4 SQL: SQL Server 2000 SP 4
SERVER 2: OS: Windows 2000 SP 4 SQL: SQL Server 2000 SP 4
SERVER 3: OS: Windows XP Professionnal SQL: SQL Server 2000 SP 3
Now, as you can see, SERVER 1 and SERVER 2 have identical configurations. Plus, both will accept Windows Authentication and SQL Authentication.
If I try to add a new Registration from SERVER 3 to SERVER 1, it works fine but from SERVER 3 to SERVER 2 it doesn't. I always get an error (SQL Server does not exist or access denied). But, using the exact same user name and password, a connection can be established from SERVER 1 to SERVER 2 and vice-versa. Only when trying to connect froms SERVER 3 to SERVER 2 fails.
recently i have intsalled sql server on my system . and tried to set the sql server authentication, but its giving me an error,all the time i.e not allowing me to register and it says, "not connected to the right server." or sql server is not found.
can any one help me out ASAP with this.that is show me how to register the sql server exactly and set the user name and password for the sql server.Thnaks.
I am having problems with enterprise manager crashing. I basically deleted a database on my hosting company before I deleted the SQL server registration from enterprise manager, now everytime I try and delete it in enterprise manager it crashes.
I am facing this problem for last couple of days...and here it goes
in oour office we are running windows server 2003 and in that we hav installed sql server 2000 ent edition..so far good.. the problem is with creating instance in the client environment ....
Within the client when we try to create new registration the server is getting recognized but @ the end its displaying "ACCESS DENIED OR SERVER DOES NOT EXIT MESAGE "
WHAT I DID IS , INSTALLED SQL SERVER AS CLIENT AND SERVER rather than client tools only ..on my client side ...
on my server side wen i try to create new registration evrything works well ......i dnt understand how to configure clients inorder to make thm work wel
I am trying to set up my machine for replication and have recieved thefollowing message"SQL Server replication does not support nicknames, such as "." or"(local)" as server names.Delete the SQL Server registration for this server and register itusing the actual server name"Well, I am not sure how to do that, I can't seem to find any info onit. Can anyone help out?Thanks.
I have just installed sql 2005 with sp2 and now I am trying to connect with other databases but when I try to register, it gives me an error stating something about not enabling "remote connection"..but checked the boxs and they are set to connect remotely...any ideas?
I just ran the utility without any commands ant the wizard has come up. This is all independent of my web application.I am guessing this is going to install the database tables to my existing database. UPDATE: They have been createdWill I then connect my web app to this database schema that is created?How do I change the membership/roles users in my web app to point to the database tables?
I am attempting to centrally register all of my sql server so I can go to any workstation and open enterprise manager and select to read the sql server registration from the remote server.
I followed all of the steps in books on line about going to the central server, turning off the store/user independent option, registering all of the servers and then going to a workstation and selecting the option to read from the central server.
I get error messages like registry read error: 5 and registry read error: 2
This is getting frustrating because we have a lot of servers in our environment and re-registering them everytime is getting to be quite a pain. If the central store will not work, is there a way to write a script to register all servers in an enterprise.
I have a problem I can't seem to solve. Maybe you guys have seen it before and can help me out.
A developer in the company has previously registered his SQL 2000 machine in EM using the Registration Wizard. Registering the same server with both "(local)" and "<server_name>" in the same EM pane worked out fine, until a couple of days ago. After deinstalling and reinstalling SQL 2000 and registering "(local)" --which works fine--, he can no longer add the same instance using "<server_name>". The message that appears on the last page of the SQL Server Registration Wizard states:
ARMADAN800-001: A Server with this name already exists.
I wonder if it's due to the (local) entry, or if it has something to do with e.g. registration key that lingers on in the registry and prevents him from adding the server to the server group.
Since the Properties button on the Registration Wizard window is disabled, this is all the information I can provide you. Before re-installing SQL, cleaning the registry using something like regclean and reinstalling SQL again, I thought I'd ask you people for advise.
Are there any issues with dropping registration of a SQL 6.5 database and then registering it again. I think this is what I am going to have to do because a consultant we are using decided to change the security from standard to Integrated. Now we are getting the following error when we are in the SQL Enterprise Manager and trying to open TAP:
A connection could not be established to TAP[SQL Server]Login failed:Reason:Not associated with trusted SQL Server connection.
I have 3 SQL Servers running here. Here are their configurations:
SERVER 1: OS: Windows 2000 SP 4 SQL: SQL Server 2000 SP 4
SERVER 2: OS: Windows 2000 SP 4 SQL: SQL Server 2000 SP 4
SERVER 3: OS: Windows XP Professionnal SQL: SQL Server 2000 SP 3
Now, as you can see, SERVER 1 and SERVER 2 have identical configurations. Plus, both will accept Windows Authentication and SQL Authentication.
If I try to add a new Registration from SERVER 3 to SERVER 1, it works fine but from SERVER 3 to SERVER 2 it doesn't. I always get an error (SQL Server does not exist or access denied). But, using the exact same user name and password, a connection can be established from SERVER 1 to SERVER 2 and vice-versa. Only when trying to connect froms SERVER 3 to SERVER 2 fails.
Hi all In Enterprise manager i RightClicked on my server (Local (Win NT)) and selected "New Sql Server Registration"....I successfully create my new server BUT now i want to remove it...how should i do that? there isn't any Delete Item on context or toolbar menu!!! I'm using sql Server 2000.