By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,906 Members | 1,767 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,906 IT Pros & Developers. It's quick & easy.

Server Explorer and SQL Server

P: n/a
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

Nov 20 '05 #1
Share this Question
Share on Google+
15 Replies


P: n/a
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

Nov 20 '05 #2

P: n/a
"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

Nov 20 '05 #3

P: n/a
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

Nov 20 '05 #4

P: n/a
* "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>
Nov 20 '05 #5

P: n/a
"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.

Nov 20 '05 #6

P: n/a
"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
Nov 20 '05 #7

P: n/a
"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.

Nov 20 '05 #8

P: n/a
* "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>
Nov 20 '05 #9

P: n/a
"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.

Nov 20 '05 #10

P: n/a
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.

Nov 20 '05 #11

P: n/a
"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.

Nov 20 '05 #12

P: n/a
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.

Nov 20 '05 #13

P: n/a
"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

Nov 20 '05 #14

P: n/a

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

Nov 20 '05 #15

P: n/a
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

Nov 20 '05 #16

This discussion thread is closed

Replies have been disabled for this discussion.