Server Explorer and SQL Server

  • Thread starter Thread starter Tom Leylan
  • Start date Start date
T

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
 
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
 
Bernie Yaeger said:
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.
Click to expand...

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

Tom
 
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 said:
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 :-)
Click to expand...

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>
 
Herfried K. Wagner said:
AFAIK VS.NET 2003 professional only supports MSDE with the Server
Explorer.
Click to expand...

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.
 
Rick Mogstad said:
We use SQL server strictly with SQL Authentication, and the Server
Click to expand...
Explorer works with that, so it
will definitely work with something other than windows auth.
Click to expand...

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 said:
The trouble I'm having is that most of what I have found on the subject
seems to be rumor.
Click to expand...

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.
 
* "Tom Leylan said:
The trouble I'm having is that most of what I have found on the subject
seems to be rumor.
Click to expand...

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 said:
Something is messed up...
Click to expand...

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.
 
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)
 
EricJ said:
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)
Click to expand...

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.
 
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
 
EricJ said:
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)
Click to expand...

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
 
Tom Leylan said:
Explorer works with that, so it

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.
Click to expand...

Yes, I can create/Delete tables and stored procedures, though i use it mostly for debugging SPs.
Hope you get it figured out.
 
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....
 
Back
Top