Anyone can tell me the difference between
Microsoft SQL Server 2005 Express Edition with Advanced Services
and
Microsoft SQL Server 2005 Express Edition Toolkit
I am wondering which one should i install
If you want to use all posisble features of express you should install both.I installed C# with SQL Server Express, however I wanted to add the Full Text Searching and the SQL Server Management Studio Express, so I downloaded and installed the SQL Server 2005 Express Edition with Advanced Services SP1. When I installed it over top of my current installation, it complained of version mismatching, and then C# failed to recognize that I had SQL 2005 Express installed at all.
What I'd like to know is, which version is more current (they have to be different, they had different version numbers, one was 9.xx.xxxx the other was 2005.9.xx.xxxx) The one bundled with C#, or the SP1 downloadable one.
Firstly, I want to be up todate as far as security patches, and Secondly, how do I add the full text searching and SSMSE to the one bundled with C# without breaking it.
THe one with Visual Studio does not have SP1 integrated, it also does not have the following features:
SQL Server Express with Advanced Services contains the following features:
SQL Server Management Studio Express, a graphical management tool based on SQL Server Management Studio that makes it easy to manage and administer SQL Server Express databases.
Reporting Services, an integrated report creation and design environment to create reports.
Full-Text Search, a powerful search engine for searching text-intensive data.
(From: http://msdn.microsoft.com/vstudio/express/sql/download/)
HTH, jens Suessmeyer.
http://www.sqlserver2005.de
|||Are there instructions for upgrading to the SP1 version?
I tried installing it directly overtop, and now it is broken.
When I try to add a database to a project, I get the following error:
Connection to SQL Server files require SQL Server Express 2005 to function properly. Please verify the isntallation of the component.
|||Follow the RTFM rule. The readme file can be found at http://go.microsoft.com/fwlink/?LinkId=58557. The instaruction there show step by step how to *migrate* the instance.
HTH, jens Suessmeyer.
http://www.sqlserver2005.desql
I installed C# with SQL Server Express, however I wanted to add the Full Text Searching and the SQL Server Management Studio Express, so I downloaded and installed the SQL Server 2005 Express Edition with Advanced Services SP1. When I installed it over top of my current installation, it complained of version mismatching, and then C# failed to recognize that I had SQL 2005 Express installed at all.
What I'd like to know is, which version is more current (they have to be different, they had different version numbers, one was 9.xx.xxxx the other was 2005.9.xx.xxxx) The one bundled with C#, or the SP1 downloadable one.
Firstly, I want to be up todate as far as security patches, and Secondly, how do I add the full text searching and SSMSE to the one bundled with C# without breaking it.
THe one with Visual Studio does not have SP1 integrated, it also does not have the following features:
SQL Server Express with Advanced Services contains the following features:
SQL Server Management Studio Express, a graphical management tool based on SQL Server Management Studio that makes it easy to manage and administer SQL Server Express databases.
Reporting Services, an integrated report creation and design environment to create reports.
Full-Text Search, a powerful search engine for searching text-intensive data.
(From: http://msdn.microsoft.com/vstudio/express/sql/download/)
HTH, jens Suessmeyer.
http://www.sqlserver2005.de
|||Are there instructions for upgrading to the SP1 version?
I tried installing it directly overtop, and now it is broken.
When I try to add a database to a project, I get the following error:
Connection to SQL Server files require SQL Server Express 2005 to function properly. Please verify the isntallation of the component.
|||Follow the RTFM rule. The readme file can be found at http://go.microsoft.com/fwlink/?LinkId=58557. The instaruction there show step by step how to *migrate* the instance.
HTH, jens Suessmeyer.
http://www.sqlserver2005.de
Are SQL Server Express & SQL Server 2005 one & the same thing? Or is the former a part of the latter? Actually when I was downloading Visual Web Developer 2005 Express, I was given the option to download Microsoft SQL Server 2005 Express Edition as well; so I am getting confused between SQL Server Express & SQL Server 2005.
I installed SQL Server 2005 in my WinXP Pro m/c. from the Microsoft website (after re-installing WinXP Pro since XP became corrupt). Earlier I used to login to Management Studio Express using my m/c. name followed by a \ followed by SQLEXPRESS as the server name. So if my m/c. name is MyPC, then I used to login to Management Studio Express using MyPC\SQLEXPRESS as the server name but now when I try to login to Management Studio Express using the above server name i.e. MyPC\SQLEXPRESS, then an error gets thrown saying
Cannot connect to MyPC\SQLEXPRESS.
Now how do I find out what's the server name so that I can login to create & manage databases in Management Studio Express?
Please note that after re-installing WinXP Pro, my m/c. name has remained the same; I didn't change it.
Thanks,
Arpan
>> Are SQL Server Express & SQL Server 2005 one & the same thing?
No. Express edition refers to the free version released by Microsoft with some limitations. Where the other editions have many other features.
The major limitations of express edition are :
* Lack of enterprise features support
* Limited to one CPU
* One GB memory limit for the buffer pool
* Databases have a 4 GB maximum size
>> Cannot connect to MyPC\SQLEXPRESS.
Please use the Browse option instead of typing the server name in Management studio to find the server.
|||Thanks, Bool, for highlighting the differences.
As far as not being able to connect to SQL Server 2005 is concerned, when I click the option <Browse for more...>, under the Local Servers tab, no servers get listed & under the Network Servers tab, 3 servers do get listed under Database Engine but none of them belong to me! Why isn't my local server not getting listed under the Local Servers tab?
What do I do next? Please help me resolve this issue.
I guess I should have mentioned this in the first thread of this post itself. It would have saved me some time. Anyway, better late than never!
Thanks once again,
Regards,
Arpan
|||These articles will point you in the right direction to connect.
Configuration -Configure SQL Server 2005 to allow remote connections
http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277
http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx
Configuration -Connect to SQL Express from "downlevel clients"
http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx
Configuration -Connect to SQL Express and ‘Stay Connected’
http://betav.com/blog/billva/2006/06/getting_and_staying_connected.html
This article will help point out the version differences:
SQL Server 2005 Features, Version Comparison
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
And this may be helpful (if you don't have it...)
SQL Server 2005 Express Books Online Express Edition
http://msdn2.microsoft.com/en-us/library/ms165706.aspx
>> under the Local Servers tab, no servers get listed
>> What do I do next? Please help me resolve this issue.
Then I think it means that the local server does not exist or has been stopped. Try to restart the server (refer some books on how to do it), or worst case, just try to reinstall the express edition database engine again.
Three things:
1 - I attached a database from another computer in the Microsoft SQL Server Management Studio Express tool. It looks like my database diagrams did not follow.At first, it told me that the owner of the database was not set correctly and, hence, diagrams could not be supported. I ran the following query to fix that -> Alter authorization on database::DB_NAME to [MACHINE_NAME\USER]. Now, I can create new diagrams but I would like to see the ones I had before. How can I transfer my database files (.mdf and .ldf) with the diagrams?
2 – I would like to generate a database script that would not only create the table structure but also generate the insert statements to populate the database. When I use the “generate scripts” wizard, I don’t see an option where I could get the insert statements included in the script.Any help would be appreciated.
3 - I would like to read/find a short tutorial on how to set up security for my database. For now, I use the default user/security everywhere and I am sure it is not a good way of doing things. Basically, I would like to make sure I am not leaving a big security hole without having to read an entire book on SQL Server.Where could I get started?
Thanks a lot,
Dom.
1/ the diagrams should have come across with the database as they are stored in special tables, was this a SQL 2000 db that was upgraded by any chance?
2/ There is no way to generate insert statements in the UI today, there are some samples out in the community that can do it through.
3/ Have you read books on line?
|||1 - No this is not a database upgrade, a SQL Server 2005 Express Edition to SQL Server 2005 Express Edition
2 - This is sad, there should be something to generate insert statements.
3 - Do you have any good ones to suggest?
thanks.
|||Check out Securing your SQL Server Express Edition Server, it's from beta, but all the prinicples apply. You can also read the various pages of the BOL linked to from the Security Consideration for SQL Server topic.
Regards,
Mike Wachal
SQL Express team
-
Mark the best posts as Answers!
I am new to SQL server 2005. I am developing stored procedures as follows in Management Studio:
1)Right click Stored Procedures folder on a database
2)Select "New Stored Procedure"
3)Write the query in a .sql file
4)Execute the query.
Now in this model, I dont seem to have a develop->test->develop and then deploy, type of development cycle. The problem is each time I execute a query it is deployed and re-executing it results in an error like: "There is already an object named 'NewEmployee' in the database." Which forces you to manually delete the SP and re-execute your query. It doesn't give you a chance to test your SP logic before deploying. Contrary to this, If I developed CLR SP's in Visual Studio, I would test/debug the procedure, and then "deploy" it later when I'm finished with it. Can I not do this in Management Studio?
Thanks,
Bahadir
right click the existing stored proc
click on "script stored procedure as">alter>"new query editor"
modify the scripts
and run
|||Doh! I think this was a bit stupid question. More clever next time :)Thanks,
Bahadir
I am new to SQL server 2005. I am developing stored procedures as follows in Management Studio:
1)Right click Stored Procedures folder on a database
2)Select "New Stored Procedure"
3)Write the query in a .sql file
4)Execute the query.
Now in this model, I dont seem to have a develop->test->develop and then deploy, type of development cycle. The problem is each time I execute a query it is deployed and re-executing it results in an error like: "There is already an object named 'NewEmployee' in the database." Which forces you to manually delete the SP and re-execute your query. It doesn't give you a chance to test your SP logic before deploying. Contrary to this, If I developed CLR SP's in Visual Studio, I would test/debug the procedure, and then "deploy" it later when I'm finished with it. Can I not do this in Management Studio?
Thanks,
Bahadir
right click the existing stored proc
click on "script stored procedure as">alter>"new query editor"
modify the scripts
and run
|||Doh! I think this was a bit stupid question. More clever next time :)
Thanks,
Bahadir
I have the full version of SQL Server installed on my machine and am developing an app using BI DTS packages, VB.Net, SQL SPs, etc.. I will need to deploy this app w/SQL Server Express (SSE).
-Do I have to install SSE on my development machine for the purpose of creating the install package of my application? I am afraid that if I do install SSE on my machine, it may mess up my installation of the full version of SQL Server... will it?
-Can you point me to a link with information about how to do the development with the full version of SS, and create the installation package using the SSE?
Thanks for your help.
Steph
You cannot deployment SQL Server 2005 Integration Services packages in SQL Server Express because the runtime now comes with the server license. In SQL Server 2000 the DTS package comes with the runtime that changed in 2005. Hope this helps.|||Thanks for the response.
The way I posed my question was misleading. I'm sorry about that. I shouldn't even have mentioned the DTS packages.
The big picture of the app is this:
- Data resides in a datamart at a central office. The central office will be running the full SQL Server 2005 version (this is where the DTS packages reside and run).
- Satellite (very small) offices need to download updated information relating to them from the central office. I'm thinking of having these satellite offices run SQL Express.
I'm developing the code to update the satellite office data from the central office data. On my development system, I am running the full version of SQL Server 2005. Should I also install SQL Express on my development system ? Will it mess up my full SQL Server 2005 installation?
Thanks,
Steph
|||It is tricky but here is how you could do it legally create Asp.net application run it from your main office SQL Server create a job to execute the many versions of the package make your small offices destination. It will take more work but the alternative solution may cost you more hardware SQL Server Express can be a subscriber in replication so you can push the data with replication. You could always talk to your local Microsoft SQL Server contact person, in some areas there is regional contact person. Hope this helps
Hi,
I'm trying to use reporting services in teh VS2003 but the Option to I create the project does not appear, i've already installed SP3 and no success, any idea ?
Thanks
Which reporting service? I don't believe SQL 2000 Reporting Services is supported on MSDE. You should probably be asking this question in a Visual Studio forum rather than a SQL forum.
Mike
|||Ok, then
Thanks... And do you Know if SQL 2005 Express has this service ?
Thanks
|||Yes, SQL Express with Advanced Services includes Reporting Services. The tool to create reports, BIDS, is available in the SQL Express Toolkit. Both can be downloaded from http://msdn.microsoft.com/vstudio/express/sql/download.
Regards,
Mike Wachal
SQL Express team
Nice....
Another thing, I have an application that is currently using MSDE, I use some stored procedures and functions.... Is it all compatible with SQL Express 2005 do I need to change anything in my application ?
Thanks
|||Hi, question regarding developing a report using SQL Express with advanced/reporting services. I have all packages installed correctly (I think) but am unable to start the BI report developer tool because the Start menu shortcut for the business intelligence development studio points to an executable that is not there. It points to: "C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\devenv.exe"
FYI, I am running Windows XP SP2 and do not have Visual Studio installed, although I do have Visual C# Express installed. There is a VCSExpress.exe in that directory, if that helps.
I can access the web based links for the reporting services manager at http://localhost/Reports$SQLExpress with no problems.
Any idea on how to use the report developer tool?
Thanks,
Todd
In Visual Web Developer 2005 Express if I connect to the database and view some table data I can do that fine but then as soon as I try to view a page in the browser I get the error:
Login failed for user 'MachineName\ASPNET'
If in web developer I go to the database explorer and close the connection to the database then refresh the page it all works fine.
Anyone have anyideas on how to correct this?
Thanks
Scott
This is a frequently asked issue
The login 'MachineName\ASPNET' is used by IIS when your website trying to connect to SQL with Window Authentication (Integrated Security=SSPI). So in this case just add the account to SQL Server Logins with proper database permissions, which can be easily done in Management Studio: go to Security->Logins->right clich and choose add login->add the Windows account 'MachineName\ASPNET' and give it permissions (or simply add it to sysadmin server role). You can download Management Studio Express from here:
http://msdn.microsoft.com/vstudio/express/sql/download/
I am trying to compare developer edition and Express edition. I almost purchased the developer edition and wanted to compare it with other editions. no info to be found. Would greatly appreciate it, if someone could direct me to a resourse that shows this comparision.
thanks
ps.The product comparision page doesnt show developer edition.
Hi,have a look here:
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
HTH, Jens K. Suessmeyer.
-
http://www.sqlserver2005.de
-
If someone could point to some articles or documents that explains this in detail I would really appreciate it.
Thanks.
Express and Developer can install side-by-side. Application should be developed Edition agnostic. However, there is a feature in Express (User Instances) that is not available in other Editions. Keep an eye on MSDN for new content.
Dan
http://blogs.msdn.com/dtjones
SQL Server Express will support multiple users. To connect from other computers you must first enable "Local and remote connections" in the Surface Area configuration tool .
Karl
|||You should also read the Blog entry at http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx. You may need to enable SQL Browser and create Excpetions in your Firewall to allow people to connect to your SQL Express server. It all depends on the configuration of your computer and how you want to connect.
Regards,
Mike Wachal
SQL Express
