all groups > sql server connect > august 2007 >
You're in the

sql server connect

group:

Can't connect to SQL Express using Windows Authentication


Can't connect to SQL Express using Windows Authentication phil.dewhurst NO[at]SPAM rogers.com
8/17/2007 5:37:01 PM
sql server connect:
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
Re: Can't connect to SQL Express using Windows Authentication William Vaughn
8/17/2007 6:57:21 PM
Check out the whitepaper on connecting on my blog. It has helped any number
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 group.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.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 rights.
__________________________________
Visit www.hitchhikerguides.net to 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)
-----------------------------------------------------------------------------------------------------------------------

[quoted text, click to view]
Re: Can't connect to SQL Express using Windows Authentication phil.dewhurst NO[at]SPAM rogers.com
8/18/2007 4:54:43 PM
[quoted text, click to view]

William

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
"server"?

Phil
AddThis Social Bookmark Button