I can not find a SQL management studio installation that will install the management only (client) without installing the DB itself, as it was with 2005.
Does Microsoft supply such setup?
View Complete Post
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.
I've posted my problem in a few other categories. Sorry for that. I didn't see the security category until now.
I'm trying to use ASP.NET's built-in role/user management for a couple ASP.NET MVC 2 sites. I'm using the MVCMusicStore as my guide. I click on the Configuration Tool as the tutorial suggests, which launches the site administration page. Unfortunately when I click on the security tab, I get an error that it cannot connect to the data store. Attempting to test the AspNetSqlProvider gives me a similar error.
I've run the aspnet_regsql program as the error message suggested, and I have a role/user management database ready to go on the server. The proper tables are constructed, and all that. The configuration tool still doesn't see the data store.
As a test, I ran the MVCMusicStore demo in the debugger. Its role/user management functionality worked. I was able to add myself as a customer, and add/remove items from my cart with no errors or exceptions. However, when I attempted to access its security tab in the configuration tool, I received the same error as I get for my own project. How is it possible that role/user management works, but the configuration tool cannot change its settings?
Any suggestions on how I can get the configuration t
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