Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Setting Up SSO Portal 2003 (UNCLASSIFIED)

  Asked By: Tapasvi    Date: May 22    Category: Sharepoint    Views: 756

I am attempting to configure SSO on my SP Portal 2003 server with MS SQL
2000 on a separate server. I have set the Microsoft Single Sign On Service
started and using a service account. I also created a database manually
called SSO. My service account has full Admin privileges on the database
server and also in SQL itself. But I am receiving the error message:

Login failed for user ('null'). Reason: Not associated with a trusted SQL
Server connection.

My ODBC connection tests successfully and I have the SQL Tools, Enterprise
Manager installed on the server with a SQL Registration to my database
server that gives me no errors.

Also I am logging into the machine with the same account that I am using for
SSO

Share: 

 

5 Answers Found

 
Answer #1    Answered By: Elisa Santos     Answered On: May 22

Right click your DB instance, go to Properties - Security and select SQL
Server and Windows Authentication mode.

 
Answer #2    Answered By: Tatiana Houston     Answered On: May 22

Also I would like to add that I have also turned off "Integrated Windows
authentication" and left "Basic Authentication" enabled while attempting
this configuration.

 
Answer #3    Answered By: Selena Glenn     Answered On: May 22

I have SQL and Windows Authentication Mode set. :-( That was the first thing
I looked at too.

 
Answer #4    Answered By: Jolene Sandoval     Answered On: May 22

Is it possible to create a link to a colleague in mysite if they have not
created a mysite yet?

 
Answer #5    Answered By: Caleb Gordon     Answered On: May 22

If you talking about MOSS 2007 now then I may have an answer for you. The
colleagues section of my site seems to begin populating once you have
imported users from your AD. If you haven't done that then i think they
have to create a my site before you can link to them.

 
Didn't find what you were looking for? Find more on Setting Up SSO Portal 2003 (UNCLASSIFIED) Or get search suggestion and latest updates.




Tagged: