Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Computing > Windows 64bit > Win7 & (SQL2005 / SQL2008) Integrated Security issue / across domains

Reply
Thread Tools

Win7 & (SQL2005 / SQL2008) Integrated Security issue / across domains

 
 
Martin Knauer
Guest
Posts: n/a
 
      07-07-2009

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

 
Reply With Quote
 
 
 
 
Martin Knauer
Guest
Posts: n/a
 
      07-07-2009

Seems I'm not alone...

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


--
---
Martin Knauer

"Martin Knauer" <(E-Mail Removed)> wrote in message
news:udzdXZw$(E-Mail Removed)...
> 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


 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Win7 Pro x64 dies with BSOD on my toshiba laptop (Win7 Retail/RTM) Warren Postma Windows 64bit 6 11-20-2009 11:23 PM
Integrated Security Issue Ross Culver ASP .Net 10 03-07-2008 06:25 PM
using integrated windows authentication across 2 domains Dica ASP .Net 0 04-16-2007 06:41 PM
Integrated Windows Authentication for Multiple Domains Jacksm ASP .Net 1 11-13-2006 12:51 PM
Signals across two clock domains Weng Tianxiang VHDL 9 12-22-2003 09:36 PM



Advertisments