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/stuf...tion_errors.ht

m



Thanks

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/stuf...tion_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...b;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/de...-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/de...-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

>-----Original Message-----

>hi,

>"Culbert" <anonymous@discussions.microsoft.com> ha

scritto nel messaggio[vbcol=seagreen]

>news:9fc901c47908$3cad5bf0$a501280a@phx.gbl... 

MSDE[vbcol=seagreen] 

http://www.neolinkcomputers.com/stuf...tion_errors.ht 

>

>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!!

>

Hi,



Maybe I should start a new thread, but my problem is the same, except that I know that the problem is my TCP/IP Access is disabled to MSDE. 



I have no Enterprise Manager, any idea wich registry key I need to modify to enable TCP/IP Access? 



(Similar to the SQL/Windows Authentification problem?)



Thanks!

hi,

"uritsukidoji" <uritsukidoji.1aq8cb@mail.mcse.ms> ha scritto nel messaggio

news:uritsukidoji.1aq8cb@mail.mcse.ms...

>

> Hi,

>

> Maybe I should start a new thread, but my problem is the same, except

> that I know that the problem is my TCP/IP Access is disabled to MSDE.

>

> I have no Enterprise Manager, any idea wich registry key I need to

> modify to enable TCP/IP Access?

>

> (Similar to the SQL/Windows Authentification problem?)

>

> Thanks!



have a look at Server Network Utility (svrnetcn.exe) for server side

settings, and ClientNetwork Utility (cliconfg.exe) fro client side part

--

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