Adding (local) SQL Server registration

Hi,
I am using windows 2000. I uninstalled SQL server 2000
and then reinstalled the client tools only. I deleted the
(local) SQL Server registration. Now I have problem with
adding it back. Even if I uninstall and reinstall the SQL
server the (local) SQL Server registration doesn't show
up.
When I try adding (local) SQL Server registration I am
getting this error:
(LOCAL)- SQLServer does not exist or access denied.
(local) is not showing up in my available servers list
when I try to add a new SQL Server Registration.
Does anybody know how can I add it back?
Thank you.
.Hi,
It seems you have removed SQL Server from your machine and installed only
client tools. In this case you will not
have the local sql server. The (local) server can only be registered if you
have a SQL server installed in the
local machine.
Can you check the control -- Admin tools -- services for any MSSQLServer
service. If it is not there in the list then
you do not have a SQL Server installed in your machine.
Thanks
Hari
MCDBA
<anonymous@.discussions.microsoft.com> wrote in message
news:2164501c45a3b$be962de0$a001280a@.phx
.gbl...
> Hi,
> I am using windows 2000. I uninstalled SQL server 2000
> and then reinstalled the client tools only. I deleted the
> (local) SQL Server registration. Now I have problem with
> adding it back. Even if I uninstall and reinstall the SQL
> server the (local) SQL Server registration doesn't show
> up.
> When I try adding (local) SQL Server registration I am
> getting this error:
> (LOCAL)- SQLServer does not exist or access denied.
> (local) is not showing up in my available servers list
> when I try to add a new SQL Server Registration.
> Does anybody know how can I add it back?
> Thank you.
> .
>|||Hi,
Thanks for your reply.
There is no SQLServerAgent or any similar service
running. I only installed client tools because other
options were grayed out and I got this error message:
'Microsoft SQL Server 2000 Standard Edition server
component is not supported on this operating system. Only
client components will be available for installation.'
My operating system is windows 2000. I know that sql
server was runing on this system and I uninstalled it. It
seems that some Windows programs are deleted when I
uninstalled the SQL Server for the first time. Do you
know what should I check and what may be missing? I don't
want to reinstall my operating system.
Thank you,
Rosie

>--Original Message--
>Hi,
>It seems you have removed SQL Server from your machine
and installed only
>client tools. In this case you will not
>have the local sql server. The (local) server can only
be registered if you
>have a SQL server installed in the
>local machine.
>Can you check the control -- Admin tools -- services for
any MSSQLServer
>service. If it is not there in the list then
>you do not have a SQL Server installed in your machine.
>
>--
>Thanks
>Hari
>MCDBA
><anonymous@.discussions.microsoft.com> wrote in message
> news:2164501c45a3b$be962de0$a001280a@.phx
.gbl...
the[vbcol=seagreen]
with[vbcol=seagreen]
SQL[vbcol=seagreen]
>
>.
>|||Hi,
It seems edition of SQL Server you are tryng to install is not supported in
your current OS.
How to check the OS version
1. From the command prompt, execute WINMSD
2. In the system summary you can get the OS Name , if it is Windows
professional you can only install
SQL Server Personal edition and MSDE.
Have a look into the Edition supported in each OS. (From Books online)
Operating Systems Supported by the Editions of SQL Server 2000
This table shows the operating systems supported for running the server
software from each Microsoft SQL ServerT 2000 edition.
Operating System
Enterprise Edition
Standard Edition
Personal Edition
Developer Edition
Desktop Engine
SQL Server CE Enterprise Evaluation Edition
Microsoft Windows 2000 DataCenter Supported Supported Supported
Supported Supported N/A Supported
Windows 2000 Advanced Server Supported Supported Supported Supported
Supported N/A Supported
Windows 2000 Server Supported Supported Supported Supported Supported
N/A Supported
Windows 2000 Professional N/A N/A Supported Supported Supported N/A
Supported
Microsoft Windows NT 4.0 Server, Enterprise Edition Supported
Supported Supported Supported Supported N/A Supported
Windows NT 4.0 Server Supported Supported Supported Supported
Supported N/A Supported
Windows NT 4.0 Workstation N/A N/A Supported Supported Supported N/A
Supported
Microsoft Windows 98 N/A N/A Supported N/A Supported N/A N/A
Microsoft Windows CE N/A N/A N/A N/A N/A Supported N/A
Thanks
Hari
MCDBA
<anonymous@.discussions.microsoft.com> wrote in message
news:218d401c45ad1$5ccb0450$a401280a@.phx
.gbl...[vbcol=seagreen]
> Hi,
> Thanks for your reply.
> There is no SQLServerAgent or any similar service
> running. I only installed client tools because other
> options were grayed out and I got this error message:
> 'Microsoft SQL Server 2000 Standard Edition server
> component is not supported on this operating system. Only
> client components will be available for installation.'
> My operating system is windows 2000. I know that sql
> server was runing on this system and I uninstalled it. It
> seems that some Windows programs are deleted when I
> uninstalled the SQL Server for the first time. Do you
> know what should I check and what may be missing? I don't
> want to reinstall my operating system.
> Thank you,
> Rosie
>
> and installed only
> be registered if you
> any MSSQLServer
> the
> with
> SQL

