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.........
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.