Can't connect to my running MSDE server

I see my little icon in the stystem tray, and I have the green arrow lit as
well. I go into Access and start a project and try to connect to my server
which is listed in the drop down box of my choice of servers.
It asks me a user name and password to connect, but how do I
create/add/remove users and how do I set their passwords? I tried my network
ID and password but I just get connection errors that say either the server
does not exist or that access is denied.
How do connect?
Thanks,
Try "sa" (without the quotes) for the ID with a blank password. That is the
default setup on many instances.
Wayne
"Culbert" <Culbert@.discussions.microsoft.com> wrote in message
news:F1E34845-9F16-45B6-A910-4A79D6CE0B05@.microsoft.com...
> I see my little icon in the stystem tray, and I have the green arrow lit
as
> well. I go into Access and start a project and try to connect to my
server
> which is listed in the drop down box of my choice of servers.
> It asks me a user name and password to connect, but how do I
> create/add/remove users and how do I set their passwords? I tried my
network
> ID and password but I just get connection errors that say either the
server
> does not exist or that access is denied.
> How do connect?
> Thanks,
|||I tried that, and when I did that at first it looked like it was working, but
then still I got an error message :o(
Is there a way to assign user names and such?
"Wayne Wengert" wrote:

> Try "sa" (without the quotes) for the ID with a blank password. That is the
> default setup on many instances.
> Wayne
> "Culbert" <Culbert@.discussions.microsoft.com> wrote in message
> news:F1E34845-9F16-45B6-A910-4A79D6CE0B05@.microsoft.com...
> as
> server
> network
> server
>
>
|||hi,
"Culbert" <Culbert@.discussions.microsoft.com> ha scritto nel messaggio
news:1925EC53-DC5E-4DDA-8476-5C3CC6BB6B41@.microsoft.com[vbcol=seagreen]
> I tried that, and when I did that at first it looked like it was
> working, but then still I got an error message :o(
> Is there a way to assign user names and such?
>
> "Wayne Wengert" wrote:
MSDE installs by default enabling only "trusted" connections, thus non
permitting to specify Username and Password and you should choose a
WindowsNT authenticated connection...
if you want to modify that behaviour, both at install time or later, you can
have a look at
http://support.microsoft.com/default...;en-us;Q285097
in order to "add" Windows users you can use the
EXEC sp_grantlogin ...
stored procedure (
http://msdn.microsoft.com/library/de...ga-gz_8dri.asp )
, where, in order to add a SQL Server authenticated user, you have to resort
on
EXEC sp_addlogin ..
stored procedure
(http://msdn.microsoft.com/library/de...-us/tsqlref/ts
_sp_adda_0q7i.asp)
you can have a look at
http://support.microsoft.com/default...;EN-US;q325003 for further
info on how to use oSql.exe command line tool to manage logins and users..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply