MSDE Remote Connect strange problem

I'm trying to connect to the SharePoint MSDE database from Windows XP

SP2 machine over Ethernet LAN. I was getting server not found or access

denied, until I enabled TCP/IP via svrnetcn.exe. Now, I'm getting

OK

Connection failed:

SQLState: '01000'

SQL Server Error: 10061

[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen

(Connect()).

Connection failed:

SQLState: '08001'

SQL Server Error: 17

[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not

exist or access denied.

I just did an netstat -an and I don't see the server listening on 1433.

What am I not doing?

The svrnetcn tool has no effect. I make a change and check the logs,

but nothing happens. What would be causing this?

Did you ever get an answer to this problem? I'm having a similar error on Windows XP SP2 machines that have MDAC 2.8SP1. I have an MS Access front end that links to SQL Server database using ODBC connections. The report will run, but keeps asking for SQL Server login info, then finally I get the same Connection failed error you listed with the exception on the line: SQL Server Error: 10048. However, the report actually finishes with all the data requested.

I have this same Access front end running on other XP machines with SP1 and Windows 2000 machines with MDAC 2.7 SP1. When the report runs on those machines it only asks for SQL Server login info when the program is first connecting to the db.

Any ideas?

|||

Thank you thank you for letting me know about the svrnetcn.exe tool. I have been trying for hours to get a Sharepoint portal going and whilst for the error I had MS KB said enable tcp/ip, it didn't say how to do it for msde. Where did you find out about svrnetcn.exe and are there other useful tools I should know about? I'm ok with osql.

I have seen the error you are getting. It will happen if I'm not using Windows integrated authentication. If I try to connect with osql -U sa -S servername\instancename it doesn't work and gives a server does not exist or access denied. I have to use osql -E -S servername\instancename and it goes in fine.

Hope this helps - even if its a bit late!

Nath

|||

Nathan,

here is the linke which might be useful to you guys

http://www.codeproject.com/database/ConfigureMSDE.asp

Best regards,
Web

sql