Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cant connect to my new sqlserver 2005 (SSPI context)
Message
From
12/04/2008 10:17:42
 
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01310168
Message ID:
01310171
Views:
15
>>I just installed SS2005 yesterday on my laptop which belongs to a domain. I was connected to the domain at the time.
>>Now I am at home, away from the domain. NAd I cannot connect to the server local / OTT-LT0769 (the name of my laptop) anymore.
>>I get this error:
>>
>>
>>'TITLE: Connect to Server
>>------------------------------
>>
>>Cannot connect to OTT-LT0769.
>>
>>------------------------------
>>ADDITIONAL INFORMATION:
>>
>>Cannot generate SSPI context. (Microsoft SQL Server, Error: 0)
>>
>>For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=0&LinkId=20476
>>
>>------------------------------
>>BUTTONS:
>>
>>OK
>>------------------------------
>>
>>
>>
>>I google this but cannot make any sese out of any responses.
>>I just think it has to do with the security.
>>
>>the loginscreen has this info:
>>Server type: Database engine
>>Server name: OTT-LT0769
>>Authentication: Windows Authentication
>> grayed out: User name: CortielP
>> grayed out: Password: 'blank'
>> grayed out: Remember password

>>
>>if I switch to sql serve authentication, what is the defaul user and password?
>
>Used to be 'sa' and no password. Not sure if that still applies though.
>HTH,
>Viv

nope, does not help
Peter Cortiel
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform