Soul
05-12-2005, 03:23 PM
I have it partially figured out. You have to enable the tcp/ip connection for the MSDE service.
Run C:\Program Files\Microsoft SQL Server\80\Tools\Binn\svrnetcn
Select tcp/ip and move to enabled protocol but I don't know what the username and password for the msde is so I can perform the registration.
Has SQL Server authentication been disabled for the default MSDE installation?
EDIT:
Fixed it on my own. Once you remote desktop into the server you need to navigate to that same above directory and run osql -E
This will give you a trusted sql server connection where you can issue commands
Type the following commands...
1> use master
2> EXEC sp_addlogin 'yourusernameyouwanttobeadmin','yourpasswd'
3> EXEC sp_addsrvrolemember 'yourusernameyouwanttobeadmin', 'sysadmin'
4> go
This should create a user with the name 'yourusernameyouwanttobeadmin' and with 'yourpassword' that you can use to register your SQL Server into SQL Enterprise Manager.
I don't know what the default sa account password is for the plesk system. It would make sense that it should be set to the main password when you set up the VDS.
Run C:\Program Files\Microsoft SQL Server\80\Tools\Binn\svrnetcn
Select tcp/ip and move to enabled protocol but I don't know what the username and password for the msde is so I can perform the registration.
Has SQL Server authentication been disabled for the default MSDE installation?
EDIT:
Fixed it on my own. Once you remote desktop into the server you need to navigate to that same above directory and run osql -E
This will give you a trusted sql server connection where you can issue commands
Type the following commands...
1> use master
2> EXEC sp_addlogin 'yourusernameyouwanttobeadmin','yourpasswd'
3> EXEC sp_addsrvrolemember 'yourusernameyouwanttobeadmin', 'sysadmin'
4> go
This should create a user with the name 'yourusernameyouwanttobeadmin' and with 'yourpassword' that you can use to register your SQL Server into SQL Enterprise Manager.
I don't know what the default sa account password is for the plesk system. It would make sense that it should be set to the main password when you set up the VDS.