Re: Having trouble connecting to MSDE
From: Andrea Montanari (andrea.sqlDMO_at_virgilio.it)
Date: 08/03/04
- Next message: Ferde: "Re: SQL SERVER 2000 SP3 HOSES MDAC 2.8"
- Previous message: Aaron [SQL Server MVP]: "Re: SQL SERVER 2000 SP3 HOSES MDAC 2.8"
- In reply to: Culbert: "Having trouble connecting to MSDE"
- Next in thread: Culbert: "Re: Having trouble connecting to MSDE"
- Reply: Culbert: "Re: Having trouble connecting to MSDE"
- Reply: uritsukidoji: "Re: Having trouble connecting to MSDE"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 3 Aug 2004 16:20:30 +0200
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
- Next message: Ferde: "Re: SQL SERVER 2000 SP3 HOSES MDAC 2.8"
- Previous message: Aaron [SQL Server MVP]: "Re: SQL SERVER 2000 SP3 HOSES MDAC 2.8"
- In reply to: Culbert: "Having trouble connecting to MSDE"
- Next in thread: Culbert: "Re: Having trouble connecting to MSDE"
- Reply: Culbert: "Re: Having trouble connecting to MSDE"
- Reply: uritsukidoji: "Re: Having trouble connecting to MSDE"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
