.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Sharon Maxwell
Post New Web Links

SQL Server 2008 SSMS disappear after removing one instance

Posted By:      Posted Date: October 08, 2010    Points: 0   Category :Sql Server
 

Hi,


I just removed one SQL Server 2008 instance from my Windows Server 2008.
The SQL Server is working, but however, I can't find the SQL Server Management Studio in that server.
Do I need to install extra SQL Server 2008 components or what?
Thanks for help.

Jason




View Complete Post


More Related Resource Links

How to connect to local instance of SQL Server 2008 Management Studio Express ?

  

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\SQLExpress

nothing 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 Server/Instance Specified)
----------------------------


SSMS on networked machine - can see server but not instance

  
Hi, We have been running sql server 2008 enterprise on a single networked machine (SBS 2008) which is also runs DHCP and DNS.  We have bought a new server to just run SQL Server 2008 and I cannot manage to connect to it via SSMS from my laptop - I can see the server but not the instance.   Here is roughly what I have done: Installed Windows Server 2008 Enterprise on the box Installed SQL Server 2008 Enterprise on the box Create a named instance Configured instance to listen on TCP 1533 Created a new firewall rule to allow traffic through on TCP 1533 Created a new rule for sqlsrvr.exe on the firewall I have the services loging on with the following accounts: SQL Server Integration Services 10.0 = DOMAIN\dbadmin = running = automatic SQL Server Analysis Services = DOMAIN\dbadmin = running = automatic SQL Server (namedinstance) = DOMAIN\dbadmin = running = automatic SQL Full-text Filter Daemon Launcher = NT AUTHORITY\LocalService = running = manual SQL Server Reporting Services = NT AUTHORITY\LocalService = running = automatic - this is installed but not configured SQL Server Agent = DOMAIN\dbadmin = Stopped = manual SQL Server Browser = LocalSystem = running = automatic When I log onto the new box as a domain user and log into management studio on my laptop I can then suddenly see the instance and connect. It sounds to me that it is a permissions / acc

installed ms sql server 2008 and there is no db instance

  
I had the 2005 version on installed on my pc...I installed visual studio 2010 professional but the sql 2005 did not work. I tried to install sql 2008 but I was unable to. Searched on the web and found out that I had to uninstall sql 2005 for some reason. I did. I successfully installed sql 2008 now but there is no database instance. I tried sqlcmd -L and there where no servers available.   Can I install I new instance now? How can I do that?

named instance sql server 2008 install on cluster

  
I have a production two-node cluster with sql server 2008 sp1 cu7 running over windows server 2008 sp2. If I were to install a new named instance on this live environment, would it impair the default sql server instance functionality? I'm not referring to processor/io while the install is in progress. My question specifically is would the install process by its nature bring down the default instance. I'm pretty sure it won't, but don't see any documentation that would confirm this. thanks.

Can not connect to user instance of SQL Server 2008 Express with Advance Services in Visual Studio 2

  
I used SQL Server 2008 Express with Advanced Services (not SQL Server 2008 Express) in Visual Studio 2010 because it is the fast and easy way to developed and managed data-driven applications with powerful built-in reporting and full-text search functionality. I received Sql Server 2008 Service Pack 1 with Windows Update. It's ok if I connect to instance of SQL Server 2008 Express with Advance Services (with SP1) through SQL Server Management, but if I try to attach a database in Server Explorer (Visual Studio 2010), I get the following error: "Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed." I'm stuck at this point. Is there a fix or a workaround? I've already tried deleting the 'C:\Users\Administrtor\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS' directory as mentioned in other posts, with no luck. The error.log at 'C:\Users\Administrator\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS\error.log' has the following relevant entries: 2010-09-01 14:44:10.47 Server      Error: 17156, Severity: 16, State: 1. 2010-09-01 14:44:10.47 Server      initeventlog: Could not initiate the EventLog Service for the key '3677F6D3-17C7-4F', last error code is 2. 2010-09-01 14:44:10.47 Server &

Failed to generate a user instance of SQL Server 2008 Express with Advance Services in Visual Studio

  
I used SQL Server 2008 Express with Advanced Services (not SQL Server 2008 Express) in Visual Studio 2010 because it is the fast and easy way to developed and managed data-driven applications with powerful built-in reporting and full-text search functionality. I received Sql Server 2008 Service Pack 1 with Windows Update. It's ok if I connect to instance of SQL Server 2008 Express with Advance Services (with SP1) through SQL Server Management, but if I try to attach a database in Server Explorer (Visual Studio 2010), I get the following error: "Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed." I'm stuck at this point. Is there a fix or a workaround? I've already tried deleting the 'C:\Users\Administrtor\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS' directory as mentioned in other posts, with no luck. The error.log at 'C:\Users\Administrator\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS\error.log' has the following relevant entries: 2010-09-01 14:44:10.47 Server      Error: 17156, Severity: 16, State: 1. 2010-09-01 14:44:10.47 Server      initeventlog: Could not initiate the EventLog Service for the key '3677F6D3-17C7-4F', last error code is 2. 2010-09-01 14:44:10.47 Server &

sql server 2008 cluster multi instance

  
we have a cluster with 2 nodes and we are thinking to add another instance so that node 1 takes care of instance 1 and node 2 takes care of instance 2, and at anytime they are watching each other's back. How is this done???? what is the procedure? thanks.  

SSMS 2008 Activity Monitor Activity Monitor is unable to execute queries against server (SQL Server

  
I get the following error when running SQL Server SSMS 2008 (32-bit) on my (Windows 7 64-bit) workstation against our SQL Server 2005 (32-bit) development server running Windows Server 2003 (32-bit): TITLE: Microsoft SQL Server Management Studio ------------------------------ The Activity Monitor is unable to execute queries against server <my server\instance name>. Activity Monitor for this instance will be placed into a paused state. Use the context menu in the overview pane to resume the Activity Monitor. ------------------------------ ADDITIONAL INFORMATION: Unable to find SQL Server process ID 2256 on server VTX-DEV-01 (Microsoft.SqlServer.Management.ResourceMonitoring)   I can expand the panes and all display data except Overview and Data File I/O. This is true for all instances on that server. The SSMS 2005 Activity Monitor (also on my workstation) works fine when connected to that server. I checked for the registry setting to disable the performance counters on both my machine and the server, and it was not there. I started the Performance Counter DLL Host on my machine, but that made no difference. I can see all Processor counters on the server from my local Performance Monitor. I ran "lodctr /R" on both systems, but that didn't help. The only SQL counters I see on the server (from my workstation) are SQLServer:SSIS Pipeline and SQLServer:SSIS

Rebooting one Instance on a SQL 2008 Server with multiple instances installed

  
Hello, Hoping someone can answer the following questions ... If I have SQL Server 2008 with multiple Named Instances configured on it, can I reboot one Named Instance without rebooting any of the other Named Instances, or without having to reboot the entire server ? For example, if I have an application that needs to be re-booted and it requires the Database to be re-booted. Regards, JD

PERFMON: Cannot see SQL Server 2008 R2 64 bit instance counters from remote machine

  
Hi, I have 2 machines X and Y. I am using X machine to run perfmon which will remote connect to Y machine and collect the counters for Y machine. I am surprised to see that I am not able to see the counters for SQL Server 2008 R2 64 bit when I remote connect the perfmon on X machine to Y machine. However, when I directly log in to Y machine and open perfmon, I can see the counters for SQL Server 2008 R2 64 bit !! What is not allowing me to see those counters while connecting remotely? I have same adminstrator rights on both machine for my login and use same login details to log into both machines. Both machiens X and Y are in same network and same domain. Any help will be appreciated.

Create new instance of sql 2008 R2 server

  
Is there a way to create a instace of sql server just using my pc name? Currently sql uses 'machine name\instance name'

SQL Server 2005 and SSMS 2008

  

Hi folks

All am asking is, can SQL Server management studio express 2008 work on VS 2008 with SQL Server 2005 database? to administer it.


problem with connecting to local SQL Server 2008 default instance using windows authentication

  

Hello, 

 

I have a user getting some problem with connecting to local SQL Server 2008 default instance using windows authentication with a user which has sysadmin role and is owner of each existing database:

2010-09-28 15:40:35.04 Logon       Error: 18456, Severity: 14, State: 11.

 

2010-09-28 15:40:35.04 Logon       Login failed for user 'IIS APPPOOL\RoomViewSEWebClient'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: 127.0.0.1]

 

 

This us

Removing a Server name From SSMS

  

Hi all, When I start SS Management Studio I am presented with the "Connect to Server" dialog window. I want to remove one of the obsolete items in the "Server name" dropdown. 

I got a reference to same problem

http://social.msdn.microsoft.com/forums/en-us/sqlsetupandupgrade/thread/21E91E52-1E9E-4A7A-8636-AED4227FE9E7

but that thing does not work for me ...may be because I am using Sql server 2008 R2...


SQL Server Express 2008 instance fails to start

  

I've installed SQL Server Express with a named instance 'SQLSERVER2'. I was able to connect to it and reference it in the management studio. There was a problem though with Visual Studio 9 when running an ASP.NET web application that required connecting to the same instance. So, I went into the configuration manager to change the security level of the instance from network to local service. The change went through but could not restart the instance. That is what has created my next round of problems. I can't go in and change it back to network because the instance is permanently stopped. I cannot start it with the services manager. How can I fix this?

Here is the connection log:

2009-12-21 11:36:32.20 Server      Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)
 Jul  9 2008 14:43:34
 Copyright (c) 1988-2008 Microsoft Corporation
 Express Edition with Advanced Services on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)

2009-12-21 11:36:32.50 Server      (c) 2005 Microsoft Corporation.
2009-12-21 11:36:32.51 Server      All rights reserved.
2009-12-21 11:36:32.51 Server      Server process ID is 21856.
2009-12-21 11:36:32.51 Server      Authentication mode

SQL Server 2008 instance question

  

Hi,

Is it possible to install a SQL Server 2008 without giving it an instance name?  So that my dotnet applications' connection string won't need to change to "data source:dbServer\Instance;...", and still can use the "data source:dbServer;..."
Thanks for help.

Jason


Report Server Instance not shown in SQL 2008 R2 version for Configuration Manager

  

Hi,

I am using Windows Server 2003. I have installed SQL Server 2005 and SQL 2008 R2 version in the machine. The sql server 2008 R2 version has the instance name as SQL2008R2

I am trying to configure "Reporting services Configuration Manager" for the SQL 2008 r2. I gave the machine name and hit the Find button, I am not able to get the Report server instance name.

But when I gave the server name, i am able to browse to the folders page in the Internet explorer. so the server is available . I gave like this in the IE, and I am able to see the page:

http://Server IP/Reports_SQL2008R2/Pages/Folder.aspx

In the eventvwr, I found the following errror "The Drive:\Program Files\Microsoft SQL Server\MSRS10_50.SQL2008R2\Reporting Services\ReportServer\RSReportServer.config file failed to load. This error may occur if the XML is not valid. "

How to get the Report server instance name in the configuration manager.

Thank you


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend