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

Post New Web Links

Removing a Server name From SSMS

Posted By:      Posted Date: September 29, 2010    Points: 0   Category :Sql Server

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


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

View Complete Post

More Related Resource Links

SQL Server 2008 SSMS disappear after removing one instance



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.


Any issues removing backup mount point cluster resources from SQL Server dependencies?

Win 2003, SQL 2005/SQL2008 64 bit enterprise failover cluster with 3 nodes and 6 instances. The mount points configured as cluster resources for the data/backup/logs. The entire cluster mount points are SAN replicated to a DR Site. But backup drives/LUNs are excluded from the replication. All the disk resources including backup LUNs are set to dependencies on the SQL Server server. The SQL Server is not coming on-line in the DR Site due to unavailability of the backup LUNs (failed resources). As per the documentation all the disk resources must be set to dependencies (http://support.microsoft.com/kb/835185). Thought it did not specifically mentions only Data/Log mount points and/or the backup LUNs as well. "The SQL Server 2005 resource depends on the SQL network name resource and the physical disk resources that hold its data. When mount points are being used together with the physical disks, each mount point must appear as a cluster resource. Additionally, each mount point must also be added as a SQL Server dependency. If only the root physical disks dependency is added and the mount points are not added, database corruption will occur on failover. Database corruption may also occur when SQL Server is restarted without failing over. "     What if I remove the backup LUNs from dependencies list. This will allow me to recover the SQL Server

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

When to add "tcp:" to "Server name:" connecting from SSMS remotely

Having read in [1] that to connect to the database engine from another computer using SSMS "In the Server name box, type tcp: to specify the protocol, followed by the computer name... type tcp:<computer_name>. In our example for a named instance, type tcp:<computer_name>,49172", why do I connect to remote server without adding "tcp:"? I do not remember adding "tcp:" connecting to earlier versions of MS SQL server either... [1] Connecting to the Database Engine from Another Computer(MS SQL Server 2008 R2) http://msdn.microsoft.com/en-us/library/ms345343.aspx#otherComp

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

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.

SSMS - Connect to Server dialog box - server history not showing


When I invoke SSMS, the "Connect to Sever" dialog box comes up.  Under the "Server Name" dropdown, it only displays a maximun of history entries (previously used connections/servers).  On other machines, it shows 10-15 previously used servers.

Does anyone know what I need to do or what needs to be configured on my machine to allow it to store my history entries?  If I connect to a new server, then one of the existing gets dropped off.  Just got tired of entering server names here...

Thank you very much.

Cannot Install SQL Server Management Studio after removing Express edition


I'm trying to upgrade my management studio to the full version, I uninstalled Express edition and started the install for the full version, but I get an error stating "you cannot install this component because it is already installed". I had a word with one of the guys in the office and he said the only way he's ever been able to get round this is by flattening the entire PC and starting again. Obviously I want to avoid that!

SQL Server Management Stduio 10.0 (SSMS) Window Menu Listing Open Windows


In SSMS for 2008 the windows menu listing of open files is inconsistent.

When only windows that have previously been saved to a file are opened the Window menus lists as follows:
File Name - Connection (Username(spid)) - This is perfect since the file name is at the front and it's easy to identify a window

However, when an unsaved window is open (typically named SQLQueryX.sql) along with these saved windows the Window menu lists as follows:
File Name - Connection (Username(spid)) - Only for the first (active) window
C:\...\Connection (Username(spid)) - For remaining windows - this is annoying since we can't easily identify the windows by file name

Sql server 2008 R2 x64 / SSMS : Intermittent Connectivity Issue


I have read almost everything on this topic, applied each proposed solution, checked all conf settings but I am stil stuck with these frequent but intermittent connectivity issues.

I moved our databases from a win 2003 + SQL Server 2005 x86 enterprise (where I had no connectivity issue) to a clean install of SQL server 2008 R2 x64 enterprise on Windows Server 2008 R2 x64. Enabled tcp/ip & named pipes, recreated the users (& fixed orphans), opened ports on firewalls client, hardware, even Win Server although it is disabled, applied the UC4 patches, tried various connection strings, created aliases (for x64 and x32), ran the different recommended tools (portQryV2...) to no avail.

Most of the time, I can connect, with SSMS or via code with SqlConnection and execute queries. But frequently, I either lose the connection or cannot connect on the first call. Then it works on subsequent calls. In vb, the  code hangs on the call of the open method of the SqlConnection (and yes I properly close my connections once the queries have been executed). Setting the CommandTimeout has no effect. The code/SSMS freezes for 30/40 seconds.

No error is showing up in the Profiler, Nothing in the SQL Server Logs. The client and the server are on different networks. I connect via TCP/IP(remot

Error removing SharePoint Server 2007


I am having issues removing a SharePoint 2007 server from the farm.  I have disconnected the server from SharePoint but the server is still showing in CA.   When I click the remove server link I get this error message below.  Version I am using the SharePoint System account to removed the SharePoint server. 

All the servers in the Farm are having major issues and I need to rebuild each one of them.   How can I correct this error so I can removed the server from CA?  Is there another way I can removed this server correctly?

Object reference not set to an instance of an object.   at Microsoft.SharePoint.Administration.SPConfigurationDatabase.DeleteObject(Guid id)
   at Microsoft.SharePoint.Administration.SPConfigurationDatabase.DeleteObject(SPPersistedObject obj)
   at Microsoft.SharePoint.Administration.SPPersistedObject.Delete()
   at Microsoft.SharePoint.Administration.SPServer.Delete()
   at Microsoft.SharePoint.WebControls.TopologyView.RemoveLink_Click(Object sender, CommandEventArgs e)
   at System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e)
   at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandle

Can't log into a SQL Server 2005 Integration Services with SSMS 2008.


We have a server running SQL Server 2005 Ent on a Windows Server 2003 platform. It runs just fine and I have no problem accessing any of the Business Intelligence services using SSMS 2005.

I recently upgraded my development PC to SQL Server 2008 as we'll be deploying it to our production servers in the next few days. I am able to access the Database Engine, SSAS and SSRS on the 2005 server with SSMS 2008, but when I try to log into Integration Services, I get the following error:

TITLE: Connect to Server
Cannot connect to servername.
Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

Connect to SSIS Service on machine "servername." failed:
Class not registered

Luckily I did not uninstall SSMS 2005, so I can still access it from there, but it would be nice if I could use just one client. I'm also afraid that this might happen after the production server gets upgraded.

Thanks in advance for any help in resolving this.

Thanks Ron...

Can we Implement in SQL MDX query SQL Signature as in normal SSMS(SQL Server Management Studio)


Can we implement SQL query signature in SQL MDX query? how can we implement the same

Connect SQL Server 2005 SSMS to SQL Server 2008


is it ok to connect to sql server2008 server form sql server 2005 management studio. If yes, can you please let me know what should i do ?

editor for xml fields in SQL server 2008 R2 SSMS?



I have a question regarding possibility of editing XML fields via SQL server management studio. I know that this "feature" isnt provided in SQL server 2008, but I was wondering whether microsoft wasnt thinking ahead and maybe added this "feature" to SQL server 2008 R2?

If not, is there some workaround except for creating application for that?
I have found something called xmlspy which is used for this matter. But I dont see a reason why should someone buy that, I think this "feature" should be included in SSMS.

thanks in advance



Login SQL Server with Dynamic Code and block SSMS remote connection


Dear all,

- Can we configure SQL Server login integrated using Dynamic Code (TOKEN) ?

As far i know , we can use Dynamic code / Token with Login Windows, but i dont know about Token/Dynamic Code with SQL Server login.

- and can we block SSMS Remote connection, so we cannot connect using SSMS /Query analyzer to the server. The only way is local connection.

thanks in advance

Our Environments :
-SQL Server 2K8EE integrated with LUna HSM & RSA

-Win Server 2k8EE


Regards, Mathias.Arya

call JavaScript - jQuery code from ASP.NET Server-Side

jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side.
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