Any Idea How to integrate MS SQL Server in Plesk 11

[OgilvyO]

Hi,

Any one have an idea how to integrate MS SQL Server 2008 R2 Web Server, 64-bit with Plesk Control. Currently in Plesk Control Database Server->Add Server is showing only MySQL.

Any once can guide me how to update license key and enable ms sql server option in plesk control.

Regards,
Qainan Idris.

 

[IgorG]

Have you read this doc? http://download1.parallels.com/Plesk/PP11/11.0/Doc/en-US/online/plesk-administrator-guide/59428.htm

 

[UmairQ]

MS SQL connection issue.

Have you read this doc? http://download1.parallels.com/Plesk/PP11/11.0/Doc/en-US/online/plesk-administrator-guide/59428.htm

Keep this following error when adding MS SQL Server.


Error: Test connection to the database server has failed because of network problems:

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

 

[IgorG]

Are you sure that "Administrator" is correct MSSQL server admin's username?

 

[Andrei C]

Hello UmairQ,

Could you tell me, what kind of Authentication type using?
-SQL Authentication
-Windows Authentication

 

[UmairQ]

Thanks for your reply.

Uninstalled all my SQL express components
Renamed User.config file , [USER_NAME]\AppData\Local\Microsoft_Corporation\LandingPage.exe_StrongName_ryspccglaxmt4nhllj5z3thycltsvyyx\10.0.0.0 TO USER.CONFIG.BAK
fresh installation of the MS SQL Express 2008 R2.
No errors in installations.

Windows Authentication
And I uses , Administrator/password.
also tried sa/ Administrator password.

Management studio connect to database using windows auth Administrator/password

It is a 1and1 dedicated server.


Please help

 

[Andrei C]

Dear Support,

Could you tell me, if Plesk Panel support Windows Authentication? I try only SQL Authentication, and it's work perfectly.
But Windows Authentication not working for me.

-----------------------------
Hello UmairQ,

Could you tell me, if you using only Windows Authentication mode on MSSQL Server?

Maybe can help next solution.
Try use SQL and Windows Authentication mode as you can see on picture.
http://blogs.technet.com/cfs-file.a...ip_5F00_image004_5F00_thumb_5F00_5FD79448.jpg
and use "sa" account.

 

[UmairQ]

did that , but I dont know my sa password.

tried windows admin password with "sa" , still the same.

tried resting sa password using osql command , but native client time out error.

 

[Andrei C]

by default "sa" account is disabled. Maybe need to enable this account?

did that , but I dont know my sa password.

tried windows admin password with "sa" , still the same.

tried resting sa password using osql command , but native client time out error.

 

[UmairQ]

enabled sa , still the same.

Uninstalled SQL R2 , restarted the server.
reinstalled SQL R2 with both authentications

sa login work to connect in Management studio but plesk 11 is still coming up with the same error.

Error: Test connection to the database server has failed because of network problems:

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.


sick and tired ......

Pls help..

 

[Andrei C]

Try this http://kb.parallels.com/en/3771

enabled sa , still the same.

Uninstalled SQL R2 , restarted the server.
reinstalled SQL R2 with both authentications

sa login work to connect in Management studio but plesk 11 is still coming up with the same error.

Error: Test connection to the database server has failed because of network problems:

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.


sick and tired ......

Pls help..

 

[UmairQ]

Try this http://kb.parallels.com/en/3771

This article is for Parallels Helm 3, not for plesk 11.