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

Top 5 Contributors of the Month
Post New Web Links

Missing default instance

Posted By:      Posted Date: October 05, 2010    Points: 0   Category :Sql Server
I am in a new company now and my machine has SQL Server 2008 installed. The only problem is, from what I am told, none of the machines here have a local instance installed, just connections to external instances such as a development and production environments. Without having the installation disc, is it possible to install a local instance on my machine without raising any red flags? If so, can you please provide the steps involved? Also would anyone know why a company would not want a local instance installed on a machine? It makes no sense because live data can still be accessed at external sources. Thanks in advance for any help.

View Complete Post

More Related Resource Links

Instance and Default connection properties on SQL Server 2005

We had a sql server fail and I have been having troubles.  I compared the connection properties on the server properties and noticed that multiple default settings are no longer set.  So I'm wondering if during the failure these could have some gotten flipped.  DB's that worked all of a sudden don't work and we had to migrate to a different instance.  I have never changed any of the setings below and wonder what impact they would have if I changed them back to the default of an installed instance? ansi warning is checked ansi padding is checked ANSI NULLS is checked arithmetic abort is checked quoted identified is checked No Count is checked concat null yields null is checked Could anyone tell me how clearing these checked options will impact my db?   -- Paul Bergson MVP - Directory Services MCITP: Enterprise Administrator MCTS, MCT, MCSE, MCSA, Security+, BS CSci 2008, Vista, 2003, 2000 (Early Achiever), NT4 http://www.pbbergs.com    Twitter @pbbergs Please no e-mails, any questions should be posted in the NewsGroup This posting is provided "AS IS" with no warranties, and confers no rights.

SmoApplication.EnumAvailableSqlServers() does not list default instance if sqlexpress is in same mac

Hi I am using SMO to find available sqlservers of a network.But in one machine it doesnot give Default instance name but for all other machines it gives the named and default instance wil be showing. Observe my Scenario. Ex: Machine Name :rkwrk3-vm-sr (local machine from where i am running app in which sqlserver2008 installed)    in this actually i have sql2008 as default instance and sqlexpress(2005) as named instance...    But it shows only one instance rkwrk3-vm-sr\sqlexpress and it doesnot ahows rkwrk3-vm-sr.    and some other machines Hr-2k3-tm(where sqlserver2005 installed)    for this it is showing Hr-2k3-tm and Hr-2k3-tm/sqlexpress How can i fix this .Any Help wil Greately Appreciated. Thanks in Advance.

SQL 2005 Server export to Foxpro fails by "default codepage missing"

Hi, I just tried to apply the foxpro driver VFPOLEDBSetup.msi to import and export an old format dbf. First of all no other method is available in this case, as one of the dbf-tables holds about 9 million rows. I don't want to (manually) go to excel and wait for 10 years importing it there, then only to discover i need another 10 years to get it into sql server.   Here's my task at hand: Source: street/housenumber database with approx 9 million rows Task:  Convert it to SQL server database (import DTS)           Change some data Export it back to DBF format. I don't have any problems acting on the first two steps (dts import to SQL 2k5 and changing data) I doooo have some problems with the last part. As soon as i define the DTS through the wizzard, it leaves the "CodePage" blank. However, upon executing it i receive some warnings and finally errors: On the "Setting Destination Connection" action in the final execution progress window: - Setting Destination Connection (Warning) Messages Warning 0x80202066: Destination - housenum [40]: Cannot retrieve the column code page info from the OLE DB provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the co

InstancePersistenceCommand interrupted due to missing instance

  Hi I created a workflow service in which I have 2 RecieveAndSendReply activities that communicate on a single handle (initialized with a Query Correlation Initializer on the variable VacationId). When I run the workflow service WCFClient and execute the StartVacation service all works fine and I get response as expected. After that I execute the ProcessVacation service with received VacationId, I get the following error:   The execution of an InstancePersistenceCommand was interrupted because the instance key '0abf323d-09a0-dcaa-8a37-1295507e9cd7' was not associated to an instance. This can occur because the instance or key has been cleaned up, or because the key is invalid. The key may be invalid if the message it was generated from was sent at the wrong time or contained incorrect correlation data. Server stack trace:    at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc)    at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)    at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)    at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message) Exception rethro

Missing column statistics from default trace

I am seeing Missing statistics events on my default trace and was wondering whether I need to create statistics on the table. Missing Column Statistics Is this a good practice considering the advice on http://msdn.microsoft.com/en-us/library/ms190397.aspx

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




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:]



This us

BDC: Cannot create default instance on a Parameter with DircetionType 'Out', 'Return' or 'SqlRe



I created a ADF with the Application Definition Designer. Some things are allready working, some don't. One thing I want to achieve is the filtering on wildcard filters. I defined a method for a "Customers" table and added two "in"-parameters for "Name" and "FirstName". I also added an instance of type "Finder". Now I want to receive some data from this query with help of the "Execute" feature of the Application Definition Designer. But this return only an error "Cannot create default instance on a Parameter with DircetionType 'Out', 'Return' or 'SqlReturn'". What am I doing wrong?