Adding (local) SQL Server registration

Hi,
I am using windows 2000. I uninstalled SQL server 2000
and then reinstalled the client tools only. I deleted the
(local) SQL Server registration. Now I have problem with
adding it back. Even if I uninstall and reinstall the SQL
server the (local) SQL Server registration doesn't show
up.
When I try adding (local) SQL Server registration I am
getting this error:
(LOCAL)- SQLServer does not exist or access denied.
(local) is not showing up in my available servers list
when I try to add a new SQL Server Registration.
Does anybody know how can I add it back?
Thank you.
..
Hi,
It seems you have removed SQL Server from your machine and installed only
client tools. In this case you will not
have the local sql server. The (local) server can only be registered if you
have a SQL server installed in the
local machine.
Can you check the control -- Admin tools -- services for any MSSQLServer
service. If it is not there in the list then
you do not have a SQL Server installed in your machine.
Thanks
Hari
MCDBA
<anonymous@.discussions.microsoft.com> wrote in message
news:2164501c45a3b$be962de0$a001280a@.phx.gbl...
> Hi,
> I am using windows 2000. I uninstalled SQL server 2000
> and then reinstalled the client tools only. I deleted the
> (local) SQL Server registration. Now I have problem with
> adding it back. Even if I uninstall and reinstall the SQL
> server the (local) SQL Server registration doesn't show
> up.
> When I try adding (local) SQL Server registration I am
> getting this error:
> (LOCAL)- SQLServer does not exist or access denied.
> (local) is not showing up in my available servers list
> when I try to add a new SQL Server Registration.
> Does anybody know how can I add it back?
> Thank you.
> .
>
|||Hi,
Thanks for your reply.
There is no SQLServerAgent or any similar service
running. I only installed client tools because other
options were grayed out and I got this error message:
'Microsoft SQL Server 2000 Standard Edition server
component is not supported on this operating system. Only
client components will be available for installation.'
My operating system is windows 2000. I know that sql
server was runing on this system and I uninstalled it. It
seems that some Windows programs are deleted when I
uninstalled the SQL Server for the first time. Do you
know what should I check and what may be missing? I don't
want to reinstall my operating system.
Thank you,
Rosie

>--Original Message--
>Hi,
>It seems you have removed SQL Server from your machine
and installed only
>client tools. In this case you will not
>have the local sql server. The (local) server can only
be registered if you
>have a SQL server installed in the
>local machine.
>Can you check the control -- Admin tools -- services for
any MSSQLServer[vbcol=seagreen]
>service. If it is not there in the list then
>you do not have a SQL Server installed in your machine.
>
>--
>Thanks
>Hari
>MCDBA
><anonymous@.discussions.microsoft.com> wrote in message
>news:2164501c45a3b$be962de0$a001280a@.phx.gbl...
the[vbcol=seagreen]
with[vbcol=seagreen]
SQL
>
>.
>
|||Hi,
It seems edition of SQL Server you are tryng to install is not supported in
your current OS.
How to check the OS version
1. From the command prompt, execute WINMSD
2. In the system summary you can get the OS Name , if it is Windows
professional you can only install
SQL Server Personal edition and MSDE.
Have a look into the Edition supported in each OS. (From Books online)
Operating Systems Supported by the Editions of SQL Server 2000
This table shows the operating systems supported for running the server
software from each Microsoft SQL ServerT 2000 edition.
Operating System
Enterprise Edition
Standard Edition
Personal Edition
Developer Edition
Desktop Engine
SQL Server CE Enterprise Evaluation Edition
Microsoft Windows 2000 DataCenter Supported Supported Supported
Supported Supported N/A Supported
Windows 2000 Advanced Server Supported Supported Supported Supported
Supported N/A Supported
Windows 2000 Server Supported Supported Supported Supported Supported
N/A Supported
Windows 2000 Professional N/A N/A Supported Supported Supported N/A
Supported
Microsoft Windows NT 4.0 Server, Enterprise Edition Supported
Supported Supported Supported Supported N/A Supported
Windows NT 4.0 Server Supported Supported Supported Supported
Supported N/A Supported
Windows NT 4.0 Workstation N/A N/A Supported Supported Supported N/A
Supported
Microsoft Windows 98 N/A N/A Supported N/A Supported N/A N/A
Microsoft Windows CE N/A N/A N/A N/A N/A Supported N/A
Thanks
Hari
MCDBA
<anonymous@.discussions.microsoft.com> wrote in message
news:218d401c45ad1$5ccb0450$a401280a@.phx.gbl...[vbcol=seagreen]
> Hi,
> Thanks for your reply.
> There is no SQLServerAgent or any similar service
> running. I only installed client tools because other
> options were grayed out and I got this error message:
> 'Microsoft SQL Server 2000 Standard Edition server
> component is not supported on this operating system. Only
> client components will be available for installation.'
> My operating system is windows 2000. I know that sql
> server was runing on this system and I uninstalled it. It
> seems that some Windows programs are deleted when I
> uninstalled the SQL Server for the first time. Do you
> know what should I check and what may be missing? I don't
> want to reinstall my operating system.
> Thank you,
> Rosie
> and installed only
> be registered if you
> any MSSQLServer
> the
> with
> SQL

