| Author |
Topic |
|
imughal
Posting Yak Master
192 Posts |
 Posted - 2007-07-27 : 07:30:40
|
| i am configuring single sign on services on sharepoint portal server 2003. I am logged as domain administrative account and this account is part of STS_WPG and SPS_WPG group. Sharepoint portal 2003 and SQL Server 2000.on single sign on services i have assigned domain account to start services.when i try to configure single sign on from sharepoint central adminsitration i am getting following error message.An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)kindly help me out how to fix this error and configure single sign on |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-28 : 00:27:27
|
| Which version of sql do you really use? For sql2k5, ensure sql server browser service is running on sql server. |
 |
|
|
imughal
Posting Yak Master
192 Posts |
Posted - 2007-07-28 : 00:34:08
|
| i am using SQL Server 2000. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-28 : 00:42:37
|
| But you got sql2k5 error message, how? |
|
|
|
imughal
Posting Yak Master
192 Posts |
Posted - 2007-07-30 : 00:07:41
|
| i am also surprised why i am getting SQL 2005. i am working on sharepoint single signon. Sharepoint 2003 and SQL Server 2000. when i am configuring single sign on i am getting error message.how i fix it. any idea.thanks |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-30 : 23:19:18
|
| What's sql service name in services applet? |
|
|
|
imughal
Posting Yak Master
192 Posts |
Posted - 2007-07-31 : 00:38:05
|
| for which service name are you asking. when i configure single signon and used sharepoint wizrad it just ask me the database name and user name password. when i click to next it give me mentioned error.any solution. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-31 : 23:17:54
|
| Should have sql service if uses sql server. |
|
|
|
imughal
Posting Yak Master
192 Posts |
Posted - 2007-08-02 : 00:11:44
|
| Services name running on SQL Server 2000 is sqlservr.exe i got it feom services.what to do. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-02 : 23:43:46
|
| That's program name. Service name should something like 'sql server (mssqlserver)'. |
|
|
|
imughal
Posting Yak Master
192 Posts |
Posted - 2007-08-03 : 00:27:08
|
| Display name : MSSQL$KCIPORTALDB |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-03 : 11:39:23
|
| It's sql2k named instance. Double check sharepoint configuration to ensure it goes to correct sql server. |
|
|
|
|
An error has occurred while establishing a connect