Cannot register server (LOCAL)

I'm trying to register the (LOCAL) database using SQL Server authentication
.
However, I get the following message. I still can register other servers
using ip addresses though.
========================================
=============
Cannot connect to (LOCAL).
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: TCP Provider, error: 0 - No connection could be made because the
target machine actively refused it.) (Microsoft SQL Server, Error: 10061)
========================================
=============did you try localhost?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"rkbnair" <rkbnair@.community.nospam> wrote in message
news:5439BC07-3618-4DC5-99BB-7957915C6894@.microsoft.com...
> I'm trying to register the (LOCAL) database using SQL Server authenticati
on.
> However, I get the following message. I still can register other servers
> using ip addresses though.
> ========================================
=============
> Cannot connect to (LOCAL).
> --
> 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: TCP Provider, error: 0 - No connection could be made because th
e
> target machine actively refused it.) (Microsoft SQL Server, Error: 10061)
> ========================================
=============
>|||Hi,
To let me better understand your issue, could you please let me know the
following questions:
1. Did you mean registering server named (local) or a database?
2. How did you perform the registration?
3. Why would you like to register a (local) server (database?) ?
From the error message, it seemed that you were trying to register a
(local) server remotely. "(local)" is preserved keyword for the default
instance of local SQL Server. You can only use it to locally connect to
your default instance of your SQL Server not remotely. Generally it is no
need to register a (local) server, if you want to rename a SQL server
instance, you can use sp_dropserver/sp_addserver stored procedures. You may
refer to:
How to: Rename a Computer that Hosts a Stand-Alone Instance of SQL Server
2005
http://technet.microsoft.com/en-us/...y/ms143799.aspx
Anyway I think that I have not totally understood your scenario. If there
is any misunderstanding, I appreciate your pointing and kindly making some
further explanation.
Thanks and have a nice day!
Best regards,
Charles Wang
Microsoft Online Community Support
========================================
=============
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties, and confers no rights.
========================================
==============|||Yes, But no luck on that too.
test
"Tibor Karaszi" wrote:

> did you try localhost?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "rkbnair" <rkbnair@.community.nospam> wrote in message
> news:5439BC07-3618-4DC5-99BB-7957915C6894@.microsoft.com...
>
>|||Under the registered servers I see the following:
3tsd3b1
3tsd3b1\sqlexpress (which I can connect to successfully)
Under the Server Group I see the following items:
(LOCAL)
10.100.1.67 (which I can connect to successfully))
3TSSD3B1\SQLEXPRESS (which I can connect to successfully)
What should I do to create a database on my local machine.
In other words, what is the equivalent of registering (LOCAL) server in SQL
Server 2000?
"Charles Wang[MSFT]" wrote:

> Hi,
> To let me better understand your issue, could you please let me know the
> following questions:
> 1. Did you mean registering server named (local) or a database?
> 2. How did you perform the registration?
> 3. Why would you like to register a (local) server (database?) ?
> From the error message, it seemed that you were trying to register a
> (local) server remotely. "(local)" is preserved keyword for the default
> instance of local SQL Server. You can only use it to locally connect to
> your default instance of your SQL Server not remotely. Generally it is no
> need to register a (local) server, if you want to rename a SQL server
> instance, you can use sp_dropserver/sp_addserver stored procedures. You ma
y
> refer to:
> How to: Rename a Computer that Hosts a Stand-Alone Instance of SQL Server
> 2005
> http://technet.microsoft.com/en-us/...y/ms143799.aspx
> Anyway I think that I have not totally understood your scenario. If there
> is any misunderstanding, I appreciate your pointing and kindly making some
> further explanation.
> Thanks and have a nice day!
> Best regards,
> Charles Wang
> Microsoft Online Community Support
> ========================================
=============
> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ========================================
==============
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> ========================================
==============
>
>
>|||I suggest you first check what SQL Server related services you have installe
d. From that we can see
how many instances of SQL Server you installed.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"rkbnair" <rkbnair@.community.nospam> wrote in message
news:D5D736D2-EFB4-4E02-A37A-7CDE47D5C019@.microsoft.com...[vbcol=seagreen]
> Under the registered servers I see the following:
> 3tsd3b1
> 3tsd3b1\sqlexpress (which I can connect to successfully)
> Under the Server Group I see the following items:
> (LOCAL)
> 10.100.1.67 (which I can connect to successfully))
> 3TSSD3B1\SQLEXPRESS (which I can connect to successfully)
> What should I do to create a database on my local machine.
> In other words, what is the equivalent of registering (LOCAL) server in SQ
L
> Server 2000?
>
>
> "Charles Wang[MSFT]" wrote:
>|||The following services are started:
Server Status (green)
Report Server Virtual Directory (Red)
Report Manager Virtual Directory (red)
Windows Service Identity (Green)
Database Setup (Red)
Encryption Keys (Grey)
Initialization (Grey)
Email settings (Yellow)
Execution Account (Yellow)
test
"Tibor Karaszi" wrote:

