Problems accessing MSDE Sql server on Windows server 2003

[wesleyfraser]

Hi Guys,

I wrote a little app for a client of mine and he recently got a new server with server 2003 on. He wanted me to move my database over to the new server.

So I installed the MSDE and was able to access the database from osql.exe using the sa username and password. When I tried to access the database from the ODBC database manager it returns a message saying that sqlserver does not exist or access is denied.

If anyone can help it would be greatly appreciated?

Wesley

 

[MielieSpoor]

I know that MS is doing away with MSDE and as far as I know MSDE is not fully supported by SQL Server 2005.

What database is it? SQL Server? If SQL Server, why don't you install the database server on the Win Server and then do a client install on all the PC's that need to connect to the server?

 

[wesleyfraser]

It is sql server 2000. What I am trying to do is have the database installed on the server and then my program that is installed on all the other machines the connect to the database. But that currently is not possible

 

[MielieSpoor]

Sorry, don't know MSDE! All I can say is - do a client install for SQL Server on all the client PC's. That will cost you but I don't know of any other ways.

Go to these links to get help:

SQL Server 2000 Desktop Engine

How to manage the SQL Server Desktop Engine

MSDN Forums: SQL Server

On those forums you should get an answer within a few hours. Always first try MSDN forums!

I also included MSDN articles - worth the read!

 

[wesleyfraser]

Thanks Mieliespoor,

MSDE = Microsoft Sql Desktop Engine...

In my lingo. It might not make sense LOL

 

[diabolus]

It is sql server 2000. What I am trying to do is have the database installed on the server and then my program that is installed on all the other machines the connect to the database. But that currently is not possible

Just get the sequel to MSDE. It's called SQL SERVER EXPRESS . This is the free version of SQL Server 2005, much better. You can still use the same db on the new Express server.

 

[wesleyfraser]

I will have look...

 

[MielieSpoor]

MSDE = Microsoft Sql Desktop Engine...

Also called SQL Server 200 Desktop engine.

Inbetween those articles you would've seen SQL Server Express. It works alot easier! Rather use that. You've got alot more power over your database!

 

[wesleyfraser]

Will do, I am doing the install at 13:00 today will let you know if everything went ok...

Thanks again for the help

 

[MielieSpoor]

Please! As diabolus has said, rather go for SQL Server Express if you can.

 

[wesleyfraser]

Hi Mieliespoor, I just wanted to let you know that Sqlexpress 2005 worked like a charm....

Thanks for all the help