My company will soon be upgrading our Access Database to SQL Server 2000. In order to begin testing and programming for the move, I have downloaded and installed SQL2K MSDE SP3. My install went smooth and it works fine. The problem I am having is when I am creating new databases or upgradin...more >>

I have J2EE web application, that uses Datasources, which works fine with SQL Server 2000 Developer Edition running on Windows 2000 Server but I am having issues with running the same code against MSDE version of SQL Server 2000 running locally on Windows XP Professional. Is MSDE version of...more >>

Hi! I've just moved a mdb to MSDE without problem. The problem comes when I try to open the tables I have attached via ODBC. Tables are in MSDE and I call them from Access. I get an error telling me that the user is not allowed to read (error 18456). Following that message, I get a login ...more >>

Hi, How would i go about viewing / logging current connections / connection attempts with msde. Angelo ...more >>

Hi All, What would cause the following error? "Fatal Error" - Execution cannot continue as the language dependent resource file D:\MSDE\Resources\1033\setup.RLL could not be loaded. Thanks in advance! Kind regards - Fred ...more >>

How can I change the login name and password? Quite frankly, I would like the login name to be same as my WIndows login and no passwrod....more >>

Jens, My Outlook Express rejected a direct reply to you. It only offered a reply to the entire group and I did not think that appropriate. So I am sending a new post. Here is the error message that I received in sending to you. The message could not be sent because one of the rec...more >>

I run a tutorial website with average 50,000 page views per day and hoping to grow this number to 100,000 per day in next 1 year. Currently, I use MS Access database and lot of caching in the web site for performance reasons. Can I use SQL 2005 Express for such a good traffic web site? Does S...more >>

I have a bit of a problem that I hope someone else might have experienced and can help with. I just inherited a location to support and in the course of applying SP3a to their installation, discovered that the database reports itself as the Personal Edition rather than the Standard Edition ...more >>

Have successfully installed VS.Net 2003 and had started to use the VS Startup WalkThroughs for Creating a Web app. It asked for the server information for a Pub database. I asked the MS Newsgroup for VS.Net Setup and they directed me to install MSDE and they attached a ConfigSamples app to...more >>

About a year or so ago, I had some dialog with this newsgroup about MSDE. At that time, it seems that Microsoft or someone was making a free product to make installations of MSDE a lot simpler. Has this been developed? I mean no one wants to release a commerical product designed for SQL Ser...more >>

Hello, Article Q319930 states that MSDE clients must be members of the Administrators group on the machine which is hosting MSDE. Is this really correct? I want to use MSDE with non-admin clients, and have done the appropriate sp_grantdbaccess, but still get 'login failed' errors when u...more >>

Hi We have an access app (front-end+backend) running on the company network. I am trying to setup replication for laptop users who go into field and need the data synched between their laptops and the server upon return to the office. I am planning it this; Move all access tables to sql ...more >>

I'm setting up a learning environment at home so that I can learn to program stored procedures. I need a debugger so that I can set breakpoints, examine variable values, etc. Is there any way to get the SQL Server 2000 query debugger to work with MSDE? If not, would it be worthwhile t...more >>

Hi guys, did anyone come across this problem? I have a query where I ORDER BY Part_Number field which is varchar but the ordered result is 10169-G 10169-MVS 10169 which is mess because normal person would put first the 10169 and then the others? Thanks for any help M...more >>

Hi, I'm about going to be using a database on the MSDE installed with Windows SBS 2003. The problem is that in the service manager there are no servers or services listed. Do I have to reinstall? Thanks. -- Message posted via http://www.sqlmonster.com...more >>

Come posso accedere tramite TCP/IP a SQL?? ho provato con http://localhost:1433 la porta è giusta?? cosa sbaglio? Grazie ...more >>

I tried to create "Database Maintenance Plan" for MSDE server by Enterprise Manager. However I could not set complete backup tag. (see attachment) Please give me advice to fix this. I want to take a back up correctry. Yoyako....more >>

Hi, Andrea, Thank you for your reply. I didn't drop the table,and the records in the table seldom change. Does it has anything to do with the weekly backup schedule? I remember I once did something wrong and I had to restore the database. Thanks for any relpy. Long...more >>

I found a problem with my MSDE2000 release A, today I tried to add some data into the DB, and it didn't work. After several tries, I figured out what happened. My field feature ( "default value") has gone. There was no default value at all. This had happened before, I thought I forgot to set ...more >>

Hi all, I want to install a msde into a specific directory. All works fine with including TARGETDIR and DATADIR into the installation settings. But there are some files (ClientTools such as »SVRNETCN.exe« and »sqlmangr.exe« etc.) installed in the C:\Program Files\Microsoft SQL Server d...more >>

Hello there I have a local installation of SQL Server 200 Developer Edition. I was about to caually download MSDE locally for evaluation perposes then realised there could be a problem - unfortunately I'm not in a position where I can easily make the installs on separate machines and would ...more >>

Hi We have an access app (both front & back ends are in access) that runs over win server networks. There are now more and more users who would like to take away a copy of app with them, work offline, and when they come back expect the client copy to sync (both ways) with the server copy. Seem...more >>