Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2003
    Posts
    7

    Angry Unanswered: Server Explorer 2003 Trouble

    I recently installed VISUAL STUDIO .NET 2003 and SQL SERVER 2000 personal edition on my XP system.
    I also applied service pack 3a to it. I use windows integrated security, and server runs from it's system account (SA).
    The problem is that I cannot create tables, views, procedures or databases from SERVER EXPLORER. I can do it through Enterprise Manager. When I install destop engine instead of sql server it's OK, but when it's SQL server personal edition, then it's a problem. I tried giving my account, and my account group (builtin/administrators) all rights and privilegies I could think of, but it still doesn't work.
    I did not have this problem vith previous version of Visual Studio .net.
    I think it's something about security and permissions.
    Any suggestions ?
    Thx in advance.........

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Any error or information during this behaviour.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Dec 2003
    Posts
    7
    No,none.
    For instance, when I right click the tables label, I simply dont get New Table option. I only get Refresh and Properties options.The same goes for the views and procedures. I can only retrive data from tables and views, and execute procedures.
    Also when I try to create new database, i get following message
    "Cannon create databases on this server".
    But when I install SQL server Desktop engine only, all works perfectly.

  4. #4
    Join Date
    Dec 2003
    Posts
    7
    One more thing.
    When I clikck on a database (northwind), on the properties tab, USER is dbo. Does that have anything to do with the problem?

  5. #5
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    As a default all the system databases owner is DBO.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  6. #6
    Join Date
    Dec 2003
    Posts
    7
    I've got it figured out....
    PROFESSIONAL version of visual studio simply does not support that feature on SQL server installations. It works only on Desttope Engine.

    Enterprise version and up supports it all..

Posting Permissions

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