MSDE

Not able to connect to named instance of MSDE
C:\>osql -E -S NT14954\MSSQL$MYMSDE1
[DBMSLPCN]SQL Server does not exist or access denied.
[DBMSLPCN]ConnectionOpen (Connect()).
HelpHi,
See if the SQL Server service is running. If running then open the SQL
Server error log and see the name of the SQL server.
After that use the same name to connect.
Thanks
Hari
SQL Server MVP
"docsql" <docsql@.noemail.nospam> wrote in message
news:%23YPOANkuFHA.128@.TK2MSFTNGP09.phx.gbl...
> Not able to connect to named instance of MSDE
> C:\>osql -E -S NT14954\MSSQL$MYMSDE1
> [DBMSLPCN]SQL Server does not exist or access denied.
> [DBMSLPCN]ConnectionOpen (Connect()).
>
> Help
>|||The name of your MSDE instance is NT14954\MYMSDE1 so to connect use
osql -E -S NT14954\MYMSDE1
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"docsql" <docsql@.noemail.nospam> wrote in message
news:%23YPOANkuFHA.128@.TK2MSFTNGP09.phx.gbl...
> Not able to connect to named instance of MSDE
> C:\>osql -E -S NT14954\MSSQL$MYMSDE1
> [DBMSLPCN]SQL Server does not exist or access denied.
> [DBMSLPCN]ConnectionOpen (Connect()).
>
> Help
>