A
aSoundMind
Hi Guys,
I am having problem in adding project server user using forms
authentication. The error is "unable to connect to sql server
database". I have checked on similar posting in this project server
group
http://groups.google.com/group/micr...e+to+connect+to+sql+database#b40aceb3dba03108
He fixed his problem by changing the 127.0.0.1 into the computer
\Project but the solution does not work for me. (Not sure if I am
following it correctly)
I was also assuming that maybe windows authentication mode is the
cause of the problem, so I tried the sql user authentication mode by
providing the username and password. This method also does not work.
Everything is installed in a single server
Details:
Server name : Synergy-svr01
Database instance : Synergy-svr01
Database : SQL Server 2005
Project Server : Project Server 2007
Based on http://technet2.microsoft.com/Offic...56f7-4399-ad28-15ac35e8723d1033.mspx?mfr=true
article, I did these steps :
1. I created "aspnetdb" database using cmd
C\Microsoft.NET\Framework\v2.0.50727\aspnet_regsql.exe -A m -E
2. aspnetdb Database was created successfuly, Next is extending web
application
I use http://synergy-svr01, port 80
The options selected for extending web application was :
- Create a new iis website. In the description I put "Sharepoint Form
Authentication"
- Port : 7
- Path : C:\Inetpub\wwwroot\wss\VirtualDirectories\77
- Authentication Provider : NTLM
- Allow Anonymous : No
- Use SSL : No
- URL : http://synergy-svr01:77/
- Zone : Intranet
3. On authentication provider,
I select :
- Intranet
- Windows
- Form Authentication
- Name : AspNetSqlMembershipProvider
4. Adding sqlmembership provider to the web.config file
- Open Inetmgr, expand the websites, then sharepoint form
authentication
- Modify the web.config
Added this xml part
<connectionStrings>
<remove name="synergy-svr01" />
<add name="synergy-svr01" connectionString="data source=synergy-
svr01\synergy-svr01;Integrated Security=SSPI;Initial
Catalog=aspnetdb" />
</connectionStrings>
NOTE-: At this point, I also tried to modify the datasource to these
and NONE of them works
a) data source=synergy-svr01
b) data source=127.0.0.1
c) data source=localhost
5. Configuring the users.xml for new users
- on cmd, I type
PjFormsAuthUpgrade.exe -createemptyusersfile -log c:\forms.log -url
http://synergy-svr01/pwa -usersfile users.xml
At this point, form.log is created on C:\ and users.xml is created on
C:\Program Files\Microsoft Office Servers\12.0\Bin
The content of users.xml was this
<?xml version="1.0"?>
<Users xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://
schemas.microsoft.com/Project/Users.xsd">
Noticing the differences with the sample, I added my own xml to become
like this
<?xml version="1.0"?>
<Users xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://
schemas.microsoft.com/Project/Users.xsd">
<CreateUser>
<DisplayName>Muliadi Jack</DisplayName>
<EmailAddr>[email protected]</EmailAddr>
<LogonName>MuliadiJack</LogonName>
<Password>pass@word1</Password>
<Guid>3313798b-9da0-4601-bd42-6ad306749e9e</Guid>
<PasswordQuestion>Password Question</PasswordQuestion>
<PasswordAnswer>Password Answer</PasswordAnswer>
</CreateUser>
<UpdateUser>
<DisplayName>Display Name</DisplayName>
<EmailAddr>[email protected]</EmailAddr>
<LogonName>LogonName</LogonName>
<Password>pass@word1</Password>
<Guid>a3b5f0c5-3a93-4f80-a655-948ba1d6e4af</Guid>
<PasswordQuestion>Password Question</PasswordQuestion>
<PasswordAnswer>Password Answer</PasswordAnswer>
</UpdateUser>
</Users>
NOTE: I am not sure about the GUID, the GUID above is just pasting
from the technet article.
6. Import the user data into the membership store (this is the part
where I encounter the problem)
- Open cmd, and entered PjFormsAuthUpgrade.exe -log c:\forms.log -url
http://synergy-svr01/pwa -usersfile users.xml
After this I keep on getting the error of
Error: An error occured creating user MuliadiJack
in the membership provider.
Error: Unable to connect to SQL Server database
Error: Failed to add user Muliadi Jack in the membership store.
Error: An error occured creating user LogonName in membership provider
Error: Unable to connect to SQL Server database
Error: Failed to add user Logonname in the Membership store
I am having problem in adding project server user using forms
authentication. The error is "unable to connect to sql server
database". I have checked on similar posting in this project server
group
http://groups.google.com/group/micr...e+to+connect+to+sql+database#b40aceb3dba03108
He fixed his problem by changing the 127.0.0.1 into the computer
\Project but the solution does not work for me. (Not sure if I am
following it correctly)
I was also assuming that maybe windows authentication mode is the
cause of the problem, so I tried the sql user authentication mode by
providing the username and password. This method also does not work.
Everything is installed in a single server
Details:
Server name : Synergy-svr01
Database instance : Synergy-svr01
Database : SQL Server 2005
Project Server : Project Server 2007
Based on http://technet2.microsoft.com/Offic...56f7-4399-ad28-15ac35e8723d1033.mspx?mfr=true
article, I did these steps :
1. I created "aspnetdb" database using cmd
C\Microsoft.NET\Framework\v2.0.50727\aspnet_regsql.exe -A m -E
2. aspnetdb Database was created successfuly, Next is extending web
application
I use http://synergy-svr01, port 80
The options selected for extending web application was :
- Create a new iis website. In the description I put "Sharepoint Form
Authentication"
- Port : 7
- Path : C:\Inetpub\wwwroot\wss\VirtualDirectories\77
- Authentication Provider : NTLM
- Allow Anonymous : No
- Use SSL : No
- URL : http://synergy-svr01:77/
- Zone : Intranet
3. On authentication provider,
I select :
- Intranet
- Windows
- Form Authentication
- Name : AspNetSqlMembershipProvider
4. Adding sqlmembership provider to the web.config file
- Open Inetmgr, expand the websites, then sharepoint form
authentication
- Modify the web.config
Added this xml part
<connectionStrings>
<remove name="synergy-svr01" />
<add name="synergy-svr01" connectionString="data source=synergy-
svr01\synergy-svr01;Integrated Security=SSPI;Initial
Catalog=aspnetdb" />
</connectionStrings>
NOTE-: At this point, I also tried to modify the datasource to these
and NONE of them works
a) data source=synergy-svr01
b) data source=127.0.0.1
c) data source=localhost
5. Configuring the users.xml for new users
- on cmd, I type
PjFormsAuthUpgrade.exe -createemptyusersfile -log c:\forms.log -url
http://synergy-svr01/pwa -usersfile users.xml
At this point, form.log is created on C:\ and users.xml is created on
C:\Program Files\Microsoft Office Servers\12.0\Bin
The content of users.xml was this
<?xml version="1.0"?>
<Users xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://
schemas.microsoft.com/Project/Users.xsd">
Noticing the differences with the sample, I added my own xml to become
like this
<?xml version="1.0"?>
<Users xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://
schemas.microsoft.com/Project/Users.xsd">
<CreateUser>
<DisplayName>Muliadi Jack</DisplayName>
<EmailAddr>[email protected]</EmailAddr>
<LogonName>MuliadiJack</LogonName>
<Password>pass@word1</Password>
<Guid>3313798b-9da0-4601-bd42-6ad306749e9e</Guid>
<PasswordQuestion>Password Question</PasswordQuestion>
<PasswordAnswer>Password Answer</PasswordAnswer>
</CreateUser>
<UpdateUser>
<DisplayName>Display Name</DisplayName>
<EmailAddr>[email protected]</EmailAddr>
<LogonName>LogonName</LogonName>
<Password>pass@word1</Password>
<Guid>a3b5f0c5-3a93-4f80-a655-948ba1d6e4af</Guid>
<PasswordQuestion>Password Question</PasswordQuestion>
<PasswordAnswer>Password Answer</PasswordAnswer>
</UpdateUser>
</Users>
NOTE: I am not sure about the GUID, the GUID above is just pasting
from the technet article.
6. Import the user data into the membership store (this is the part
where I encounter the problem)
- Open cmd, and entered PjFormsAuthUpgrade.exe -log c:\forms.log -url
http://synergy-svr01/pwa -usersfile users.xml
After this I keep on getting the error of
Error: An error occured creating user MuliadiJack
in the membership provider.
Error: Unable to connect to SQL Server database
Error: Failed to add user Muliadi Jack in the membership store.
Error: An error occured creating user LogonName in membership provider
Error: Unable to connect to SQL Server database
Error: Failed to add user Logonname in the Membership store