MSDE and network

Hi

I need to access an MSDE database on a computer on the LAN. The lan uses static IP addresses, and is a simple windows workgroup (peer to peer) setup.

I am having trouble getting my VB application to connect to the MSDE on another computer.

It works on a network with a domain such as NT4 server.

The connection string I use look like this...

Code:

---

Provider=SQLOLEDB.1;Persist Security Info=False;User ID=" & SQLuser & ";Password=" & SQLpassword & ";Initial Catalog=" & SQLcatalog & ";Data Source=" & SQLserver

---

The above code works fine with a domain. SQLpassword, SQLuser, SQLcatalog and SQLserver are string variables that are used to build the connection string.

Any help would be greatly appreciated.

Thanks

Are you getting an error message?

for the SQLserver variable are you using a computer name or IP address?

Hi. Thanks for replying.

I get the following error message.

I SQLserver is the correct IP address or the correct computer name, the message is...

Cannot connect to SQL Server
[DBNMPNTW]Access denied

If I specify the wrong IP number or computer name I get...

Cannot connect to SQL Server
[DBNMPNTW]Specified SQL server not found


So the program can see the server. I am using a login that has been set up. It works on a local computer, or on a network with a domain.

I would appreciate any further help.

Thanks.

Does SQL server or MSDE even work on a workgroup network?

Well, definitely a security/permissions issue

Do you have it set up to use Mixed-Mode or Integrated Security? Try using a standard SQL server username & password (don't use NT security)