March 25, 2010 at 7:40 am
I recently installed a vanilla sql server 2008 express instance on my computer. I can connect to it using SQL Server Management Studio without issue. However, if I try to connect to the database using "sqlcmd -S .\sqlexpress" I get the error: HResult 0x80090304, Level 16, State 1 SQL Server Network Interfaces: The Local Security Authority cannot be contacted Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : Cannot generate SSPI context.
Even though I'm not trying to connect via any network (this is all on a single machine, with me running an administrator account under XP/SP3), I have enabled all of the remote protocols for this instance and restarted the SQL browser and the database engine. I have seen this same question asked a number of times and not answered.
Nothing shows up in any of the system logs.
Thoughts?
March 25, 2010 at 12:24 pm
The middle reference resolved my issue, thanks. It's a combination of working from a machine that belongs to a domain and not being connected to that domain. Several work-arounds are presented in that document. Thanks.
March 25, 2010 at 12:26 pm
Interesting. I swapped the order of the first two thinking it was more likely - ah well - glad to hear you have it sorted out now.
Thanks!
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply