Can't get connected to MSDE Remotely

I have a problem getting connected to an instance of MSDE remotely. I can
register the instance in Enterprise Manager, and work with it locally on the
machine it is installed on but cannot get connected remotely. I get the
famous SQL Server does not exist or access is denied.
It is a named instance.
The security mode is set to SQL.
Network Protocols are enabled.
netstat tells me that it is listening on the correct port.
I'm logging in remotely as sa with the correct password.
Any help here would be appreciated.
Also for some reason the name of the server doesn't show up in the list in
Enterprise manager on the remote machine when trying to register the server.
I typed in the name of the server, the sa login and password, but still the
same error. Server doesn't exist or access is denied.
"jdehne" wrote:

> I have a problem getting connected to an instance of MSDE remotely. I can
> register the instance in Enterprise Manager, and work with it locally on the
> machine it is installed on but cannot get connected remotely. I get the
> famous SQL Server does not exist or access is denied.
> It is a named instance.
> The security mode is set to SQL.
> Network Protocols are enabled.
> netstat tells me that it is listening on the correct port.
> I'm logging in remotely as sa with the correct password.
> Any help here would be appreciated.
|||I have also tried adding the alias with the same port as MSDE is configured.
"jdehne" wrote:
[vbcol=seagreen]
> Also for some reason the name of the server doesn't show up in the list in
> Enterprise manager on the remote machine when trying to register the server.
> I typed in the name of the server, the sa login and password, but still the
> same error. Server doesn't exist or access is denied.
> "jdehne" wrote:
|||i have also noticed that when running osql -L on the remote machine the MSDE
instance does not show up.
"jdehne" wrote:
[vbcol=seagreen]
> I have also tried adding the alias with the same port as MSDE is configured.
> "jdehne" wrote:
|||Am Mon, 17 Oct 2005 15:06:03 -0700 schrieb jdehne:
[vbcol=seagreen]
> i have also noticed that when running osql -L on the remote machine the MSDE
> instance does not show up.
> "jdehne" wrote:
I can only guess:
a) TCP is enabled on the server but not on the client
b) connect doesn't work with servername but with server-IP
c) MDAC's are different versions
bye,
Helmut
|||hi,
jdehne wrote:
> i have also noticed that when running osql -L on the remote machine
> the MSDE instance does not show up.
try having a look at http://support.microsoft.com/kb/841251/en-us ,
http://support.microsoft.com/kb/841249/en-us
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||I managed to figure it out. SP2 Secruity center was blocking the port and I
had add the sqlserver.exe to the list of programs that can get through the
firewall.
"Andrea Montanari" wrote:

> hi,
> jdehne wrote:
> try having a look at http://support.microsoft.com/kb/841251/en-us ,
> http://support.microsoft.com/kb/841249/en-us
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>

Can't find server

Hello
I installed the old MSDE 2000 (not release a) on a Windows XP Pro machine. I
manage the DB with the MSDE Manager from Vale Software. On the machine it
self, it works fine. I can select the DB and connect as 'sa' with password.
But on every other machine in the network, I can't connect to the DB. I can
ping to the server, that's no problem. I can chose the server in MSDE
Manager (and other DB-Tools like 'Aqua Data Studio' and 'DBVisualizer') but
I always get an error message like 'Cannot find server'. On the XP machine
there is no firewall running and -of course- the SQL-Server task is started.
The port 1433 isn't blocked.
Have enyone an idea why I can connect the DB on the machine it self but not
from every other machine in the network?
Thanks a lot
Dani
It's possible that the server does not have the network connectivity library
enabled.
i don't know how re-enable it in MSDE after MSDE is already installed.
Although i know it can be done, i read it a few days ago in the MSDE2000A
readme.
If it were SQL server, i'd say use the "Server Network Utility" (i think
it's called that). In that you can enable/disable tcpip,netbios,
multiprotocol, flatulance, etc.
"Daniel Geisseler" <d.geisseler@.gmx.net> wrote in message
news:2lk43sFd4pjhU1@.uni-berlin.de...
> Hello
> I installed the old MSDE 2000 (not release a) on a Windows XP Pro machine.
I
> manage the DB with the MSDE Manager from Vale Software. On the machine it
> self, it works fine. I can select the DB and connect as 'sa' with
password.
> But on every other machine in the network, I can't connect to the DB. I
can
> ping to the server, that's no problem. I can chose the server in MSDE
> Manager (and other DB-Tools like 'Aqua Data Studio' and 'DBVisualizer')
but
> I always get an error message like 'Cannot find server'. On the XP machine
> there is no firewall running and -of course- the SQL-Server task is
started.
> The port 1433 isn't blocked.
> Have enyone an idea why I can connect the DB on the machine it self but
not
> from every other machine in the network?
> Thanks a lot
> Dani
>
|||If you run svrnetcn.exe from the /Program Files/Microsoft SQL
Server/80/Tools/BINN folder it will bring up the Server network utility, you
can make sure the network libraries are enabled.
HTH
Dylan Kruger
"Ian Boyd" <admin@.SWIFTPA.NET> wrote in message
news:eGyjL5ZaEHA.1048@.tk2msftngp13.phx.gbl...
> It's possible that the server does not have the network connectivity
> library
> enabled.
> i don't know how re-enable it in MSDE after MSDE is already installed.
> Although i know it can be done, i read it a few days ago in the MSDE2000A
> readme.
> If it were SQL server, i'd say use the "Server Network Utility" (i think
> it's called that). In that you can enable/disable tcpip,netbios,
> multiprotocol, flatulance, etc.
>
> "Daniel Geisseler" <d.geisseler@.gmx.net> wrote in message
> news:2lk43sFd4pjhU1@.uni-berlin.de...
> I
> password.
> can
> but
> started.
> not
>
|||Yeah, exactly that's it! The TCP/IP was disabled. I don't now why but after
I startet again, it works fine.
1000 thanks to you...
Dani
1000 thanks
"Dylan kruger" <carmellobear1@.hotmail.com> schrieb im Newsbeitrag
news:eC7EjuaaEHA.3112@.tk2msftngp13.phx.gbl...
> If you run svrnetcn.exe from the /Program Files/Microsoft SQL
> Server/80/Tools/BINN folder it will bring up the Server network utility,
you[vbcol=seagreen]
> can make sure the network libraries are enabled.
> HTH
> Dylan Kruger
> "Ian Boyd" <admin@.SWIFTPA.NET> wrote in message
> news:eGyjL5ZaEHA.1048@.tk2msftngp13.phx.gbl...
MSDE2000A[vbcol=seagreen]
it
>
|||It's a new feature of MSDE, that by default it doesn't act like any other
server application on earth.
Go figure.
Probably Microsoft's tired of hearing people XXXXX about being
wormed/hacked/infected, and they just say, "Fine, your XXX get's no
connectivity anymore. Suck it!"
"Daniel Geisseler" <d.geisseler@.gmx.net> wrote in message
news:2lmm2oFept7kU1@.uni-berlin.de...
> Yeah, exactly that's it! The TCP/IP was disabled. I don't now why but
after[vbcol=seagreen]
> I startet again, it works fine.
> 1000 thanks to you...
> Dani
>
> 1000 thanks
> "Dylan kruger" <carmellobear1@.hotmail.com> schrieb im Newsbeitrag
> news:eC7EjuaaEHA.3112@.tk2msftngp13.phx.gbl...
> you
> MSDE2000A
think[vbcol=seagreen]
machine[vbcol=seagreen]
> it
I[vbcol=seagreen]
'DBVisualizer')[vbcol=seagreen]
but
>
|||I had a similar problem - I was not able to connect to the MSDE from
any other machine. I had tried openning the TCP/IP Port (1433) and even
shutting down the Firewall.
Eventually, I was able to able to fix the issue by adding the registry
value for "ProtocolList" under HKEY_LOCAL_MACHINE -> SOFTWARE ->
Microsoft -> MSSQLServer -> SuperSocketNetLib
But now I have a different issue. How can I connect to the MSDE
instance with DBVisualizer? I tried to create a connection but when I
try to select / edit a Driver the drop down is empty and I cannot get
one from the list that I get by hitting the Edit button.
Please help.
- manzoor

