I set up MSDE that came with VS.NET and, using the Server Explorer, created a database called 'pubs' on my server. The MSSQLServer icon is lit up in the System Tray and has been started. When I created 'pubs', I was prompted whether I wanted to use NT Integrated Security or SQL Server Authentication. I was forced to choose the NT option because any login name that I used, including my administrator account, the 'aspnet_wp account', 'SQLDebugger' and 'sa'. Every time I tried to use the SQL Server Auth. option, I would get the following error prompt:
ADO Error: '
Login failed for user 'whateverItried'. Reason: Not associated with a trusted SQL Server connection.
When running the following:
Dim myConnection As SqlConnection = New SqlConnection("server=(local);database=pubs;uid=sa;pwd=")
it would result in this error message:
Index #0
Error: System.Data.SqlClient.SqlError: SQL Server does not exist or access denied.
I also tried using 'localhost' and <my-computername>\<my-servername> for the server. For my database name, I tried both pubs and dbo.pubs. I also tried every username I could think of.
No luck.
Here's the funny thing: I was able to create a View on the database that did exactly what I was trying to do in code, so the DB is working.
If anyone has sucessfully ran the first example program in Chapter 16 of Beginning VB.NET 2nd edition, please respond. That's where I got this example.
Thanks for any help!
JasonWhat is the authentication mode used to connect?
Refer to books online for Troubleshooting the Transact-SQL Debugger topic.|||Originally posted by Satya
What is the authentication mode used to connect?
Refer to books online for Troubleshooting the Transact-SQL Debugger topic.
I'm not sure what you are asking. Remember that I'm using MSDE and I don't go through a lot of the setup that MS SQL uses.
I was forced to use the NT Integrated Security, since no usernames or password combinations that I knew would work for the SQL option, if that's what you mean.|||True, update the SQL Server Authentication mode back to SQL Server Authentification as referred in this KBA (http://support.microsoft.com/default.aspx?scid=kb;EN-US;285097).|||I have only one icon running in my system tray and it is set to SQL Server, not SQL Server Agent.
Do I need both running? If so, how can I get an instance of Agent to run as well as the server, as suggested in the KBA?
By the way, thanks for your response!
Jason|||Also, what username do I use? 'SA'?
Jason
Originally posted by jtimms
I have only one icon running in my system tray and it is set to SQL Server, not SQL Server Agent.
Do I need both running? If so, how can I get an instance of Agent to run as well as the server, as suggested in the KBA?
By the way, thanks for your response!
Jason|||We have the same issue. If you also have Enterprise Manager installed on the same machine, use it to be sure TCP/IP is an enabled protocol. We did that and were able to connect.
The 64 dollar question is how you do this if you DON'T have Enterprise manager. Anyone know how to do it programatically?
Jim M.
Orrtax Software|||Of course you can!
Search for this file:
svrnetcn.exe
usually in:
"C:\Program Files\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe"
which is the Server Network Configuration|||Manowar...thank you! I had the same problem as above, and it turned out that my server had not had TCP/IP enabled! Thank you so much!|||hi manomar - thanks a lot for your entry to this forum. i have had exactly the same problem and thru your entries - now it works!
regards,
Originally posted by manowar
Of course you can!
Search for this file:
svrnetcn.exe
usually in:
"C:\Program Files\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe"
which is the Server Network Configuration|||MSDE usually installs as a named instance, rather than the default instance (this way no two MSDE installs can interfere with each other...theoretically). Check in Administrative tools->services, and check the name of the MSSQL service. If it is MSSQLService, then it is amazingly the default instance. If it is MSSQL$blah, then you have a named instance. In order to address a named instance, you need to specify the name of the server, and the name of the instance as
server=servername\blah
You can also use IP addresses:
10.10.10.10\blah
Not sure if this works:
(local)\blah
Note that while the service is named with a '$', and all folders related to the instance are named with a '$', the service is addressed with '\'. Intuitive, right?|||I have another strange problem:
When I use SVRNETCN or click on the properties in enterprise manager, I see that TCP/IP is enabled for my msde Instance.
But when I look in the error.log of my instance, I see only the entry:
SQL server listening on Named Pipes
There is no entry that the server is listening on TCP/IP and I still get the error message "SQL Server does not exist or access denied" when I try to connect to my database over the network.
So I think my server is still not listening on TCP/IP.
Has anyone a workaround for this problem?
Thanks in advance
Showing posts with label denied. Show all posts
Showing posts with label denied. Show all posts
Friday, March 30, 2012
Monday, March 19, 2012
MSDE (SQL Server does not exist or access denied.)
Hi all,
I'm getting this error message when I try to connect my MSDE database from other machine using enterprise manager application. Both of the machines are WinXP SP2. I found some solution such as using 'SQLServer Network Utility' but didn't work out for me. I even can not connect my database on my computer using TCP/IP. When I connect with name, it worked fine. I already enable both TCP/IP and Named pipe protocol on the MSDE machine.
If someone has solution on that please let me know.
Thanks,
MyoDid you open the ports on the computers ?
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de|||If you have SQL Server 2005 installed on the same box as the MSDE, you need make sure SQL Browser is running. Make sure the ports (UDP/1434 and your TCP Port) are open if firewall exists. Also try file sharing between machines and make it work, otherwise NP won't work. When you use cliconfg.exe, make TCP and NP are on the client protocol lists.|||
Yes,
There is also SQL 2000 and 2005Express running together with MSDE. I already changed the port no and try to connect it. But, still didn't work out. I tried at the other machine and it works. I don't know why it still doesn't work at this machine. May be I miss some configuration. I'll try again. Thanks for the message.
Regards,
Myo|||
I have exactly the same issue. I have installed MSDE2000 on a PC with Windows XP Professional and SP2. I have tried everything to connect to another remote server and still get the same error message
I have added ports 135 and ports 445 to the firewall but again without much success. Does anyone out there have any ideas on how to get this working?
|||You will first have to determine the port that MSDE is using by starting the application Srvnetcn.exe naviagte to TCP and note that number down. After this you will have to create an exclude filter for the firewall for the application sqlservr.exe using this number and the 1434 UDP for incoming request. That should egt you started for SQL Server.HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de|||
Hi Jens,
Many thanks for your prompt response. I have tried all your suggestions but still cannot gain access to a remote database. TCP/IP is running on port 1433, using Srvnetcn.exe to check, and I have added both the entries you have suggested to the firewall exclude lists. Any other ideas? Thanks in advance
Monday, March 12, 2012
MSDE & Enterprise Manager
I seem to be having problems registering an MSDE instance with my Enterprise
Manager. I keep getting the 'access denied or server does not exist' error.
Is there something special that I need to do or some other version of
Enterprise Manager that I should be using?
thanks for all your help.
JD
Did you consider this article to set up the desired communication ?
http://www.codeproject.com/database/ConfigureMSDE.asp
HTH, jens Suessmeyer.
|||Jens,
Thank you much for this link. It looks very promising. A few years back,
I had some information on how to set this up but have since lost it.
Once again, Thanks,
Joe
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1129564389.827519.206390@.z14g2000cwz.googlegr oups.com...
> Did you consider this article to set up the desired communication ?
>
> http://www.codeproject.com/database/ConfigureMSDE.asp
>
> HTH, jens Suessmeyer.
>
|||Hello,
This is a general error and you can refer to the following article to
troubleshoot the issue:
Potential causes of the "SQL Server does not exist or access denied" error
message
http://support.microsoft.com/kb/328306/
I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Sophie,
Thanks for the link. I'll check it out this morning.
Joe D
"Sophie Guo [MSFT]" <v-sguo@.online.microsoft.com> wrote in message
news:fI6TTq60FHA.3328@.TK2MSFTNGXA01.phx.gbl...
> Hello,
> This is a general error and you can refer to the following article to
> troubleshoot the issue:
> Potential causes of the "SQL Server does not exist or access denied" error
> message
> http://support.microsoft.com/kb/328306/
> I hope the information is helpful.
> Sophie Guo
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> ================================================== ===
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ================================================== ===
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
|||Hello,
You are welcome. If anyting is unclear, feel free to post back.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
Manager. I keep getting the 'access denied or server does not exist' error.
Is there something special that I need to do or some other version of
Enterprise Manager that I should be using?
thanks for all your help.
JD
Did you consider this article to set up the desired communication ?
http://www.codeproject.com/database/ConfigureMSDE.asp
HTH, jens Suessmeyer.
|||Jens,
Thank you much for this link. It looks very promising. A few years back,
I had some information on how to set this up but have since lost it.
Once again, Thanks,
Joe
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1129564389.827519.206390@.z14g2000cwz.googlegr oups.com...
> Did you consider this article to set up the desired communication ?
>
> http://www.codeproject.com/database/ConfigureMSDE.asp
>
> HTH, jens Suessmeyer.
>
|||Hello,
This is a general error and you can refer to the following article to
troubleshoot the issue:
Potential causes of the "SQL Server does not exist or access denied" error
message
http://support.microsoft.com/kb/328306/
I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Sophie,
Thanks for the link. I'll check it out this morning.
Joe D
"Sophie Guo [MSFT]" <v-sguo@.online.microsoft.com> wrote in message
news:fI6TTq60FHA.3328@.TK2MSFTNGXA01.phx.gbl...
> Hello,
> This is a general error and you can refer to the following article to
> troubleshoot the issue:
> Potential causes of the "SQL Server does not exist or access denied" error
> message
> http://support.microsoft.com/kb/328306/
> I hope the information is helpful.
> Sophie Guo
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> ================================================== ===
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ================================================== ===
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
|||Hello,
You are welcome. If anyting is unclear, feel free to post back.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
MSDE & Enterprise Manager
I seem to be having problems registering an MSDE instance with my Enterprise
Manager. I keep getting the 'access denied or server does not exist' error.
Is there something special that I need to do or some other version of
Enterprise Manager that I should be using?
thanks for all your help.
JDDid you consider this article to set up the desired communication ?
http://www.codeproject.com/database/ConfigureMSDE.asp
HTH, jens Suessmeyer.|||Jens,
Thank you much for this link. It looks very promising. A few years back,
I had some information on how to set this up but have since lost it.
Once again, Thanks,
Joe
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1129564389.827519.206390@.z14g2000cwz.googlegroups.com...
> Did you consider this article to set up the desired communication ?
>
> http://www.codeproject.com/database/ConfigureMSDE.asp
>
> HTH, jens Suessmeyer.
>|||Hello,
This is a general error and you can refer to the following article to
troubleshoot the issue:
Potential causes of the "SQL Server does not exist or access denied" error
message
http://support.microsoft.com/kb/328306/
I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Sophie,
Thanks for the link. I'll check it out this morning.
Joe D
"Sophie Guo [MSFT]" <v-sguo@.online.microsoft.com> wrote in message
news:fI6TTq60FHA.3328@.TK2MSFTNGXA01.phx.gbl...
> Hello,
> This is a general error and you can refer to the following article to
> troubleshoot the issue:
> Potential causes of the "SQL Server does not exist or access denied" error
> message
> http://support.microsoft.com/kb/328306/
> I hope the information is helpful.
> Sophie Guo
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> =====================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Hello,
You are welcome. If anyting is unclear, feel free to post back.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.
Manager. I keep getting the 'access denied or server does not exist' error.
Is there something special that I need to do or some other version of
Enterprise Manager that I should be using?
thanks for all your help.
JDDid you consider this article to set up the desired communication ?
http://www.codeproject.com/database/ConfigureMSDE.asp
HTH, jens Suessmeyer.|||Jens,
Thank you much for this link. It looks very promising. A few years back,
I had some information on how to set this up but have since lost it.
Once again, Thanks,
Joe
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1129564389.827519.206390@.z14g2000cwz.googlegroups.com...
> Did you consider this article to set up the desired communication ?
>
> http://www.codeproject.com/database/ConfigureMSDE.asp
>
> HTH, jens Suessmeyer.
>|||Hello,
This is a general error and you can refer to the following article to
troubleshoot the issue:
Potential causes of the "SQL Server does not exist or access denied" error
message
http://support.microsoft.com/kb/328306/
I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Sophie,
Thanks for the link. I'll check it out this morning.
Joe D
"Sophie Guo [MSFT]" <v-sguo@.online.microsoft.com> wrote in message
news:fI6TTq60FHA.3328@.TK2MSFTNGXA01.phx.gbl...
> Hello,
> This is a general error and you can refer to the following article to
> troubleshoot the issue:
> Potential causes of the "SQL Server does not exist or access denied" error
> message
> http://support.microsoft.com/kb/328306/
> I hope the information is helpful.
> Sophie Guo
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> =====================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Hello,
You are welcome. If anyting is unclear, feel free to post back.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.
MSDE & Enterprise Manager
I seem to be having problems registering an MSDE instance with my Enterprise
Manager. I keep getting the 'access denied or server does not exist' error.
Is there something special that I need to do or some other version of
Enterprise Manager that I should be using?
thanks for all your help.
JDDid you consider this article to set up the desired communication ?
http://www.codeproject.com/database/ConfigureMSDE.asp
HTH, jens Suessmeyer.|||Jens,
Thank you much for this link. It looks very promising. A few years back,
I had some information on how to set this up but have since lost it.
Once again, Thanks,
Joe
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1129564389.827519.206390@.z14g2000cwz.googlegroups.com...
> Did you consider this article to set up the desired communication ?
>
> http://www.codeproject.com/database/ConfigureMSDE.asp
>
> HTH, jens Suessmeyer.
>|||Hello,
This is a general error and you can refer to the following article to
troubleshoot the issue:
Potential causes of the "SQL Server does not exist or access denied" error
message
http://support.microsoft.com/kb/328306/
I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
========================================
=============
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.|||Sophie,
Thanks for the link. I'll check it out this morning.
Joe D
"Sophie Guo [MSFT]" <v-sguo@.online.microsoft.com> wrote in message
news:fI6TTq60FHA.3328@.TK2MSFTNGXA01.phx.gbl...
> Hello,
> This is a general error and you can refer to the following article to
> troubleshoot the issue:
> Potential causes of the "SQL Server does not exist or access denied" error
> message
> http://support.microsoft.com/kb/328306/
> I hope the information is helpful.
> Sophie Guo
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> ========================================
=============
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
=============
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Hello,
You are welcome. If anyting is unclear, feel free to post back.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
========================================
=============
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
Manager. I keep getting the 'access denied or server does not exist' error.
Is there something special that I need to do or some other version of
Enterprise Manager that I should be using?
thanks for all your help.
JDDid you consider this article to set up the desired communication ?
http://www.codeproject.com/database/ConfigureMSDE.asp
HTH, jens Suessmeyer.|||Jens,
Thank you much for this link. It looks very promising. A few years back,
I had some information on how to set this up but have since lost it.
Once again, Thanks,
Joe
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1129564389.827519.206390@.z14g2000cwz.googlegroups.com...
> Did you consider this article to set up the desired communication ?
>
> http://www.codeproject.com/database/ConfigureMSDE.asp
>
> HTH, jens Suessmeyer.
>|||Hello,
This is a general error and you can refer to the following article to
troubleshoot the issue:
Potential causes of the "SQL Server does not exist or access denied" error
message
http://support.microsoft.com/kb/328306/
I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
========================================
=============
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.|||Sophie,
Thanks for the link. I'll check it out this morning.
Joe D
"Sophie Guo [MSFT]" <v-sguo@.online.microsoft.com> wrote in message
news:fI6TTq60FHA.3328@.TK2MSFTNGXA01.phx.gbl...
> Hello,
> This is a general error and you can refer to the following article to
> troubleshoot the issue:
> Potential causes of the "SQL Server does not exist or access denied" error
> message
> http://support.microsoft.com/kb/328306/
> I hope the information is helpful.
> Sophie Guo
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> ========================================
=============
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
=============
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Hello,
You are welcome. If anyting is unclear, feel free to post back.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
========================================
=============
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
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
>
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
>
Subscribe to:
Posts (Atom)