Hello, can I run the express edition on my desktop and test web site with it, but then deploy the same app to my webhost and have it use SQL2005 standard? (They don't support the express edition.)
I'm new to SQL2005 and am curious. In fact, I still don't totally understand if express is installed or just a file like access. :)
Thanks!
Stephen Rylander
Hi
We have Sql2005 x64 bit standard edition server installed in windows 2003 64 bit editio server,
currently due to buisness requirements we need to have sql2005 x64 bit enterprise edition, please let me know how do i do the upgrade or change.
is it possible to retain all our custom settings in the standard edition after changing to enterprise edition.
This has to be done for our production and very critical, please help
Thanks
Samuel I
Can you open/use a database created in SQL2005 in SQL2005 Express?
Thanks for the help!
Max
I have downloaded Microsoft SQL 2005 trial and now have this running perfectly with our main database. Before I did this I checked to make sure that you could indeed unlock trial with a valid number, and the MSDN site said yes it can be done. I have now purchased the full Standard edition, and wish to enter the product key into the trial version to unlock. How do I do this ???. I have spent 3 hours on the phone today with over 11 different departments, and they all give me conflicting info. Eopen say it cant be done and that I have to uninstall the trial, and then completely re-install STD edition (I DEFINATELY DONT WANT THIS !!!!)
They put me to tech support who say it can be done, but I have to pay for this information ...Excuse me but I yesterday paid over £4000 for the software and now they wont help me unless I pay for support !!!!! http://msdn.microsoft.com/en-us/library/ms143393.aspx says it is an acceptable upgrade path but dont say how to do it. .
Eopen say this is not true !!!
How do I unlock SQL 2005 Trial version and down grade it it to a full blown STD version with my licence number I have. Can someone please tell me how this can be done.
If anyone knows, can they please email me at rob.wheeler@ehbp.com with instructions.
Thanks,
Rob
Hi All,
I like to know that in SQL2005 how many replication sides we can create for the same database. Can we create more that one are only one for each database.
1: SQL2005 Standard version Database
2: SQL2005 Enterprize version database
Thanks
I have got a licensed copy of MS SQL Server 2005 Standard Edition. I am wondering how I can go about telling how many Processore Liscenses or Client Licenses I have with it. I have just the disk set and product key, no box. Any clues?
View 1 Replies View RelatedHi ,
We are using the a 4 CPU SQL Server 2000 Enterprise edition for our application ,
We want to migrate to SQL2005 with the compatibility level downgraded to SQL2000.
If we go for the SQL2005 Standard edition is there any problem?
We are not using the Failover clustering in our server.
thanks & Regards
siva
I am attempting to install SQL Server 2005 on a Server 2003 Enterprise edition SP2 and fully Patched with all critical updates, including .net 3.5 Additional Information, this is on a Virtuial Server.
When I try to install it fails near the beginning and the log file contains the following.
Microsoft SQL Server 2005 9.00.1399.06
==============================
OS Version : Microsoft Windows Server 2003 family, Service Pack 1 (Build 3790)
Time : Mon Mar 24 07:34:15 2008
Machine : X205
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Failed
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_X205_Support.log
Last Action : InstallFinalize
Error String : The installer has encountered an unexpected error. The error code is 2908. Could not register component {1F3316BE-825B-4390-A9D2-AF3EECCAE9F6}.
Error Number : 2908
====================================================================================
After doing some search engine digging I found some referances to simuilar problems being caused by .net. I tried uninstalling first 3.5, then 3.0 then 2.0sp1, at which point the install worked with only one error that SQL Management studio was unable to register (A bunch of black lines) although the sql installation seems to work. I then reinstalled .net 3.5 (Which also reinstalls 3.0 and updates 2.0 to SP1. Again S!QL seems to be healthy....
My Questions are:
1) is there a better way to do this???
2) If I do it this way do you see any l;ong term problems?
Kay
Can anyone comment on the engine performance difference between SQL2005 Enterprise Edition versus Standard? I'm talking generalized performance of the engine and not admin features (parallel index operations) or scaled-storage (partitioning)
( http://www.microsoft.com/sql/editions/enterprise/comparison.mspx )
The marketing literature makes note of two things:
Enterprise can use more then 4 processors
Enhanced read-ahead and scan (super scan)
(note: I cannot find anything about this 'feature')
One un-noted Feature:
only Enterprise supports 'lock pages in memory'
We are in the process of migrating from SQL2000 to SQL2005 in an OLTP environment. Based on the marketing literature; I would have chosen SQL2005-standard. But based on our limited testing, we are seeing some strange differences.
Query Performance
With MaxDOP=1 and using a large batch query (select top 1500000); SQL2005-Enterprise is twice as fast as SQL2005-Standard.
(Note: this difference persists regardless of lock-pages-in-memory setting)
CPU Utilization
In addition, taskmgr shows that SQL2005-Enterprise uses a single processor at ~90%. While SQL2005-Standard shows a single processor at ~20%.
Lock Behavior
We are also seeing lock-behavior differences. A single DML statement that attempts to modify ~5000 rows will cause Table-locks on SQL2005-Standard but obtain normal row-locks on SQL2005-Enterprise.
These empirical differences make me wonder if the engine codebase is fundamentally different between the two?
Any insight would be appreciated.
I recognize that this question borders on blasphemy but I am curious as to whether there is a version of sql2005 express for the mac platform. Would like to keep a compatible local instance of 2005 on my mac notebook.
many thanks,
dj
Hi,
We are in the midst of developing/upgrading an online store in ASP.net 2.0 that typically gets about 100,000+ hits per week and we are considering MS SQL 2005 Express as its free to use. My question is how will MS SQL 2005 Express support so many concurrent visitors and will MS SQL 2005 Standard / MS SQL 2005 Workgroup be a better option as far as performance?
Thanks,
Kamran
Can SQL2005 Express get SSRS report server installed and run on a box that already has IIS? Thanks.
View 5 Replies View RelatedHello, I hope I am posting this question in the right forum. I have been working on some ASP applications and using them to connect to a MySQL database. I would like to move all of the data from MySQL over to SQL2005 Express. The problem is that the express version doesn't offer an import/export tool for CSV files. I am able to export my table data from MySQL to a CSV file, how can I import this data into my SQL2005 Ex database? Thanks.
Jim Miller
Hi friends,
I want to install Visual Studio .NET 2005.
I've seen that there are several questions about upgrading from SQL Express to Standard edition, so I though that if it's possible, first I install SQL Server Standard and then during installing Visual Studio I don't install SQL Express that is by default is installed, but I don't know is it possible to introduce Standard edition instead of Express edition to Visual Studio? and if it's possible, how can I do it?
would you help me?
thank you in advance.
Good day all, I apologize if this is somewhere and I didnt search enough. I currently have a nice internal application that provides company wide visibility into some key data. Im now being asked to create some reports from an Oracle 9i platform in SQL 2005 Reports Server. However the ORACLE data extension is not allowed in the express edition so Im stuck for a moment. I would like to do an inplace upgrade of my existing MS SQL server from 2005 express to 2005 standard. However, I am a little concerned it might break some things. Has anyone achieved this with great results, a mixed bag, or totally blown up their server? I would like to know the good, bad and then down right ugly details of this if there are any. I am currently running a windows 2003 server with MS SQL 2005 Express (Advanced edition to get the Report Server in there). Is it at all possible to do an inplace upgrade from Express to Standard edition and not lose any connectivity permissions, reports server and so on? Would there be 2 seperate installations one for SQL Server and another for the Report server?
Thanks in advance for all your replies, Ive used this forum on many occasions and learned alot along the way. I hope someone here can help.
I have SQL Server 2005 Express that was installed with SharePoint Server 2007. I'm trying to upgrade it to SQL Server 2005 Standard edition and it gives this "Edition Change Check (Warning)" message:
"To change an existing instance of Microsoft SQL Server 2005 to a different edition of SQL Server 2005, you must run SQL Server 2005 Setup from the command prompt and include the SKUUPGRADE=1 parameter."
I tried "setup skuupgrade=1" from the command prompt, but it's giving me the same message.
Can someone tell me how to correctly make the upgrade?
Sam
I am currently using MSDE as the Db for a website and using (cheating?)
enterprise manager i have created and scheduled a backup job that the
agent runs.
Now I am wanting to upgrade the Database to SQL2005 Express but I want
to have a similar scheduled backup job. From the reading of the
OLBs it appears I have to manually create a script but I don't know how
to schedule the running of the script.
So my questions are:
1. How do you schedule the running of a back up script in SQL Express? and,
2. Is there a tool that automates the creation of a script similar to how you do it in the old Enterprise manager?
TIA
Antony
We are coming out of the dark ages with our app using SQL 7 and, following the excellent advice of the folks here on SQLTeam, installing SQL 2005 Express on our new webserver.
Not being terribly fluent in all things SQL, I was wondering if anybody could provide input on the best practices for getting SQL 2005 Express going on the new server.
So far I've:
- Installed SQL 2005 Express
- Downloaded and "installed" the SSEUtil for CMD line instructions
- Downloaded and installed the graphical management interface (very nice, makes me feel more comfortable - like SQL 7 console!)
- Copied backup files (made using SQL backup maintenance) to the new server
Should I simply create an empty db of the same name on the 2005 server and then restore the 7 data? Or ????
I searched briefly for previous posts of this nature and didn't find too much info so I hope I'm not duplicating effort here...
Thanks in advance for any advice!
Mmmmmkay. Yeah, did you get the memo about the TPS reports?
Hi,
Ive got a SQl2005 Express server which doesnt appear on the network as an sql box. Im able to ping the server without any issues but when I try to attach to the server by using Connect option on the SMSE installed on my machine, I see my other sql 2005 express boxes and my sql2000 box but I cannot see my new SQL2005 Express box.
Any ideas?
Thanks
DW
DW
Hi
I'm trying to install sql express sp2 2005 in my laptop but i can't, give me this error
Machine : W7J
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.2.3042.00
Install : Failed
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_W7J_SQL.log
Last Action : InstallFinalize
Error String : SQL Server Setup could not connect to the database service for server configuration. The error was: {Microsoft}{SQL Native Client}{SQL Server}Login failed for user 'sa'. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
Error Number : 29515
I'm choosing Windows autentication mode, so i don't know it says "sa" user.
can you help me?
Thanks
Hi,
I have an aplication (VS2005 and Sql2005 Express), where I need to lock a table when opening one form, and then close it when completing another form.
Is there a way to do this, maybe using a Stored Procedure.? I'd prefer to be still able to access the table in read only mode if possible.
I've looked at pessimistic concurrency, but the particular part of my application is not using a dataset, being based upon SqlCommand.ExecuteScalar(), so I'm fairly sure this is not an option.
Thanks
Excuse the cross post (to VBexpress fourum) but maybe someone here will have a different take?
have searched all around can't seem to see how to configure a SQL2005 developer ed so I can use vb express to develop a local front end. keep getting "the user instance login flag is not supported on this version of sql server" I have configured the .net framework via aspnet_regsql.exe. Also I configured the "Machine.config" file. but so far no luck.
Selecting sql2005 as the server thru the add new database connection in advanced area yields the error message
surely there is away.
So far still no joy,
While Scotty indicates that the connection to SQL2005 is intentionally hampered other posters indicate that the user instance problem can be solved by running the .net config tool to add the asp database to sql server, which I have done.
However this does not yet work.
I cannot get the code to spark yet.
Again my configuration cannot be any simpler. sql express sp1 and sqldeveloper on the same machine using windows security (all installed with default cofigurations)
In the absence of other ideas I may try to get sql express downloaded and going, I'm not sure what issues that will present re: what I'm trying to develop.
I'm trying to develop the skills to replace some fairly involved reporting and some user table interface that I had going in access2003, I hate to pruchace a big piece of sw when I don't know if it will remove the current roadblocks...
Appreciate the help here, but doesn't someone have a "simpler" complete answer? I.e. one that would get the developer database to accept the connection wizard? (user instance issue)
We are developing a new online booking system with asp.net and looking for optiosn for the data store. Currently the PHP applciation utlizes MySQL but we would like to use SQL Server in the rewrite.
What limitations would we run into with Express over Standard for such a system? Is the 4GB size limit and advanced SQl features such as replication, etc the only differences? We are looking for something to run on a dedicated or VPS based Windows server that will only be running our app and database. System is an online hotel type booking system with approx 7000-12000 transactions per month which may double in the coming year.
Express certainly has a cost advantage but we don't want to run into issues with this version if there are any we should watch out for.
I have installed VS2005 with SQL Server Express. I used this setup for about a month. Now i have SQL Server Standard Edition. I am confused about how to swap them over. Everything is running on the same machine - i just want to use SQL Server Standard instead of SQL Server Express. Can anybody explain how to get this up and running?
Also will membership, profiles and the other built in providers work with this? - Thanks for any help!
- Callam
I'm considering upgrading from MSDE 2000 to Express 2005.
Before I do that I need to know if my linked server dependant
scheduled jobs will continue to function properly.
Here's my current configuration:
I have a local SQL Server 2000 Standard edition box linked via IP address to a remote MSDE 2000 SQL Server. This link
uses SQL authentication.
I want to upgrade the remote MSDE server to 2005 Express. Will my local 2000 SQL Server link successfully with a 2005 Express server?
Also, I have 2000 Developer Edition on my machine and am using Enterprise Manager where I have registered the remote MSDE so I can easily manage the server. Will I be able to register a 2005 Express server or will I need to upgrade my developer machine to 2005? If I do upgrade my developer machine, will I still be able to register the 2000 Standard Sql Server?
If there are any other issues with running a mixed environment like the one described here, please speak up! I want to make an informed
decision.
Thanks so much for your help!
Hi,
What is the best way to upgrade a SQL SERVER 2005 EXPRESS to the STANDARD version?
I am working with someone in a different state. He is using SQL Express, I am using SQL standard. He has created a large DB that i need a copy of on my machine.
Is there a way for him to make a copy of his DB so it can be placed on our FTP site for me to download?
Thanks
I've got some applications which need .NET 3. And since theoretically .NET3 is using .NET2's runtime (CLR), I'm told that applications for .NET2 should work in .NET3 as well. But I would still like to ask to have a confirmation:
Can SQL 2005 Standard edition and Express work with .NET 3 or .NET 3.5? Has Microsoft tested this and can confirm this?
TIA
I'm not a developer and would like your input to compare against what a sales rep is telling me.
I'm managing a small web project that will have a database with a max of 20,000 records with less than 50 field each. It will be hit by anything from 200 to 500 people in a day (max) via Internet connection from all over with all sorts of speed.
The users will select less than 50 filters to obtain the results of the info they are looking for among the 20000 records. Most users will only choose less than 10 filters per search.
That's all that the database will do...seems to me enterprise is way too much, but since I'm not expert, need one of you to help with your input.
Thanks very much!
Can I install SQL 2005 Express on a server that's running SQL 2000 Standard Edition?
View 6 Replies View RelatedI've got some applications which need .NET 3. And since theoretically .NET3 is using .NET2's runtime (CLR), I'm told that applications for .NET2 should work in .NET3 as well. But I would still like to ask to have a confirmation:
Can SQL 2005 Standard edition and Express work with .NET 3 or .NET 3.5? Has Microsoft tested this and can confirm this?
TIA
Hi,
I have installed SQL standard Edition in my computer for one project. We want to kick off a new project, and intend to use SQL Express, Will anybody advise me whether I can install SQL express when SQL Standard Edition is there? or I need to remove SQL standard Edition first and install SQL express?
Thanks a lot
Haihong
I developed a project (web application) using the Express editions.
How do I migrate the project from Express (SQL Server Express & VWD Express) to Visual Studio 2005 Standard and SQL Server Standard?
Thanks if you can answer this.
Ken