MSDE Question

Sorry if this is basic stuff but I'm new to MSDE and SQL.

I am running MSDE as the server.

I created a Microsoft Access Project and connected to the MSDE. Security is
set to Integrated Security.

When I try to open the database from an application I am writing I get a
login error stating the user doesn't have rights to the database. I am
logged in to the computer with administrator privledges but get the error.

I know that I have to tell the server that users have access to the database
but how do I do that if I can't gain access to the database?

Thanks,

EricI have hit this problem with sql server as well. I fixed it by
creating a server based login. that is one that requires a user name
and password. That way in the program all you need for permission is
those to fields in teh Connection String. Of course you still need to
grant that login access to the relevent dbs

MSDE Not Connected

Hi,

I installed MSDE 2000 SP3 to use the ASP.NET QuickStart samples on
my Windows 2000 machine. I ran
setup.exe /qb+ INSTANCENAME=VSDOTNET DISABLENETWORKPROTOCOLS=1 SAPWD<my password>

I then ran the QuickStart installer.

These steps were documented by MS.

But when I rebooted, the SQL Service Manager was 'Not Connected'
and the circle in front of the server icon was blank/white. Also the QuickStart samples that connect to MSDE won't and give errors like 'System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.' or '...Login failed for user '<my server name>\ASPNET'

When I run 'osql -E -S <my server name>\VSDOTNET' command I get '1>'. So there is a connection that's possible. Also the MSSQL$VSDOTNET is Started.

Any suggestions?Try running the SVRNETCN.exe tool to find out what protocols MSDE is using. I had a similar problem (not with .NET) and found that NO protocols were selected. Ergo, no connection possible.

C:\Program Files\Microsoft SQL Server\80\Tools\Binn\SVRNETCN.exe

-- Steve

Originally posted by ericscat
Hi,

I installed MSDE 2000 SP3 to use the ASP.NET QuickStart samples on
my Windows 2000 machine. I ran
setup.exe /qb+ INSTANCENAME=VSDOTNET DISABLENETWORKPROTOCOLS=1 SAPWD<my password>

I then ran the QuickStart installer.

These steps were documented by MS.

But when I rebooted, the SQL Service Manager was 'Not Connected'
and the circle in front of the server icon was blank/white. Also the QuickStart samples that connect to MSDE won't and give errors like 'System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.' or '...Login failed for user '<my server name>\ASPNET'

When I run 'osql -E -S <my server name>\VSDOTNET' command I get '1>'. So there is a connection that's possible. Also the MSSQL$VSDOTNET is Started.

Any suggestions?|||Hi,

Thanks I ran it and restarted the MSSQL$VSDOTNET service, but I
don't see any change. Sorry I don't know much of this. Your right
there were no protocols selected so I enabled TCP/IP. What is the
SQLAgent$VSDOTNET service? It's setup as a Manual startup.

Any more tips? I would assume that when I installed MSDE and
setup the instance that I would see the small green right pointing
arrow in the Service Manager icon. The Manager still says Not Connected.
??|||Sorry,

I rebooted and got an automatic connection/Sql Server Service
started.
Thanks for your help.

MSDE newbie question: contents of default databases

Having installed MSDE and connected to it, it seems there are several
default databases already:
master
model
msdb
tempdb
Are these intended to be for any specific use?
How do I get a list of the tables that are in these databases?
Simon Elliott http://www.ctsn.co.uk
hi Simon,
"Simon Elliott" <Simon at ctsn.co.uk> ha scritto nel messaggio
news:ureI8NzQEHA.1624@.TK2MSFTNGP09.phx.gbl...
> Having installed MSDE and connected to it, it seems there are several
> default databases already:
> master
> model
> msdb
> tempdb
> Are these intended to be for any specific use?
> How do I get a list of the tables that are in these databases?
in order to limit distribution size, MSDE only ships with system database
you do not have to touch =;-D
these databases are relatated to MSDE itself and are not user database...
if you like some sample database, you can install the Northwind and Pubs
demo databases from
http://www.microsoft.com/downloads/d...DisplayLang=en
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply