I installed MSDE SP3a on my XP Pro laptop using the following options:
SAPWD=abc456
instancename=MSDE01
DISABLENETWORKPROTOCOLS=0
SECURITYMODE=SQL
DATADIR="C:\MSDE"
TARGETDIR="C:\MSDE"
I went to services and started MSSQL$MSDE01 and SQLAgent$MSDE01.
I opened up MSACCESS 2003 and created a new project with new data. The SQL Server Database Wizard popped up and I entered (local)MSDE01 for the SQL server and clicked the Use Trusted Connection.
After several seconds, I receive an error message:
Connection failed:
SQLState: '01000'
SQL Server Error: 53
[Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen(Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or access denied.
I can connect to this instance of MSDE using ASP.NET and the Server Explorer. So I'm pretty sure that I have a good install of MSDE.
Does anyone have a clue as to what I am doing wrong when I try to connect via Access?
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
Hi,
Try (local)\MSDE01 instead.
HTH,
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:uv46MJeIEHA.3968@.TK2MSFTNGP12.phx.gbl...
> I installed MSDE SP3a on my XP Pro laptop using the following options:
> SAPWD=abc456
> instancename=MSDE01
> DISABLENETWORKPROTOCOLS=0
> SECURITYMODE=SQL
> DATADIR="C:\MSDE"
> TARGETDIR="C:\MSDE"
> I went to services and started MSSQL$MSDE01 and SQLAgent$MSDE01.
> I opened up MSACCESS 2003 and created a new project with new data. The
SQL Server Database Wizard popped up and I entered (local)MSDE01 for the SQL
server and clicked the Use Trusted Connection.
> After several seconds, I receive an error message:
> Connection failed:
> SQLState: '01000'
> SQL Server Error: 53
> [Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen(Connect()).
> Connection failed:
> SQLState: '08001'
> SQL Server Error: 17
> [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or
access denied.
> I can connect to this instance of MSDE using ASP.NET and the Server
Explorer. So I'm pretty sure that I have a good install of MSDE.
> Does anyone have a clue as to what I am doing wrong when I try to connect
via Access?
>
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.
|||or .\MSDE01
HTH,
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:uv46MJeIEHA.3968@.TK2MSFTNGP12.phx.gbl...
> I installed MSDE SP3a on my XP Pro laptop using the following options:
> SAPWD=abc456
> instancename=MSDE01
> DISABLENETWORKPROTOCOLS=0
> SECURITYMODE=SQL
> DATADIR="C:\MSDE"
> TARGETDIR="C:\MSDE"
> I went to services and started MSSQL$MSDE01 and SQLAgent$MSDE01.
> I opened up MSACCESS 2003 and created a new project with new data. The
SQL Server Database Wizard popped up and I entered (local)MSDE01 for the SQL
server and clicked the Use Trusted Connection.
> After several seconds, I receive an error message:
> Connection failed:
> SQLState: '01000'
> SQL Server Error: 53
> [Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen(Connect()).
> Connection failed:
> SQLState: '08001'
> SQL Server Error: 17
> [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or
access denied.
> I can connect to this instance of MSDE using ASP.NET and the Server
Explorer. So I'm pretty sure that I have a good install of MSDE.
> Does anyone have a clue as to what I am doing wrong when I try to connect
via Access?
>
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.
Showing posts with label laptop. Show all posts
Showing posts with label laptop. Show all posts
Friday, March 30, 2012
msde AlaptopND sql server on save
I have SQL Server Developer edition on my laptop. Want to install MSDE on
same laptop (so VB .NET 2003 will work.
Any issues here with two versions/inmstances of "SQL Server" on same box?
On Sat, 16 Apr 2005 13:11:28 -0700, rOBBY wrote:
>I have SQL Server Developer edition on my laptop. Want to install MSDE on
>same laptop (so VB .NET 2003 will work.
>Any issues here with two versions/inmstances of "SQL Server" on same box?
Hi Robby,
I have never tried it myself, but I *think* that it should work. Though
I can imagine your poor laptop having a hard time, attempting to serve
two memory-intensive applications. :-)
For a more authorative answer, I suggest you repeat your question in
microsoft.public.sqlserver.msde, or microsoft.public.sqlserver.setup.
This group (microsoft.public.sqlserver.mseq) is actually about English
Query, so most MSDE and setup experts don't hang around here.
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)
same laptop (so VB .NET 2003 will work.
Any issues here with two versions/inmstances of "SQL Server" on same box?
On Sat, 16 Apr 2005 13:11:28 -0700, rOBBY wrote:
>I have SQL Server Developer edition on my laptop. Want to install MSDE on
>same laptop (so VB .NET 2003 will work.
>Any issues here with two versions/inmstances of "SQL Server" on same box?
Hi Robby,
I have never tried it myself, but I *think* that it should work. Though
I can imagine your poor laptop having a hard time, attempting to serve
two memory-intensive applications. :-)
For a more authorative answer, I suggest you repeat your question in
microsoft.public.sqlserver.msde, or microsoft.public.sqlserver.setup.
This group (microsoft.public.sqlserver.mseq) is actually about English
Query, so most MSDE and setup experts don't hang around here.
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)
Friday, March 23, 2012
MSDE 2000 Install - setup.ini
I have installed MSDE 2000 on my Windows 2000 laptop using the SP3 setup.exe and associated setup.ini file.
So far I have included the following parameters in the setup.ini file -
SAPWD=<my own SA password>
SECURITYMODE=SQL
COLLATION=SQL_Latin1_General_CP1_CI_AS
My next test is to connect to a database on the laptop from my desktop (via my LAN) using SQL Server 2000 Enterprise Manager and/or Query Analyser.
The problem is that although I can 'see' my laptop (ping/My Network Places etc.), I can not see the MSDE installation hense my database on the laptop. The message I get is '[Microsoft]ODBC SQL server driver [DBNETLIB] SQL Server does not exist or access denied'
Have I missed a parameter i.e. do I need to set up a parameter to ensure I can connect to the installation from remote?
Being new to installing MSDE, are there any other parameters I have missed?
Ian
p.s. Anyone know of a simple to follow install instruction set for MSDE 2000 which shows what parameters can be set upSolved the problem myself.
With Service Pack 3, msde has added a new parameter to the install = DISABLENETWORKPROTOCOLS. This parameter is defaulted to 1 which blocks remote access to the database. By adding the parameter with a value of 0 to the setup.ini file I can now connect from remote.
Ian
Originally posted by Ian Grant
I have installed MSDE 2000 on my Windows 2000 laptop using the SP3 setup.exe and associated setup.ini file.
So far I have included the following parameters in the setup.ini file -
SAPWD=<my own SA password>
SECURITYMODE=SQL
COLLATION=SQL_Latin1_General_CP1_CI_AS
My next test is to connect to a database on the laptop from my desktop (via my LAN) using SQL Server 2000 Enterprise Manager and/or Query Analyser.
The problem is that although I can 'see' my laptop (ping/My Network Places etc.), I can not see the MSDE installation hense my database on the laptop. The message I get is '[Microsoft]ODBC SQL server driver [DBNETLIB] SQL Server does not exist or access denied'
Have I missed a parameter i.e. do I need to set up a parameter to ensure I can connect to the installation from remote?
Being new to installing MSDE, are there any other parameters I have missed?
Ian
p.s. Anyone know of a simple to follow install instruction set for MSDE 2000 which shows what parameters can be set up
So far I have included the following parameters in the setup.ini file -
SAPWD=<my own SA password>
SECURITYMODE=SQL
COLLATION=SQL_Latin1_General_CP1_CI_AS
My next test is to connect to a database on the laptop from my desktop (via my LAN) using SQL Server 2000 Enterprise Manager and/or Query Analyser.
The problem is that although I can 'see' my laptop (ping/My Network Places etc.), I can not see the MSDE installation hense my database on the laptop. The message I get is '[Microsoft]ODBC SQL server driver [DBNETLIB] SQL Server does not exist or access denied'
Have I missed a parameter i.e. do I need to set up a parameter to ensure I can connect to the installation from remote?
Being new to installing MSDE, are there any other parameters I have missed?
Ian
p.s. Anyone know of a simple to follow install instruction set for MSDE 2000 which shows what parameters can be set upSolved the problem myself.
With Service Pack 3, msde has added a new parameter to the install = DISABLENETWORKPROTOCOLS. This parameter is defaulted to 1 which blocks remote access to the database. By adding the parameter with a value of 0 to the setup.ini file I can now connect from remote.
Ian
Originally posted by Ian Grant
I have installed MSDE 2000 on my Windows 2000 laptop using the SP3 setup.exe and associated setup.ini file.
So far I have included the following parameters in the setup.ini file -
SAPWD=<my own SA password>
SECURITYMODE=SQL
COLLATION=SQL_Latin1_General_CP1_CI_AS
My next test is to connect to a database on the laptop from my desktop (via my LAN) using SQL Server 2000 Enterprise Manager and/or Query Analyser.
The problem is that although I can 'see' my laptop (ping/My Network Places etc.), I can not see the MSDE installation hense my database on the laptop. The message I get is '[Microsoft]ODBC SQL server driver [DBNETLIB] SQL Server does not exist or access denied'
Have I missed a parameter i.e. do I need to set up a parameter to ensure I can connect to the installation from remote?
Being new to installing MSDE, are there any other parameters I have missed?
Ian
p.s. Anyone know of a simple to follow install instruction set for MSDE 2000 which shows what parameters can be set up
Monday, March 12, 2012
MSDE - MSSQL$MICROSOFTSMLBIZ ?
I need to work with MSDE on a new laptop ive been given. Apparently msde is already installed. I have a service runningnamed "MSSQL$MICROSOFTSMLBIZ" - how do i configure it, or shouldI just download a later copy of msde and setup a new copy ? Iknow I know...use sql express. However, I need to work with msdein this case to make it easier (on me) for moving the data into a sql2000 database.
thanks
So you have SQL2000 instance? Then you can register the MSDE instance in Enterprise Manager, thus it should be much easier to manage the MSDE databases: Open Enterprise Manager->right click a SQL Server Group->choose New SQL Server Registration.
Otherwise you have to use osql utility to manage MSDE, which would be painful if you're not familiar with T-SQL.
Wednesday, March 7, 2012
msde
i have 2 computers 1 desktop dell the other a hp laptop both run windows xp
home , but only the laptop will show the sever running. I would like to get
the same on my desktop but i do not know how if someone could show me how to
set it up on desktop i would appreciate.
ty john myrick
hi John,
john m wrote:
> i have 2 computers 1 desktop dell the other a hp laptop both run
> windows xp home , but only the laptop will show the sever running. I
> would like to get the same on my desktop but i do not know how if
> someone could show me how to set it up on desktop i would appreciate.
what do you mean by "but only the laptop will show the sever running" ?
is the MSDE instance service not running or just not showing in the SQL
Server Service Manager?
(http://support.microsoft.com/default...b;EN-US;814132)
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
home , but only the laptop will show the sever running. I would like to get
the same on my desktop but i do not know how if someone could show me how to
set it up on desktop i would appreciate.
ty john myrick
hi John,
john m wrote:
> i have 2 computers 1 desktop dell the other a hp laptop both run
> windows xp home , but only the laptop will show the sever running. I
> would like to get the same on my desktop but i do not know how if
> someone could show me how to set it up on desktop i would appreciate.
what do you mean by "but only the laptop will show the sever running" ?
is the MSDE instance service not running or just not showing in the SQL
Server Service Manager?
(http://support.microsoft.com/default...b;EN-US;814132)
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
Subscribe to:
Posts (Atom)