MSDE Connection problems

Hot Topic

SQL Server Authentication + SSL
Can't connect to SQL Server 2005
"...conversion between types DT_I1 and DT_I2 is not supported"
how to pass XML file path as input string to a Stored Procedure
Service Broker from behind the NAT
Remote Connection problem on MS SQL 2000
SSIS data lookup question
Template Parameters Dialog Box Not appearing(Stored Procedures)
"product level is insufficient" message during flat file import
sql server 2000

SQL Server

Fuzzy Lookup
How can I move the system databases?
Custom Destination Adapter
Oddball SQL calculation query - any Gurus up to this??
Insert Trigger
Passing Multivalue Parameters Through a Report Link
Encrption Level
wmi event watcher task
Many-To-Many Self-Join
SQL Agent Failing when trying to run my SSIS Package

MSDE Connection problems

Hi All,

I got a new computer and installed MSDE2000 on it. I put the SECURITYMODE=SQL in the ini file. Using the OSQL command string

'osql -SPROG200601\VSdotNET -dmaster -Usa -Ppassword'

I can get to it from my computer's DOS prompt.

I do not have a firewall, but when I try to access the SQLServer from my other computers on my network using the exact same string I get the message that says

[DBNETLIB]SQL Server does not exist or access denied.
[DBNETLIB]ConnectionOpen (Connect()).

I am able to access other computers' MSDE from my computer.

Any ideas what I could be doing wrong

Thanks

Answer this question

MSDE Connection problems

  • v-pakote

    Which protocols are enabled on your server You need at least one more protocol other than Shared Memory (which is for local). Also, do you have SQL Server 2005 instance installed on your server machine If so, make sure SQL Browser is running.

    Thanks.



  • Astrogator

    Can you telnet to the tcp port that the MSDE2000 is listening on or using osql "-Stcp:yourserver,tcpport -U... -P.." What you said does not confirm TCP is enabled on the sql server. Sounds like you enable TCP for client on all machines. You should use SQL Server Server Utilities to double check SQL Server is listenning on TCP. or check you errorlog file to confirm. Please try run "net start sqlbrowser", just to confirm no sql browser is installed.

    Thanks,



  • SpeakerBob

    Hi XinWei,

    I am using MSDE 2000. The only protocol I have loaded is TCP/IP on both the computer whose MSDE I can access and the computers whose MSDE I cannot access. Any idea what I can check.

    Thanks

  • Dondata

    Hi Xinwei,

    Thanks for clarifying the problem. After resetting the ports, I saw an instance of the MSDE i was unaware of and it was grabbing all the remote requests. When I removed the instance and reset the ports, everything works.
  • MSDE Connection problems
Answer this question