Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cant connect to my new sqlserver 2005 (SSPI context)
Message
 
 
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:
01310184
Views:
13
You assign sa password when you install SQL Server. It sound like you install it in Windows Authentication mode.

>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?
>
>
>HELP!
>
>thanks
>
>Peter
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform