«

Hi,

installed Windows 7 last weekend. The client is not member in a domain.
Installed SQL 2008 (DEV). SQL-Server is running fine (it seems) on local
machine.

Tried to connect at customer-side to their SQL 2008 (OS: Windows Server
200 via my SSMS with Integrated Security
=> "Login failed. The login is from an untrusted domain and cannot be used
with Windows authentication. (Microsoft SQL Server, Error: 18452)"

Tried to connect at customer-side to their SQL 2005 (OS: Windows Server
2003) via my SSMS with Integrated Security
=> "Login failed for user ''. Reason: Not associated with a trusted SQL
Server connection."

I know these (esp. the last) messages are due to not being authenticated
within the domain.

BTW: both SQL-Servers have entries in Application Eventlog "SSPI handshake
failed with error code 0x8009030c while establishing a connection with
integrated security; the connection has been closed. [CLIENT: <ipadress>]"


Previously with Windows XP I opened Windows Explorer, connected to a share
on the SQL-Server-Computer (supplied and saved my customer credentials).
After that I was able to connect to SQL 2005 and SQL 2008 via my SSMS with
Integrated Security successful.

Tried this "workaround" on Windows 7 also, but without success.

Any ideas what security settings are blocking me?

Any hint greatly appreciated.

---
Martin

Seems I'm not alone...

Found a workaround here:
http://www.jasonfollas.com/wiki/(X(1...ookieSupport=1


--
---
Martin Knauer

"Martin Knauer" <> wrote in message
news:udzdXZw$...
> Hi,
>
> installed Windows 7 last weekend. The client is not member in a domain.
> Installed SQL 2008 (DEV). SQL-Server is running fine (it seems) on local
> machine.
>
> Tried to connect at customer-side to their SQL 2008 (OS: Windows Server
> 200 via my SSMS with Integrated Security
> => "Login failed. The login is from an untrusted domain and cannot be used
> with Windows authentication. (Microsoft SQL Server, Error: 18452)"
>
> Tried to connect at customer-side to their SQL 2005 (OS: Windows Server
> 2003) via my SSMS with Integrated Security
> => "Login failed for user ''. Reason: Not associated with a trusted SQL
> Server connection."
>
> I know these (esp. the last) messages are due to not being authenticated
> within the domain.
>
> BTW: both SQL-Servers have entries in Application Eventlog "SSPI handshake
> failed with error code 0x8009030c while establishing a connection with
> integrated security; the connection has been closed. [CLIENT: <ipadress>]"
>
>
> Previously with Windows XP I opened Windows Explorer, connected to a share
> on the SQL-Server-Computer (supplied and saved my customer credentials).
> After that I was able to connect to SQL 2005 and SQL 2008 via my SSMS with
> Integrated Security successful.
>
> Tried this "workaround" on Windows 7 also, but without success.
>
> Any ideas what security settings are blocking me?
>
> Any hint greatly appreciated.
>
> ---
> Martin