Cant find installer

I'm trying my first install of MSDE 2000 and having some
difficulty. I downloaded the package, then extracted it.
Then read the entire readme telling me all the
requirements and such. I then opened a console window,
and tried to install it. I made my changes to my .ini
file and referenced that on the command line. I'm
getting an error message however that says this. "The
installation package could not be opened. Verify that
the package exists and that you can access it, or contact
the application vendor to verify that this is a valid
Windows installer pakcage".
I went to the knowledge base and the only thing I could
find as a possible problem was that I have SQL server
running all 16 instances on my machine, but this is my
first install ever so there's no way that I have any
other instances running. Please help!
"Culbert" <anonymous@.discussions.microsoft.com> wrote in message
news:7d1301c4773e$0d033c10$a301280a@.phx.gbl...
> I'm trying my first install of MSDE 2000 and having some
> difficulty. I downloaded the package, then extracted it.
> Then read the entire readme telling me all the
> requirements and such. I then opened a console window,
> and tried to install it. I made my changes to my .ini
> file and referenced that on the command line. I'm
> getting an error message however that says this. "The
> installation package could not be opened. Verify that
> the package exists and that you can access it, or contact
> the application vendor to verify that this is a valid
> Windows installer pakcage".
> I went to the knowledge base and the only thing I could
> find as a possible problem was that I have SQL server
> running all 16 instances on my machine, but this is my
> first install ever so there's no way that I have any
> other instances running. Please help!
This may be belaboring the obvious, but you did navigate to the directory
where MSDE was extracted before issuing the install command (or, include the
fully qualified path to the install file in the command), correct?
Peter [MVP Visual Developer]
Jack of all trades, master of none.
|||
>--Original Message--
>"Culbert" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:7d1301c4773e$0d033c10$a301280a@.phx.gbl...
some[vbcol=seagreen]
it.[vbcol=seagreen]
contact
>This may be belaboring the obvious, but you did navigate
to the directory
>where MSDE was extracted before issuing the install
command (or, include the
>fully qualified path to the install file in the
command), correct?
>--
>Peter [MVP Visual Developer]
>Jack of all trades, master of none.
>
>.
>
Thank you for the reply. I figured it out, but what it
was I never though of. I downloaded a corrupt .exe
file. It was the same size, but when I re-downloaded it,
it will still the same size except it had WAY more files
this time after extracting.
Thanks!
|||"Culbert" <anonymous@.discussions.microsoft.com> wrote in message
news:9e0501c47907$84099910$a401280a@.phx.gbl...
> Thank you for the reply. I figured it out, but what it
> was I never though of. I downloaded a corrupt .exe
> file. It was the same size, but when I re-downloaded it,
> it will still the same size except it had WAY more files
> this time after extracting.
> Thanks!
Glad you got it worked out, and thank you for posting the resolution!
Peter [MVP Visual Developer]
Jack of all trades, master of none.
sql

Cant Create MSDE Database using ASP.NET Matrix

