MSDE Configuration on Windows XP

[Guest]

I'm having problems trying to configure MSDE on Windows XP home edition. I
think I've followed the advice on kb 841252. I've added the sqlserver.exe
file to the Windows Firewall allowables, I've also enabled SQL Server port on
the McAfee Firewall (incoming and outgoing port 1433). Also ran svrnetcn.exe
- found TCP/IP was disabled so I enabled it. Checked that port was 1433.
Finally re-checked value in registry key HKLM/Software/Microsoft SQL
Server/VSDOTNET/SuperSocketNetLib/Tcp. TcpPort value was 1433.

When I try to run the "osql -E" utility I get two error messages, the first
stating an Invalid Connection, the second stating an Invalid Instance for the
ConnectionOpen method.

There is an instance of SQL server running on the PC named <myname>\VSDOTNET.

Sorry if this may have already been covered but I cannot find any more info.

 

[sirfunusa]

Post the exact syntax of your osql command line, as well the exact text
of the error messages

 

[Guest]

the exact syntax was "osql -E". I've also tried "osql -U <myname>\vsdotnet"
and get same error messages.

 

[Guest]

Another osql command I've tried is "osql -S <server>\VSDOTNET -U sa -P
<sapassword>" and have received message:-

Login falied for user 'sa'. Reason: Not associated with trusted SQL Server
connection.