Is it ok to use the RTM release of management studio express R2 in a production environment?
When will it be officially realeased? The engine was released on 9/29/2010....
View Complete Post
I just installed SQL Server 2008 Management studio Express on my Vista machine. i tried connecting to local machine using :.\sqlexpress, (local)\sqlexpress, or .\SQLExpress, MyPCNAME\SQLExpressnothing is working, getting this error:-----------------------------Cannot
connect to PC-NAME\SQLEXPRESS. A network-related or instance-specific
error occurred while establishing a connection to SQL Server. The server
was not found or was not accessible. Verify that the instance name is
correct and that SQL Server is configured to allow remote connections.
(provider: SQL Network Interfaces, error: 26 - Error Locating
We have SQL server 2008 installed in a virtual server and I just want to download tools for querying etc...om my pc. I downloaded the SQL Server 2008 Managemnt Express and installed the tools. My DBA is saying remove the express install and install the tools
from the full version. Is he correct or could I have used the SSME install to query the full version?
I can't get the SQL Server Management Studio to install. I'm running Windows 7 (32-bit), and have successfully installed the Sql Server 2008 R2 developer edition (from dreamspark.com). Some of the SQL Server (SQLEXPRESS) advanced Properties are
File Version: 2007.100.4000.0
Instance ID: MSSQL10.SQLEXPRESS
64-bit OS: No
Service Pack Level: 2
I downloaded the x86 SSMS 2008 express from http://www.microsoft.com/downloads/en/details.aspx?FamilyID=08e52ac2-1d62-45f6-9a4a-4b76a8564a2b
When I execute the download, I get a compatibility issues message stating I must apply SQL Server 2008 SP1 or later before I run SS2008 on my version of windows. When I run the program, it extracts all the files and then launches the SQL Server Installation
I select the "Installation" option for a new SS stand-alone or add features, which then launches the Setup Support Rules (Passed: 7, Failed: 0, W:0 S:0). I click OK, advancing to the Setup Support Files stage. Clicking on install completes
(P:10 F:0 W:1 (firewall) S:0), and then clicking on Next brings me to the Installation Type screen. I select the Add Features radio button & click Next, which then brings me to the Feature Selection screen.
It is here where I get stuck because I can't select any
Why do you make it so, so complicated?
I just want to install the piece of software that manages Azure databases. I've being downloading all kinds of files all day, getting incomprehensible error messages, and still am getting no where!
I'vw worked out that it's not this file: SQLManagementStudio_x86_ENU.exe
or this one: SQLEXPRWT_x86_ENU.exe
So please, which file is it, and where can I download it?
I tried to install SQL Server 2008 R1 Express with Tools on Windows Server 2008 R2. It installed, but the management studio failed to install because it said I already had Visual Studio installed and it needed Visual Studio service pack 1 before Management
Studio could install.
Visual Studio is nowhere to be found in Programs and Features, and when I try to install Visual Studio SP1, it won't install, saying:
A compatible version of Visual Studio 2008 was not detected on the system. This update is designed for only the Microsoft Visual Studio 2008 (ENU) product family, and is not compatible with any Express editions.
Though I can't find any Express version of SP1 to try, and there is no SP1 in windows update.
What the heck? Why am I getting this error? Server worked but I can not run Management Studio.
Edition update http://support.microsoft.com/kb/971268 does not help.
remove and fresh install Management Studio does not help.
I need to be able to manage a SQL Server 2008 database on a remote server. The hosting company suggests SQL Server Management Studio 2008 Express since I'm on a low budget. The first thing I found when researching this was a MS warning that SQL Server Management Studio Express shouldn't be used with hosted environments. The more I read, the more it looks like it would work but the more confused I get. If any of you have experience with this or know of a good tutorial covering it I'd be very grateful. Just getting SQL Server Management Studio 2008 Express installed has been a pain with needing .Net Framework 4.0 and updates and has eaten up hours I hadn't planned on.
My local OS is Windows 7 and the hosting server is Windows Server 2008.
I've been struggling with the following issue for 3 days: I can access and use my SQL Express 2008R2 database flawlessly from SQL Server Management Studio. But I can only intermittently
access it from Visual Studio (ultimate edition with TF Server). Sometimes it works, sometimes it doesn't. I mostly see the error when I try to "Update Model from Database" within my Entity framework model, or when I try to access the database from
within Server Explorer.
Here is the error I see when I try to update my Entities form the Database: An error occurred while connecting to the database. The database
might be unavailable. An exception of type 'System.Data.SqlClient.SqlException' occurred. The error message is: 'Cannot open user default database. Login failed. Login failed for user 'Tim-PC\Tim'.'
I think the connection string is fine as I am able to connect