Hi i am having problems creating a new MSDE database when using the
ASP.NET Web Matrix to create it.
It says to click on New Connection, select SQL Sever Authentication,
add in the username and password and then click create new database.
I get an error though saying
Unable to connect to database server
SQL Server does not exist or access denied
ConnectionOpen(Connect())
Any suggestions?
Perhaps you didn=B4t setup the right network settigns:
http://www.codeproject.com/database/ConfigureMSDE.asp
HTH, Jens Suessmeyer.
|||Nope still doesnt seem to be letting me create a new database through
the ASP.Net Matrix.
I removed and then reinstalled the MSDE following the link you gave me,
then set it up following their stages.
I can create a database through the cmd.exe but still having the
problems with ASP.Net Matrix.
Going to remove and reinstall the .net matrix and see if that works.
|||Hi there, managed to get everything working now. deleted the .net web
matrix and the MSDE off my computer. then reinstalled everything again.
the version of .net web matrix i had seemed to be out of date so maybe
this is what was causing the problem.
Thanks for your help.

Can't create a ODBC DSN to a remote MSDE instance

Hello,
I need to create an ODBC DNS that points to a remote MSDE instance, but I
can only get it to work if I turn Windows Firewall off. Both the local and
remote machines are WinXP SP2 and have SQL2000 and MSDE, same domain and I
can login as the same person on each machine.
On the remote machine I've enabled TCP/IP and the default port, and I've
added that port to the firewall, but when I try to add a DSN (on the local
machine) in the ODBC control panel it says
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
access denied.
I've looked at the instance via Enterprise Manager and my domain login has
admin privs, and can connect a DSN to the SQL2000 server on that machine.
Stumped.
Suggestions?
Keith
hi Keith,
Keith wrote:
> Hello,
> I need to create an ODBC DNS that points to a remote MSDE instance,
> but I can only get it to work if I turn Windows Firewall off. Both
> the local and remote machines are WinXP SP2 and have SQL2000 and
> MSDE, same domain and I can login as the same person on each machine.
> On the remote machine I've enabled TCP/IP and the default port, and
> I've added that port to the firewall, but when I try to add a DSN (on
> the local machine) in the ODBC control panel it says
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not
> exist or access denied.
> I've looked at the instance via Enterprise Manager and my domain
> login has admin privs, and can connect a DSN to the SQL2000 server on
> that machine.
did you define an exception on the server's firewall on the MSDE used TCP/IP
port or on the service itself?
http://support.microsoft.com/default.aspx?kbid=841249
http://support.microsoft.com/default.aspx?scid=kb;[LN];841251
http://support.microsoft.com/default.aspx?scid=kb;[LN];884012 (Win2003)
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||>
> did you define an exception on the server's firewall on the MSDE used
> TCP/IP port or on the service itself?
> http://support.microsoft.com/default.aspx?kbid=841249
> http://support.microsoft.com/default.aspx?scid=kb;[LN];841251
> http://support.microsoft.com/default.aspx?scid=kb;[LN];884012 (Win2003)
Well, after some reboots and a walk around the block it works now.
I finally got it to work either with firewall port exception, or a service
exception, but neither way seemed very consistent. Making changes to the
firewall while it is running just doesn't seem to work that well; perhaps I
wasn't waiting long enough for the changes to propagate or I just need to
stop/start the firewall after changing something.
And I suspect that some of the changes that don't "require" rebooting really
do.
Anyway, thanks for the quick response and support links.
Keith

Can't connet to MSDE with Query Analyzer

I'm running MSDE on a WIN2K and I'm having a problem accessing the MSDE from
a laptop with WINXP Professional. I'm using a NETGEAR MR314 cable router w/
firewall to connect the two computers and I'm getting the following error:
Unable to connec to server SERVERNAME
Server: Msg 17, Level 16, State1
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
access denied
I've tried by creating a new account with owner rights to all databases and
I still get the same error when connecting with Query Analyzer. When I get
the "Connect to SQL Server" dialog box I can see the server but when I enter
the user name an password it gives me the error message.
The client is attempting to connect using TCP/IP so you will
want to make sure this protocol is enabled for MSDE. You can
use the server network utility to check, enable the
protocols. The utility file name is svrnetcn.exe. You can
find it in the Tools\Binn directory of your installation
path.
You can also find some general troubleshooting for the error
at:
INF: Potential Causes of the "SQL Server Does Not Exist or
Access Denied" Error Message
http://support.microsoft.com/?id=328306
-Sue
On Sun, 2 May 2004 16:00:49 -0500, "Sal Young"
<salyoung@.comcast.net> wrote:

