Posted by raylopez99 on 03/31/07 18:19

On Mar 30, 2:29 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:
> raylopez99 (raylope...@yahoo.com) writes:
> > Thank you Erland. I see the problem is not as simple as I thought. I
> > also see I have two problems: one is what you addressed, the other is
> > more simple: how to use VS2005 from an account other than
> > "Administrator" when working on databases. So far I've not been able
> > to figure out this, and only use "Adminstrator" to code.
>
> I did not answer that question, since I was uncertain of the scope of
> your question. But it's fairly simple, although there are several options.
>
> One is to enable SQL Server Authentication through Management Studio.
> (Right-click the server itself in the Object Explorer, select Properties
> and go the the Security tab. You need to restart SQL Server for the
> setting to take effect.) Then you can connect as sa from VS and have
> sysadmin rights. The good thing with this is that when you connect
> through your application with Windows authentication, you are a plain
> user and can test that you have granted that user the right permissions.
>

Well, turns out I don't have "Management Studio" on my system (yet
strangely I was able to create a simple SQL database and run some
commands). If you don't have "Management Studio" you don't have
"Object Explorer", even though it's possible to have SQL Server 2005
Express (a 36.5 MB file) and not the SQL Server Management Studio
Express (a 46.1 MB file) installed on your PC, as I have. Details
here: http://go.microsoft.com/fwlink/?LinkId=65110

I'll post again if I'm successful, for anybody reading this thread in
the future.

RL

Information on OE below...

Using Object Explorer

Object Explorer, a component of SQL Server Management Studio, connects
to Database Engine instances, Analysis Services, Integration Services,
Reporting Services, and SQL Server Compact Edition. It provides a view
of all the objects in the server and presents a user interface to
manage them. The capabilities of Object Explorer vary slightly
depending on the type of server, but generally include the development
features for databases, and management features for all server types.

Viewing Object Explorer

Object Explorer is visible in the Management Studio by default. If you
cannot see Object Explorer, on the View menu, click Object Explorer.

Connecting Object Explorer to a Server

To use Object Explorer you must first connect to a server. Click
Connect on the Object Explorer toolbar and choose the type of server
from the drop-down list. The Connect to Server dialog box opens. To
connect, you must provide at least the name of the server and the
correct authentication information.

[Back to original message]