Database import and access problems

[AbdullahN]

Hi,

I am using ParaPlesk 9.5 (as a client). I created an MS SQL database from the Panel's Database options (New Database). I also created a user with a valid password.

But when I try to use WebAdmin to import a local DB (created on MS SQL 2000) it just redirects to a "page not found" page - http://mssql.[hostname].com/mla2005/silentlogon.aspx. Why does this happen?

I then used http://mssql.[hostname].com which worked.

What I need to know is that if it possible to access my database using SQL Mgmt Studio, if yes what exactly will be the Server Name?

Thanks

 

[IgorG]

Try this:

Start > Run > type cmd

cd %plesk_bin%
websrvmng.exe --reconfigure-sqladmin
defpackagemng.exe --fix --type=sqladminmssql

 

[ZoranV]

Same problem

Windows Server 2008 R2 Standard - Plesk 9.5.3

In order to have access I've did the above commands and mssql is accessible through mssql.domain.com
The problem is, soon as I restart the server i have to enter every time again the same commands.

Any solution ?

Zoran