Friday, February 24, 2012

Can't connect to SS2005

Hello,
I had SS2K running on my local machine (everything worked). Then I
installed SS2005 and was able to connect the server running locally. Once I
uninstalled SQL Server 2000, I was unable to connect. Even if I try to
create a new registration, I get the error that I can't connect to the
server. Any help with this would be greatly appreciated.
--
Thanks in advance,
sck10Hello,
It seems issues in client tools. You may want to check "sql server browser"
service is started. Also, please remove/reinstall SQL tools via Add/Remove
programs to test the situation.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
>From: "sck10" <sck10@.online.nospam>
>Subject: Can't connect to SS2005
>Date: Wed, 8 Feb 2006 10:05:31 -0600
>Lines: 14
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
>Message-ID: <#e309lMLGHA.2392@.TK2MSFTNGP09.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 11.202.185.135.in-addr.arpa 135.185.202.11
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:420451
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hello,
>I had SS2K running on my local machine (everything worked). Then I
>installed SS2005 and was able to connect the server running locally. Once
I
>uninstalled SQL Server 2000, I was unable to connect. Even if I try to
>create a new registration, I get the error that I can't connect to the
>server. Any help with this would be greatly appreciated.
>--
>Thanks in advance,
>sck10
>
>|||Hello Peter,
I re-installed SS2005, but I am still unable to create a new registration on
my local machine. I first went to the SQL Server Browser service, but there
were no devices to turn off or on. I then went to the Surface Area
Configurator, but received the following error. I am the administrator for
this machine (Windows XP Pro).
TITLE: Surface Area Configuration
--
No SQL Server 2005 components were found on the specified computer. Either
no components are installed, or you are not an administrator on this
computer. (SQLSAC)
--
Thanks in advance,
sck10
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl...
> Hello,
> It seems issues in client tools. You may want to check "sql server
browser"
> service is started. Also, please remove/reinstall SQL tools via Add/Remove
> programs to test the situation.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> --
> >From: "sck10" <sck10@.online.nospam>
> >Hello,
> >
> >I had SS2K running on my local machine (everything worked). Then I
> >installed SS2005 and was able to connect the server running locally.
Once
> I
> >uninstalled SQL Server 2000, I was unable to connect. Even if I try to
> >create a new registration, I get the error that I can't connect to the
> >server. Any help with this would be greatly appreciated.
> >
> >--
> >Thanks in advance,
> >
> >sck10|||Hello,
It seems there are permission issues for admin users on this machine,
please try the following command to reset permission on this machine to
test.
secedit /configure /cfg %windir%\repair\secsetup.inf /db secsetup.sdb
/verbose
Also, you may want to log on a different admin to test.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
>From: "sck10" <sck10@.online.nospam>
>References: <#e309lMLGHA.2392@.TK2MSFTNGP09.phx.gbl>
<5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl>
>Subject: Re: Can't connect to SS2005
>Date: Thu, 9 Feb 2006 08:57:01 -0600
>Lines: 56
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
>Message-ID: <OivfWkYLGHA.3060@.TK2MSFTNGP10.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 11.202.185.135.in-addr.arpa 135.185.202.11
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:420554
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hello Peter,
>I re-installed SS2005, but I am still unable to create a new registration
on
>my local machine. I first went to the SQL Server Browser service, but
there
>were no devices to turn off or on. I then went to the Surface Area
>Configurator, but received the following error. I am the administrator for
>this machine (Windows XP Pro).
>TITLE: Surface Area Configuration
>--
>No SQL Server 2005 components were found on the specified computer. Either
>no components are installed, or you are not an administrator on this
>computer. (SQLSAC)
>--
>Thanks in advance,
>sck10
>
>"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
>news:5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl...
>> Hello,
>> It seems issues in client tools. You may want to check "sql server
>browser"
>> service is started. Also, please remove/reinstall SQL tools via
Add/Remove
>> programs to test the situation.
>> Best Regards,
>> Peter Yang
>> MCSE2000/2003, MCSA, MCDBA
>> Microsoft Online Partner Support
>> When responding to posts, please "Reply to Group" via your newsreader so
>> that others may learn and benefit from your issue.
>> --
>> >From: "sck10" <sck10@.online.nospam>
>> >Hello,
>> >
>> >I had SS2K running on my local machine (everything worked). Then I
>> >installed SS2005 and was able to connect the server running locally.
>Once
>> I
>> >uninstalled SQL Server 2000, I was unable to connect. Even if I try to
>> >create a new registration, I get the error that I can't connect to the
>> >server. Any help with this would be greatly appreciated.
>> >
>> >--
>> >Thanks in advance,
>> >
>> >sck10
>
>

No comments:

Post a Comment