Where will i have to install ms sql?

[pepsyxanh]

After i remove msde, i install ms sql standart edition but i don't know where are the paths for install ms sql. In my computer have two path for that C:\website\mssql\data and C:\Program files\swsoft\Plesk\MSDE\MSSQL. Where will i have to config paths when i install ms sql for plesk know and run ms sql correct.
Please help me
Thanks!

 

[AbsolutelyFreeW]

I've heard you can "upgrade" msde to sqlserver.. not uninstall/install it.

the data path is for data I believe, so your real mssql should be the other..

 

[pepsyxanh]

I never success for that. If any know how to config it run correct please tell me.
Thanks

 

[cviviani]

Standard Path is "C:\Program Files\Microsoft SQL Server"

Set - sql and windows - Authentication

give to "SA" (SystemAdministrator) the same password as with plesk admin logon

mssql or mysql does not depend on the path

mfg Claudius Viviani

 

[pepsyxanh]

I use SQL Server Enterprise from client and connect to SQL SERVER but i get error "SQL server does not exist or access denied ConnectionOpen(Connect())"
anyone know please help me
Thanks

 

[cviviani]

I hope the sql the servers run on the same maschiene as plesk.
did you only install client tools?
does the SQL Server service run?

when ok
start under Programms>Microsoft SQL Server> SQL Query Analyzer and try to logon on our SQL Server with "sa"

can you logon successfully ?

 

[pepsyxanh]

I installed ms sql on the same server with plesk and installed client/server. And the service for ms sql is running
But i can't login to ms sql from another pc to this server.

 

[cviviani]

on the server with mssql and plesk

run SQL Query Analyzer

start under Programms>Microsoft SQL Server> SQL Query Analyzer and try to logon on our SQL Server with "sa" or us integratet Authentification

can you logon successfully ?
set password for "sa" or install mssql again and set the password for "sa"

 

[pepsyxanh]

I login successfull from SQL Query Analyzer on my server. But i can't logint successfull from Client computer to this server.

 

[cviviani]

are you logged in with "SA" ? ? ? ? ?
tell me please more

and what you mean with client computer ??
what is your application ??

I think you make somewhat crazy and abuse plesk
it is more one asks of as one from one client on mssql accesses, as of plesk

 

[pepsyxanh]

I logged with user name SA.
On client computer i connection with username and password SA to this ms sql server. I user SQL Enterprise & SQL Query

 

[cviviani]

is activ firewall?
do you make the connection over the IP or over the netbios name ? (set client for microsoft network in the properties of the LAN network)

ar the computers in the same subnet or it goes over a router?

 

[pepsyxanh]

My server don't have any firewall. And it stay in GNAX. I make connection to ms sql on this server throw ip.
Cviviani, do you have YM nick name? i will chat with you for details.
Thanks

 

[cviviani]

aah

is under the plesk panel under >system>server> service Microft sql server running

got to the plesk panel under >system>server>database set the password for "sa"

it doesn't help make a backup from plesk and make a new clean instalation

Look howto install

 

[pepsyxanh]

The service for ms sql started. And all login from client or server to ms sql is SA. I don't set firewall on plesk and on my network to now. Do you know active port 1433 of ms sql. I think i don't open and i don't know how to open it.

 

[cviviani]

you set the passwort to:
>system>server>database set the password for "sa"

for the clients you can create database user the must not have sa permission.
it gives som application the needs administrator rights under mysql like typo3.

sql goes over the localhost.

 

[pepsyxanh]

I think plesk block port 1433 and 1434 so i can't login to ms sql from client. Do you know open these ports?
System>server>database I get "Editing Credentials for Access to the Database
Microsoft SQL server
Server:localhost
(Unable to change the database server name: one or several databases are used on this server by control panel )"

 

[cviviani]

ohh man

set up your server new

you can try the computer name on localhost to change

localhost means 127.0.0.1

otherwise you could not connect with the query analyzer.

look to the log sql and event viewer

one can perhaps make it - but

set up your server new
that saves time and you has a clean server (us plesk backup)

I cannot help you any longer

 

[pepsyxanh]

everything now work perfect. After i install microsoft sql sp3 it work well. I can't reinstall windows because more websites running on my server it can't stop. Thanks for support from cviviani

 

[sezhian]

Dear Friends
This is sezhian,I am New To this Forum
I am Using plesk for windows.
I am using asp.net 2.0 and sqlserver2000 for dveloping my website
In this regard ,i dont know how to create tables in my Database.
And also i need the connection string to connect to the database
pls help me.its very urgent.
thanks
urs'
sezhian.k
[email protected]