SQL Server, SQL registration Problem

microsoft.public.sqlserver.server - Microsoft SQL Server forum discussing administration and other SQL Server related topics. MS SQL Server is used for high performance and enterprise level applications.


SQL Server >> SQL registration Problem

by RGF2aWQ » Sun, 12 Sep 2004 11:25:02 GMT

hi! at first, am having problem with sql server registration.
Am getting the following msg when trying to do sql server
registration :

"SQL Server Registation failed .....
SQL Server does not exist or access denied
ConnectionOpen(Connect())"

After reading through the related discussions posted to this
workgroup. I'm able to create an alias and added in the sql
server registration to the sql server successfully.

Now the problem is that for that SQL server, it's becoming
very slow when i try to browse through the items in the
enterprise manager(locally through the sql enterprise manager) until it's
stop responding.
It's even faster to access that sql
server remotely through another server(with sql installed also) which
i added in the server registration and access it remotely.

Any idea what's wrong with that server? Thks!


"SQL Server Registation failed .....
SQL Server does not exist or access denied
ConnectionOpen(Connect())"




Top

SQL Server >> RE: SQL registration Problem

by U2FsZWVtIEhha2FuaQ » Sun, 12 Sep 2004 15:01:07 GMT


What Edition of SQL Server have you installed?
MSDE? or Standard., If it's MSDE the Network protocols by default are
disabled if that's the case make sure you enable them from SQL Network
configuration by right clicking on SQL Server and selecting Properties.

It's also possible that SQL Server may be listening on some other port and
by default your client tools would connect using 1433. check SQL client
network utility and make sure you have proper values.

HTH
XXXX@XXXXX.COM





Top
Similar Threads

1. SQL Newbie:Sql Registration Problem

2. SQL registration problem solved

3. SQL Server Registration Problem - SQL Server

4. SQL Server Registration problem 

I have installed the MSDE on my machine, and I'm trying to register an
instance on one of our servers (not the default instance) and no matter what
instance I register, it always shows the default instance db's.  Does
anybody know what might fix this?  I've installed the latest mdac (2.7).

Thanks,
Barry

5. Custom Task Registration Problems; Error: Not Implemented - SQL Server DTS

6. problem with registration... 

when i try to create a new sql server registration it fail 
and display this message "communication link failure" only 
from one server the comunication is ok, what is the 
problem???

                                     Thank's
                               Emiliano Biocchetti

7. Registration problem

8. Failure compiling WMI Registration File problem during install 

I've noticed a few other posts from people with the same problem, but
a solution has not yet been posted.  When I install Reporting Services
on a Windows 2000 Server SP4, I am getting an error "Failure compiling
WMI registration file".  I've opened up the RSMS10.log and the
following error appears:

<Func Name='InstallMOF'>
Failed to compile file C:\Program Files\Microsoft SQL
Server\80\Tools\binn\reportingservices.mof. Error value: 2147549445
(0x80010105)
<EndFunc Name='InstallMOF' Return='-2147417851' GetLastError='0'>


I'm only trying to install the server components, and not the client
components (I'll install the client components on a development pc).

Any ideas of what I can do?