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 11:31:43
 
 
To
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:
01310177
Views:
13
>>>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

Three suggestions to try:
1. The 'greyed-out' User name and password you see are SQLServer login credentials(which you must have used at some point?) Try just switching to SQL Server Authentication and using those existing values.

2. The problem may be to do with identifying the machine rather than with the windows login. You could try using the IP address instead for the server name.

3. Leave it till Monday - go to the pub instead <g>
Regards,
Viv
Previous
Reply
Map
View

Click here to load this message in the networking platform