MSDE 2000 and Windows 2003

I am having trouble connecting to a Windows 2003 w/ MSDE 2000 from all my client PCs. I can connect locally from my Server. I have no firewalls or any other devices in between my clients and server.
Did you enable network connection on msde? Use svrnetcn.exe.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jiffy" <anonymous@.discussions.microsoft.com> wrote in message
news:94F601EF-E2C2-4777-BDB8-DDC76DFFE97A@.microsoft.com...
> I am having trouble connecting to a Windows 2003 w/ MSDE 2000 from all my client PCs. I can connect locally
from my Server. I have no firewalls or any other devices in between my clients and server.
|||After you do this you will need to stop and restart MSDE.
Rand
This posting is provided "as is" with no warranties and confers no rights.

MSDE 2000 and Windows 2003

I am having trouble connecting to a Windows 2003 w/ MSDE 2000 from all my cl
ient PCs. I can connect locally from my Server. I have no firewalls or any o
ther devices in between my clients and server.Did you enable network connection on msde? Use svrnetcn.exe.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jiffy" <anonymous@.discussions.microsoft.com> wrote in message
news:94F601EF-E2C2-4777-BDB8-DDC76DFFE97A@.microsoft.com...
> I am having trouble connecting to a Windows 2003 w/ MSDE 2000 from all my client P
Cs. I can connect locally
from my Server. I have no firewalls or any other devices in between my clien
ts and server.|||After you do this you will need to stop and restart MSDE.
Rand
This posting is provided "as is" with no warranties and confers no rights.

Msde 2000

Hi

I installed the MSDE that comes with Office 2000. When connecting to my mdf, I received an error saying that the header file is invalid. I understand that the MSDE shipped with Office 2000 uses the SQL 7 engine, therefore it does not recognize the my SQL 2000 database file format. Can someone tell me where can I get a copy of the correct version of MSDE that will work with my SQL 2000 mdf?

Thanks

SHKMSDE 2000 (http://www.microsoft.com/sql/msde/downloads/download.asp)|||Thank You

MSDE - Problems connecting using SQL Authentication

I'm trying to use the import/export part of MSDE. When I choose to connect to the server via Windows NT Authentication, everything works fine, assuming I have a connection to the server open (ie VPN connection).

When I chooose SQL Server Authentication, I get the following error:

Client unable to establish connection [CBNMPNTW] ConnectionOpen(CreateFile()).

I need to be able to connect using sql server authentication. Can anyone help me?

Thanks,
StephanieRE:
I'm trying to use the import/export part of MSDE. When I choose to connect to the server via Windows NT Authentication, everything works fine, assuming I have a connection to the server open (ie VPN connection). When I chooose SQL Server Authentication, I get the following error: Client unable to establish connection [CBNMPNTW] ConnectionOpen(CreateFile()). I need to be able to connect using sql server authentication. Can anyone help me?
Thanks,
Stephanie

Q1 Can anyone help me?
A1 Possibly, more information would be helpful and is probably quite necessary. You may well have more than one issue, i.e.(Are you using DSNs, do you have a local DSN(s) configured to use TCP/IP instead of Named Pipes, are you able to tracert / ping your MSDE server with and / or without Windows NT Authentication via your VPN, is your VPN Win NT authentication based, etc., etc.,?).

Msde - Connecting To The Database

Hi,

I have installed MSDE into my system, in which SQL Server is not installed. I have followed the installation instructions and installed MSDE.
How can i connect to the database? I have the .MDF file of the database (already created in sqlserver) in the Data Folder. How can i connect to the database from Visual Basic 6?Check out the following download from microsoft. Note - It shows you 2 methods dao and ado - also, the objects are created using late binding - once you have decided what you are going to use, make sure to change this to early binding.
link (http://download.microsoft.com/download/vstudio60ent/Update/6/WIN98MeXP/EN-US/msde_vb6.exe)

MSDE

Having Problem connecting to Database with WebMatrix

When I try to ADD Database in WebMatrix through Sql Connection & enter USERNAME & PASSWORD it fails. Is there a way to create New USERNAME & PASSWORD? Perhaps through
the Command Line Prompt?

Any Help/Advice TIA

Tristen"setup /upgradesp" option may be for U.
Read carefullySQL Server MSDE notes.