> I suggest you first check what SQL Server related services you have instal
led. From that we can see
> how many instances of SQL Server you installed.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "rkbnair" <rkbnair@.community.nospam> wrote in message
> news:D5D736D2-EFB4-4E02-A37A-7CDE47D5C019@.microsoft.com...
>|||What tool did you use to get that list? None of those looks like the name of
a SQL Server 2005
service to me. I suggest you do Run and in there type : services.msc
This starts the "Services" windows applet. In there you look for services wh
ere the name starts with
SQL Server, such as :
SQL Server (MSSQLServer)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"rkbnair" <rkbnair@.community.nospam> wrote in message
news:145F3211-E6D3-4D4F-877B-7F47AE7C7759@.microsoft.com...[vbcol=seagreen]
> The following services are started:
> Server Status (green)
> Report Server Virtual Directory (Red)
> Report Manager Virtual Directory (red)
> Windows Service Identity (Green)
> Database Setup (Red)
> Encryption Keys (Grey)
> Initialization (Grey)
> Email settings (Yellow)
> Execution Account (Yellow)
> --
> test
>
> "Tibor Karaszi" wrote:
>|||Hi,
Thanks for your response.
I recommend that you post some screenshots here or or mail them to me
(changliw_at_microsoft_dot_com) so that we can better understand your
issue. Also as Tibor said, please run services.msc from command line and
check what the SQL Server services are listed. The SQL Server service name
is like "SQL Server (<instance name> )" or "MSSQLServer".
Additionally I need to confirm with you several questions for further
research:
a. What is the version of your (local) SQL Server instance, SQL Server 2000
or SQL Server 2005?
b. What is the client tool you use, SQL Server Enterprise Manager or SQL
Server Management Studio?
c. Was "3tsd3b1" the name of your local computer and was "10.100.1.67" the
IP address of your local computer?
Creating a database on your local machine does not mean registering (LOCAL)
server in SQL Server 2000. If you would like to register (LOCAL) server in
SQL Server 2000 (Enterprise Manager ?) , you need to ensure that there is a
SQL Server 2000 default instance (the service name is MSSQLServer in
Services panel) has been installed. Also SQL Server 2000 Enterprise Manager
(EM) cannot manage SQL Server 2005 instance, so if you would like to use
SQL Server 2000 EM to register a SQL Server 2005 instance, it is not
possible to do it. In this case, you have to use SQL Server 2005 Management
Studio (SSMS) to do it.
If there is a SQL Server 2000 default instance installed, you can locally
use either SQL Server 2000 EM or SSMS to connect to it via your computer
name, IP or "(local)" to connect to it. Appreciate your understanding if we
could not cleary understand your issue, it is hard for us to go further.
Thanks for your cooperation and look forward to your response.
Best regards,
Charles Wang
Microsoft Online Community Support
========================================
=============
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties, and confers no rights.
========================================
==============|||SQL Server (SQLEXPRESS)
SQL Server Active Directory Helper
SQL Server Analysis Services (MSSQLSERVER)
SQL Server Browser
SQL Server Integration Services
SQL Server Reporting Services (MSSQLSERVER)
SQL Server VSS Writer
test
"Tibor Karaszi" wrote:

> What tool did you use to get that list? None of those looks like the name
of a SQL Server 2005
> service to me. I suggest you do Run and in there type : services.msc
> This starts the "Services" windows applet. In there you look for services
where the name starts with
> SQL Server, such as :
> SQL Server (MSSQLServer)
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "rkbnair" <rkbnair@.community.nospam> wrote in message
> news:145F3211-E6D3-4D4F-877B-7F47AE7C7759@.microsoft.com...
>