"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 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)
> =====================================================
>

"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...
> > 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)
> > =====================================================
> >
>
>
>

"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 may
> refer to:
> How to: Rename a Computer that Hosts a Stand-Alone Instance of SQL Server
> 2005
> http://technet.microsoft.com/en-us/library/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.
> ======================================================
>
>
>
>
>

"rkbnair" <rkbnair@community.nospam> wrote in message
news:D5D736D2-EFB4-4E02-A37A-7CDE47D5C019@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 may
>> refer to:
>> How to: Rename a Computer that Hosts a Stand-Alone Instance of SQL Server
>> 2005
>> http://technet.microsoft.com/en-us/library/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.
>> ======================================================
>>
>>
>>
>>
>>

"Tibor Karaszi" wrote:

> I suggest you first check what SQL Server related services you have installed. 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...
> > 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 may
> >> refer to:
> >> How to: Rename a Computer that Hosts a Stand-Alone Instance of SQL Server
> >> 2005
> >> http://technet.microsoft.com/en-us/library/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.
> >> ======================================================
> >>
> >>
> >>
> >>
> >>
>

"rkbnair" <rkbnair@community.nospam> wrote in message
news:145F3211-E6D3-4D4F-877B-7F47AE7C7759@microsoft.com...
> 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 installed. 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...
>> > 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 may
>> >> refer to:
>> >> How to: Rename a Computer that Hosts a Stand-Alone Instance of SQL Server
>> >> 2005
>> >> http://technet.microsoft.com/en-us/library/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.
>> >> ======================================================
>> >>
>> >>
>> >>
>> >>
>> >>
>>

"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...
> > 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 installed. 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...
> >> > 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 may
> >> >> refer to:
> >> >> How to: Rename a Computer that Hosts a Stand-Alone Instance of SQL Server
> >> >> 2005
> >> >> http://technet.microsoft.com/en-us/library/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.
> >> >> ======================================================
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >>
>
>

"rkbnair" <rkbnair@community.nospam> wrote in message
news:83688470-F1FB-4618-B743-D1F9B0B267E2@microsoft.com...
> 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...
>> > 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 installed. 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...
>> >> > 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 may
>> >> >> refer to:
>> >> >> How to: Rename a Computer that Hosts a Stand-Alone Instance of SQL Server
>> >> >> 2005
>> >> >> http://technet.microsoft.com/en-us/library/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.
>> >> >> ======================================================
>> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >>
>>
>>