Then I proceeded with a Batch.file installation and that seemed to work for the most part.
This is what I used for the Batch.file
setup.exe SAPWD=somename INSTANCENAME=somename SECURITYMODE=SQL
The Problem I ran into is - I can't seem to get the (SQL SERVER SERVICE MANAGER) to connect. I've entered the server name & instancename but so far no luck.
Ive checked - Control Panel/Administive Tools/Services - to make sure that it was installed & Yes it is there. So I Proceeded to start it up. Next I tried to Connect Via SERVER MANGER with no luck.
Then I did a c:\>osql -E check with the Command Line Prompt which returned the following message:
[Shared Memory]SQL Server does not exist or access denied.
[Shared Memory]ConnectionOpen <Connect<>>.
Tried again with c:\>osql -E -S
returned the same message.
[Shared Memory]SQL Server does not exist or access denied.
[Shared Memory]ConnectionOpen <Connect<>>.
Not sure what to do at this point any help/advice. Thx/TIA
(MSDE Version: sql2kdesksp3)
OS = XP ProUpdate:
Finally Managed to Connect to (SERVICE MANAGER) So now I have Connection with my server. I had to Specify ServerName\Instancename - and finally managed to connect.
But I can't seem to make a Database Connection In webMatrix. I entered The (USERName & Password Name) with no luck, even tried different combinations but still no luck!! USERNAME:Someusername**** (and) PASSWORD:SomePassword****
Is there a way I can create a New USERNAME & PASSWORD, with the command Line Prompt?
Anyone know how to do this? THX /TIS
Tristen|||view post 446484|||Thank you for Link/replying Bill,
Problem corrected. Reinstalled MSDE & Made a New SQL Authentication Password.|||Did "setup /upgradesp" help you?
