On Aug 17, 9:57 pm, "William Vaughn" <billvaNoS...@betav.com> wrote:
> Check out the whitepaper on connecting on my blog. It has helped any numb=
er
> of people with similar questions about SQL Express. I suspect you have not
> setup rights to the initial catalog for the specific user or his/her grou=
p=2E
>
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant, Dad, Grandpa
> Microsoft MVP
> INETA Speaker
www.betav.comwww.betav.com/blog/billva
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no right=
s=2E
> __________________________________
> Visit
www.hitchhikerguides.netto get more information on my latest book:
> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
> -------------------------------------------------------------------------=
--=AD--------------------------------------------
>
> <phil.dewhu...@rogers.com> wrote in message
>
> news:1187397421.030444.86050@a39g2000hsc.googlegroups.com...
>
>
>
> > Hi
>
> > I have installed SQL Express with advanced services and all the toys
> > on 2 machines. A desktop and a laptop intending to use the desktop as
> > a "server". I followed instructions to enable the server installation
> > for remote connection by enabling TCP and the browser.
>
> > Using SQL Server manager from the laptop I can navigate and find the
> > SQL Express instance on the desktop but whe I try to connect using
> > Windows Authentication I get the following error
>
> > <Login failed for user ''. The user is not associated with a trusted
> > SQL Server connection. (Microsoft SQL Server, Error: 18452)>
>
> > I have successfully connected from the desktop using windows
> > authentication.
> > I have successfully connected from the laptop using SQL Authentication
> > so I think that the problem is not with the network settings of the
> > server rather with the way that the windows authentication is being
> > passed (or not) from the laptop to the desktop.
>
> > Any ideas?
>
> > Phil- Hide quoted text -
>
> - Show quoted text -
Thankyou for the link to your blog. I read the connection paper.
I have not found the silver bullet yet. I can't find anything
obviously wrong. Do I need to have IIS installed and running on the