>I'm running MSDE on a WIN2K and I'm having a problem accessing the MSDE from
>a laptop with WINXP Professional. I'm using a NETGEAR MR314 cable router w/
>firewall to connect the two computers and I'm getting the following error:
>Unable to connec to server SERVERNAME
>Server: Msg 17, Level 16, State1
>[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
>access denied
>
>I've tried by creating a new account with owner rights to all databases and
>I still get the same error when connecting with Query Analyzer. When I get
>the "Connect to SQL Server" dialog box I can see the server but when I enter
>the user name an password it gives me the error message.
>

Can't connet to MSDE with Query Analyzer

I'm running MSDE on a WIN2K and I'm having a problem accessing the MSDE from
a laptop with WINXP Professional. I'm using a NETGEAR MR314 cable router w/
firewall to connect the two computers and I'm getting the following error:
Unable to connec to server SERVERNAME
Server: Msg 17, Level 16, State1
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not
exist or
access denied
I've tried by creating a new account with owner rights to all databases and
I still get the same error when connecting with Query Analyzer. When I get
the "Connect to SQL Server" dialog box I can see the server but when I enter
the user name an password it gives me the error message.Hi Sal,
Try creating a Test ODBC DSN to the MSDE server. Then review the OS
Error returned.
This will help troubleshoot the problem.
Example:
10060 = Connection Timeout
11001 = Host not found.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Can't connet to MSDE with Query Analyzer

I'm running MSDE on a WIN2K and I'm having a problem accessing the MSDE from
a laptop with WINXP Professional. I'm using a NETGEAR MR314 cable router w/
firewall to connect the two computers and I'm getting the following error:
Unable to connec to server SERVERNAME
Server: Msg 17, Level 16, State1
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
access denied
I've tried by creating a new account with owner rights to all databases and
I still get the same error when connecting with Query Analyzer. When I get
the "Connect to SQL Server" dialog box I can see the server but when I enter
the user name an password it gives me the error message.
MSDE doesn't listen to any netlibs by default. You can enable netlibs using the svrnetcn.exe utility.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Sal Young" <salyoung@.comcast.net> wrote in message news:MMadnZ23tfPw_AjdRVn-sA@.comcast.com...
> I'm running MSDE on a WIN2K and I'm having a problem accessing the MSDE from
> a laptop with WINXP Professional. I'm using a NETGEAR MR314 cable router w/
> firewall to connect the two computers and I'm getting the following error:
> Unable to connec to server SERVERNAME
> Server: Msg 17, Level 16, State1
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
> access denied
>
> I've tried by creating a new account with owner rights to all databases and
> I still get the same error when connecting with Query Analyzer. When I get
> the "Connect to SQL Server" dialog box I can see the server but when I enter
> the user name an password it gives me the error message.
>

Can't connet to MSDE with Query Analyzer

I'm running MSDE on a WIN2K and I'm having a problem accessing the MSDE from
a laptop with WINXP Professional. I'm using a NETGEAR MR314 cable router w/
firewall to connect the two computers and I'm getting the following error:
Unable to connec to server SERVERNAME
Server: Msg 17, Level 16, State1
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
access denied
I've tried by creating a new account with owner rights to all databases and
I still get the same error when connecting with Query Analyzer. When I get
the "Connect to SQL Server" dialog box I can see the server but when I enter
the user name an password it gives me the error message.
Hi Sal,
Try creating a Test ODBC DSN to the MSDE server. Then review the OS
Error returned.
This will help troubleshoot the problem.
Example:
10060 = Connection Timeout
11001 = Host not found.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

cant connect xp pro sp2 to database on ntserver 4

We have a program using sqlserver7, bde 5.01, msde, which works fine on the
98se machines we have connecting to ntserver4, however we got a new xp pro
machine with sp2, I have mapped the exe to the network and it goes to a login
screen, where it then fails to connect to the database with a generic cannot
connect to database error. I have turned the firewall in xp off to see if
that helps, I have also included the exe and the instance of sql server on
the list of exceptions
in the firewall
any ideas what I'm missing?
managed to fix the problem ourselves, looked in the registry settings for
borland, turns out the config file was looking at the server but the dll was
looking locally, so we repointed the dll to the server borland folder and hey
presto program connects and works fine
another side point, I was able to export the borland registry key from a
98se machine into the xp pro machine to enable quick setup of borland on xp
"seatzie" wrote:

> We have a program using sqlserver7, bde 5.01, msde, which works fine on the
> 98se machines we have connecting to ntserver4, however we got a new xp pro
> machine with sp2, I have mapped the exe to the network and it goes to a login
> screen, where it then fails to connect to the database with a generic cannot
> connect to database error. I have turned the firewall in xp off to see if
> that helps, I have also included the exe and the instance of sql server on
> the list of exceptions
> in the firewall
> any ideas what I'm missing?

cant connect xp pro sp2 to database on ntserver 4

We have a program using sqlserver7, bde 5.01, msde, which works fine on the
98se machines we have connecting to ntserver4, however we got a new xp pro
machine with sp2, I have mapped the exe to the network and it goes to a logi
n
screen, where it then fails to connect to the database with a generic cannot
connect to database error. I have turned the firewall in xp off to see if
that helps, I have also included the exe and the instance of sql server on
the list of exceptions
in the firewall
any ideas what I'm missing?managed to fix the problem ourselves, looked in the registry settings for
borland, turns out the config file was looking at the server but the dll was
looking locally, so we repointed the dll to the server borland folder and he
y
presto program connects and works fine
another side point, I was able to export the borland registry key from a
98se machine into the xp pro machine to enable quick setup of borland on xp
"seatzie" wrote:

> We have a program using sqlserver7, bde 5.01, msde, which works fine on th
e
> 98se machines we have connecting to ntserver4, however we got a new xp pro
> machine with sp2, I have mapped the exe to the network and it goes to a lo
gin
> screen, where it then fails to connect to the database with a generic cann
ot
> connect to database error. I have turned the firewall in xp off to see if
> that helps, I have also included the exe and the instance of sql server on
> the list of exceptions
> in the firewall
> any ideas what I'm missing?

Can't connect via Enterprise Manager

Hi All,
We have a MSDE on a W2K server installed. It is running fine and the
application can access it without a problem. We have another server on that
same subnet that has an SQL 2000 server installed. When trying to connect to
the MSDE via the Enterprise Manager, only the local SQL shows up and we
cannot connect to the MSDE instance.
When we go to the ODBC on the MSDE box we see both SQL - the local and the
remote one. On the ODBC on the other server we only see the local one.
Does anybody have an idea what is going on?
Thanks,
Claus
Hi Claus,
Most likely network protocols not enabled. Run svrnetcn.exe and check which
protocols (eg tcp) are enabled. By default, none are.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"cjobes" <cjobes@.nova-tech.org> wrote in message
news:%234wb4E1oEHA.4044@.TK2MSFTNGP10.phx.gbl...
> Hi All,
> We have a MSDE on a W2K server installed. It is running fine and the
> application can access it without a problem. We have another server on
that
> same subnet that has an SQL 2000 server installed. When trying to connect
to
> the MSDE via the Enterprise Manager, only the local SQL shows up and we
> cannot connect to the MSDE instance.
> When we go to the ODBC on the MSDE box we see both SQL - the local and the
> remote one. On the ODBC on the other server we only see the local one.
> Does anybody have an idea what is going on?
> Thanks,
> Claus
>
|||Hi Greg,
Thanks for the answer. I double checked and both protocols (tcp and named
pipe) are enabled.
Claus
"Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
news:%23LcQb96oEHA.1160@.tk2msftngp13.phx.gbl...
> Hi Claus,
> Most likely network protocols not enabled. Run svrnetcn.exe and check
which[vbcol=seagreen]
> protocols (eg tcp) are enabled. By default, none are.
> HTH,
> --
> Greg Low [MVP]
> MSDE Manager SQL Tools
> www.whitebearconsulting.com
> "cjobes" <cjobes@.nova-tech.org> wrote in message
> news:%234wb4E1oEHA.4044@.TK2MSFTNGP10.phx.gbl...
> that
connect[vbcol=seagreen]
> to
the
>
|||Claus,
Have you checked the firewall settings on the second server? If it has
the TCP port used by MSDE blocked you won't be able to connect.
Ron Allen
"cjobes" <cjobes@.nova-tech.org> wrote in message
news:%23WJfzS9oEHA.3460@.tk2msftngp13.phx.gbl...
> Hi Greg,
> Thanks for the answer. I double checked and both protocols (tcp and named
> pipe) are enabled.
> Claus
> "Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
> news:%23LcQb96oEHA.1160@.tk2msftngp13.phx.gbl...
> which
> connect
> the
>
|||Hi Claus,
I might need more inputs to trouble shoot this issue. Before this, you
could try Re- registering the MSDE Server in your Enterprise Manager.
Please use the Register SQL Server Wizard. For the sake of Clarity, I am
outling the steps here.
In the Enterprise Manager, If the MSDE Server is already
Registered, then Select Server, Right Click on the Server and Select Delete
SQL Server Registration.
1. In the Enterprise Manager, Start Register SQL Server Wizard. (Right
Click on SQL Server Group, Select New SQL Server Registration)
2. In the 'Select a SQL Server' page (second page), In the 'Available
Servers' Text box enter the Computer Name on which the MSDE is installed.
(Hope it is a default instance. If it is a Named Instance then enter
Instance Name also eg: Default Instance on Computer Named Test - TEST,
Named Instance 'Test1' on TEST - TEST\Test1 ). Then click 'ADD' button.
Click Next.
3. In the Next Page Select Authentication Mode.
4. In the Next Page Click Next
5. In the Last Page Select Finish.
After few minutes, You would see a screen which should say
'Server Registration completed' Status 'Registered Successfully'.
If this goes through, You would be able to see the MSDE in your Enterprise
manager. In case it fails, Please mail me the exact Error Message that you
would see in the Status column. We would try and troubleshoot it further.
Thanks,
Soma Sekhara Reddy
|||There is no firewall on that server and I'm in the same subnet trying to
connect.
"Ron Allen" <rallen@._nospam_src-us.com> wrote in message
news:eXZzmPJpEHA.1644@.tk2msftngp13.phx.gbl...
> Claus,
> Have you checked the firewall settings on the second server? If it
has[vbcol=seagreen]
> the TCP port used by MSDE blocked you won't be able to connect.
> Ron Allen
> "cjobes" <cjobes@.nova-tech.org> wrote in message
> news:%23WJfzS9oEHA.3460@.tk2msftngp13.phx.gbl...
named[vbcol=seagreen]
on[vbcol=seagreen]
we[vbcol=seagreen]
and[vbcol=seagreen]
one.
>
|||Thanks for your answer. This is what I have tried several times. The answer
I get back is "SQL server not running or access denied". I'm trying to
connect with SQL authentication (sa and password). I'm sure about the sa and
password because I use it in the local ODBC connection and the test works
fine.
I know I'm missing something really obvious - just can't put my finger on
it.
Claus
"Soma Sekhara Reddy" <somsredd@.microsoft.com> wrote in message
news:nyon0IQpEHA.3212@.cpmsftngxa06.phx.gbl...
> Hi Claus,
> I might need more inputs to trouble shoot this issue. Before this, you
> could try Re- registering the MSDE Server in your Enterprise Manager.
> Please use the Register SQL Server Wizard. For the sake of Clarity, I am
> outling the steps here.
> In the Enterprise Manager, If the MSDE Server is already
> Registered, then Select Server, Right Click on the Server and Select
Delete
> SQL Server Registration.
> 1. In the Enterprise Manager, Start Register SQL Server Wizard. (Right
> Click on SQL Server Group, Select New SQL Server Registration)
> 2. In the 'Select a SQL Server' page (second page), In the 'Available
> Servers' Text box enter the Computer Name on which the MSDE is installed.
> (Hope it is a default instance. If it is a Named Instance then enter
> Instance Name also eg: Default Instance on Computer Named Test - TEST,
> Named Instance 'Test1' on TEST - TEST\Test1 ). Then click 'ADD' button.
> Click Next.
> 3. In the Next Page Select Authentication Mode.
> 4. In the Next Page Click Next
> 5. In the Last Page Select Finish.
> After few minutes, You would see a screen which should
say
> 'Server Registration completed' Status 'Registered Successfully'.
> If this goes through, You would be able to see the MSDE in your Enterprise
> manager. In case it fails, Please mail me the exact Error Message that
you
> would see in the Status column. We would try and troubleshoot it further.
> Thanks,
> Soma Sekhara Reddy
>
|||Hi Claus,
Please use the 'ODBCPING' command line utility to check the connectivity.
The syntax is
odbcping -Sservername -Uusername -Ppassword
This tool is loaded with SQL Server client utilities and would be available
on your system. Please do not leave any space betweeb -S and servername,
-S is caps (case sensitive).
Thanks,
Soma Sekhara Reddy

Can't connect to sql express 2005

I have an very big application written in vb6 running on msde 2000. I tried to change it to sql express 2005 and I cannot connect to the database. I wrote a sample app in vb6 using adodc and it works fine. From the other app I get no connection. I copied the same connection string!. I do not use the adodc control.I connect with a connection object.I have enabled pipes and tcp/ip. Any ideas or suggestions more than welcome.

Which error do you get ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

There are many KB articles which walk through remote connections to SQL Express. Please check out the following:

http://support.microsoft.com/kb/555585/en-us - in addition to enabling tcp connections, you need to ensure you have allowed remote connections and setup the firewall correctly.

http://support.microsoft.com/kb/319930/en-us

|||

The error message is -2147217843 Login failed for user 'Master'.

I detached the databases from msde2000 and attached them on SQLExpress 2005.

|||I don't have a firewall installed and by inspecting the registry key the LoginMode is set to 2 Mixed Mode authentication.|||Can you post your connection string here? You can hide some sensitive info.|||

The connection is

Server = "CMP\SQLEXPRESS"

g_SQLProvider = "SQLNCLI.1"

ConnOpsDB = "Persist Security Info=False;User ID=George;Password=''" _
& ";Data Source=" & Server
With cnOpsDB
.Provider = g_SQLProvider
.ConnectionString = ConnOpsDB
.Open
.DefaultDatabase = "MercDB"
End With

|||With this connection string, do you still get "Login failed for user 'Master'."? Looks like the user is "george" here. But, anyway you should make sure the user in the connection string should have login premission to its default or initial database.|||

With the above connection string I am getting "Login failed for user 'George'. THe problem is that after attaching the database from MSDE 2000to Sql Express 2005 and using the MS SQL Server Management Studio I cannot set the permissions right. I cannot have the user i want behave as sa. any ideas?

|||OK, you Upgraded / attached the database to the SQL Server 2005 Express instance. The database principal is included within the database whereas the login fo the user you are trying to use is not automatically created as a server principal on the server level. YOu will have to either delete the user in the database and recreate it at server level granting him acces and the appropiate rights in the database from scratch or will have to remap the newly created server principal with the "old" database principal. See more information here:

http://vyaskn.tripod.com/troubleshooting_orphan_users.htm

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Can't connect to sql express 2005

I have an very big application written in vb6 running on msde 2000. I tried to change it to sql express 2005 and I cannot connect to the database. I wrote a sample app in vb6 using adodc and it works fine. From the other app I get no connection. I copied the same connection string!. I do not use the adodc control.I connect with a connection object.I have enabled pipes and tcp/ip. Any ideas or suggestions more than welcome.

Which error do you get ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

There are many KB articles which walk through remote connections to SQL Express. Please check out the following:

http://support.microsoft.com/kb/555585/en-us - in addition to enabling tcp connections, you need to ensure you have allowed remote connections and setup the firewall correctly.

http://support.microsoft.com/kb/319930/en-us

|||

The error message is -2147217843 Login failed for user 'Master'.

I detached the databases from msde2000 and attached them on SQLExpress 2005.

|||I don't have a firewall installed and by inspecting the registry key the LoginMode is set to 2 Mixed Mode authentication.|||Can you post your connection string here? You can hide some sensitive info.|||

The connection is

Server = "CMP\SQLEXPRESS"

g_SQLProvider = "SQLNCLI.1"

ConnOpsDB = "Persist Security Info=False;User ID=George;Password=''" _
& ";Data Source=" & Server
With cnOpsDB
.Provider = g_SQLProvider
.ConnectionString = ConnOpsDB
.Open
.DefaultDatabase = "MercDB"
End With

|||With this connection string, do you still get "Login failed for user 'Master'."? Looks like the user is "george" here. But, anyway you should make sure the user in the connection string should have login premission to its default or initial database.|||

With the above connection string I am getting "Login failed for user 'George'. THe problem is that after attaching the database from MSDE 2000to Sql Express 2005 and using the MS SQL Server Management Studio I cannot set the permissions right. I cannot have the user i want behave as sa. any ideas?

|||OK, you Upgraded / attached the database to the SQL Server 2005 Express instance. The database principal is included within the database whereas the login fo the user you are trying to use is not automatically created as a server principal on the server level. YOu will have to either delete the user in the database and recreate it at server level granting him acces and the appropiate rights in the database from scratch or will have to remap the newly created server principal with the "old" database principal. See more information here:

http://vyaskn.tripod.com/troubleshooting_orphan_users.htm

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Can't connect to SQL 2005

Hi,
I just installed MSDE 2005 (or, rather, whatever it's called now) on my
machine. I'm trying to connect to it using Enterprise Manager, but I
keep getting Unable to connect/connection refused messages.
I've tried giving it my machine name, the word (local), localhost,
127.0.0.1, my machine's IP... nothing. I've also tried all those
permutations using cliconfg.exe, with the same results.
I ran the SQL Manager plug-in, and it shows that SQL Server is indeed
running. Also I tried doing an ODBCPING against it, with the following
errors:
SQLState: 08001 Native Error: 17
Info. Message: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL
Server
does not exist or access denied.
SQLState: 01000 Native Error: 1326
Info. Message: [Microsoft][ODBC SQL Server Driver][DBNETLIB]
ConnectionOpen (Connect()).
Any recommendations on a next step to try?If you're trying to run the EM for 2000, it won't work. Not supported.
"Scott McNair" <scott.mcnair@.sfmco.takethispartout.com> wrote in message
news:Xns95D7AB2AE2D3Bsfmco@.207.46.248.16...
> Hi,
> I just installed MSDE 2005 (or, rather, whatever it's called now) on my
> machine. I'm trying to connect to it using Enterprise Manager, but I
> keep getting Unable to connect/connection refused messages.
> I've tried giving it my machine name, the word (local), localhost,
> 127.0.0.1, my machine's IP... nothing. I've also tried all those
> permutations using cliconfg.exe, with the same results.
> I ran the SQL Manager plug-in, and it shows that SQL Server is indeed
> running. Also I tried doing an ODBCPING against it, with the following
> errors:
> SQLState: 08001 Native Error: 17
> Info. Message: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQ
L Server
> does not exist or access denied.
> SQLState: 01000 Native Error: 1326
> Info. Message: [Microsoft][ODBC SQL Server Driver][DBNETLIB]
> ConnectionOpen (Connect()).
> Any recommendations on a next step to try?|||Derrick Leggett wrote:
> If you're trying to run the EM for 2000, it won't work. Not supported.
>
> "Scott McNair" <scott.mcnair@.sfmco.takethispartout.com> wrote in message
> news:Xns95D7AB2AE2D3Bsfmco@.207.46.248.16...
>
>
>
What about setting up an ODBC System DSN? Shouldn't this be supported
through the SQL Native Client? I get pretty much the same errors when
trying to do that.

Can't connect to SQL 2005

Hi,
I just installed MSDE 2005 (or, rather, whatever it's called now) on my
machine. I'm trying to connect to it using Enterprise Manager, but I
keep getting Unable to connect/connection refused messages.
I've tried giving it my machine name, the word (local), localhost,
127.0.0.1, my machine's IP... nothing. I've also tried all those
permutations using cliconfg.exe, with the same results.
I ran the SQL Manager plug-in, and it shows that SQL Server is indeed
running. Also I tried doing an ODBCPING against it, with the following
errors:
SQLState: 08001 Native Error: 17
Info. Message: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server
does not exist or access denied.
SQLState: 01000 Native Error: 1326
Info. Message: [Microsoft][ODBC SQL Server Driver][DBNETLIB]
ConnectionOpen (Connect()).
Any recommendations on a next step to try?
If you're trying to run the EM for 2000, it won't work. Not supported.
"Scott McNair" <scott.mcnair@.sfmco.takethispartout.com> wrote in message
news:Xns95D7AB2AE2D3Bsfmco@.207.46.248.16...
> Hi,
> I just installed MSDE 2005 (or, rather, whatever it's called now) on my
> machine. I'm trying to connect to it using Enterprise Manager, but I
> keep getting Unable to connect/connection refused messages.
> I've tried giving it my machine name, the word (local), localhost,
> 127.0.0.1, my machine's IP... nothing. I've also tried all those
> permutations using cliconfg.exe, with the same results.
> I ran the SQL Manager plug-in, and it shows that SQL Server is indeed
> running. Also I tried doing an ODBCPING against it, with the following
> errors:
> SQLState: 08001 Native Error: 17
> Info. Message: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server
> does not exist or access denied.
> SQLState: 01000 Native Error: 1326
> Info. Message: [Microsoft][ODBC SQL Server Driver][DBNETLIB]
> ConnectionOpen (Connect()).
> Any recommendations on a next step to try?
|||Derrick Leggett wrote:
> If you're trying to run the EM for 2000, it won't work. Not supported.
>
> "Scott McNair" <scott.mcnair@.sfmco.takethispartout.com> wrote in message
> news:Xns95D7AB2AE2D3Bsfmco@.207.46.248.16...
>
>
What about setting up an ODBC System DSN? Shouldn't this be supported
through the SQL Native Client? I get pretty much the same errors when
trying to do that.

Can't connect to remote MSDE with ODBC

I have been trying on an off for a month to connect to an MSDE (SQL server)
database from a remote computer with ODBC. I can connect just fine from
within the workgroup.
In Cliconfg, I have set up an alias pointing to servername.com\INSTANCENAME.
tcp/ip is set. There is not a firewall in play at this time. The server is
also configured to use TCP/IP.
Is it possible to connect to a remote SQL server with ODBC? This is really
frustrating.
I did the same drill with mysql and it is a piece of cake, but I really need
to use SQL server in this instance.
BradI just figured out my problem.
I reviewed the server logs and found that the server was listening on port
1212. So, with cliconfg I set up an alias to use this same port.
Man, what a relief to finally get this figured out.
Brad
"Brad Dennis" <Brad@.f1csp.com> wrote in message
news:eGiujTq5DHA.2732@.TK2MSFTNGP09.phx.gbl...

quote:

---

> I have been trying on an off for a month to connect to an MSDE (SQL

---

server)

quote:

---

> database from a remote computer with ODBC. I can connect just fine from
> within the workgroup.
> In Cliconfg, I have set up an alias pointing to

---

servername.com\INSTANCENAME.

quote:

---

> tcp/ip is set. There is not a firewall in play at this time. The server

---

is

quote:

---

> also configured to use TCP/IP.
> Is it possible to connect to a remote SQL server with ODBC? This is

---

really

quote:

---

> frustrating.
> I did the same drill with mysql and it is a piece of cake, but I really

---

need

quote:

---

> to use SQL server in this instance.
> Brad
>

---

Can't connect to my running MSDE server

I see my little icon in the stystem tray, and I have the green arrow lit as
well. I go into Access and start a project and try to connect to my server
which is listed in the drop down box of my choice of servers.
It asks me a user name and password to connect, but how do I
create/add/remove users and how do I set their passwords? I tried my network
ID and password but I just get connection errors that say either the server
does not exist or that access is denied.
How do connect?
Thanks,
Try "sa" (without the quotes) for the ID with a blank password. That is the
default setup on many instances.
Wayne
"Culbert" <Culbert@.discussions.microsoft.com> wrote in message
news:F1E34845-9F16-45B6-A910-4A79D6CE0B05@.microsoft.com...
> I see my little icon in the stystem tray, and I have the green arrow lit
as
> well. I go into Access and start a project and try to connect to my
server
> which is listed in the drop down box of my choice of servers.
> It asks me a user name and password to connect, but how do I
> create/add/remove users and how do I set their passwords? I tried my
network
> ID and password but I just get connection errors that say either the
server
> does not exist or that access is denied.
> How do connect?
> Thanks,
|||I tried that, and when I did that at first it looked like it was working, but
then still I got an error message :o(
Is there a way to assign user names and such?
"Wayne Wengert" wrote:

> Try "sa" (without the quotes) for the ID with a blank password. That is the
> default setup on many instances.
> Wayne
> "Culbert" <Culbert@.discussions.microsoft.com> wrote in message
> news:F1E34845-9F16-45B6-A910-4A79D6CE0B05@.microsoft.com...
> as
> server
> network
> server
>
>
|||hi,
"Culbert" <Culbert@.discussions.microsoft.com> ha scritto nel messaggio
news:1925EC53-DC5E-4DDA-8476-5C3CC6BB6B41@.microsoft.com[vbcol=seagreen]
> I tried that, and when I did that at first it looked like it was
> working, but then still I got an error message :o(
> Is there a way to assign user names and such?
>
> "Wayne Wengert" wrote:
MSDE installs by default enabling only "trusted" connections, thus non
permitting to specify Username and Password and you should choose a
WindowsNT authenticated connection...
if you want to modify that behaviour, both at install time or later, you can
have a look at
http://support.microsoft.com/default...;en-us;Q285097
in order to "add" Windows users you can use the
EXEC sp_grantlogin ...
stored procedure (
http://msdn.microsoft.com/library/de...ga-gz_8dri.asp )
, where, in order to add a SQL Server authenticated user, you have to resort
on
EXEC sp_addlogin ..
stored procedure
(http://msdn.microsoft.com/library/de...-us/tsqlref/ts
_sp_adda_0q7i.asp)
you can have a look at
http://support.microsoft.com/default...;EN-US;q325003 for further
info on how to use oSql.exe command line tool to manage logins and users..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Can't connect to MSDE with Query Analyzer

I'm running MSDE on a WIN2K and I'm having a problem accessing the MSDE from
a laptop with WINXP Professional. I'm using a NETGEAR MR314 cable router w/
firewall to connect the two computers and I'm getting the following error:
Unable to connec to server SERVERNAME
Server: Msg 17, Level 16, State1
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
access denied
I've tried by creating a new account with owner rights to all databases and
I still get the same error when connecting with Query Analyzer. When I get
the "Connect to SQL Server" dialog box I can see the server but when I enter
the user name an password it gives me the error message.
To start with, run the following command using ISQL.exe
ISQL -Stcp:ServerNameHere -Usa -Ppassword -Q"select @.@.version"
The reason why I am asking you to do this is because this will help you in
troubleshooting the error. Try looking for the OS Error returned.
I am suspecting that the server is not listening on the port and you can
try to restart MSSQLServer and can verify that SQL is listening. Hope this
helps.
Sanchan [MSFT]
sanchans@.online.microsoft.com
This posting is provided "AS IS" with no warranties, and confers no rights.

Cant connect to MSDE on XPSP1

We are writing a setup program for a customer that requires a MSDE
installation.
Using the following flags for the MSDE setup.exe:
SAPWD = "password" SECURITYMODE=SQL
The setup complete successfully, we are restarting the installed machine
(SQL services restarts as well)
But we cannot connect to the MSDE from any enterprise manager (Enterprise,
Developer versions)
This happens only when the MSDE installed on a WindowsXP SP1 machine.
Can someone help us solve this problem?
Thanks,
Shif
It may be that you don't have any network protocols enabled for MSDE. Run
the tool svrnetcn.exe (you'll find it in C:\Program Files\Microsoft SQL
Server\80\Tools\Binn) and check to make sure that you have the necessary
protocols enabled.
Jim
"Shif Arad" <shif@.inter.net.il> wrote in message
news:Om8nd%23vJEHA.2604@.tk2msftngp13.phx.gbl...
> We are writing a setup program for a customer that requires a MSDE
> installation.
> Using the following flags for the MSDE setup.exe:
> SAPWD = "password" SECURITYMODE=SQL
>
> The setup complete successfully, we are restarting the installed machine
> (SQL services restarts as well)
> But we cannot connect to the MSDE from any enterprise manager (Enterprise,
> Developer versions)
> This happens only when the MSDE installed on a WindowsXP SP1 machine.
>
> Can someone help us solve this problem?
> Thanks,
> Shif
>