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 09:50:36
 
 
To
12/04/2008 09:37:03
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01310168
Message ID:
01310169
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform