MSDE access denied error

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

MSDCT Volumes not available for SQL Install

There on and accessable through Explorer and Disk Management. However when I
try to install SQL as a new virtual instance I only have access to my Quorum
Resources.
Installing Sql2000 on 2003 server Active /Passive.
One instance is already installed and running. Has been for several months.
If I remember right for each SQL Instance you would need new spindles as
they cannot be shared between SQL Instances on a MSCS.
"dibblm" <dibblm@.hotmail.com> wrote in message
news:u1cRduCIFHA.2456@.TK2MSFTNGP09.phx.gbl...
> There on and accessable through Explorer and Disk Management. However when
> I try to install SQL as a new virtual instance I only have access to my
> Quorum Resources.
> Installing Sql2000 on 2003 server Active /Passive.
> One instance is already installed and running. Has been for several
> months.
>
|||Correct.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog
"wasonce" <mike@.ntadmins.org> wrote in message
news:OzISmIQIFHA.576@.TK2MSFTNGP15.phx.gbl...
> If I remember right for each SQL Instance you would need new spindles as
> they cannot be shared between SQL Instances on a MSCS.
> "dibblm" <dibblm@.hotmail.com> wrote in message
> news:u1cRduCIFHA.2456@.TK2MSFTNGP09.phx.gbl...
>
|||I dont understand what you mean as far as new spindles.
I have 3 columes in a 6TB SAN. I have SQL installed to one. With the datbase
on another and the log files on another. Thus utilizing 3 seperate volumes
for disaster management and recovery. What do you mean as far as needing a
new spindle?
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:ekNy3YQIFHA.3364@.TK2MSFTNGP10.phx.gbl...
> Correct.
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> http://www.msmvps.com/clustering - Blog
> "wasonce" <mike@.ntadmins.org> wrote in message
> news:OzISmIQIFHA.576@.TK2MSFTNGP15.phx.gbl...
>
|||This article
http://www.sqlservercentral.com/colu...youbuyasan.asp
gives you great examples. More disks, more spindles.
Here is a pretty explanation of what a spindle is
http://www.webopedia.com/TERM/s/spindle.html.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"dibblm" <dibblm@.hotmail.com> wrote in message
news:eSgSrfzIFHA.588@.TK2MSFTNGP15.phx.gbl...
>I dont understand what you mean as far as new spindles.
> I have 3 columes in a 6TB SAN. I have SQL installed to one. With the
> datbase on another and the log files on another. Thus utilizing 3 seperate
> volumes for disaster management and recovery. What do you mean as far as
> needing a new spindle?
>
> "Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
> message news:ekNy3YQIFHA.3364@.TK2MSFTNGP10.phx.gbl...
>
|||I personally think this isn't my issues. I have 42 Drives (Or spindles) I
have plenty of room. The problem is with Sql itself on the install.
Something is hosed in the os where the SQL install doesnt even see the
resources.
Let me get you a little closer to the problem.
You state the sql setup.
You can shoose either local, remote or virtual. ( I choose virtual)
then you have to assign ip's and so on
once you get to the area where you pick where you want to install the
instance to.......... My only resource is the Quorum resource itself. I
do not even see my other resources that contain other volumes.
My initial install showed as follows
<Quorum>
<<<<<Q:
<<<<<F: ( left over storage that wasnt needed)
<MSDTC>
<<<<<G: ( About 2 TB of storage)
<<<<<H: (About 2 TB of storage)
<<<<<I: (About 2 TB of storage)
<WEB IP's>
<<<<<Resource of a list of clustered IP;s I use for internal web
addreses
Now when I re-intall or try to install a new instance...
I only see my Quorum resource. My other 2 resources arent even showing.. Yes
they are running , Yes they are on the same node in which I am installing
from. No I cannot see them from the other node when I move them and try to
install from the 2nd node ( as a test)
Everything works normal, I have a 1.5 TB Database that is growing daily that
works great, Clustered resources work and failover as planned.
Now after further explination. Do you still think that this is a spindle
issue when I have plenty of room to work with still?
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:OVLes8zIFHA.1280@.TK2MSFTNGP09.phx.gbl...
> This article
> http://www.sqlservercentral.com/colu...youbuyasan.asp
> gives you great examples. More disks, more spindles.
> Here is a pretty explanation of what a spindle is
> http://www.webopedia.com/TERM/s/spindle.html.
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> http://msmvps.com/clustering - Blog
> "dibblm" <dibblm@.hotmail.com> wrote in message
> news:eSgSrfzIFHA.588@.TK2MSFTNGP15.phx.gbl...
>
|||It sounds like you have configured the SAN as one drive to the OS, but with
multiple partitions. Clustering can only talk to drives, all parturitions
are treated as the same thing. Is this the case?
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"dibblm" <dibblm@.hotmail.com> wrote in message
news:uS2K8L$IFHA.2784@.TK2MSFTNGP09.phx.gbl...
> I personally think this isn't my issues. I have 42 Drives (Or spindles) I
> have plenty of room. The problem is with Sql itself on the install.
> Something is hosed in the os where the SQL install doesnt even see the
> resources.
> Let me get you a little closer to the problem.
> You state the sql setup.
> You can shoose either local, remote or virtual. ( I choose virtual)
> then you have to assign ip's and so on
> once you get to the area where you pick where you want to install the
> instance to.......... My only resource is the Quorum resource itself. I
> do not even see my other resources that contain other volumes.
> My initial install showed as follows
> <Quorum>
> <<<<<Q:
> <<<<<F: ( left over storage that wasnt needed)
> <MSDTC>
> <<<<<G: ( About 2 TB of storage)
> <<<<<H: (About 2 TB of storage)
> <<<<<I: (About 2 TB of storage)
> <WEB IP's>
> <<<<<Resource of a list of clustered IP;s I use for internal web
> addreses
> Now when I re-intall or try to install a new instance...
> I only see my Quorum resource. My other 2 resources arent even showing..
> Yes they are running , Yes they are on the same node in which I am
> installing from. No I cannot see them from the other node when I move them
> and try to install from the 2nd node ( as a test)
> Everything works normal, I have a 1.5 TB Database that is growing daily
> that works great, Clustered resources work and failover as planned.
> Now after further explination. Do you still think that this is a spindle
> issue when I have plenty of room to work with still?
> "Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
> message news:OVLes8zIFHA.1280@.TK2MSFTNGP09.phx.gbl...
>
|||Not at all.
I have 6 mounted volumes.
C: (2 - 36 gig drives in a mirror 0+1 (Operating System))
D: CD Rom
F: (See quorum)
G: (14 - 146 Gig DRives. raid 5 with 1 HOT online spare( 2 TB))
H: (14 - 146 Gig DRives raid 5 with 1 HOT online spare( 2 TB))
I : (14 - 146 Gig DRives raid 5 with 1 HOT online spare( 2 TB))
QQuorum Drive - 2 36 Gig Drives 0+1 Mirror. 2 partitions. Q for Quorum 10
Gig - F for left over.)
SQL Was originally Installed to G Holding the data with H holding the log
files and I holding the backups.
Again,, When I install now to create a new virtual instance, I dont even see
the G, H, and I drives that are in the MSDTC Resource. I dont even see the
Resource. I will do another install today and priovide a screen capture of
my scenario. I will also Provide a screen capture of the mounted Volu mes.
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:O6qswCAJFHA.3788@.tk2msftngp13.phx.gbl...
> It sounds like you have configured the SAN as one drive to the OS, but
> with multiple partitions. Clustering can only talk to drives, all
> parturitions are treated as the same thing. Is this the case?
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> http://msmvps.com/clustering - Blog
> "dibblm" <dibblm@.hotmail.com> wrote in message
> news:uS2K8L$IFHA.2784@.TK2MSFTNGP09.phx.gbl...
>
|||Ok, cause its just not adding up yet.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog
"dibblm" <dibblm@.hotmail.com> wrote in message
news:esFdXNXJFHA.2772@.TK2MSFTNGP14.phx.gbl...
> Not at all.
> I have 6 mounted volumes.
> C: (2 - 36 gig drives in a mirror 0+1 (Operating System))
> D: CD Rom
> F: (See quorum)
> G: (14 - 146 Gig DRives. raid 5 with 1 HOT online spare( 2 TB))
> H: (14 - 146 Gig DRives raid 5 with 1 HOT online spare( 2 TB))
> I : (14 - 146 Gig DRives raid 5 with 1 HOT online spare( 2 TB))
> QQuorum Drive - 2 36 Gig Drives 0+1 Mirror. 2 partitions. Q for Quorum
> 10 Gig - F for left over.)
> SQL Was originally Installed to G Holding the data with H holding the log
> files and I holding the backups.
> Again,, When I install now to create a new virtual instance, I dont even
> see the G, H, and I drives that are in the MSDTC Resource. I dont even see
> the Resource. I will do another install today and priovide a screen
> capture of my scenario. I will also Provide a screen capture of the
> mounted Volu mes.
>
> "Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
> message news:O6qswCAJFHA.3788@.tk2msftngp13.phx.gbl...
>
|||Just to clarify you have what appears to your cluster as six physical disks
C: (2 - 36 gig drives in a mirror 0+1 (Operating System))
D: CD Rom
F: (See quorum)
G: (14 - 146 Gig DRives. raid 5 with 1 HOT online spare( 2 TB))
H: (14 - 146 Gig DRives raid 5 with 1 HOT online spare( 2 TB))
I : (14 - 146 Gig DRives raid 5 with 1 HOT online spare( 2 TB))
QQuorum Drive - 2 36 Gig Drives 0+1 Mirror. 2 partitions. Q for Quorum 10
Gig - F for left over.)
Based on this that would allow you to use disks G:, H: and I: as possible
SQL Server disks
you stated that "SQL Was originally Installed to G Holding the data with H
holding the log
files and I holding the backups."
That would leave you with only the Quorum drives Q:, F: as possible disks
Once you added the H: and I: drives to the existing SQL Server they are no
longer available for use with another instance of SQL Server.
Each SQL Server instance will require its own group, name, IP address and
phyiscal disk
Simple way to look at this is any disk in the group with an existing
instance of SQL Server will not be available and sharing of resources in a
group between multiple groups is not possible.
Dave Whitney
SQL Support