MS SQL Server - Can't connect to SS2005

Author

Can't connect to SS2005

sck10

2006-02-08, 11:23 am

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

Peter Yang [MSFT]

2006-02-09, 3:23 am

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.

====================
====================
=============

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
>
>
>

sck10

2006-02-09, 9:23 am

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.
[color=darkred]
> --------------------
Once[color=darkred]
> I

Peter Yang [MSFT]

2006-02-10, 3:23 am

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\secs
etup.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...
>browser"
Add/ Remove[color=darkred
]
>
>Once
>
>
>

Sponsored Links