MSDE and network

[PaulB]

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...

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?

[Clunietp]

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

[PaulB]

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.

[PaulB]

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

[Clunietp]

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)