provider list empty

23 Dec 2006 9:40 AM

PBsoft

I have two PCs with "SQL 2005 Express with Advanced Services" and "SQL Server
Management Studio Express" installed.

If I run SSMS on both PCs and navigate to "\Server Objects\Linked Servers\Providers"
I find an empty list.
While I know this is not regular, I don't know how solve it.

I obviously tried to reinstall SQL 2005 and also .NET framework 2.0, but
didn't solve.

Can you help me?

--
PBsoft di Gabriele Bertolucci
www.pbsoft.it
skype:pbsoftsolution

23 Dec 2006 11:56 AM

John Bell

Hi

Have you tried creating a loopback linked server

EXEC master.dbo.sp_addlinkedserver @server = 'LoopBackExpress',
            @srvproduct='',
            @provider = 'SQLNCLI',
        @datasrc=N'.\SQLExpress'
GO

What does the MDAC component checker report?

John

Show quoteHide quote

"PBsoft" wrote:

> I have two PCs with "SQL 2005 Express with Advanced Services" and "SQL Server
> Management Studio Express" installed.
>
> If I run SSMS on both PCs and navigate to "\Server Objects\Linked Servers\Providers"
> I find an empty list.
> While I know this is not regular, I don't know how solve it.
>
> I obviously tried to reinstall SQL 2005 and also .NET framework 2.0, but
> didn't solve.
>
> Can you help me?
>
> --
> PBsoft di Gabriele Bertolucci
> www.pbsoft.it
> skype:pbsoftsolution
>
>
>

Thread options