I Just installed MDSE2000A (ithink it already comes with SP3a), by doing Setup.exe /qb+ INSTANCENAME=MOC DISABLENETWORKPROTOCOLS=1 SAPWD=moc I downloaded the northwind database and tried to install it by doing osql -E -Q "EXEC sp_attach_db N'Northwind', N'c:\SQL Server 2000 Sample Databases\n...more >>

I am trying to instal a program and it needs SQL Server 2000 installed. I get a failed message when I get to File and Printer sharing. I have set File and Printing permission set on. Now what do I do?...more >>

Okay, I've got a SQL Server (MSDE) instance installed on a machine called DEBRA-F -- I specified the sa password as localadmin -- easy enough. At first, I couldn't connect to her machine FROM her machine, using the sa login. So we had to login using the -E switch (ie, no username or password...more >>

I'm deciding what "embedded" or local database to use for an application (VS2003 C#). I've looked at SQLite and am also looking at MSDE as a possible solution. The 2GB limit on MSDE is a bit worrisome but, as I understand it, SQL Express will not have this limit. So, if I begin development...more >>

I noticed there are a lot of differences between using JET and MSDE. The firm I work for has three location and needs a realtime database. I have thought about using terminal server and sticking with JET, but with JET sounding like it will be put out to pasture in the future I thought it migh...more >>

Need Help!!! I am accessing MSDE from another terminal running another service of MSDE. Error message: Access Denied How can I do this...more >>

How to check the instancename tcp port by a commandline mode?...more >>

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

Hello, is ther a way to connect to the command line for MSDE. I want to export data from the MSDE database with a command line script! How can I accomplish that??? Thanx, M.J. ...more >>

I have found conflicting info on Microsoft's website in reference to the processor requirements. In one instance it says that the processor must be a Pentium. Another instance it says Pentium or compatible. Has anyone had an issue installing MSDE on a computer with an AMD processor?...more >>

Hi, I am trying to connect remotely to a client's MSDE database with my SQL Enterprise Manager so I can administer the database. I have established a VPN to the client which I can ping and terminal serve into the server but I cannot register the server with the SQL Enterprise Manager. I h...more >>

Which version of MSDE 2000 should I install when installing on a new computer? The one 'Microsoft SQL Server 2000 Desktop Engine Release A' which is about 42MB? Or the SQL Server 2000 SP3 version? ...more >>

How can I change the collation order for a msde db? With SQL Server I use Rebuildm.exe utility, but with msde that file is not present. thanks, AF...more >>

Plz Help me. Auto shutting down of my sql service manager. what i will start it, but the server is shutdown after 30 seconds. that is why i can't used any services. Please to help me, what about to start of my sql service manager and matained of sql server 2000 (enterprice)? Please a...more >>

I've installed the MSDE and my taskbar icon says it's running. I'm then trying to create an Access project (.adp) and and I'm faced with the connection screen. I type "local" as the SQL server name and check "trusted connection". I then get an error saying: Connection failed: SQLstate: '0100...more >>

I'm trying to install an instance of MSDE on a dell poweredge 1650 server running windows 2000 server and with 2 instances of msde 2000 sp3 already running, using the following command line: D:\MSDERelA\setup.exe INSTANCENAME="INSTANCE" SAPWD="xxxxxxxx" SECURITYMODE=SQL TARGETDIR="D:\Program ...more >>

Hi, we are installing our app at different sites. Normally it is a easy job, but today we got problems. The user had MSDE from before with Win NT authenticaton only. We changed this to mixed mode. Then we used OSQL and sp_addlogin. Yesterday at another customer this was enough to get access ...more >>

We are a small company writing primarily in-house software, but also potentially developing software to market. We are converting from writing all of our software completely in Access to writing in Visual Studio (C#). We are confident this the best decision for both our in-house and pot...more >>

I have run into a problem using the default directory switch ( -UseDefDir ) with a backup. I have some installations of SQL 2000 Desktop that don't have a default directory. The error reads, "Could not get the default backup directory for database..." My question is, How do I find if a d...more >>

Hello to all, I am using MSDE and i recently realised that the query performance is decreasing while db size increases. In a db table of 20000 rows a simple select query with 6 inner joins took 1.27 sec. to execute (XP Pro, 775 MHz, 248 MB). I upgraded to SQL Server personal edition and the sa...more >>

Hi, How to convert a view to a table in SQL server? I have created the view with related tables and filtered. But my system studying on can not work with a view. or any other solution? Thanks without expect reply, ...more >>

Hello, I am installing MSDE 2000 on a Windows 98 machine. After installation, the SQL server is running, but when I try to run my program against the SQL server, I get the following message "Login failed for user "null" note associated with a trusted SQL Server connection" I'm running setu...more >>

I have a database that has reached the MSDE 2GB limit. I have tried running the sp_spaceused command and I can't see how the results equalls 2GB Can someone explain what values are used by MSDE to determine that the database has reached the 2GB limit? Sp_SpaceUsed Resuls: Database Size...more >>

Is is just me or does this query produce the wrong results??? SELECT CATALOG_NAME FROM master.INFORMATION_SCHEMA.SCHEMATA I have a MSDE sp3a installation, and this query does not include my user database in the resut set. ...more >>

Hello, We are using MSDE and I would like to know the following: - Our MDSE database is set to recovery model Simple but after restoring the backup set the log file increases to 800/900 MB; I'm puzzled about this, because I always thought that 'Simple model' leaves the log file(s) alone; - ...more >>

Hi all, Is it true that MSDE can only handle 5 concurrent connections? I cant seem to find the proof in the documentation that this is true....more >>

I am getting 'Timeout Expired - The timeout period elapsed prior to completion of the operation or the server is not responding', if a database is backed up with a T-SQL statement. The same DB backs up fine when done in Enterprise Manager. Using C# .net 2003. Also - is there any way of get...more >>

pls help I installed an instance of MSDE to a Win2000 Prof PC. It worked (disablednetworkprotocal). Then I uninstalled and reinstall. At the point the set up configures the SQL Server (very final stage), it failed. In the cnfgsv.out log file, If network protocal is disabled, the e...more >>