Cannot run Team Edition for Database Professionals if not local admin?  
Author Message
colindyck





PostPosted: Visual Studio Team System - Database Professionals, Cannot run Team Edition for Database Professionals if not local admin? Top

Hi there,

It's very annoying at our work, but we are not local admins on our machine while logged into the domain. We do have Administrator rights only when we log in as local Administrator to the machine. So when I install the CTP, I execute the setup under the local Admin account, and it installs fine, and runs fine when logged in locally. But, when logged into the domain, it does not show up as an installed product under Help -> About.

I do not have this problem with any other product ie I have the BI studio, team edition developer, team edition tester, etc running fine. Any thoughts on how to get the ctp to install and run properly for me Will this work in the future Because if it doesn't we have to go buy a few licenses of red gate, but I really want to try the database pro out to see if it is what we need for the future.

Thanks a bunch,

Colin



Visual Studio Team System31  
 
 
Brian Randell





PostPosted: Visual Studio Team System - Database Professionals, Cannot run Team Edition for Database Professionals if not local admin? Top

This is currently a limitation with the CTPs. This is scheduled to be fixed by RTM.

Cheers,

Brian Randell
MCW Technologies


 
 
colindyck





PostPosted: Visual Studio Team System - Database Professionals, Cannot run Team Edition for Database Professionals if not local admin? Top

Great, thanks for the reply. I read somewhere RTM will be sometime near the end of the year, correct

Thanks


 
 
Brian Randell





PostPosted: Visual Studio Team System - Database Professionals, Cannot run Team Edition for Database Professionals if not local admin? Top

Dates are always a nebulous thing. Gert (the Data Dude & Development Manager) is quoted here [0] as saying "We're at CTP 3. Then there will be 4 and 5 and RTM, which is expected to ship by the end of this year."

However, if you read the following post from Thomas Murphy, Group Program Manager, you'll see the team is taking feedback related to features and dates. [1]

Hope this helps.

Cheers,

Brian Randell
MCW Technologies

[0] http://www.sqlmag.com/Articles/ArticleID/50271/pg/2/2.html

[1] http://blogs.msdn.com/thomas_murphys_agile_db_blog/archive/2006/07/12/663637.aspx


 
 
J. D. Laflen





PostPosted: Visual Studio Team System - Database Professionals, Cannot run Team Edition for Database Professionals if not local admin? Top

As an alternative, I do not run as an administrator on my local box. In order to run the product I did grant my domain account DBO rights on the local sql instance that the product uses. This is not something we officially support right now, but it has been working for me.

 
 
colindyck





PostPosted: Visual Studio Team System - Database Professionals, Cannot run Team Edition for Database Professionals if not local admin? Top

I do have full rights to my 2 instances of sql on my machine. It still won't let me open/create a dbproj project in Visual Studio, though. No big deal...
 
 
Richard Waymire - MSFT





PostPosted: Visual Studio Team System - Database Professionals, Cannot run Team Edition for Database Professionals if not local admin? Top

So you're the sql server administrator of sqlexpress and still can't run our project system unless you're a windows local administrator

 
 
colindyck





PostPosted: Visual Studio Team System - Database Professionals, Cannot run Team Edition for Database Professionals if not local admin? Top

yeah, i set my domain account to be sysadmin to my two local instances (express and default). I'm confused what this has to do with my sql server permissions on my machine though - it's the Visual Studio ide that won't let me open or create a dbproj project - unless i'm misunderstanding something. when i log in as Administrator to my machine and not domain, i can create/load the dbproj projects fine - which for right now, is my solution to try data dude out. so it's all good.

Cheers


 
 
Rand AlThor





PostPosted: Visual Studio Team System - Database Professionals, Cannot run Team Edition for Database Professionals if not local admin? Top

I am having the exact same issue as outlined in this thread. When I login as a local user to my box I can create and load DB Projects just fine. When I logout and login as a domain user (who is a local Admin, btw), I get this error message:

"Failed to attach database."

The DB project will not load and creating new DB Projects just crashes VS2005. I have given my domain account full sysadmin/DBO rights in both instances of SQL (developer and express) to no avail. Is there some other step I might be missing here I see that some have been able to get it working okay, but I still have not. Anyone have any ideas or additional items that I might check I am currently running VS2005 Team System, connecting to TFS on another server, and CTP6 of VSTS DB Pros.

Thanks in advance for your time.

As an alternative, I do not run as an administrator on my local box. In order to run the product I did grant my domain account DBO rights on the local sql instance that the product uses. This is not something we officially support right now, but it has been working for me.


 
 
tomsmi - MSFT





PostPosted: Visual Studio Team System - Database Professionals, Cannot run Team Edition for Database Professionals if not local admin? Top

Try this (copied directly from the Readme)...

To create and use database projects, you must belong to the securityadmin and the dbcreator fixed server roles for your design-time validation database. In addition, if you are not connecting to SQL Server as a member of the sysadmin role, you must have View Server State permissions on the server and a member of the sysadmin role must run the following script:

USE MASTER

GO

GRANT EXECUTE ON sp_detach_db TO public

GO



 
 
J. D. Laflen MSFT





PostPosted: Visual Studio Team System - Database Professionals, Cannot run Team Edition for Database Professionals if not local admin? Top

What CTP are you using

 
 
Rand AlThor





PostPosted: Visual Studio Team System - Database Professionals, Cannot run Team Edition for Database Professionals if not local admin? Top

I am running CTP6 on both the dev box and the TFS box for Team Builds. I am contemplating upgrading to CTP7...if that will help.
 
 
J. D. Laflen MSFT





PostPosted: Visual Studio Team System - Database Professionals, Cannot run Team Edition for Database Professionals if not local admin? Top

Well, the higher the CTP the closer you are to our code base making it easier for us to debug. I am not aware of any issues wrt creating/reopening database projects and I do run as a non-administrative user on my machine. As Tom said, if the user is not an administrator, the user must be granted DB Creator, Security Admin and View Server State on the local DesignDB instance and in addition run the script specified in the readme.

If you open VS as the domain user and go to Tools -> Options -> Database Tools : Design Time Validation Database you will be able to see what local instance of Sql Server we will try to use for the DesignDB. Once you “know” what instance we are going to use you could setup Sql Profiler on that instance and see if there are any errors from the TSql we use to execute against the instance.



 
 
J. D. Laflen MSFT





PostPosted: Visual Studio Team System - Database Professionals, Cannot run Team Edition for Database Professionals if not local admin? Top

Is this the same TFS+build server we were working on in another thread If so, I thought that was a Novell network

 
 
Rand AlThor





PostPosted: Visual Studio Team System - Database Professionals, Cannot run Team Edition for Database Professionals if not local admin? Top

Message:
Is this the same TFS+build server we were working on in another thread If so, I thought that was a Novell network
<sigh> Yes, it is a Novell network. Just recently, they setup a domain server to support some of our other Microsoft initiatives and I am testing out some of the new functionality of SharePoint 2007 and single sign-on. So, I just recently joined the domain when I encountered this particular issue.

The good news is I finally figured out what the problem was by doing a SQL Server Profiler trace (thanks for the pointer!). When it was trying to physically attach to the file that was created by the Local User account before I joined the domain, the domain user did not have physical rights to the file. So, I right-clicked the specific .ldf file that the DB Project was trying to access as my domain user and gave the domain user Full Control of the file. Once I did that, I reloaded the project and everything worked.

Thanks for all your help!