MSSQL 2005 Express on 8.2

[DjFarout]

Can you have SQL Server 8.00.194 and have MSSQL 2005 Express on the server at the same time?

 

[sergius]

Yep, MSSQL supports multiple instances since version 2000.
You can integrate these instances with Plesk.
You should go to Plesk > Database Servers > Microoft SQL Server and add instance.

 

[hamed23100]

i have done all but ...

Hi,

i have tried to do same but i cant.

I have a question what is the default user name and password for SQLExpress
I get the following 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.

 

[sergius]

Re: i have done all but ...

Originally posted by hamed23100
Hi,

i have tried to do same but i cant.

I have a question what is the default user name and password for SQLExpress
I get the following 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.

There is not "the default user name and password for SQLExpress".
By default SQL Express is installed with "Windows Authentication" only.
However Plesk requires (by some reasons but we will fix it in future versions) yet "SQL Authentication".
You should switch SQL Express to "Mixed mode" and specify password for "sa".
Next you can use "sa" with known password in Plesk.

 

[hamed23100]

how cani change it

Hi,

I dont know how can i change to mixed mode, Can you please tell me that?

Regards,
Hamed

 

[DjFarout]

-Load SQL Server Management Studio Express
-Login with the default user
-Right click on the Server -> Properties
-Under "Select a page" goto Security.
-Server Authentication, select "SQL Server and Windows Authentication mode"
-OK, out of it all and your done. (wouldn't hurt to restart the services)

 

[hamed23100]

not yet connected

Hi,

I have done all you said but still while i want to add SQLEXPRESS i get the following 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."

How can i solve it?

 

[zuerner]

Hi,


i have the same Error on the installation.

Mixed Modus are active. But when i enter the Login Data it dosn't work.
Error msg:

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

How can i fix the Problem?

 

[sergius]

Please look at http://kb.swsoft.com/en/1120

We recommend you to use SWsoft Knowledgebase for solving issues.

 

[somnath]

SQLExpress needs the server name as "computername\instancename". You can get this by opening Management Studio on the server. It will show you the name of the server to connect.

 

[JackL]

Use SQL Server configuration manager to enable TCP protocols (at least on 127.0.0.1)
http://msdn2.microsoft.com/en-us/library/ms174212.aspx

John S.G.