[program-l] Re: sql server 2005 express nightmares
- From: "M. Sahyun" <sahyun@xxxxxxxxx>
- To: program-l@xxxxxxxxxxxxx
- Date: Mon, 23 Mar 2009 19:31:28 -0700 (PDT)
Marvin,
My experience with these types of issues is that the can all too often be a Sql
Server authentication problem. You need to make sure that the Sql Server user
(this would be the Sql Server username that logs into Sql Server for access)
belongs to a group that has rights to the Database it's trying to connect to,
otherwise it may act like the daabase itself doesn't exist. It does, of
course. And indeed this can be kind of a pain. Also, I don't know if this is
true in Sql Server 2005, but all too often in Sql Server 2000 you could not be
logged in as Administrator and launch applications hoping to access things in
Sql Server, regardless of what Sql Server username you were going under. It
was deliberately designed to prevent developers from getting into the habit of
logging on as Administrator -- isn't that annoying?
Hope it works out for you.
Best,
Mike Sahyun
--- On Sun, 3/15/09, Marvin Hunkin <startrekcafe@xxxxxxxxx> wrote:
> From: Marvin Hunkin <startrekcafe@xxxxxxxxx>
> Subject: [program-l] sql server 2005 express nightmares
> To: program-l@xxxxxxxxxxxxx
> Date: Sunday, March 15, 2009, 11:42 PM
> Hi.
> doing a tutorial from some one, and he is blind.
> and now, i am having nightmares usinging the web admin tool
> for visual web
> developer dot net 2005 express.
> when i click on the website menu,click the asp website
> tool, and try to
> click on security, get an error saying something about my
> data store not
> being correct, and then clicking on save data store.
> then i get the provider link page and it is checked and the
> asp server radio
> button is checked.
> then i click test.
> but then i get an error about the database not being
> connected or created
> and try to create the database again.
> and then tried using the sql command line tool.
> and went to cmd / sqlcmd, and said that sql server could
> not connect.
> went to sql configuration, went to protocals, made sure
> that tcpip was
> enabled.
> and saying the sql server native client could not connect.
> and then added my self as a admin for the surface
> configuration tool.
> so tearing my hair out.
> so how do i get this to connect?
> tried downloading sql server express, uninstall and
> reinstalling.
> but made no differnece.
> so how to get this working.
> unless, some one who has jaws, visual web developer, sql
> server and who
> wants to do a jaws tandem session.
> tearing my hair out and real frustrated.
> and cannot do the login and authentification section of his
> tutorial until i
> get this issue fixed.
> any ideas or help.
> would be appreciated.
> do not want to mess my wireless internet network at home.
> so not touching that.
> got jaws 10, vista home premium, internet explorer 7.
> cheers Marvin.
> E-mail: startrekcafe@xxxxxxxxx
> MSN: sttartrekcafe@xxxxxxx
> Skype: startrekcafe
> We Are The Borg! You Will Be Assimilated! Resistance Is
> Futile!
> Star Trek Voyager Episode 68 Scorpian Part One
>
>
> ** To leave the list, click on the immediately-following
> link:-
> ** [mailto:program-l-request@xxxxxxxxxxxxx?subject=unsubscribe]
> ** If this link doesn't work then send a message to:
> ** program-l-request@xxxxxxxxxxxxx
> ** and in the Subject line type
> ** unsubscribe
> ** For other list commands such as vacation mode, click on
> the
> ** immediately-following link:-
> ** [mailto:program-l-request@xxxxxxxxxxxxx?subject=faq]
> ** or send a message, to
> ** program-l-request@xxxxxxxxxxxxx
> with the Subject:- faq
>
** To leave the list, click on the immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** program-l-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** program-l-request@xxxxxxxxxxxxx with the Subject:- faq
Other related posts:
