Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Cant connect to my new sqlserver 2005 (SSPI context)
Message
 
 
À
12/04/2008 09:37:03
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01310168
Message ID:
01310184
Vues:
14
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--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform