Server Explorer and SQL Server

[Tom Leylan]

Something is messed up...

I was using MSDE but I just bought/installed SQL Server instead and stuff
has stopped working. I used to be able to connect to the server through
VS2002 (and VS2003)'s Server Explorer window and from there I could add/edit
databases, tables and stored procedures.

Upon installing SQL Server I have read/only access to the server. This is
getting very frustrating :-)

Does anybody have any idea what I may have failed to set properly? I've set
my Windows account as an administrator in SQL Server so I should have all
the rights that the sa account does. I don't mind using the sa account even
but I don't believe that the Server Explorer connects in any way except by
using the current Windows account.

And now I'm stuck... any ideas?

Thanks,
Tom

[Bernie Yaeger]

Hi Tom,

It's probably a simple tweak, but I don't know it. I'd strongly recommend
you post to microsoft.server.sqlserver.server - they always have the sql
server answer I need.

Bernie

"Tom Leylan" <ge*@iamtiredofspam.com> wrote in message
news:d7*********************@twister.nyc.rr.com...

Something is messed up...

I was using MSDE but I just bought/installed SQL Server instead and stuff
has stopped working. I used to be able to connect to the server through
VS2002 (and VS2003)'s Server Explorer window and from there I could add/edit databases, tables and stored procedures.

Upon installing SQL Server I have read/only access to the server. This is
getting very frustrating :-)

Does anybody have any idea what I may have failed to set properly? I've set my Windows account as an administrator in SQL Server so I should have all
the rights that the sa account does. I don't mind using the sa account even but I don't believe that the Server Explorer connects in any way except by
using the current Windows account.

And now I'm stuck... any ideas?

Thanks,
Tom

[Tom Leylan]

"Bernie Yaeger" <be*****@cherwellinc.com> wrote...

It's probably a simple tweak, but I don't know it. I'd strongly recommend
you post to microsoft.server.sqlserver.server - they always have the sql
server answer I need.

Thanks Bernie... I've posted it over there now. As complicated as
everything is these days "it's always something." :-)

Tom

[Rick Mogstad]

We use SQL server strictly with SQL Authentication, and the Server Explorer works with that, so it
will definitely work with something other than windows auth.
"Tom Leylan" <ge*@iamtiredofspam.com> wrote in message
news:d7*********************@twister.nyc.rr.com...

Something is messed up...

I was using MSDE but I just bought/installed SQL Server instead and stuff
has stopped working. I used to be able to connect to the server through
VS2002 (and VS2003)'s Server Explorer window and from there I could add/edit
databases, tables and stored procedures.

Upon installing SQL Server I have read/only access to the server. This is
getting very frustrating :-)

Does anybody have any idea what I may have failed to set properly? I've set
my Windows account as an administrator in SQL Server so I should have all
the rights that the sa account does. I don't mind using the sa account even
but I don't believe that the Server Explorer connects in any way except by
using the current Windows account.

And now I'm stuck... any ideas?

Thanks,
Tom

[Herfried K. Wagner [MVP]]

* "Tom Leylan" <ge*@iamtiredofspam.com> scripsit:

Something is messed up...

I was using MSDE but I just bought/installed SQL Server instead and stuff
has stopped working. I used to be able to connect to the server through
VS2002 (and VS2003)'s Server Explorer window and from there I could add/edit
databases, tables and stored procedures.

Upon installing SQL Server I have read/only access to the server. This is
getting very frustrating :-)

AFAIK VS.NET 2003 professional only supports MSDE with the Server
Explorer.

--
Herfried K. Wagner
MVP · VB Classic, VB.NET
<http://www.mvps.org/dotnet>

<http://www.plig.net/nnq/nquote.html>

[Tom Leylan]

"Herfried K. Wagner [MVP]" <hi***************@gmx.at> wrote...

AFAIK VS.NET 2003 professional only supports MSDE with the Server
Explorer.

The trouble I'm having is that most of what I have found on the subject
seems to be rumor. And these days I can't even figure out what "supports'
means... I can view everything, I can add data to the tables I just can't
create a table. Other people have posted they use the pair and strangely
enough I have a book which illustrates doing it.

At the moment I have questions posted a few places. And all things
considered (if this is the case) I think MS has made a very dumb move. I
cannot imagine what the upside would be for them. They can't be hoping that
more people opt to use the free MSDE version.

[Tom Leylan]

"Rick Mogstad" <ri**@NOSPAM.computetosuit.com> wrote...

We use SQL server strictly with SQL Authentication, and the Server Explorer works with that, so it will definitely work with something other than windows auth.

That sounds good to me... I just updated to MDAC 2.8 because somebody posted
something which I found in Google but no dice... Can I confirm that you can
actually create a table and/or add a stored procedure? I can view, add/edit
records and such but I can't add a table.

Tom

[Tom Leylan]

"Tom Leylan" <ge*@iamtiredofspam.com> wrote...

The trouble I'm having is that most of what I have found on the subject
seems to be rumor.

OK... I think I've found it. As you wrote it seems to be a limitation of VS
"Pro" and it is supported by Enterprise, etc. it's in the docs as a missing
check mark. I've been reading the replies as "VS .Net 2003" didn't support
it...

So now I have to install MSDE again (for development) and try to automate
the transfer into SQL Server for testing purposes.

[Herfried K. Wagner [MVP]]

* "Tom Leylan" <ge*@iamtiredofspam.com> scripsit:

"Herfried K. Wagner [MVP]" <hi***************@gmx.at> wrote...

AFAIK VS.NET 2003 professional only supports MSDE with the Server
Explorer.

The trouble I'm having is that most of what I have found on the subject
seems to be rumor.

I found that in a German language "advertisement flyer" by Microsoft
that functionality for designing stored procedures and triggers/... with
the visual database tools is limited to MSDE in the Professional Edition.

--
Herfried K. Wagner
MVP · VB Classic, VB.NET
<http://www.mvps.org/dotnet>

<http://www.plig.net/nnq/nquote.html>

[Tom Leylan]

"Tom Leylan" <ge*@iamtiredofspam.com> wrote...

Something is messed up...

To recap (somebody might see this and save a couple of hours) :-) I
uninstalled SQL Server, reinstalled MSDE (that makes VS2003 Pro happy again)
and then went back and added just the tools from SQL Server (that makes me
happy again.)

I have SQL Server itself installed on another machine so I can still test
stuff there when necessary.

[EricJ]

in addition you could have a look at access
you can create a project on existing data and point that to your sql server
(if you don't have an enterprise manager it can be usefull)
"Tom Leylan" <ge*@iamtiredofspam.com> wrote in message
news:uC**************@TK2MSFTNGP09.phx.gbl...

"Tom Leylan" <ge*@iamtiredofspam.com> wrote...

Something is messed up...
To recap (somebody might see this and save a couple of hours) :-) I
uninstalled SQL Server, reinstalled MSDE (that makes VS2003 Pro happy

again) and then went back and added just the tools from SQL Server (that makes me
happy again.)

I have SQL Server itself installed on another machine so I can still test
stuff there when necessary.

[Tom Leylan]

"EricJ" <ericRéMo**@ThiSomnipack.be> wrote...

in addition you could have a look at access
you can create a project on existing data and point that to your sql server (if you don't have an enterprise manager it can be usefull)

Hi Eric... It is an alternative certainly (and I own Access) but I don't
think it supports many of the things that SQL Server does. A lot of the
code would have to be rewritten to move it up and that isn't the case with
MSDE.

[EricJ]

hmm (i have to admit it has been a while since i used access w sqlserver)
normally you can create tables views stored procedures ... on the sql server
and i thought that was enough (looking at your original post)

like i said it was an addition (but not one to be underestimated ;p )

eric

"Tom Leylan" <ge*@iamtiredofspam.com> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...

"EricJ" <ericRéMo**@ThiSomnipack.be> wrote...

in addition you could have a look at access
you can create a project on existing data and point that to your sql

server

(if you don't have an enterprise manager it can be usefull)

Hi Eric... It is an alternative certainly (and I own Access) but I don't
think it supports many of the things that SQL Server does. A lot of the
code would have to be rewritten to move it up and that isn't the case with
MSDE.

[Tom Leylan]

"EricJ" <ericRéMo**@ThiSomnipack.be> wrote...

hmm (i have to admit it has been a while since i used access w sqlserver)
normally you can create tables views stored procedures ... on the sql server and i thought that was enough (looking at your original post)

Oh I misunderstood. You were suggesting using Access to look at/operate SQL
Server? I thought you suggested using Access for development work and then
porting the data at some point. In any case it's working now using MSDE and
SQL Server tools.

Tom

[Rick Mogstad]

"Tom Leylan" <ge*@iamtiredofspam.com> wrote in message
news:d2********************@twister.nyc.rr.com...

"Rick Mogstad" <ri**@NOSPAM.computetosuit.com> wrote...

We use SQL server strictly with SQL Authentication, and the Server

Explorer works with that, so it

will definitely work with something other than windows auth.

That sounds good to me... I just updated to MDAC 2.8 because somebody posted
something which I found in Google but no dice... Can I confirm that you can
actually create a table and/or add a stored procedure? I can view, add/edit
records and such but I can't add a table.

Yes, I can create/Delete tables and stored procedures, though i use it mostly for debugging SPs.
Hope you get it figured out.

[Rick Mogstad]

Oh, also, I dont have VS 2003 at work yet, and i only have MSDE at home, so maybe its a combo of
true SQL Server and VS2003....
"Tom Leylan" <ge*@iamtiredofspam.com> wrote in message
news:d2********************@twister.nyc.rr.com...

"Rick Mogstad" <ri**@NOSPAM.computetosuit.com> wrote...

We use SQL server strictly with SQL Authentication, and the Server

Explorer works with that, so it

will definitely work with something other than windows auth.

That sounds good to me... I just updated to MDAC 2.8 because somebody posted
something which I found in Google but no dice... Can I confirm that you can
actually create a table and/or add a stored procedure? I can view, add/edit
records and such but I can't add a table.

Tom