MSDE And SQL Server
Dec 22, 2004
Hi have just installed MSDE on a laptop. When I installed it I created a default account
username - sa
password - ?
With network protocols enabled and in mixed mode.
I then Created a script of a databse from are SQL server and ran that on the MSDE. So now I have an identical database on the laptop, but without any data. All going well hey.
The problem is I am now trying to copy the data across using the DTS wizard in SQL server. I can select the server from the dropdown, but it will not let me connet, it says not aurthorised or cannot find server. I am using SQL authentication, and using the user account sa. Any ideas what I'm missing. Am very new to SQL server, so any help would be very much appreciated.
View 7 Replies
ADVERTISEMENT
Jun 6, 2005
Hello,
I'm not sure if it's the setup I did wrong, but I can't seem to get my
text datatype in my database to store more than 900 characters.
I'm trying to setup a news database for my website, which will populate
the information into a datagrid. To test, I manually added a news
item in the database through the visual studio 2003 gui. I
immediately noticed a problem as the I was getting an error after a
long news item saying:
"The value you entered is not consistent with the data type or length of the column, or over grid buffer limit."
I couldn't find anthing to set the buffer limit and the datatype is
"text" filled with simple text in the column. As a further test,
I
simply entered 12334567890123... up to 900 characters and still
recevied the error.
I would appreciate someone leading me in the right direction on this one.
Thanks a lot.
View 1 Replies
View Related
May 27, 2000
I am trying to change the computer name of a machine running MSDE but I get an error when SQL Server starts. With regular SQL when I change the name of a computer I re-run setup and setup fixes this problem. MSDE can only be installed from unattended mode so I can’t rerun setup and fix the problem.
My question is "How do I change the name of a computer running MSDE with out reinstalling MSDE"
View 1 Replies
View Related
Mar 27, 2001
We currently have the problem, that all our machines are produced with the
same name and afterwards the name is changed. So we have the problem that
the checksum key for the MSDE isn't valid anymore. As MSDE can only be installed
from unattended mode so I can’t rerun setup and fix the problem. Does anyone
know a solution for this problem ?? A program recalculating the cheksum ??
regards,
Manfred
View 3 Replies
View Related
Mar 9, 2005
I'm not sure if this is the correct forum for this this question but I'll give it a shot.
The only db development that I have ever done is in MS Access. I have a project at work that is being accomplished in VB and I need a db engine to use as the back end. Visual studio came with a copy of MSDE. Is this tool worth using or should I invest in mySQL? Are there any advantages to using MSDE over mySQL?
View 4 Replies
View Related
Aug 6, 2007
Hello,
at the moment I have the following problem:
We have installed a version of the MSDE 2000 Sp3 with our software since 2005. Now we install SQL Server Express 2005 in order to use the latest version and to be compatible with Vista.
We have never had any problems with the MSDE, so it was no problem that we installed the german version (by mistake) because there never was any output at installation time.
When we now upgrade the existing MSDE installing the new version of our software, there are often problems and there are error messages, unfortunately in german, which cannot be read by most of our international users.
The problem is, that there seems to be no possibility to upgrade the existing (german) MSDE with the english version of SQL Server Express 2005.
My question is, if it is possible to upgrade the german MSDE to the english SQL Server 2005 to enable our international users to read the error messages at installation time in english?
Thanks in advance.
Best regards,
Peter
View 4 Replies
View Related
Jan 24, 2006
After installing MSDE(with SP4) and SQL Server 2000 SP4 Replication Components, the SQL Server 2005 Mobile Server Tools installation fails when running the System Configuration Check with a SQL Server requirement Error.
"You must first install the Replication Components for SQL Server 2000 SP 3a or higher or the SQL Server 2005 Replication Components"
Am I getting this error because I'm using the Desktop Engine version of the SQL Server 2000??
View 7 Replies
View Related
Jan 26, 2004
Apparently since I downloaded SQL Server SP3 and tried to install it on a computer without SQL Server in the first place, it's a bad thing.
I'm trying to get SQL Server Desktop Engine to install and I do the cmd.exe thing and it works, then 1 second before it finishes it rolls back.
All the files are still there, just missing the ones you need to run the SQL Server.
I used to have it on my 98, before I upgraded. Now I have the ASP.NET WebMatrix on my XP Home.
Is there a way to get SQL to install correctly?
John
View 2 Replies
View Related
Jul 23, 2004
I have created a SQL server database on my localhost. The live server that I am going to host the site does not have SQl server. I was thinking of putting MSDE on the live server. Would I have to make any changes to my SQL server database to put on the live server where i only have MSDE. Any idea what's involved with all that??
Thanks!
View 2 Replies
View Related
Dec 14, 2004
I have an SQL Server .MDF and .LDF file. The files were created a while ago and backed up. Well I need to use the database again, however I can't use SQL Server. So my next solution is MSDE.
How to I create a new database in MSDE using the already created .MDF and .LDF files as the actual database?
View 1 Replies
View Related
Jan 15, 2004
I own a copy of SQL Server 7 but am not using it for anything at present. I want to convert an Access db to this Server however I'd like to have a development environment on my laptop. Can I install MSDE and manually transfer the .db files to and from the SQL Server seamlessly?
Thanks
Dog
View 2 Replies
View Related
Jan 29, 2004
I am using SQL Server 2000 MSDE for Test Development of a site in .Net. The MSDE is installed on my workstation and the web site is depolyes on a web server. When I try to access data from the site at the development server, the connection to the SQL Server MSDE fails, saying:
System.Data.SqlClient.SqlException: SQL Server does not exist or access denied
But when I access the web site from the same box where the SQL Server MSDE is installed, everything works fine.
Here is the connection string I am using:
<add key="DBConnection" value="Data Source=<MyMSDEBoxName>; Initial Catalog=<DatabaseName>; Integrated Security=SSPI;"/>
I have tried using User Id and Passoword but it failed too!
Any help will be appreciated.
View 2 Replies
View Related
Feb 4, 2004
Hi,
We have developed a product in VB using MS-Sql Server200 as the DB. Now for distributing the product we have decided to use MSDE. Can any one tell me how to distribute the Product with MSDE. What should we do for that
Thanks in Advance
View 1 Replies
View Related
Jun 21, 2005
hi - I am developing locally using .Net 2.0/Access but just recently started trying out SQL Server Express. I have deployed my application to a host who provides 2.0 but as would be expected only MSDE/SQL server 2000. Now if I'd switch completely to SSE, would my SQL queries (which are pretty simple) work on MSDE or SQL server 2000? The only thing I see as more sophisticated sql queries would be the built-in 2.0 Roles/Membership functions... Do you think they would run smoothly on MSDE/SQL 2000?Finally... since the database is already done locally, is there any way (a stored procedure for example) to copy it's scheme if I'd create a new DB on my host's SQL server?
View 2 Replies
View Related
Oct 26, 2006
We have 3 MSDE databases (3 seperate servers) which we need to make into one Sql 2000 server (new server). How is this done? Can't find anything clear about this.
Thanks
View 3 Replies
View Related
Dec 9, 2003
Hi
I think I must operate a similar system to the rest of you here, where I have a Shared SQL Server Database on the web for my website and since I cant afford the full SQL Server to develop on I'm developing on the MSDE that comes with VS.net(I think thats where I got it longtime ago). Anyway my point is since in the database project on VS.net I cant generate Create Table SQL Code against MSDE, Apparently you need the full SQL Server to do that. Whats the best way for me to transfer any changes from my dummy development database to my production database on a real SQL Server.
Any help would be appreciated I'm still rather new to SQL Server(been using cheap MySQL) so could do with some pointers.
Thanks
Andy
View 2 Replies
View Related
May 30, 2004
I plan on replacing a SQL2000 database with MSDE for lowering budget.
Can we script up the SQL database (with SPs, triggers, and UDFs) and recreate it in MSDE?
Thanks.
View 3 Replies
View Related
Jul 29, 2004
I have installed MSDE on Windows Server 2003 along with IIS. I am having problems getting SQL SM to work. I cannot login to it.
Here's how I installed SQL SM:
setup.exe /qb+ INSTANCENAME=NetSDK DISABLENETWORKPROTOCOLS=1 SAPWD=paswd
I cannot log in...
I have tried Windows Integrated and SQL login...
View 2 Replies
View Related
Mar 11, 2005
Is it possible to link MSDE to another server through ODBC? I want to do this like you can in Access, where you get external data by linking tables. Any ideas? Thanks!
View 1 Replies
View Related
Apr 20, 2005
Hi All,
I recently created my entire site before even starting to look at hosting providers. It's a very complex ASP.NET e-Commerce site built on SQL Server. I've (nearly) got it to a point where I want it to go live.
I found a host that caters for all my needs and is a good price. What I need to do now is migrate all my data, as well as all my tables and stored procedures, into the database with my host.
Is there an easy wy to go about this?
- Mina
View 2 Replies
View Related
Feb 25, 2006
Hi - I have an MSDE database running on my server - I'd like to port my asp.net 1.1 app to asp.net2, and make use of SQL 2005 Express.How do I transfer my data from an MSDE database to SQL Server Express, keeping intact all of my unique ID fields, indexes, and SPs (I don't have any functions or views)Thanks for any help,Mark
View 4 Replies
View Related
Aug 28, 2000
During the install of a product, we need to know if they have MSDE or SQL Server installed and what version/service packs have been applied.
When you query the database with select @@Version, it will bring back exactly the same information....
Is their another way to determine if they are running MSDE or Sql Server?
Thanks!
View 1 Replies
View Related
Apr 12, 2004
3 of 100 MSDE servers' sql agent stop working with 'sqlAgent servise has marked as deleted'.
1. is there a way to fix this service could not start issue?
2. probably not. before moving all DBs to a new MSDE server, I run scripts on daily via isql to these 3 MSDE to run the daily backup and dbcc jobs. The problem is I could forget to run.
I tried to run following:
backup database remote1.db1 to Backup_db1 with init
so that I could run a job from my server on scheduling time. but it did not work.
Any idea to turn manual process to semi-weapon?
thanks
-D
View 1 Replies
View Related
Jun 4, 2004
Hi. I am working on a dynamic website and backed up the data from our database (SQL Server) into a .bak file from our server. I want to develop the site locally on another machine (doesn't have SQL Server, but MSDE) using the database so I restored the database backup using RESTORE DATABASE FROM... (in the DOS prompt). I found a tutorial how to do this at
http://www.popkin.com/customers/customer_service_center/tip_of_the_week/01_19_04/tipofweek.htm
It did the restore successfully (or so it said) but all that it restored was the database structure (table structure, user information, etc.) but not the actual data in the database. I am using Specify (www.specifysoftware.org) as a database manager.
Could anyone help me out? Can I not go from SQL Server to MSDE? This doesn't seem to be the case because the structure restored okay.
What should I do to correct this problem?
Thanks for your help in advance!
Nik
View 1 Replies
View Related
Oct 1, 2004
Is it possible?
How about all dev in sql server then migrate to "production msde" using either DTS or bcp and DDL scripts?
Can you bcp in to msde? And is msde true client server?
View 4 Replies
View Related
Mar 12, 2004
I am using VB.net to build ASP.net pages. I finally decided it was time to start using SQL server based code. So, I installed MSDE....or so I thought.
I have the server Icon in the bottom systray and it's green and seems to be running.
I have been able to use Microsoft Access' Database Upgrade Wizard to create BB.adp file.
An in VB.net I see a master.dbo connection in Server Explorer.
But I can't figure out how to access the database via the SQL server. When I right click on Server Explorer....the Create a New SQL database menu item is greyed out.
My concern is that my installation is not complete and/or I don't know how to locate and verify the server.
Any help would be appreciated. Thanks
View 1 Replies
View Related
Jul 23, 2005
Hi all,I just got SQL Server 2000, but I already have MSDE installed. Is there anyreason I would want to keep MSDE around on my computer if I install SQLServer 2000? I use MS Visual Studio 2002 on Windows XP SP2, in case itmakes any difference. I intend to deinstall MSDE before installing SQLServer 2000, but I get the impression from a few posts that some people haveboth installed and I'm not sure why that would be done. What functionalityis in MSDE that is not in SQL Server 2000?Thanks for answering.--Diana
View 1 Replies
View Related
Jul 23, 2005
Can an individual computer be configured contain both a SQL Serverinstance & an MSDE instance?Our software we charge separate costs depending if they are running ona MSDE or SQL Server edition, and if they already have SQL Serverrunning (which they may have installed for some other application), canwe install our MSDE instance on the same machine?And on the flip side, if they already have a machine that has an MSDEinstance, can the SQL Server install be done over top of that withoutaffecting the MSDE?Thanks for any help,GregJoin Bytes!
View 1 Replies
View Related
Oct 29, 2005
So I installed an instance of SQL for an application (WSUS) and all waswell. Having read in many places that I could install multiple instances ofMSDE on the same box, I started the second install today (Live CommunicationServer). The MSDE install portion of LCS gets almost completed and then itrolls itself back and fails with Event ID: 11708. Now when I go back intothe SQL Server Service Manager it says not connected and there are noServices available in the drop down list, including the one that should bethere for WSUS. Should I just reinstall WSUS again (hopefully I won't haveto reconfigure all of the updated approval/deny settings). Any thoughts onwhy the second instance fails? Thanks in advance.
View 1 Replies
View Related
Jul 20, 2005
Does anyone know if there is a way to determine if the SQL Serverinstallation being run is MSDE or SQL ServerStandard/Professional/Enterprise?Thanks!*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
View 1 Replies
View Related
Jun 7, 2007
what are pseudo tables
how queries run by MSDE
how stored procedures run in backend by MSDE
how triggers run by MSDE
where triggers and stored proc stored in MSDE and in which form
where logs are being maintained of transactions/DML statement by default
View 1 Replies
View Related
Jun 18, 2007
hi all
What I need to include with my application setup,
My application is working with Sql Server 2005.
I mean what substitute MSDE for sql server 2005
thanks
View 1 Replies
View Related
Nov 29, 2003
Hi
I wonder what the differences between MSDE and SQL Server are. The main thing I'm conserned about is...
Are there any limit of concurrent users to the MSDE?
Regards
M
View 2 Replies
View Related
