Re: Unable to register 2nd SQL server instance.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

See if this helps:
http://support.microsoft.com/default.aspx?scid=kb;en-us;265808&sd=tech
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/


<mitchell.chris@xxxxxxxxx> wrote in message
news:1121714863.522077.183970@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Quick background, This is running on a Win 2k3 server, and SQL 2000
> std. I have installed a 2nd instance of SQL, everything seemed to
> install correctly. I am able to register the default and 2nd
> instancein enterprise mgr on the local server. When i try to register
> the default instance on my workstation i can, however when i try to
> register the 2nd instance i am unable to. I get the following error.
>
> SQL server does not exist or access is denied.
>
> I am trying to register with the same user name and password. When i
> register i have tried servername\instancename, IPaddress\instancename
> and creating aliases with the servername\instancename,
> IPaddress\instancename. I get the same error every time. I then went
> to the properties and network configuration and changed the port 0 to
> 1433, stop/start the services, then reboot, and then change the port to
> 1533 to make sure it was not conflicting with the default instance,
> start and stop services and reboot. Still no luck. Can someone please
> help. I have seen this in the news group multiple times but i have not
> yet found a solution that works. Any emails and posts are greatly
> appreciated.
>
> Thanks in advance
> Chris
> cmitchell at smtusa.com
>


.

Relevant Pages

  • Re: Unable to use Kerberos Delegation from IE6 --> IIS 5.0 (asp.net)--> SQL 2000
    ... No problem with this configuration except SQL Server isn't smart enough to register all the ports in the Active Directory. ... the only registered Service Principal Name was for port 1433. ...
    (microsoft.public.inetserver.iis.security)
  • Re: Unable to use Kerberos Delegation from IE6 --> IIS 5.0 (asp.net)--> SQL 2000
    ... No problem with this configuration except SQL Server isn't smart enough to register all the ports in the Active Directory. ... the only registered Service Principal Name was for port 1433. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Replication to server with different Port
    ... I have a SQL server running on a remote location that has a different port ... to register I have to specify the port number as well eg. ... Enterprise Manager on my machine and on setting up the subscriber I am able ...
    (microsoft.public.sqlserver.replication)
  • RE: 0x80004005 - you need permission to view its data
    ... SPN without the port number and another SPN with the port number. ... typical, non-clustered computer that is running SQL Server, you only have ... to register the SPN with the port number. ...
    (microsoft.public.sqlserver.security)
  • Re: Beta of Microsoft Certification Exam 70-442
    ... I have registered for the SQL Server Beta test too. ... To register visit one of our independent testing providers: ... exam will receive a free exam voucher* for any Microsoft Certification ...
    (microsoft.public.cert.mcdba)