Re: Having trouble connecting to MSDE
From: Culbert (anonymous_at_discussions.microsoft.com)
Date: 08/09/04
- Previous message: liz23: "msde 2000 verify instance"
- In reply to: Andrea Montanari: "Re: Having trouble connecting to MSDE"
- Next in thread: uritsukidoji: "Re: Having trouble connecting to MSDE"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 8 Aug 2004 19:11:58 -0700
>-----Original Message-----
>hi,
>"Culbert" <anonymous@discussions.microsoft.com> ha
scritto nel messaggio
>news:9fc901c47908$3cad5bf0$a501280a@phx.gbl...
>> I have a very basic workgroup at home. I have three
>> computers, two of them on XP Pro (the ones I'm using
MSDE
>> with). I was able to install MSDE and I see the icon on
>> my system tray. Now, I was reading how to upsize an
>> Access database from this page
>> http://msdn.microsoft.com/library/default.asp?
>> url=/library/en-us/dnmsde/html/msdeforvs.asp
>>
>> I choose to create a new database after starting the
>> Upsize wizard. Then I choose the server, which shows up
>> in the drop down box. Then it asks me for a username and
>> password that has "CREATE DATABASE" privileges on the
>> server. So I put my administrator user name and password
>> in, then choose the name of my new MSDE database, but it
>> won't connect. I then tried using no username or
>> password and I get another error message. What's going
>> on?
>> This is a link to my errors.
>>
http://www.neolinkcomputers.com/stuff/connection_errors.ht
>> m
>>
>> Thanks
>
>the reported errors indicate :
>a) you instance is set to only allow Windows NT (trusted)
connection, which
>is the default when installing MSDE on Windows NT
platform... in order to
>allow SQL Server authenticated connection, please have a
look at
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;285097 for further
>info in order to change this behaviour both at install
time and later...
>
>b)you windows account you are using to connect to that
MSDE instance is not
>granted login provileges...
>you have to login with a sysadmin login, usually part of
>builtin\administrators of SQL Server, and grant that
windows account login
>privileges using sp_grantlogin system stored procedure
>(http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/tsqlref/ts
>_sp_ga-gz_8dri.asp) and then grant database access to
that login for all
>desired databases using sp_grantdbaccess system stored
procedure
>(http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/tsqlref/ts
>_sp_ga-gz_290z.asp)
>for your convenience, you can have a look at a free prj
of mine at the link
>following my sign., which provides a user interface
similar to Enterprise
>Manager, which provides these functionnalities too in a
viusal way..
>further free and/or commercial tools for managing MSDE
can be found at
>http://www.microsoft.com/sql/msde/partners/default.asp and
>http://www.aspfaq.com/show.asp?id=2442
>--
>Andrea Montanari (Microsoft MVP - SQL Server)
>http://www.asql.biz/DbaMgr.shtm
http://italy.mvps.org
>DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
>(my vb6+sql-dmo little try to provide MS MSDE 1.0 and
MSDE 2000 a visual
>interface)
>--------- remove DMO to reply
>
>.
Incredible! I haven't tried this yet, but I'm confident
that this will work. Thank you for such a great response!!
>
- Previous message: liz23: "msde 2000 verify instance"
- In reply to: Andrea Montanari: "Re: Having trouble connecting to MSDE"
- Next in thread: uritsukidoji: "Re: Having trouble connecting to MSDE"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
