SQL Server

Microsoft SQL Server 2017 powers your entire data estate by supporting structured and unstructured data sources. It builds on previous versions of SQL Server, which have been industry leading for four years in a row and a leader in TPC-E. It scales to petabytes of data and allows customers to process big data through PolyBase using T-SQL over any data. SQL Server has also been the least vulnerable database during the last seven years. SQL Server 2017 brings data insights with business intelligence capabilities that provide analytics at a fraction of the cost on any device along with advanced analytics with support for R and Python.

More details about SQL Server are available in the SQL Server documentation.
If you have a technical issue, please open a post on the developer forums through Stack Overflow or MSDN.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Updates such as changes in Role membership are slow or timeout in large databases Initial Connection is Slow

    Updates such as role membership changes or calculated member changes are extremely slow or timeout with large databases with many partitions, and substantial aggregations.
    As a hack workaround we have been able to update the the MDXScript file and bounce the SSAS service to make changes in a fraction of the time it takes to update via BIDS or Mgt. Studio. In addition, any intial connection to a sever with one or more large databases is very slow as metadata is loaded. It appears that a single aggregation design which is defined once in a measure group and reused for…

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  2. logging of ssis tasks are incomplete when run by sql agent job

    when a logging-enabled package (stored in msdb) is run by a sql server agent job, the log data is not complete.
    If it is run in BIDS, it logs all data like I would expect it to do.

    i have reproduced this on two sql environments - both sql2008 and win2003srv

    is this an issue with the sql agent job (dtexec)?
    or with the property of LoggingMode 'UseParentSetting'?

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 10

    <=-=Sep 24 2009 1:01PM=-=>

    Thank you for your submission. We will be reviewing your information and providing you feedback on our findings and progress. Thanks for your interest and support of SSIS.

    <=-=Oct 5 2009 12:57AM=-=>

    can anybody confirm this issue? it takes just some minutes to follow the steps. I can also give more information, if neccessary.

    <=-=Dec 15 2009 11:29AM=-=>

    See http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/02874b24-0e09-4b71-bf45-2db26d1310bc/ for more people encountering this issue. No word in two and a half months?

    <=-=Dec 21 2009 5:46AM=-=>

    I made up a thread here: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/511502a6-99d6-4693-94da-2c317c3f59c6

    feedback from MS: it will be fixed in next major release => SQL11 (not SQL10 R2) …
    … i’m disappointed – because it’s a common functionality without any customiziation

    <=-=Dec 13 2011 10:30AM=-=>

    I created several new packages from scratch with SSIS 2008 R2 and I experienced the same problem with most of the events including OnInformation. The…

  3. Space usage after disabling change tracking

    After disabling change tracking, space used for change tracking is not released.

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 1

    <=-=Oct 5 2009 9:38AM=-=>

    We will take a further look at this issue. But I believe change tracking is cleaned by checkpoints in a lazy fashion. So if this space is never recovered even after few hours please let us know.

    <=-=Oct 19 2009 8:10PM=-=>

    I have this installation on 7 servers. After waiting 1 month, still none of them was cleaned.

    <=-=Jan 5 2010 10:27AM=-=>

    Could you please try with SQL 2008 sp1 CU4? We believe this issue is resolved in this hotfix update. You can contact customer support to get hold of hotfixes. Thanks

    <=-=Jan 11 2010 3:04PM=-=>

    Closing this issue as resolved. If the issue still persists after SP1 CU4, please let us know.

  4. SQL Server 2008 SP1 - Reporting Services Rounds Parameters of Data Type Datetime2(7) to Datetime

    Reports executed via Report Manager convert parameters of data type DATETIME2(7) to data type DATETIME and truncates any fractional seconds. For instance, a value of 9/30/09 23:59:59.9999999 is rounded to 9/30/09 23:59:59.000.

    Reports executed via subscription convert parameters of data type DATETIME2(7) to data type DATETIME and round to the nearest value which may be higher or lower than the supplied value. For instance, a value of 9/30/09 23:59:59.9999999 is rounded to 10/01/09 00:00:00.000.

    The behavior between the execution methods should be consistent at a minimum. Also, it would be nice if it could support DATETIME2(7) instead of rounding to…

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  5. Query optimizer generates incorrect plan with a deffered filter operator

    If you execute both queries below, in SQL Server 2008 (with or without SP1), the second query is more optimized than the first one.

    select SalesOrderID, SalesOrderNumber
    from Sales.SalesOrderHeader
    where OrderDate = '20010702'

    select SalesOrderID, SalesOrderNumber
    from Sales.SalesOrderHeader with(index(1))
    where OrderDate = '20010702'
    go

    The first one has this execution plan:
    StmtText

    SELECT [SalesOrderID],[SalesOrderNumber] FROM [Sales].[SalesOrderHeader] WHERE [OrderDate]=@1
    |--Filter(WHERE:([AdventureWorks2008].[Sales].[SalesOrderHeader].[OrderDate]='2001-07-02 00:00:00.000'))
    |--Compute Scalar(DEFINE:([AdventureWorks2008].[Sales].[SalesOrderHeader].[SalesOrderNumber]=[AdventureWorks2008].[Sales].[SalesOrderHeader].[SalesOrderNumber]))
    |--Compute Scalar(DEFINE:([AdventureWorks2008].[Sales].[SalesOrderHeader].[SalesOrderNumber]=isnull(N'SO'+CONVERT(nvarchar(23),[AdventureWorks2008].[Sales].[SalesOrderHeader].[SalesOrderID],0),N'*** ERROR ***')))
    |--Clustered Index Scan(OBJECT:([AdventureWorks2008].[Sales].[SalesOrderHeader].[PK_SalesOrderHeader_SalesOrderID]))

    The second one , in which I force to use the cluster index, the query optimizer chooses to apply the filter condition while doing the cluster index scan, which is the…

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 3

    <=-=Oct 5 2009 12:08PM=-=>

    Dear Customer,

    Thanks for taking the time to file this issue. I’ve tried but failed to create a repro by examining the query and plans that you provided. Please could you provide the table and clustered index definitions? This looks like something that could be tightened.

    thank-you,
    Campbell Fraser, SQL Development

    <=-=Oct 14 2009 4:59AM=-=>

    Hi Campbell.
    I�m using the default configuration from AdventureWorks2008, here is a resume of the table structure:

    Columns

    SalesOrderID int
    RevisionNumber tinyint
    OrderDate datetime
    DueDate datetime
    ShipDate datetime
    Status tinyint
    OnlineOrderFlag Flag
    SalesOrderNumber nvarchar
    PurchaseOrderNumber OrderNumber
    AccountNumber AccountNumber
    CustomerID int
    SalesPersonID int
    TerritoryID int
    BillToAddressID int
    ShipToAddressID int
    ShipMethodID int
    CreditCardID int
    CreditCardApprovalCode varchar
    CurrencyRateID int
    SubTotal money
    TaxAmt money
    Freight money
    TotalDue money
    Comment nvarchar
    rowguid uniqueidentifier
    ModifiedDate datetime

    Indexes

    AK_SalesOrderHeader_rowguid nonclustered, unique located on PRIMARY rowguid
    AK_SalesOrderHeader_SalesOrderNumber nonclustered, unique located on PRIMARY SalesOrderNumber
    IX_SalesOrderHeader_CustomerID nonclustered located on …

  6. Msg 8152, Level 16, State 13, Procedure sp_helpconstraint, Line 220

    I'm receiving an error from the sp_help stored procedure when running it on a table. I've scripted the table and condensed the script to focus where the bug is being caused by. It's being caused by a column name exceeding 106 characters. If you take my script and remove the ending p from the column name (thereby reducing the column size less than or equal to 106 characters), the sp_help procedure no longer fails.

    Here's my version information, I've run it on two different SQL Servers and it's failed on both:
    Server1 - Microsoft SQL Server 2008 (SP1) - 10.0.2531.0…

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 3

    <=-=Oct 8 2009 7:22AM=-=>

    Yes, I can reproduce this, and I agree that if I can create an object, the supporting code around it shouldn’t trip on it.

    However, the sp_ procedures are not going to be maintained forever, and actually haven’t had many fixes or changes at all since 2005 work started. And that really is a ridiculously long and unusable column name. Just because we can use that many characters when we create our objects, doesn’t make it a good idea. :-)

    <=-=Oct 8 2009 9:42AM=-=>

    Yeah, if you read my blog about it. I commented briefly about the length being unwieldy. The use case was an existing application doing a pivot of some data and automatically creating a column based on values in the data (not my design, wouldn’t have been my choice to create it this way).

    http://blog.scoftware.com/post/2009/10/07/SQL-Server-2008-sp_help-bug-logged.aspx

    <=-=Oct 26 2009 3:14PM=-=>

    Hi,

    Thankyou…

  7. SQL Server is terminating because of fatal exception c0000005. This error may be caused by an unhandled Win32 or C++ exception

    First time we got this error. the only thing that was running during that time was a backup job...doing fine for months.

    10/06/2009 02:33:05,Server,Unknown,* ex_handle_except encountered exception C0000005 - Server terminating
    10/06/2009 02:33:05,Server,Unknown,* BEGIN STACK DUMP:
    10/06/2009 02:33:05,Server,Unknown,***Stack Dump being sent to E:\MSSQL.1\MSSQL\LOG\SQLDump0411.txt
    10/06/2009 02:33:05,Server,Unknown,**Dump thread - spid = 0<c/> PSS = 0x0000000000000000<c/> EC = 0x0000000000000000
    10/06/2009 02:33:05,Server,Unknown,Using 'dbghelp.dll' version '4.0.5'
    10/06/2009 02:33:05,Server,Unknown,SQL Server is terminating because of fatal exception c0000005. This error may be caused by an unhandled Win32 or C++ exception<c/> or by an access violation encountered during exception handling. Check the SQL error log for any related…

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 5

    <=-=Oct 16 2009 11:22AM=-=>

    Dear Customer,

    Thank you for reporting this failure!
    We are investigating possible causes. You�ll hear from us as we make progress on it.

    Zlatko Michailov
    Program Manager, SQL Server Protocols
    Microsoft Corp.

    <=-=Nov 18 2009 6:37AM=-=>

    We have also hadthe same error:
    2009-11-18 14:28:35.63 Server Error: 17311, Severity: 16, State: 1.
    2009-11-18 14:28:35.63 Server SQL Server is terminating because of fatal exception c0000005. This error may be caused by an unhandled Win32 or C++ exception, or by an access violation encountered during exception handling. Check the SQL error log for any related stack dumps or messages. This exception forces SQL Server to shutdown. To recover from this error, restart the server (unless SQLAgent is configured to auto restart).
    2009-11-18 14:28:35.75 Server Using ‘dbghelp.dll’ version ‘4.0.5’
    2009-11-18 14:28:35.78 Server **Dump thread – spid = 0, EC = 0×00000000

    <=-=Jul 3 2017 12:50PM=-=>

    Same error SQL

  8. Parameterized Spatial Queries in Report Builder 3.0 cause design issues

    Parameterized Spatial Query causes the report design environment to show sample points rather than the actual points in the database. This makes it difficult to know how to center the viewport.

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  9. Reporting Services Multi Select Bug

    Hello,
    On my report, a multiselect parameter (called GROUP) is driven by a dataset which can change depending on the other parameters you select. When you open the report, the parameter (called LEVEL) is defaulting to 2. With this parameter on 2, the GROUP multi-select shows the set of options e.g.
    Select All
    a,
    b,
    d,
    e,
    f,
    h,
    i,
    j

    The Select All option is ticked which in turn has ticked all the other options in the list

    When you change the LEVEL parameter to 3 and before you click View Report, the multiselect set now changes to
    Select…

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  10. SQLBrowser Service Won't Start as service but works fine from command line

    We just added three new nodes to our cluster (x64) and when we went make them usuable on for the virtual server, the install went fine until it tried to start the sql browser service.

    After fiddling with it for a while i realized this key
    HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\90\SQL Browser\SsrpListener
    with a (1) would prevent the service from starting so i changed it to a (0) and the install completed successfully because the service would start now. It did this on all 3 new nodes.

    I found some articles about possibly having ssrp failures due to an old x86 key…

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 1

    <=-=Oct 14 2009 9:44AM=-=>

    Thanks for submitting the issue.
    When it fails the start as service, can you run the following command from console and see if there is any process still holding UDP port 1434? If so, please kill the process.

    “netstat -abno”

    Thanks.

  11. Dimension Attribute does not display in Excel 2007 if it has a realted Date attribute with a value in the 19th century

    I am not sure if this is an Excel or Analysis Services problem, probably the former. I have a dimension with an attribute of company name which has a related attribute Date of Incorporation (Data Type = Date). When using an Excel pivot table connected to this cube if any of the Date of incorporation values are prior to 01 Jan 1900 when I select Company Name in the PivotTable field list, Excel de-selects the Company name and does not display anything. If I modify all Date of incorporations' with values prior to 01 Jan 1900 to be 01 Jan…

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  12. [SSRS] Parameters don't support dimension cubes

    I've been using SSRS against SSAS a lot lately and I have found myself becoming more and more frustrated with each passing day, hence there may be a few more of these submissons in the next few days.

    This one is regarding the use of dimensions cubes, i.e. Implicitly built cubes that can be used to query members of a dimension using the $ syntax as described by Mosha: http://sqlblog.com/blogs/mosha/archive/2006/10/11/querying-dimensions-in-mdx.aspx

    Quite simply, dimensions cubes are not supported in SSRS. I try to execute a query against a dimension cube that works perfectly well in an MDX query window in SSMS…

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 7

    <=-=Dec 7 2009 11:09AM=-=>

    Thanks for your feedback on this issue. Currently this restriction is by design, but I have converted the bug to a DCR that we will consider for a future release.

    <=-=Dec 7 2009 11:15AM=-=>

    OK fair enough. I do think this is important though. Hoping to see this in the future.

  13. INSTALLSHAREDWOWDIR parameter ignored for no reason

    INSTALLSHAREDWOWDIR parameter ignored for no reason (when specified from command line) on 64-bit OS.

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 1

    <=-=Apr 10 2009 4:03PM=-=>

    Thanks for contacting us with this issue. This is a duplicate of a bug that we plan to fix for the next major release. This is actually a messaging issue as we need to provide a better message in the logs and on the UI.

    Here is the summary of the issue:

    No matter 64-bit or Wow 32-bit, once a component is present in anyone of the shared directories, users are not allowed to change the shared directory anymore. This is by design.

    So, it looks as if setup ignored your input parameter /INSTALLSHAREDWOWDIR=“C:\Test\x86”, when in fact you already had the component installed prior to this setup session, but into the “C:\Program Files (x86)\Microsoft SQL Server” folder. We do not allow you to change the shared folder after that.

    The problem is we have a bug that does not clearly indicate this…

  14. RepeatOnNewPage option not working as expected

    I have a tablix (that is really a SSRS 2005 table converted to SSRS 2008), it have a group with many cells and a subreport in one of the cells.
    I want to have some rows repeated on each page, so I did as suggested in Connect and opened the advanced tablix options, and select each static item I want to be repeated as "RepeatOnNewPage" but still not working, not sure if because of the subreport (which, as I reported in another issue) seems to be also doing strange things as ignoring the KeepTogether directive.
    Also, there is a RepeatWith…

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 10

    <=-=Jan 5 2010 3:55PM=-=>

    Hello,

    Thanks for writing in about this. The current expected behavior is that if the contents of a Tablix cell (inside which is a textbox or a subreport in your case) is split across a page, the group header for that cell is not repeated. I have linked your filing into an existing feature request to allow report authors to better control this behavior. We will evaluate this for a future release.

    Best regards,
    Chris B.
    SSRS Team

  15. If database files not available, trying to connect displays wrong error message

    If the database files (*.MDF and *.LDF) are not available, trying to connect yields the wrong error message

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 0

    <=-=Jan 9 2006 2:28PM=-=>

    Need exact error message to help troubleshoot

    <=-=Jan 14 2006 2:53PM=-=>

    Creating databases on network share is not a good idea anyway…

    <=-=Apr 28 2006 2:52PM=-=>

    We cannot reproduce the messages that were mentioned in this report.

    Here are samples of messages that we encountered while attempting to reproduce this issue:

    Msg 5120, Level 16, State 101, Server *, Line 1
    Unable to open the physical file “d:\test\test.mdf”. Operating system error 5: " 5(Access is denied.)". File activation failure. The physical file name “d:\test\test.ldf” may be incorrect.
    Msg 4064, Level 11, State 1, Server *
    , Line 1
    Cannot open user default database. Login failed.

    If you are still encountering this issue, please reactivate this error report and provide the following additional information:

    - error messages that you received - a description of the steps that can be used to reproduce this issue

    Thanks

  16. September CTP - COM Error when creating or modifying any data connection on Windows Server 2003 SP1

    After rebuilding a Windows 2003 Server SP1 machine from scratch and installing September CTP, any attempt to modify an existing connection or create a new connection to a SQL Server database results in the following error:

    THIS ERROR IS CRITICAL TO THE POINT THAT NO WORK CAN BE DONE ON THE MACHINE. IT WORKED FINE WITH THE JUNE CTP.

    TITLE: Microsoft Visual Studio
    ------------------------------

    Retrieving the COM class factory for component with CLSID {C8B522D0-5CF3-11CE-ADE5-00AA0044773D} failed due to the following error: 8007007f.

    ------------------------------
    BUTTONS:

    OK
    ------------------------------

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  17. 0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 1

    <=-=Jul 11 2005 3:15PM=-=>

    I just tried to copy two stored procedures from a 2000 to 2005 and from 2005 and 2000 and it all worked fine:
    1. You may have an old version (if this is the case, hopefully once you get a new drop it will be fixed) or,
    2. you not have set CopySchema property to true (if this is the case, try setting it and see if it works. If it does great, if it doesn’t then probably you need a new drop)

  18. Install Microsoft SQL Server 2005 CTP directory missing entries

    If one first installs only the SQL Server 2005 database component off the CD and then
    installs desktop components, the start/all programs/Microsoft SQL Server 2005 CTP/ directory is missing the new entries.

    What happens is that you install the secondary components sucessfully, but the entries for the secondary componets are missing from the start/all programs/Microsoft SQL Server 2005 CTP/ directory.

    A full install works correctly.

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 0

    <=-=Sep 28 2005 6:04PM=-=>

    Thanks for the feedback. Can you please clarify your repro steps? You first install the SQL Database. How did you go about adding the “desktop tools” after that? Also, which specific components do you mean when you say “desktop tools”? Do you mean Managament Studio? Thanks, Mike

  19. sp_reset_connection need to clear CONTEXT_INFO

    sp_reset_connection does not clear CONTEXT_INFO

    It is possible with connection pooling enabled to read the CONTEXT_INFO of a previous session. This is especially true when a web-server is making hundreds of connections of behalf of web-users.

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 4

    <=-=Aug 22 2006 12:44PM=-=>

    Saying “won’t fix” without saying why doesn’t help. This is clearly a security bug that needs to be fixed.

    <=-=Sep 26 2006 11:05AM=-=>

    Hi
    Thanks for the feedback. We’re considering addressing this in an upcoming Service Pack of SQL 2005 and future releases of SQL Server.

    - Christian Kleinerman

    <=-=Oct 13 2006 5:17PM=-=>

    Hi Jack!

    Thank you for filing bug 126925
    (http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?Feedb
    ackID=126925).

    I actually couldn’t repro it, so I’m having several questions.

    1. What is exactly version number of your SQL Server?
    2. What client API of what version are you using to connect to it
    at the client?
    3. I need a clarification on your repro sequence (between /* Load
    the saved context info / and /But hope that the connection pooling gives you the same connection*/comments). Do you assume somewhere in the middle the connection is reset? Or you…

  20. SQL Server Express 2005 fails to install

    I had successfully installed the 2005 express versions of VC++, VC# and Web Developer, and SQL Express (downloaded as .img files). This was working, as I tried out the security options in asp.net 2.0, which uses at database.
    I then uninstalled SQL Server 200 Express and tried to reinstall it. If fails, with no error message.
    I tried uninstalling all the express 2005, and running through the cleanup process at http://blogs.msdn.com/astebner/archive/2005/04/16/408856.aspx.
    I deleted all files under Program Files\Microsoft SQL Server, and tried again, with the same error.
    I attach log files.

    0 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 1

    <=-=Jun 5 2006 3:08PM=-=>

    Thanks for your feedback. Looks like there is a sql instance already installed with the same instance name as what you are trying to install. You can either install with a different instance name, uninstall the instance thorough Add Remove Programs or at a last resort, file the manual uninstall steps at: http://support.microsoft.com/kb/909967/en-us

    If this does not resolve your issue, please let us know.

    <=-=Jun 5 2006 3:32PM=-=>

    Microsoft comments: Thanks for your feedback. Looks like there is a sql instance already installed with the same instance name as what you are trying to install. You can either install with a different instance name, uninstall the instance thorough Add Remove Programs or at a last resort, file the manual uninstall steps at: http://support.microsoft.com/kb/909967/en-us

    If this does not resolve your issue, please let us know.

    <=-=Jun 13 2006 1:37PM=-=>

    I tried following the manual removal…

  • Don't see your idea?

SQL Server

Categories

Feedback and Knowledge Base