SQL Express Interfere With Currently Running MSDE On A Webserver?
Jan 17, 2007
Currently I am running MSDE on a webserver. The MSDE was installed by a software package for web survey's. I am wondering if SQL express will interfere with this installation? Would I be better to install MySQL instead?
The problem I am trying to solve is simply giving a web developer some database space so that he can connect his web app to store some data. I'm kind of a n00b at this so I thought SQL express would be the best route. If I'm headed in the wrong direction can someone point me the right way?
Cheers!
View 1 Replies
ADVERTISEMENT
Sep 13, 2004
Currently, we have our SQL database behind our firewall.
Our App is required to log each page hit to a DB table with some additional data that we would not get from the regular IIS logfiles. So every page hit means a trip through the firewall...
Since this type of activity is limited purely to DB inserts, i'm curious what the thoughts are on using a copy of MSDE on the webserver itself to store this data.
What is the lesser of 2 evils
-- Take a trip through the firewall for each page to log the hits in a secure SQL DB
-- Log the Hit in a less secure / limited version of a SQL DB
View 1 Replies
View Related
Feb 24, 2007
Hi -
I may not sound desparate, but I really am. I have spent many days now trying to install and re-install Microsoft SQL 2005 Express. I still cannot connect to the database! I have read this forum and tried various suggestions, like setting the remote connections and TCP/IP + Named Pipes. Still doesnt work!
The environment is Dell Dimension 24000 (I86) with WinXPPro.
Out of desparation, I downloaded and installed Oracle 10g XE. It works just fine !
My question is: Does the Oracle database server interfere with connecting to the Microsoft SQL 2005 Express server ?
Also, I notice that there are an awful lot of questions posted on this Forum concerning just getting your software up and running. Are there that many stupid folks out there like myself, or has this application been released prematurely ?
View 3 Replies
View Related
Jan 23, 2007
i am working on upgrading the clients and server computers from 2000 MSDE to 2005 SQL Express Adv. Plan to upgrade using the template.ini.
i can find the version of sql server running on th server by @@version but how do i find the version of client connctivity components the computer has installed in order to ugrade?
1. somehow i need to know whether to upgrade a client computer CONNECTIVITY COMPONENTS from 2000 to 2005?
2. is there a way to enable tcp/ip in installation script of SQL Express?
THANKS
View 9 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
Oct 15, 2007
I've developed some custom etl in an sp that "trickles" data from an "intake" table to an "archive". The sp will be controlled by windows task scheduler and it's run frequency will depend on user need case by case.
The intake table is clustered on an identity column that is a pk. It also has an index on an "occurence" date.
The archive is clustered on the occurence date and it has all intake fields except the identity column.
The etl uses set based commands that insert chunks of intake to archive, delete those chunks from intake and then commit. If my "chunks" are defined as 100 rows and I have 40000 rows to ship, I insert/delete/commit 400 times. I'm purposely not using a cursor and purposely not using a truncate.
There may be some union type queries (between intake and archive tables) running infrequently, possibly while this etl is running. Can those queries cause the etl to fail? Can the etl cause the queries to fail? Can either cause the arrival of new rows into the intake to fail and vice versa? I have no explicit locking set in the sp at this time.
View 4 Replies
View Related
Dec 19, 2003
How can I check to be sure that the MSDE is installed properly and that it is running?
Should I be able to see the Service Manger in the tray?
Thank you,
View 1 Replies
View Related
Feb 19, 2004
I have a large VB 6.0 application running with Jet 4.0 Access DB. I am considering moving the DB to MSDE. For testing, I installed MSDE on another computer in a peer to peer network running XP sp1, loaded up the DB from Access to MSDE2000A -- all without problem. (I should add the obvious fact I am new to using SQL server.)
What I find is that with a relatively small test DB, running just a single instance of the application, query response from MSDE is taking several seconds (4-5 second lag) longer than response from the Access DB, which runs extremely fast. This is with the Access DB installed on the same network drive, running the same application and the same queries syntax -- only changing configuration of connection for each (SQL vs Jet 4).
Any clues as to what may be going on? The lag time is unacceptable. I am using SQL password instead of NT security. It seems the process is perhaps lagging in the process of authorization.
Thanks for any suggestions or ideas on this.
View 1 Replies
View Related
Jul 20, 2005
Without the Client Network Utility that is available in the full blown MSSQL Server is there a way to find out what port the MSDE is running on?Short and sweet, thats all I needTIA
View 1 Replies
View Related
Jan 12, 2007
Hello,
I have one program using MSDE as database. It runs OK on the machine with MSDE or without MSDE.
But it can not connect to MSDE database if PC with 'Microsoft SQL Server 2005' and 'Microsoft SQL Server Desktio Engine(MICROSOFTSMLBIZ)' installed.
Form SQL Server Server Manager: my instance ...MYINSTANCE and ...SQLEXPRESS are both running OK.
Why not connect to my MSDE instance under this situation? Could anyone give me any advice?
Thanks,
Dennis
View 6 Replies
View Related
Jan 30, 2008
I want to view the sample databases within Access 2003. When I try to view them an error message appears saying I need MSDE 2000 but this will not run on Windows Vista which is my operating system. What do I need to view the sample database as well as develop applications within Access using SQL server?
View 1 Replies
View Related
Apr 20, 2006
Hi!
Today I decided to finally install MS SQL 2005 Express on my VPS. For a long time I tried to work with MS Access what definitely brings a lot of complications.
I already installed SQL05Exp on my local machine and everything works great here. Because I'm quite new to these things I simply installed SQL05Exp on the Server the same way like locally. I just clicked through the installation with the predefined settings and everything installed without troubles.
When I uploaded my first Application and tried to run it, I got the following error-message:
Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed.
I then read somewhere that I could change the web.config connectionstring to "User Instance=False" what leads to the following:
CREATE DATABASE permission denied in database 'master'.An attempt to attach an auto-named database for file C:Inetpubvhostsgsp-peru.comsubdomainsmuestrahttpdocsApp_DataDatabase.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
I read a lot of documents about how to install, etc. but it couldn't really use it for me, surely for a lake of basics. When I understand the problem correctly, the user running the app on the server and trying to attach the mdf-database to the sql-server has not the rights to do that. However I don't know what to do against that.
What I would really love is a simple solution that allows me to connect to the sql-server from whatever domain on the server, just by copying the mdf. It also would be nice to use some kind of password in the connectionstring to assure that just my apps can connect to my databases.
I would be very thankful if someone could give me some good basic explanation what to do and maybe also give me a reference to some nice and understandable informations on this.
Best regards,
Markus
View 13 Replies
View Related
Sep 28, 2006
Hi,
I have a .Net website being served by my provider from Server A. It stores data in SQL Server B. Two seperate machines.
I have access to server A, but limited access to server B. Is there a script I can put on server A that will backup the database on SQL Server B and save it to a drive on server A (or even better my local drive).
Many thanks
Drew
Thanks
Drew
View 3 Replies
View Related
Apr 30, 2004
Hi.
I have just installed my webapplication on my ISP`s webserver with a connection to a SQL Server on the same server. My problem is that my app. cant find the database from the webserver. When I make a connection to the same db from my application running on my machine locally there is no problem. However, when i try to run the application on the webserver I get an error like this: SQL Server not found or access denied. When the remote db connection works from my machine, why doesn`t it work from tha webserver where the db is located. I use the same connection string:
"data source=gryllefjord.chriskomm.no;initial catalog=felicitas_new;persist security info=False;user id=myId;password:myPass;packet size=4096"
Can someone please help me?
Thanks!
Regards,
Knut
View 1 Replies
View Related
Mar 12, 2008
Hi all,
I can't find the answer to the following question.
Why is Visual Studio quicker then the ReportServer.
I've got a report with more then 20 parameters and several are muli-select.
When I'm opening the report in Visual Studio it appears with in one or two seconds whereas I open it on a reportserver it takes 8 to 15 seconds to open or to refresh. After that I can enter the report parameters and then the report is running in approximately the same time.
I know that the refresh is by default, so I can't change that, but the users have problems with wating 15 seconds between entering the parameter values.
The development machine is 2,8 GHz P4, the reportserver is a 4 proc 16 GB databaseserver.
The development machine is just being used editing the rdl in Visual Studio.The databases are kept on the database server.The network speed is 100mbps.
Is the only alternative to build my ASPX and reportviewer component inside of that APSX.
Thanks,
Eric
View 10 Replies
View Related
Jul 12, 2007
We currently have a standard star schema warehouse that contains clickstream data from our web server farm. We use a home grown ETL process that is a combination of java code and shell scripts to process these logs on a daily basis. The clickstream data represents both our dimensional data as well as measurements. We are currently processing 22GB of compressed data daily and are currently on a 50% growth rate year over year.
My question is does anyone have experience/pointers on using SSIS to process a stream of data that contains both the dimensions and fact data? Our current architecture pulls out dimensional attributes, processes them separately, and then substitutes the dimensional keys back into the fact stream. I have to believe there is a more efficient way to do this via SSIS.
Any advice would be appreciated.
Thanks
--sean
View 3 Replies
View Related
Sep 2, 2006
Hi, I've installed SQL Server 2005 Express Edition, SQL Server Management Studio Express using Windows Authentification and IIS 5. The problem occurs when I try to access the default address of my local computer to test my installation. I've tried with both http://localhost and http://127.0.0.1. The system requires a password despite I don't use password for my Windows Authentification. Does IIS always demands a password regardless my settings for Windows Authentification or?
Best regards
View 4 Replies
View Related
Sep 14, 2006
Are there any concerns for upgrading from MSDE to Express? Anything that has to be done to the database itself?
I will be uninstalling MSDE completely so I can reuse the instance name to minimize issues with other programs already setup for it. This means that I will be installing Express, basically, clean on the machine. What I am worried about is anything that needs to happen to the db itself, changing compatability levels and such.
Thank you in advance for any help.
View 1 Replies
View Related
Mar 21, 2006
Hi ....I am a developer and building an enterprise level application for general purpose. I need to include a database in that. I am working in Visual Studio .NET 2003 having Framwork 1.1 installed. Now what should I do? is it necessary to have visual studio .NET 2005 and Framwork 2.0 to work with SQL Server Express? can any one help?
Amir
View 1 Replies
View Related
Oct 30, 2006
I know this may have been asked in the past, and I've tried to search the forum, but didn't find any clear responses.
The question is about MSDE and SQL Express being "Free".
Can MSDE or SQL Server express be used for the backend DB for an application for a private (for profit) company? A COTS that we are planning to puchase can work with either commercial version of SQL server or MSDE / Express. Any input would be appreciated.
Thank you,
View 4 Replies
View Related
Mar 9, 2007
We have a product on the market, with 100k or so installs that use MSDE as its database (desktop application in .net). Our number 1 complaint is massive installation problems with MSDE.
Now, we are stuck a bit - first, we need to release a Vista Compatible version - which means no MSDE. We also need to migrate users from MSDE to SQL Express, with no data loss (we deal with financial information, and people tend to have zero tolerance for data loss here).
So, I have large scale reservations for two reasons - first, Microsoft's track record in supporting and making MSDE in the past has not been stellar.
With that said - are the multiple installation failure issues fixed in SQL Express? Did MS make the effort to get SQL Express to install on Win2k/XP/Vista improved? Are their benchmark figures out there regarding SQL Express install failure rates?
Additionally, can I get some information regarding MSDE to SQL Express upgrades done during for existing customers?
jason
View 1 Replies
View Related
Jan 11, 2007
I need to know if I will run into problems with sql express on a sql 2000 server. I get the impression that my isp is using 200 server just by lookng at the connection string. Is there a addin I could use if needed I seen a post mentioning the publishing wizard cpt but not much after is it released yet. and then there is the web data admnistrator for msde will that work with sql express.One other question can I reinstall sql and change the authentication process from windows to user name and password.
DKB
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
Mar 7, 2008
Not sure where to poswt this but I have a question. Is it possible to downgrade a remote SQL instance (the RTC database for LCS 2005 EE) to MSDE / SQL EXPRESS running on the LCS node?
I have two LCS2005EE pools side by side in the same account domain. The company recently went through a split where a part of our operation was spun off to another company. We're trying to figure out a way to leave them a working LCS but cut our hosted server count. What I came up with was basically 3 or 4 possible scenarios:
Leave only two servers (LCS and SQL.)
Try to move and run two instances on new production equipment
Try to downgrade the remote RTC instance into MSDE / SQL EXPRESS and leave one server.
Any ideas would be greatly appreciated.
Joe H. Wise
View 7 Replies
View Related
Oct 1, 2007
Hi everyone!
We are trying to restore a database backup created o MSDE 2000 server to SQL Express 2005.
The collation settings of both SQL Express and MSDE are the same: Turkish_CI_AS
The problem is that the log of restore operation has some warnings like:
Processed 344 pages for database 'MYDB', file 'MYDB_Data' on file 1.
Processed 1 pages for database 'MYDB', file 'MYDB_Log' on file 1.
Converting database 'MYDB' from version 539 to the current version 611.
Database 'MYDB' running the upgrade step from version 539 to version 551.
Warning: The index "myt_idx01" on "dbo"."myt" may be impacted by the
collation upgrade. Run DBCC CHECKTABLE.
Warning: The index "PK_BankLDef" on
"dbo"."BankLDef" may be impacted by the collation
upgrade. Run DBCC CHECKTABLE.
Warning: The index "AgreeHist_idx1" on
"dbo"."AgreeHist" may be impacted by the collation upgrade.
Run DBCC CHECKTABLE.
....
....
Database 'MYDB' running the upgrade step from version 551 to version 552.
Database 'MYDB' running the upgrade step from version 552 to version 553.
Database 'MYDB' running the upgrade step from version 553 to version 554.
Database 'MYDB' running the upgrade step from version 554 to version 589.
Database 'MYDB' running the upgrade step from version 589 to version 590.
Database 'MYDB' running the upgrade step from version 590 to version 593.
Database 'MYDB' running the upgrade step from version 593 to version 597.
Database 'MYDB' running the upgrade step from version 597 to version 604.
Database 'MYDB' running the upgrade step from version 604 to version 605.
Database 'MYDB' running the upgrade step from version 605 to version 606.
Database 'MYDB' running the upgrade step from version 606 to version 607.
Database 'MYDB' running the upgrade step from version 607 to version 608.
Database 'MYDB' running the upgrade step from version 608 to version 609.
Database 'MYDB' running the upgrade step from version 609 to version 610.
Database 'MYDB' running the upgrade step from version 610 to version 611.
RESTORE DATABASE successfully processed 345 pages in 0.420 seconds
(6.712 MB/sec).
What is the severity of this warnings? Is there a way to make them disappear?
Thanks in Advance.
Adnan
View 1 Replies
View Related
Feb 3, 2007
I read scott's tutorial for Deploying database to Hoster's server
"Recipe: Deploying a SQL Database to a Remote Hosting Environment (Part 1)"
bt cud nt upload n get the user login functinality wrking..
so plz help me..
View 1 Replies
View Related
Oct 26, 2007
How do I import an excel file from a public website / webserver thru SSIS? What are the steps and procedures?
Thanks in advance for all your help/ tips.
View 1 Replies
View Related
Nov 9, 2005
I posted previously about concerns of using SQL Server 2005 Express in a shared hosting environment that is running SQL Server 2000. While I've received no responses I'm beginning to assume that an .mdf file created by mssql 2005 cannot be attached to mssql 2000. So I have a few questions...How do I set Visual Studio to create the aspnetdb file using an instance of msde instead of sql server express 2005? I've already tried changing the Instance name under Tools...Options...Database Tools...Data Connections to my msde instance but when I create a new site and use the the website configuration tool a sql 2005 db is still created in the App_Data folder.Do I need to uninstall 2005 express? Manually create and place a new .mdf file in the App_Data folder?
View 1 Replies
View Related
Dec 15, 2005
I have heard that machines running applications with embedded MSDEfrequently experience conflicts between the MSDE apps and otherapplications such as BackupExec. What can anyone tell me about this?And if this is true, does/will the new SQL Server Express Editionbehave better?
View 1 Replies
View Related
Feb 2, 2007
I posted this in one of the VB forums but I'm starting to think itmight be more appropriate to have it here, since it really seems to bea SQL server (MSDE/Express 2005) problem:Hey, all, I have a problem with queries against a SQL server instancethat I just found and is causing me fits. I hope someone can pointmein the right direction, please. TIA.Basically, I got a Vista OS machine to test my VB6 app on it as someof my clients will be switching over in the coming months. I went toa local Circuit City during early business hours in the middle of theweek and I installed my application on each of 5 PC's on the newVistaOS (Tuesday, when it was released). I had read that MSDE 2000, whichI normally use as my DB is not supported on Vista so I had downloadedand was using SQL Express 2005. Each system had at least a 1.9 GHzdual core processor and 1 GB of RAM. One process in my program findsrecords in one table that do not match records in another table andthen reports those un-matched entries. On my development machine(laptop with 1 GB of RAM, XP Pro SP2, MSDE 2000 (current SP), 2 GHzCentrino (IIRC)) the process takes less than 30 seconds consistently.On each of those 5 systems at Circuit City the process took 5 minutes(on each of 3 HP machines, a1700n, a1720n, a1730n, and 11 minutes oneach of two Gateway systems (the model numbers of which I forget atthe moment). Each of these computers should be much faster than mylaptop, and some had twice the RAM, and all had SATA or SATA IIdrivesinstead of my piddly 5400 laptop drive, I would have thought they'dall be faster but were abysmally slow.So, seeing a huge difference in the time, and to try to keep thisshort and sweet, I fired up another computer I have, running XP SP2,on 512 MB RAM, AMD Athlon 2300+. First I loaded MSDE 2000 and myapplication and ran the process. < 30 seconds on each of multipleruns. Second, I unloaded MSDE 2000 and installed SQL Express 2005andmoved the DB to it (sp_attach_db) which caused some upgrading(messages reported in OSQL about update/upgrade). When it was done Irebooted, to be sure, and the ran the program and the process again.On the same data, on the same computer, the process took 7-9 minutesconsistently on each of several runs. This makes this part of theapplication unusable, and even the simple stuff like grabbing asinglerecord from the DB (maybe 5 columns of no more than 500 bytes total)is noticeably slower on the SQL Express 2005 than on MSDE 2000.So, the problem seems to be with my interaction with the DB. I amusing ADO 2.8 in VB 6 (SP 6). I use DSN-less connections with aconnection string like: Driver={SQL Server};server=(local)caredata;database=caredata;Uid=sa; Pwd=<password>I use the RecordsSet Object to open the data similar to this:oRS.OpenstrSQL$, oCN, adOpenKeysetafter the oCN object has had the connection string set and the objectis opened.Considering that the same computer, against the same data, with thesame program, takes about 14 times (or more) longer to run, then ithas to be either that SQL Express 2005 is slow OR that my program isinteracting with it in an incorrect manner.Can someone point me in the right direction, please?Thank you.--HCSo, the problem isn't Vista
View 11 Replies
View Related
Jun 4, 2007
We are attempting to backup using a maintenance plan a database to a network share.
The backup job works within a domain but fails within a workgroup?
Any thoughts?
thanks
View 1 Replies
View Related
Jan 15, 2008
I have an application that is already installed on a Win2k3 Server using SQL Express 2005. I have another application that wants to use MSDE 2000 (already tried using SQL Express 2005, but it won't install). My question is, can both of these be installed on the same server and running at the same time without any problems? Thanks!
- Adam
View 1 Replies
View Related
Nov 30, 2006
I have a 3 workstation peer to peer network with everything running Windows XP Pro. I need to replace the machine that hosts my SQL MSDE server. I have built a new system and all software is installed except the MSDE. I use a proprietary product called Time Matters for my law practice that uses the SQL server. Since I might want to run Vista eventually (not right now) I thought that I would try to migrate the MSDE to SQL Express. I assume that Time Matters will run on SQL Express. Can someone please give me some help on how to proceed. I'm thinking that I will install the SQL Express server on the new machine and then somehow migrate the database over to the new machine and shut down the old unit. Any help would be greatly appreciated.
View 1 Replies
View Related
