Lost Server Registration! Cannot Access Databases!
Jun 13, 2002
I have a test server where I was experiencing security/rights anomalies. I tried disabling the BUILTINAdministrators account, closed SEM, and when I reopened it, I could not access my Server (all databases,etc.are on local machine). I thought I could just use the SQL accounts (sa, etc.) to connect, but they all fail?? I tried creating a new registration, and that didn't work either. Since I deleted the old registration, and I cannot reconnect, what are my options(short of restoring image)? If I re-install SQL will all my databases still be there? Is there another way to get access back?? Any help would be appreciated.
I just erased a database I had been using alot lately, that must have been set as my Default database. Now I can't access my server registration. I get the following error when clicking on my LOCAL tree in Enterprise Manager.
A connection could not be established to (LOCAL)
Cannot open user default database. Login failed.
Please verify SQL is running and check server registration properties.
I've checked both. It is definetely running and I'm using Windows Authentication. What can I do to solve this. I read from previous posts there is a command prompt method to change the default database, but I'm terrible with command prompt and couldn't figure it out. Is there another way to change this (if this is the problem)?
If the only way to solve this is through command prompt could someone lead me in the direction of how to do this on a step by step basis.
Thank you much for any help. It will be very much appreciated.
Hi AllI am posting this in the hopes someone has come across the same issue and found a solution. The other day i uninstalled Microsoft ISA server 2000 from my SQL / Web server. Since then i have not been able to connect to the sql server via php. I changed the php config file and pointed it at another sql server i have up for development purposes that has a recent copy of the same db and everything works properly.The errors php is throwing at me show that it is not even able to find the server at all. I have changed it several times from both the netBios name as well as the actual ip and nothing seems to work.I should also note that other than the php access issue sql seems to be working perfectly for all other users in the office that are accessing it through the accounting system.System:Ms SQL 2000Windows Server 2003php 5 on IIS 6Any ideas?ThankspT
Hello, I have changed the account in which the Sql Server process run and not I cannot log into the server with any other user account (even if they are System Admin, DBO and Domain admin...) than the one which run the SQL process.
What can I do to gain back access (with the user accounts) ?
Ok guys, I do a regular daily ntbackup of my entire server. I thought I had sql backups going daily but I think a admin password change stopped that and well those backups are a LONG time ago. The ntbackup is just 1 lost half day.
Windows crashed and had to be reinstalled, so I have all the files in the database folder and what I've done so far was reinstall windows, sql, and all that stuff so now windows is back up and going. I used sql admin and created the database ncdsm. Then I took the folder from the backup of the database for ncdsm and copied it to the new sql install (after stopping the service) and then turned it back on, and it shows that the tables do not exist, but it shows the list of tables in red.
How can I fix this and get all my databases back to normal? Thanks.
What do you do when the database actually, physically exists, intact, but is not recognized by SQL Server 7 and there is no backup?
On a newly installed system, I created a new database and imported tables from another system. I also disbled SQL Server 7 services, rebooted and file-copied into the directory another database, that was not on a current SQL Server system, then restarted SQL Server.
SQL Server 7 failed to recognize any of the databases - master, model, etc., as well as the user databases. Neither database was specifically detached - allegedly a requirement for using sp_attach_db. No backups had been done - I was still setting up(?).
I know that there must be a way to reload, reattach or recreate a database when the database actually exists. In this case, we also lost master, etc., which may change the situation. Any advice would be appreciated.
Yesterday, at 7 am, I was able to connect to remote databases from Enterprise Manager. Then at 11 am, I started getting "General Network Error" and connections failed. This happened on all my remote databases, so the problem is not the remote server. (I did check.) I have Comcast Broadband cable access to the internet. I can still access the internet, email, and ftp servers, just not the sql port. I rebooted my entire system several times. Today, I took my computer to a friend's house, and was able to successfully connect to the remote databases fom Enterprise Manager, so the problem is not on my computer. (I did check for the sql worm, and downloaded the McAfee Fix program, but it didn't find anything, and confirmed that the Service Pack 3 fixes were in place.) I also tried connecting directly to my cable modem, but that did not work, so it doesn't seem to be my router or firewall. I contacted Comcast and they are not blocking port 1433. I don't know what else to try. I don't think the problem is on my computer or the software.
I seem to have lost the ability to access the site settings as well as any security tabs and modify the properties under the directories etc...somehow i have lost administrator access , how do i get this back? I am still local administrator of the server reporting services is running on...only thing i can think off that could of done this is i installed Sharepoint onto the same machine and created a sharepoint site...are there things i can check in IIS or RS or etc to get this admin access back
Hi, How can I provide a user read only access to all the databases on the server. I have 15 databases on the server. I know I can give db_datareader access in each database individually but that is time consuming and I have 10 servers for this to be done.
Hi there,I have a situation where an application needs to import data fromnumber of access mdb files on a daily bases. The file names changeevery day. The data import is very straight forward:insert into sql_table select * from acess_tableThere are up to 8 tables in each access file and some access files willhave less. So the process needs to figure out which tables exist inAccess mdb file and import them whole into sql staging tables.Any recommendations are appreciated.Thanks
I have around 600 databases in my server, a user need select access of all the databases. will i have to go one by one in all the dbs and create that user and give datareader role to him. or is thr any shorter way to do so????
I wrote the below script to add a SQL server login account that is the db_datareader, db_datawriter, and granted permission on all stored procs, functions, and views on all databases within a server.
Code Snippet USE master GO SET NOCOUNT ON DECLARE @database_name sysname DECLARE @object_name sysname DECLARE @object_type char(2) CREATE TABLE #databases (DATABASE_NAME sysname, DATABASE_SIZE int, REMARKS varchar(254)) INSERT #databases EXEC sp_databases -- ++++++++++++++++++ add SQL Server Login ++++++++++++++++++ IF EXISTS ( SELECT 1 FROM master.dbo.syslogins WHERE [name] = 'WEB_USER2' ) BEGIN DECLARE db_cur CURSOR LOCAL FAST_FORWARD FOR SELECT DATABASE_NAME FROM #databases OPEN db_cur WHILE 1 = 1 BEGIN FETCH db_cur INTO @database_name IF (@@FETCH_STATUS <> 0) BREAK EXEC ('USE ' + @database_name +'; IF EXISTS ( SELECT 1 FROM sysusers WHERE [name] = ''WEB_USER2'' ) BEGIN EXEC sp_revokedbaccess ''WEB_USER2'' END ') END CLOSE db_cur DEALLOCATE db_cur EXEC sp_droplogin 'WEB_USER2' END EXEC sp_addlogin @loginame = 'WEB_USER2', @passwd = 'password' -- ++++++++++++++++++ loop thro' all User-Databases ++++++++++++++++++ DECLARE db_cur CURSOR LOCAL FAST_FORWARD FOR SELECT DATABASE_NAME FROM #databases WHERE DATABASE_NAME NOT IN ('master', 'model', 'tempdb', 'msdb', 'distribution', 'ASPState') OPEN db_cur WHILE 1 = 1 BEGIN FETCH db_cur INTO @database_name IF (@@FETCH_STATUS <> 0) BREAK PRINT '' PRINT 'Current database=' + @database_name -- add user to databases EXEC ('USE ' + @database_name +'; IF EXISTS ( SELECT 1 FROM sysusers WHERE [name] = ''WEB_USER2'' ) BEGIN EXEC sp_revokedbaccess ''WEB_USER2'' END ') EXEC ('USE ' + @database_name +'; EXEC sp_grantdbaccess ''WEB_USER2''; ') -- add user to db_datareader EXEC ('USE ' + @database_name +'; EXEC sp_addrolemember ''db_datareader'', ''WEB_USER2''; ') -- add user to db_datawriter EXEC ('USE ' + @database_name +'; EXEC sp_addrolemember ''db_datawriter'', ''WEB_USER2''; ') -- grant permission on Stored proc, Scalar function, Inlined table-function, Table function, View -- !! coz EXEC is a self-contained batch, so must use GLOBAL EXEC('USE ' + @database_name +'; DECLARE obj_cur CURSOR GLOBAL FAST_FORWARD FOR SELECT [name], [type] FROM sysobjects WHERE [type] IN (''P'', ''FN'', ''IF'', ''TF'', ''V'') ') OPEN obj_cur WHILE 1 = 1 BEGIN FETCH obj_cur INTO @object_name, @object_type IF (@@FETCH_STATUS <> 0) BREAK -- PRINT 'object=' + @object_name + '; type=' + @object_type IF LTRIM(RTRIM(@object_type)) = 'P' OR @object_type = 'FN' BEGIN -- EXEC on Stored proc, Scalar function EXEC('USE ' + @database_name +'; GRANT EXEC ON dbo.' + @object_name + ' TO WEB_USER2 ') END ELSE BEGIN -- SELECT ON table function, View EXEC('USE ' + @database_name +'; GRANT SELECT ON dbo.' + @object_name + ' TO WEB_USER2 ') END END CLOSE obj_cur DEALLOCATE obj_cur END CLOSE db_cur DEALLOCATE db_cur
I have a small client installable web application which used to work great on 32 bit machines. Well now clients are starting to use x64 Windows 2003 servers and things have begun to unravel. W2K3 x64 does not have any of the JET database drivers needed to communicate to the Access databases and it doesn't look like they're coming anytime soon.
Is SQL Server Express the new replacement for Access databases on x64 machines. Does Microsoft intend on moving some of the JET drivers over from 32 bit servers. I know that you can run IIS in 32 bit mode and everything is fine, but I can't ask everyone to do that.
Is SQL Server Express something that I can expect people to have installed, it sure doesn't sounds like it. After reading some posts, it sounds like it's a bit of a hastle to install.
I did a full BACKUP for two SQL databases using SQL Server Managament Studio. When trying to RESTORE the DBs, I get the following error:
"System.Data.SqlClient.SqlError: Exclusive access could not be obtained because the database is in use. (Microsoft.SqlServer.Smo)"
There are NO users using the application. These are DBs for the Portfolio Server 2007 application.
After exploring a little bit, I found that there are several "SLEEPING" processes with an "AWATING COMMAND" flag. The processes come from the Portfolio Server Application, maybe from previous sessions.
Can they be deleted? if so, would there be any serious consequences?
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.
