Results 1 to 9 of 9

Thread: SQL 2005 Error version ??

  1. Oct 25th, 2010, 10:57 PM #1
    Tengkorak
    Tengkorak is offline

    Thread Starter
    Addicted Member Tengkorak's Avatar
    Join Date
    Nov 2006
    Posts
    240

    SQL 2005 Error version ??

    I have a sql server database version 2005. i have a problem when I want to modify the tables with error:
    This backend version is not supported to design database diagrams or tables.
    I use Management Studio Express Editon.

    What is the solution to this?

    thank you
    Reply With Quote Reply With Quote
  2. Oct 25th, 2010, 11:21 PM #2
    jmcilhinney
    jmcilhinney is offline
    Super Moderator jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    111,221

    Re: SQL 2005 Error version ??

    It sounds like maybe Management Studio Express will not allow you to design on a non-Express instance. I can't really test that theory but that's what it sounds like from the information you've provided. Can that same instance of MSE perform the same task for a database attached to a SQL Server Express instance?
    Why is my data not saved to my database? | MSDN Data Walkthroughs
    VBForums Database Development FAQ
    My CodeBank Submissions: VB | C#
    My Blog: Data Among Multiple Forms (3 parts)
    Beginner Tutorials: VB | C# | SQL
    Reply With Quote Reply With Quote
  3. Oct 25th, 2010, 11:59 PM #3
    Tengkorak
    Tengkorak is offline

    Thread Starter
    Addicted Member Tengkorak's Avatar
    Join Date
    Nov 2006
    Posts
    240

    Re: SQL 2005 Error version ??

    I will try to install again. possible ways this could be a solution
    Reply With Quote Reply With Quote
  4. Nov 2nd, 2010, 04:58 AM #4
    Tengkorak
    Tengkorak is offline

    Thread Starter
    Addicted Member Tengkorak's Avatar
    Join Date
    Nov 2006
    Posts
    240

    Re: SQL 2005 Error version ??

    now i not use sql server management express. but i have same error.

    but when i search i found this articel :
    http://support.microsoft.com/kb/822535
    Reply With Quote Reply With Quote
  6. Nov 2nd, 2010, 07:44 AM #5
    techgnome
    techgnome is offline
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,687

    Re: SQL 2005 Error version ??

    What version of SME are you trying to use?

    -tg
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *
    Reply With Quote Reply With Quote
  7. Nov 2nd, 2010, 10:15 PM #6
    Tengkorak
    Tengkorak is offline

    Thread Starter
    Addicted Member Tengkorak's Avatar
    Join Date
    Nov 2006
    Posts
    240

    Re: SQL 2005 Error version ??

    I have been using MSE for version 9.00.1399.00

    this for details info :
    Microsoft SQL Server Management Studio 9.00.1399.00
    Microsoft Analysis Services Client Tools 2005.090.1399.00
    Microsoft Data Access Components (MDAC) 2000.085.1132.00 (xpsp.080413-0852)
    Microsoft MSXML 2.6 3.0 5.0 6.0
    Microsoft Internet Explorer 8.0.6001.18702
    Microsoft .NET Framework 2.0.50727.1433
    Operating System 5.1.2600
    Reply With Quote Reply With Quote
  8. Nov 2nd, 2010, 10:20 PM #7
    Tengkorak
    Tengkorak is offline

    Thread Starter
    Addicted Member Tengkorak's Avatar
    Join Date
    Nov 2006
    Posts
    240

    Re: SQL 2005 Error version ??

    I enclose the following example of a typed view can not connect to the database on the server
    Attached Images Attached Images  
    Reply With Quote Reply With Quote
  9. Nov 2nd, 2010, 10:46 PM #8
    jmcilhinney
    jmcilhinney is offline
    Super Moderator jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    111,221

    Re: SQL 2005 Error version ??

    What is that (Restricted User) business about?
    Why is my data not saved to my database? | MSDN Data Walkthroughs
    VBForums Database Development FAQ
    My CodeBank Submissions: VB | C#
    My Blog: Data Among Multiple Forms (3 parts)
    Beginner Tutorials: VB | C# | SQL
    Reply With Quote Reply With Quote
  11. Nov 2nd, 2010, 11:02 PM #9
    Tengkorak
    Tengkorak is offline

    Thread Starter
    Addicted Member Tengkorak's Avatar
    Join Date
    Nov 2006
    Posts
    240

    Re: SQL 2005 Error version ??

    I do not know, but there is no problem when I use sql server on another pc. only happens in my own pc
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width