473,320 Members | 2,145 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

MSDE Configuration on Windows XP

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.
--
Thanks for any help
Jun 29 '06 #1
3 3042
Post the exact syntax of your osql command line, as well the exact text
of the error messages

RobOfTage wrote:
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.
--
Thanks for any help


Jun 29 '06 #2
the exact syntax was "osql -E". I've also tried "osql -U <myname>\vsdotnet"
and get same error messages.
--
Thanks for any help
"si*******@hotmail.com" wrote:
Post the exact syntax of your osql command line, as well the exact text
of the error messages

RobOfTage wrote:
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.
--
Thanks for any help


Jun 30 '06 #3
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.

"RobOfTage" wrote:
the exact syntax was "osql -E". I've also tried "osql -U <myname>\vsdotnet"
and get same error messages.
--
Thanks for any help
"si*******@hotmail.com" wrote:
Post the exact syntax of your osql command line, as well the exact text
of the error messages

RobOfTage wrote:
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.
--
Thanks for any help


Jun 30 '06 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Igor Solodovnikov | last post by:
Hi. I am trying to automatically backup transaction log when error 9002 happened. So i have created appropriate job and alert to catch this error. I have two instances of sql server under Windows...
10
by: noname | last post by:
MSDE 2000 Release A installed under windows 2000 pro will not communicate with SQL Server Manager nor MS Access on peer computer. Can someone help? Have set DISABLENETWORKPROTOCOLS=0 at install...
41
by: NB | last post by:
Hi I have been developing on MS Access / Jet / VBA platform for about 2 years. The current project I am working on for a small business is built on Access 2002. It has about 53 tables in 2...
1
by: Paul Aspinall | last post by:
Hi I have a C# Winform app which runs using SQL Server. I want to package up the app, so that it deploys with MSDE. Can anyone offer any pointers or references to help?? Thanks
3
by: Paul Aspinall | last post by:
Hi I want to package my C# winforms app, to be deployed with MSDE, as easily as possible for the end user. I want to create an MSI or Installshield (prefer MSI), to setup my C# app, together...
4
by: Anthony P. Mancini | last post by:
Does anyone know how to make the MSDE do SQL authentication ? It appears to authenticate using Windows at all times. Thanks, Anthony
13
by: Matt Fielder | last post by:
First off, if this is better posted in another group that qualifies as a manged group, please let me know. I currently have an application written in VB.Net using MSDE as the database. Current...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.