Showing posts with label gtosql. Show all posts
Showing posts with label gtosql. Show all posts

Friday, March 9, 2012

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
>

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()).
Help
Hi,
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
>

Wednesday, March 7, 2012

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
>