Thanks for any help!



Can't install SP1 on SQL 2008 express default instance


I have SQL Express instaled as the machine default instance name MSSQLSERVER.  When I run Express SP1 setup and choose that instance, it won't let me select any features to install.  Presumably this is because it thinks my instance is not express because of the instance name.  Is there a workaround for this behavior?


Missing default SharePoint Webparts


Hi all,

I've just performed an upgrade on a SharePoint 2007 Content Database, the log says the following default sharepoint webparts are missing. This problem wasn't encountered when I set up the dev and test farms, just my luck it had to occur when doing prod. Seems to be the same problem experienced in this post http://social.technet.microsoft.com/Forums/en-US/sharepoint2010setup/thread/ec1d9cc0-b244-49c6-b107-8f837d4130bc. As suggested I did the Mount-SPContentDatabase command from the WFE but that obviously didn't work. Any know whats going on?

[powershell] [SPContentDatabaseSequence] [WARNING] [14/10/2010 8:50:00 PM]: WebPart class [94e9c166-264a-f84b-2377-bccefb8b3771] is referenced [3] times in the database [wss_content_intranet], but is not installed on the current farm. Please install any feature/solution which contains this web part.
[powershell] [SPContentDatabaseSequence] [WARNING] [14/10/2010 8:50:00 PM]: One or more web parts are referenced in the database [wss_content_intranet], but are not installed on the current farm. Please install any feature or solution which contains these web parts.
[powershell] [SPContentDatabaseSequence] [WARNING] [14/10/2010 8:50:00 PM]: WebPart class [ddbfb079-d77d-89c8-cb82-2

Full text search missing from one instance on one node of 3 node MSSQL 2008 cluster


Hello to all, 

I just started at a new client and on becoming familiar with the environment, I noticed that one of our instances on one node is missing the full text search option. The instance is not active on this node but I fear that if we ever need to failover it wont work.

The full text option is installed on the active node instance and the other passive node.

How do I add the full text search option to the instance on the node thats missing it ?

thank you.


Missing Default.aspx in MVC2 after install of MVC3 RC



After I install MVC3 RC, I then create an MVC2 application for old time sake using VWD2010 but the default.aspx is missing.

I copy-paste the default.aspx and default.vb page from another working MVC2 app and replaced the Inherits value of the default.aspx of the new app (MyAnotherMVC2App).


<%@ Page Language="VB" AutoEventWireup="false" CodeBehind="Default.aspx.vb" Inherits="MyAnotherMVC2App._Default" %>

<%-- Please do not delete this file. It is used to ensure that ASP.NET MVC is activated by IIS when a user makes a "/" request to the server. --%>

Accessing the default page in localhost works but not in production which doesn't see the MVC default page. Sad

Thank You for any help.


ODBC: My Database missing in list of default databases


Hello everybody

I have the following problem:

When creating a new ODBC data source to an SQL Server 2k5 I want to change the default database from 'master' to my database 'addresses'.

However my database 'addresses' doesn't appear in the drop down list.

I'm conneting with the 'sa' account.

I've activated all protocols in the SQL Server Configuration Manager.

What shall I do?


Any help is greatly appreciated.



Default ASP.NET Architecture

In providing an architectural approach, some assumptions are made concerning the project goals. These assumptions should be used as a litmus test to determine if the described architecture may be an appropriate fit for your ASP.NET application.

Content Query Web Part missing in SharePoint 2010

If you don't see content query web part listed in the web parts list, this is because you have not enabled "Search Server Web Parts" feature in site collection features. Enable this feature and content query web part will show in the list of web parts.

Setting the default start page in godaddy hosting?


 How do you set the start page with godaddy hosting? I can see no way of doing this! You do not seem to have access to the IIS settings that allow you to change it!

default constructor SelectList




dont have a  default constructor

new SelectList() :(

Missing 'new item templates'


 Hi all,

          I am a 'newbie' to VWD and I am slowly working through the Basic Walkthrough Help files, and learning plenty along the way.

However, when I tried to create a new database in the LINQ control walkthrough I found that the option to create a new database is missing, and further investigation has found that many other new item templates are missing.

I am using a brand new machine with Windows 7 Ultimate and have enabled IIS and .NET from Control Panel-Programs-Turn Windows Features On-Off. I used the WPI to install all basic elements eg. IIS Components, SQL Server Express.

The only 'new item templates' I have when I right-click the App_Data Folder and choose 'new item' are:-

ADO.NET Data Service

AJAX Enabled WCF Service

Dynamic Data Field

SQL Server Database

Text File

XML File

Does anyone know where I have gone wrong.


Michael J. Hill

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