Adding (local) SQL Server registration

Hi,
I am using windows 2000. I uninstalled SQL server 2000
and then reinstalled the client tools only. I deleted the
(local) SQL Server registration. Now I have problem with
adding it back. Even if I uninstall and reinstall the SQL
server the (local) SQL Server registration doesn't show
up.
When I try adding (local) SQL Server registration I am
getting this error:
(LOCAL)- SQLServer does not exist or access denied.
(local) is not showing up in my available servers list
when I try to add a new SQL Server Registration.
Does anybody know how can I add it back?
Thank you.
.Hi,
It seems you have removed SQL Server from your machine and installed only
client tools. In this case you will not
have the local sql server. The (local) server can only be registered if you
have a SQL server installed in the
local machine.
Can you check the control -- Admin tools -- services for any MSSQLServer
service. If it is not there in the list then
you do not have a SQL Server installed in your machine.
Thanks
Hari
MCDBA
<anonymous@.discussions.microsoft.com> wrote in message
news:2164501c45a3b$be962de0$a001280a@.phx.gbl...
> Hi,
> I am using windows 2000. I uninstalled SQL server 2000
> and then reinstalled the client tools only. I deleted the
> (local) SQL Server registration. Now I have problem with
> adding it back. Even if I uninstall and reinstall the SQL
> server the (local) SQL Server registration doesn't show
> up.
> When I try adding (local) SQL Server registration I am
> getting this error:
> (LOCAL)- SQLServer does not exist or access denied.
> (local) is not showing up in my available servers list
> when I try to add a new SQL Server Registration.
> Does anybody know how can I add it back?
> Thank you.
> .
>|||Hi,
Thanks for your reply.
There is no SQLServerAgent or any similar service
running. I only installed client tools because other
options were grayed out and I got this error message:
'Microsoft SQL Server 2000 Standard Edition server
component is not supported on this operating system. Only
client components will be available for installation.'
My operating system is windows 2000. I know that sql
server was runing on this system and I uninstalled it. It
seems that some Windows programs are deleted when I
uninstalled the SQL Server for the first time. Do you
know what should I check and what may be missing? I don't
want to reinstall my operating system.
Thank you,
Rosie
>--Original Message--
>Hi,
>It seems you have removed SQL Server from your machine
and installed only
>client tools. In this case you will not
>have the local sql server. The (local) server can only
be registered if you
>have a SQL server installed in the
>local machine.
>Can you check the control -- Admin tools -- services for
any MSSQLServer
>service. If it is not there in the list then
>you do not have a SQL Server installed in your machine.
>
>--
>Thanks
>Hari
>MCDBA
><anonymous@.discussions.microsoft.com> wrote in message
>news:2164501c45a3b$be962de0$a001280a@.phx.gbl...
>> Hi,
>> I am using windows 2000. I uninstalled SQL server 2000
>> and then reinstalled the client tools only. I deleted
the
>> (local) SQL Server registration. Now I have problem
with
>> adding it back. Even if I uninstall and reinstall the
SQL
>> server the (local) SQL Server registration doesn't show
>> up.
>> When I try adding (local) SQL Server registration I am
>> getting this error:
>> (LOCAL)- SQLServer does not exist or access denied.
>> (local) is not showing up in my available servers list
>> when I try to add a new SQL Server Registration.
>> Does anybody know how can I add it back?
>> Thank you.
>> .
>>
>
>.
>|||Hi,
It seems edition of SQL Server you are tryng to install is not supported in
your current OS.
How to check the OS version
1. From the command prompt, execute WINMSD
2. In the system summary you can get the OS Name , if it is Windows
professional you can only install
SQL Server Personal edition and MSDE.
Have a look into the Edition supported in each OS. (From Books online)
Operating Systems Supported by the Editions of SQL Server 2000
This table shows the operating systems supported for running the server
software from each Microsoft® SQL ServerT 2000 edition.
Operating System
Enterprise Edition
Standard Edition
Personal Edition
Developer Edition
Desktop Engine
SQL Server CE Enterprise Evaluation Edition
Microsoft Windows® 2000 DataCenter Supported Supported Supported
Supported Supported N/A Supported
Windows 2000 Advanced Server Supported Supported Supported Supported
Supported N/A Supported
Windows 2000 Server Supported Supported Supported Supported Supported
N/A Supported
Windows 2000 Professional N/A N/A Supported Supported Supported N/A
Supported
Microsoft Windows NT® 4.0 Server, Enterprise Edition Supported
Supported Supported Supported Supported N/A Supported
Windows NT 4.0 Server Supported Supported Supported Supported
Supported N/A Supported
Windows NT 4.0 Workstation N/A N/A Supported Supported Supported N/A
Supported
Microsoft Windows 98 N/A N/A Supported N/A Supported N/A N/A
Microsoft Windows CE N/A N/A N/A N/A N/A Supported N/A
Thanks
Hari
MCDBA
<anonymous@.discussions.microsoft.com> wrote in message
news:218d401c45ad1$5ccb0450$a401280a@.phx.gbl...
> Hi,
> Thanks for your reply.
> There is no SQLServerAgent or any similar service
> running. I only installed client tools because other
> options were grayed out and I got this error message:
> 'Microsoft SQL Server 2000 Standard Edition server
> component is not supported on this operating system. Only
> client components will be available for installation.'
> My operating system is windows 2000. I know that sql
> server was runing on this system and I uninstalled it. It
> seems that some Windows programs are deleted when I
> uninstalled the SQL Server for the first time. Do you
> know what should I check and what may be missing? I don't
> want to reinstall my operating system.
> Thank you,
> Rosie
> >--Original Message--
> >Hi,
> >
> >It seems you have removed SQL Server from your machine
> and installed only
> >client tools. In this case you will not
> >have the local sql server. The (local) server can only
> be registered if you
> >have a SQL server installed in the
> >local machine.
> >
> >Can you check the control -- Admin tools -- services for
> any MSSQLServer
> >service. If it is not there in the list then
> >you do not have a SQL Server installed in your machine.
> >
> >
> >--
> >Thanks
> >Hari
> >MCDBA
> ><anonymous@.discussions.microsoft.com> wrote in message
> >news:2164501c45a3b$be962de0$a001280a@.phx.gbl...
> >> Hi,
> >> I am using windows 2000. I uninstalled SQL server 2000
> >> and then reinstalled the client tools only. I deleted
> the
> >> (local) SQL Server registration. Now I have problem
> with
> >> adding it back. Even if I uninstall and reinstall the
> SQL
> >> server the (local) SQL Server registration doesn't show
> >> up.
> >> When I try adding (local) SQL Server registration I am
> >> getting this error:
> >>
> >> (LOCAL)- SQLServer does not exist or access denied.
> >>
> >> (local) is not showing up in my available servers list
> >> when I try to add a new SQL Server Registration.
> >>
> >> Does anybody know how can I add it back?
> >> Thank you.
> >>
> >> .
> >>
> >>
> >
> >
> >.
> >

Add user to Local Group Error

Guys,

I need help installing SQL Server 2005. I meet all of the pre-req's and setup seems to run normally until it starts installing the services and database engine. I receive the following error:

SQL Server Setup was unable add user NT AUTHORITY\NETWORK SERVICE to local group SQLSERVER2005DTSUser$server.

It repeats the error for for the other groups that are created with SQL install.

Am i missing something that's obvious? I couldn't find anything in the documentation or anywhere else.

Here are a couple of things to try:

1. Check the installation log files, located at %Program Files%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files for more details on the error.

2. Try to add the service manually to the local groups using the Computer Management Admin tool. Then re-run setup.

Paul

Add TCP/IP and named pipes protocls

Hi,
I have a trouble to connect to my local SQL Server 2005 instances.
I have noticed that "SQL Server Configuration Manager \ SQL Native Client
Configuration \ Client Protocols" is empty, I guest TCP/IP and named pipes
entries should exist !
How to add these protocols ?
Thank youHi
Have you enabled remote connections in the Surface Area Configuration tool?
John
"sauve mark" wrote:

> Hi,
> I have a trouble to connect to my local SQL Server 2005 instances.
> I have noticed that "SQL Server Configuration Manager \ SQL Native Client
> Configuration \ Client Protocols" is empty, I guest TCP/IP and named pipes
> entries should exist !
> How to add these protocols ?
> Thank you
>
>

Add TCP/IP and named pipes protocls

Hi,
I have a trouble to connect to my local SQL Server 2005 instances.
I have noticed that "SQL Server Configuration Manager \ SQL Native Client
Configuration \ Client Protocols" is empty, I guest TCP/IP and named pipes
entries should exist !
How to add these protocols ?
Thank youHi
Have you enabled remote connections in the Surface Area Configuration tool?
John
"sauve mark" wrote:
> Hi,
> I have a trouble to connect to my local SQL Server 2005 instances.
> I have noticed that "SQL Server Configuration Manager \ SQL Native Client
> Configuration \ Client Protocols" is empty, I guest TCP/IP and named pipes
> entries should exist !
> How to add these protocols ?
> Thank you
>
>

AD Domain Local Groups bug in RS ?

Hi,
I'm posting this problem for the third time. Still no answer from the MS
Team. I've found other users on the web having the same issue.
I have the following problem with AD an RS: when creating a group of users
as a "domain local group" in AD, i'm able to give a specific item-level role
in RS to members of this group. But it looks like rights are not effective
for those users. For example if the group is defined as "reader" on a folder,
group members can't see it in RS!
Everything works fine when the created group is a "global group" in AD.
Best Regards.
Greg.Hi all,
Is it a known bug ?
Thanx.
Greg.
"Greg - NEOS" wrote:
> Hi,
> I'm posting this problem for the third time. Still no answer from the MS
> Team. I've found other users on the web having the same issue.
> I have the following problem with AD an RS: when creating a group of users
> as a "domain local group" in AD, i'm able to give a specific item-level role
> in RS to members of this group. But it looks like rights are not effective
> for those users. For example if the group is defined as "reader" on a folder,
> group members can't see it in RS!
> Everything works fine when the created group is a "global group" in AD.
> Best Regards.
> Greg.
>|||Has someone already tested AD local groups in RS ?
Greg.
"Greg - NEOS" wrote:
> Hi all,
> Is it a known bug ?
> Thanx.
> Greg.
> "Greg - NEOS" wrote:
> > Hi,
> >
> > I'm posting this problem for the third time. Still no answer from the MS
> > Team. I've found other users on the web having the same issue.
> >
> > I have the following problem with AD an RS: when creating a group of users
> > as a "domain local group" in AD, i'm able to give a specific item-level role
> > in RS to members of this group. But it looks like rights are not effective
> > for those users. For example if the group is defined as "reader" on a folder,
> > group members can't see it in RS!
> >
> > Everything works fine when the created group is a "global group" in AD.
> >
> > Best Regards.
> > Greg.
> >

AD - SQL Service account - local or not?

Hi All,
I am looking for 'Best Practice' advise on how SQL Service accounts should b
e set up in an environment that contains many SQL 2000 Servers in an Active
Directory environment.
Is it a better practice to have the SQL Service (and SQL Agent services) run
off of Locally defined accounts (accounts defined on the SQL Server box its
elf) or AD/domain accounts? I can see how it would be a better security pol
icy to have each SQL Server
have locally defined service accounts as opposed to running off of domain/AD
accounts, but I am looking to see if there are any Best Practices advise on
this.If you do not need to access other servers on the network (like an exchange
server) then use a local account or the local system
Ray Higdon MCSE, MCDBA, CCNA
--
"DBA" <anonymous@.discussions.microsoft.com> wrote in message
news:92EC3F12-05F0-402A-8F93-01AC6113F7D6@.microsoft.com...
> Hi All,
> I am looking for 'Best Practice' advise on how SQL Service accounts should
be set up in an environment that contains many SQL 2000 Servers in an Active
Directory environment.
> Is it a better practice to have the SQL Service (and SQL Agent services)
run off of Locally defined accounts (accounts defined on the SQL Server box
itself) or AD/domain accounts? I can see how it would be a better security
policy to have each SQL Server have locally defined service accounts as
opposed to running off of domain/AD accounts, but I am looking to see if
there are any Best Practices advise on this.
>
>|||Also, if you are using virtual SQL Servers the startup account has to be
domain account.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Microsoft SQL Server 2000 SP3 Security Features and Best Practices
http://www.microsoft.com/technet/pr...n/sp3sec00.mspx
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.